Home » Applications » Oracle Fusion Apps & E-Business Suite » Price List line creation API
Price List line creation API [message #303935] Mon, 03 March 2008 06:13 Go to next message
suraj_an
Messages: 15
Registered: February 2008
Junior Member
Hi

I want to create price list lines (in qp_list_lines) for a given price list (which exists in qp_list_headers). This is the anonymous block. But it isnt creating. Is there any parameter that I have missed? Whats the problem?

declare
lr_price_list_tbl_type qp_price_list_pub.price_list_line_tbl_type;
lr_price_list_tbl_type_out qp_price_list_pub.price_list_line_tbl_type;

lr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
lr_price_list_line_val_tbl_out qp_price_list_pub.price_list_line_val_tbl_type;

lr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
lr_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

lr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
lr_qualifiers_val_tbl_out qp_qualifier_rules_pub.qualifiers_val_tbl_type;

lr_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
lr_pricing_attr_tbl_out qp_price_list_pub.pricing_attr_tbl_type;

lr_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
lr_pricing_attr_val_tbl_out qp_price_list_pub.pricing_attr_val_tbl_type;


lr_price_list_rec qp_price_list_pub.price_list_rec_type;
lr_price_list_rec_out qp_price_list_pub.price_list_rec_type;

lr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
lr_price_list_val_rec_out qp_price_list_pub.price_list_val_rec_type;

gn_user_id NUMBER := FND_GLOBAL.USER_ID;
gn_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
lc_ret_status VARCHAR2(200);
ln_msg_count NUMBER;
lc_msg_data VARCHAR2(1000);

ln_msg_cnt number;
lc_stage varchar2(1000);

begin
lr_price_list_tbl_type(1).base_uom_code:='One';
lr_price_list_tbl_type(1).inventory_item_id:=13854;
lr_price_list_tbl_type(1).organization_id:=204;
lr_price_list_tbl_type(1).created_by:=gn_user_id;
lr_price_list_tbl_type(1).last_updated_by:=gn_user_id;
lr_price_list_tbl_type(1).last_update_date:=SYSDATE;
lr_price_list_tbl_type(1).last_update_login:=gn_login_id;
lr_price_list_tbl_type(1).creation_date:=SYSDATE;
lr_price_list_tbl_type(1).list_header_id:=1000;
--lr_price_list_tbl_type(1).operation:='CREATE';--QP_GLOBALS.G_OPR_CREATE;--'INSERT';

qp_price_list_pub.process_price_list (p_api_version_number => 1.0
,p_init_msg_list => FND_API.G_FALSE
,p_return_values => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE

,x_return_status => lc_ret_status
,x_msg_count => ln_msg_count
,x_msg_data => lc_msg_data

,p_price_list_line_tbl => lr_price_list_tbl_type
,x_price_list_line_tbl => lr_price_list_tbl_type_out

,p_price_list_rec => lr_price_list_rec
,x_price_list_rec => lr_price_list_rec_out

,p_price_list_val_rec => lr_price_list_val_rec
,x_price_list_val_rec => lr_price_list_val_rec_out

,p_price_list_line_val_tbl => lr_price_list_line_val_tbl
,x_price_list_line_val_tbl => lr_price_list_line_val_tbl_out

,p_qualifiers_tbl => lr_qualifiers_tbl
,x_qualifiers_tbl => lr_qualifiers_tbl_out

,p_qualifiers_val_tbl => lr_qualifiers_val_tbl
,x_qualifiers_val_tbl => lr_qualifiers_val_tbl_out

,p_pricing_attr_tbl => lr_pricing_attr_tbl
,x_pricing_attr_tbl => lr_pricing_attr_tbl_out

,p_pricing_attr_val_tbl => lr_pricing_attr_val_tbl
,x_pricing_attr_val_tbl => lr_pricing_attr_val_tbl_out

);
end;

Here, 1000 is the list header id of the price list which exists and the item also exists in mtl_system_items_b.

Thanks

[Updated on: Mon, 03 March 2008 06:15]

Report message to a moderator

Re: Price list line creation API [message #303940 is a reply to message #303935] Mon, 03 March 2008 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Regards
Michel
Re: Price list line creation API [message #303943 is a reply to message #303935] Mon, 03 March 2008 06:30 Go to previous message
suraj_an
Messages: 15
Registered: February 2008
Junior Member
Sorry...
Previous Topic: Legal Entity & Set of books
Next Topic: AZN Menus and Oracle Segregation of Duties
Goto Forum:
  


Current Time: Tue Dec 06 14:18:41 CST 2016

Total time taken to generate the page: 0.09394 seconds