eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PRICELIST_PVT dependencies on QP_PRICE_LIST_PUB

Line 172: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

168: j number := 1;
169: l_list_header_id number;
170: l_api_version CONSTANT NUMBER := 1.0;
171:
172: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
173: temp_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
174: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

Line 173: temp_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

169: l_list_header_id number;
170: l_api_version CONSTANT NUMBER := 1.0;
171:
172: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
173: temp_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
174: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 174: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

170: l_api_version CONSTANT NUMBER := 1.0;
171:
172: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
173: temp_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
174: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

171:
172: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
173: temp_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
174: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

172: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
173: temp_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
174: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

Line 179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

175: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

Line 180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

176: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

Line 181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

177: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
185: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

178: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
185: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
186: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

179: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
185: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
186: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
187: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

180: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
181: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
182: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
185: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
186: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
187: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
188: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

Line 187: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

183: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
185: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
186: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
187: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
188: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
189: l_ozf_price_list_attr_rec OZF_PRICE_LIST_PVT.OZF_PRICE_LIST_Rec_Type;
190: l_access_rec ams_access_PVT.access_rec_type;
191: l_jtf_note_id NUMBER;

Line 188: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

184: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
185: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
186: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
187: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
188: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
189: l_ozf_price_list_attr_rec OZF_PRICE_LIST_PVT.OZF_PRICE_LIST_Rec_Type;
190: l_access_rec ams_access_PVT.access_rec_type;
191: l_jtf_note_id NUMBER;
192: l_lines_delete VARCHAR2(1) := 'N';

Line 484: QP_PRICE_LIST_PUB.Process_Price_List

480:
481: END LOOP;
482: END IF;
483:
484: QP_PRICE_LIST_PUB.Process_Price_List
485: ( p_api_version_number => 1
486: , p_init_msg_list => FND_API.G_TRUE
487: , p_return_values => FND_API.G_FALSE
488: , p_commit => FND_API.G_FALSE

Line 556: QP_PRICE_LIST_PUB.Process_Price_List

552: END IF;
553:
554: END LOOP;
555:
556: QP_PRICE_LIST_PUB.Process_Price_List
557: ( p_api_version_number => 1
558: , p_init_msg_list => FND_API.G_TRUE
559: , p_return_values => FND_API.G_FALSE
560: , p_commit => FND_API.G_FALSE

Line 952: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

948: AND aam.arc_act_market_segment_used_by = 'PRIC'
949: AND aam.segment_type = 'CELL';
950:
951:
952: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
953: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
954: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 953: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

949: AND aam.segment_type = 'CELL';
950:
951:
952: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
953: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
954: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 954: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

950:
951:
952: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
953: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
954: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

951:
952: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
953: l_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
954: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

Line 958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

954: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

Line 959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

955: l_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

Line 960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

956: l_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
964: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

957: l_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
964: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
965: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

958: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
964: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
965: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
966: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

959: l_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
960: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
961: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
964: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
965: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
966: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
967: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

Line 966: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

962: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
964: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
965: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
966: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
967: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
968:
969: BEGIN
970: SAVEPOINT move_segments;

Line 967: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

963: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
964: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
965: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
966: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
967: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
968:
969: BEGIN
970: SAVEPOINT move_segments;
971:

Line 1015: QP_PRICE_LIST_PUB.Process_Price_List

1011: END LOOP;
1012:
1013: IF l_qualifiers_tbl.count > 0 THEN
1014:
1015: QP_PRICE_LIST_PUB.Process_Price_List
1016: ( p_api_version_number => 1
1017: , p_init_msg_list => FND_API.G_TRUE
1018: , p_return_values => FND_API.G_FALSE
1019: , p_commit => FND_API.G_FALSE

Line 1194: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_REC;

1190: l_index NUMBER := 1;
1191: l_item_in_prl VARCHAR2(1);
1192: l_source_system_code VARCHAR2(30);
1193:
1194: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_REC;
1195: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

Line 1195: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;

1191: l_item_in_prl VARCHAR2(1);
1192: l_source_system_code VARCHAR2(30);
1193:
1194: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_REC;
1195: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

Line 1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;

1192: l_source_system_code VARCHAR2(30);
1193:
1194: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_REC;
1195: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

Line 1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

1194: l_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_REC;
1195: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
1202: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

1195: l_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
1202: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1203: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

1196: l_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
1202: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1203: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
1204: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

1197:
1198: v_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
1199: v_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
1202: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1203: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
1204: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
1205: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1204: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

1200: v_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
1202: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1203: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
1204: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
1205: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
1206:
1207: CURSOR c_list_header_line_id (l_source_system_code VARCHAR2) IS
1208: SELECT DISTINCT qpa.list_header_id, qpa.list_line_id

Line 1205: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

1201: v_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
1202: v_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1203: v_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
1204: v_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
1205: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
1206:
1207: CURSOR c_list_header_line_id (l_source_system_code VARCHAR2) IS
1208: SELECT DISTINCT qpa.list_header_id, qpa.list_line_id
1209: FROM qp_pricing_attributes qpa, qp_list_lines qll, qp_list_headers_b qlh

Line 1521: l_price_list_line_tbl := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;

1517: END LOOP;
1518: END LOOP;
1519: /*
1520: FOR l_list_header_line_id IN c_list_header_line_id(l_source_system_code) LOOP
1521: l_price_list_line_tbl := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1522: l_pricing_attr_tbl := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1523: l_price_list_rec := NULL;
1524: l_index := 1;
1525:

Line 1522: l_pricing_attr_tbl := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;

1518: END LOOP;
1519: /*
1520: FOR l_list_header_line_id IN c_list_header_line_id(l_source_system_code) LOOP
1521: l_price_list_line_tbl := QP_PRICE_LIST_PUB.G_MISS_PRICE_LIST_LINE_TBL;
1522: l_pricing_attr_tbl := QP_PRICE_LIST_PUB.G_MISS_PRICING_ATTR_TBL;
1523: l_price_list_rec := NULL;
1524: l_index := 1;
1525:
1526: OPEN c_list_header_detail(l_list_header_line_id.list_header_id);

Line 1697: QP_PRICE_LIST_PUB.Process_Price_List

1693: l_index := l_index + 1;
1694: END IF;
1695: END LOOP;
1696:
1697: QP_PRICE_LIST_PUB.Process_Price_List
1698: ( p_api_version_number => p_api_version
1699: , p_init_msg_list => p_init_msg_list
1700: , p_return_values => FND_API.G_FALSE
1701: , p_commit => p_commit