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.QP_LIST_HEADERS_PVT dependencies on QP_PRICE_LIST_PUB

Line 13: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

9:
10: PROCEDURE Price_List
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
14: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
17: )

Line 14: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

10: PROCEDURE Price_List
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
14: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
17: )
18: IS

Line 15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
14: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);

Line 16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
14: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 21: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
22: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
23: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
24: l_pte_code VARCHAR2(30);
25: l_source_system_code VARCHAR2(30);

Line 22: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
22: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
23: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
24: l_pte_code VARCHAR2(30);
25: l_source_system_code VARCHAR2(30);
26: l_saved_pte_code VARCHAR2(30);

Line 23: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
22: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
23: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
24: l_pte_code VARCHAR2(30);
25: l_source_system_code VARCHAR2(30);
26: l_saved_pte_code VARCHAR2(30);
27: l_saved_source_system_code VARCHAR2(30);

Line 340: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

336:
337: PROCEDURE Price_List_Lines
338: ( p_validation_level IN NUMBER
339: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
340: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
341: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
342: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
344: )

Line 341: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

337: PROCEDURE Price_List_Lines
338: ( p_validation_level IN NUMBER
339: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
340: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
341: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
342: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
344: )
345: IS

Line 342: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

338: ( p_validation_level IN NUMBER
339: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
340: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
341: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
342: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
344: )
345: IS
346: l_return_status VARCHAR2(1);

Line 343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

339: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
340: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
341: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
342: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
344: )
345: IS
346: l_return_status VARCHAR2(1);
347: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

344: )
345: IS
346: l_return_status VARCHAR2(1);
347: l_control_rec QP_GLOBALS.Control_Rec_Type;
348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
352: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

345: IS
346: l_return_status VARCHAR2(1);
347: l_control_rec QP_GLOBALS.Control_Rec_Type;
348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
352: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
353: l_rltd_modifiers_s number;

Line 350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

346: l_return_status VARCHAR2(1);
347: l_control_rec QP_GLOBALS.Control_Rec_Type;
348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
352: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
353: l_rltd_modifiers_s number;
354: l_pte_code VARCHAR2(30);

Line 351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

347: l_control_rec QP_GLOBALS.Control_Rec_Type;
348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
352: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
353: l_rltd_modifiers_s number;
354: l_pte_code VARCHAR2(30);
355: l_source_system_code VARCHAR2(30);

Line 352: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
352: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
353: l_rltd_modifiers_s number;
354: l_pte_code VARCHAR2(30);
355: l_source_system_code VARCHAR2(30);
356: l_saved_pte_code VARCHAR2(30);

Line 380: l_old_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;

376:
377: IF l_old_PRICE_LIST_LINE_tbl.EXISTS(I) THEN
378: l_old_PRICE_LIST_LINE_rec := l_old_PRICE_LIST_LINE_tbl(I);
379: ELSE
380: l_old_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;
381: END IF;
382:
383: -- Load API control record
384:

Line 1351: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1347:
1348: PROCEDURE Pricing_Attrs
1349: ( p_validation_level IN NUMBER
1350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1351: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1352: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1355: )

Line 1352: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1348: PROCEDURE Pricing_Attrs
1349: ( p_validation_level IN NUMBER
1350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1351: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1352: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1355: )
1356: IS

Line 1353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1349: ( p_validation_level IN NUMBER
1350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1351: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1352: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1355: )
1356: IS
1357: l_return_status VARCHAR2(1);

Line 1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1351: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1352: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1355: )
1356: IS
1357: l_return_status VARCHAR2(1);
1358: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1355: )
1356: IS
1357: l_return_status VARCHAR2(1);
1358: l_control_rec QP_GLOBALS.Control_Rec_Type;
1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1363: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1356: IS
1357: l_return_status VARCHAR2(1);
1358: l_control_rec QP_GLOBALS.Control_Rec_Type;
1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1363: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1364: l_pte_code VARCHAR2(30);

Line 1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1357: l_return_status VARCHAR2(1);
1358: l_control_rec QP_GLOBALS.Control_Rec_Type;
1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1363: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1364: l_pte_code VARCHAR2(30);
1365: l_source_system_code VARCHAR2(30);

Line 1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1358: l_control_rec QP_GLOBALS.Control_Rec_Type;
1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1363: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1364: l_pte_code VARCHAR2(30);
1365: l_source_system_code VARCHAR2(30);
1366: l_saved_pte_code VARCHAR2(30);

Line 1363: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1363: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1364: l_pte_code VARCHAR2(30);
1365: l_source_system_code VARCHAR2(30);
1366: l_saved_pte_code VARCHAR2(30);
1367: l_saved_source_system_code VARCHAR2(30);

Line 1420: l_old_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;

1416: IF l_old_PRICING_ATTR_tbl.EXISTS(I) THEN
1417: oe_debug_pub.add('record already exists');
1418: l_old_PRICING_ATTR_rec := l_old_PRICING_ATTR_tbl(I);
1419: ELSE
1420: l_old_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;
1421: END IF;
1422:
1423: -- Load API control record
1424: oe_debug_pub.add('before init control rec');

