| Price List line creation API [message #303935] |
Mon, 03 March 2008 06:13  |
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