Line 1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

1838: QP_GLOBALS.G_MISS_CONTROL_REC
1839: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1840: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1841: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

1839: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1840: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1841: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

1840: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1841: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

1841: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1850: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

1843: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1850: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1851: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

1844: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1850: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1851: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1852: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

Line 1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

1845: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1846: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1850: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1851: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1852: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1853: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 1851: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

1847: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1848: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1849: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1850: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1851: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1852: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1853: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1855: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

Line 1854: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

1850: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1851: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1852: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1853: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1855: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

1852: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1853: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1855: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

1853: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1855: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

1854: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1855: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1862: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

1855: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1862: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1863: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

1856: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1862: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1863: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1864: )

Line 1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

1857: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1858: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1862: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1863: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1864: )
1865: IS

Line 1863: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1859: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1860: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1861: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1862: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1863: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1864: )
1865: IS
1866: l_api_version_number CONSTANT NUMBER := 1.0;
1867: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';

Line 1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

1866: l_api_version_number CONSTANT NUMBER := 1.0;
1867: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
1868: l_return_status VARCHAR2(1);
1869: l_control_rec QP_GLOBALS.Control_Rec_Type;
1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

1867: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
1868: l_return_status VARCHAR2(1);
1869: l_control_rec QP_GLOBALS.Control_Rec_Type;
1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

1868: l_return_status VARCHAR2(1);
1869: l_control_rec QP_GLOBALS.Control_Rec_Type;
1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

1869: l_control_rec QP_GLOBALS.Control_Rec_Type;
1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1879: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1879: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1880: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1879: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1880: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1881: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1874: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1879: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1880: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1881: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1882: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1879: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1875: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1876: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1877: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1878: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1879: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1880: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1881: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1882: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1883: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1886: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1882: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1883: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1884: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1885: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1886: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1883: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1884: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1885: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1886: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1891: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1884: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1885: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1886: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1891: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1892: l_installed_status VARCHAR2(1);

Line 1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1885: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1886: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1891: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1892: l_installed_status VARCHAR2(1);
1893: -- Blanket Agreement

Line 1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1886: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1891: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1892: l_installed_status VARCHAR2(1);
1893: -- Blanket Agreement
1894: l_qual_exists VARCHAR2(1) := 'N';

Line 1891: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1887: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1888: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1889: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1890: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1891: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1892: l_installed_status VARCHAR2(1);
1893: -- Blanket Agreement
1894: l_qual_exists VARCHAR2(1) := 'N';
1895: BEGIN

Line 2377: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

2373: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2374: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2375: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2376: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2377: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2378: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2379: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 2378: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

2374: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2375: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2376: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2377: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2378: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2379: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 2379: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

2375: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2376: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2377: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2378: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2379: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

Line 2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

2376: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2377: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2378: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2379: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

2378: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2379: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

2380: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2387: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2388: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

2381: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2387: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2388: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2389: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

2382: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2387: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2388: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2389: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2390: )

Line 2387: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

2383: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2384: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2387: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2388: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2389: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2390: )
2391: IS

Line 2389: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

2385: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2386: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2387: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2388: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2389: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2390: )
2391: IS
2392: l_api_version_number CONSTANT NUMBER := 1.0;
2393: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';

Line 2395: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

2391: IS
2392: l_api_version_number CONSTANT NUMBER := 1.0;
2393: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
2394: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2395: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2396: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2397: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
2398: BEGIN
2399:

Line 2397: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

2393: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
2394: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2395: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2396: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2397: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
2398: BEGIN
2399:
2400: -- Standard call to check for call compatibility
2401:

Line 2606: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

2602: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2603: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2604: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2605: , p_list_header_id IN NUMBER
2606: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2607: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2608: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2609: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2610: )

Line 2607: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

2603: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2604: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2605: , p_list_header_id IN NUMBER
2606: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2607: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2608: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2609: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2610: )
2611: IS

Line 2609: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

2605: , p_list_header_id IN NUMBER
2606: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2607: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2608: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2609: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2610: )
2611: IS
2612: l_api_version_number CONSTANT NUMBER := 1.0;
2613: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';

Line 2614: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

2610: )
2611: IS
2612: l_api_version_number CONSTANT NUMBER := 1.0;
2613: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2614: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2615: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2616: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2617: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2618: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 2615: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

2611: IS
2612: l_api_version_number CONSTANT NUMBER := 1.0;
2613: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2614: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2615: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2616: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2617: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2618: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2619: BEGIN

Line 2617: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

2613: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2614: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2615: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2616: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2617: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2618: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2619: BEGIN
2620:
2621: -- Standard call to check for call compatibility

Line 2618: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

2614: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2615: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2616: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2617: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2618: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2619: BEGIN
2620:
2621: -- Standard call to check for call compatibility
2622: