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 1356: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1352:
1353: PROCEDURE Pricing_Attrs
1354: ( p_validation_level IN NUMBER
1355: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1356: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1357: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1358: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1359: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1360: )

Line 1357: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

1353: PROCEDURE Pricing_Attrs
1354: ( p_validation_level IN NUMBER
1355: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1356: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1357: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1358: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1359: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1360: )
1361: IS

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

1354: ( p_validation_level IN NUMBER
1355: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1356: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1357: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1358: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1359: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1360: )
1361: IS
1362: l_return_status VARCHAR2(1);

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

1355: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1356: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1357: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1358: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1359: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1360: )
1361: IS
1362: l_return_status VARCHAR2(1);
1363: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1360: )
1361: IS
1362: l_return_status VARCHAR2(1);
1363: l_control_rec QP_GLOBALS.Control_Rec_Type;
1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1368: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1361: IS
1362: l_return_status VARCHAR2(1);
1363: l_control_rec QP_GLOBALS.Control_Rec_Type;
1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1368: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1369: l_pte_code VARCHAR2(30);

Line 1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1362: l_return_status VARCHAR2(1);
1363: l_control_rec QP_GLOBALS.Control_Rec_Type;
1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1368: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1369: l_pte_code VARCHAR2(30);
1370: l_source_system_code VARCHAR2(30);

Line 1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1363: l_control_rec QP_GLOBALS.Control_Rec_Type;
1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1368: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1369: l_pte_code VARCHAR2(30);
1370: l_source_system_code VARCHAR2(30);
1371: l_saved_pte_code VARCHAR2(30);

Line 1368: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1368: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1369: l_pte_code VARCHAR2(30);
1370: l_source_system_code VARCHAR2(30);
1371: l_saved_pte_code VARCHAR2(30);
1372: l_saved_source_system_code VARCHAR2(30);

Line 1425: l_old_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;

1421: IF l_old_PRICING_ATTR_tbl.EXISTS(I) THEN
1422: oe_debug_pub.add('record already exists');
1423: l_old_PRICING_ATTR_rec := l_old_PRICING_ATTR_tbl(I);
1424: ELSE
1425: l_old_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;
1426: END IF;
1427:
1428: -- Load API control record
1429: oe_debug_pub.add('before init control rec');

Line 1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

1843: QP_GLOBALS.G_MISS_CONTROL_REC
1844: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1845: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1846: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

1844: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1845: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1846: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

1845: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1846: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

1846: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

1848: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

1849: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

Line 1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

1850: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

Line 1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1866: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1866: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1867: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1866: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1867: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1868: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

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

1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1866: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1867: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1868: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1869: )

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

1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1866: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1867: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1868: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1869: )
1870: IS

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

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

Line 1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

1871: l_api_version_number CONSTANT NUMBER := 1.0;
1872: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
1873: l_return_status VARCHAR2(1);
1874: l_control_rec QP_GLOBALS.Control_Rec_Type;
1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

1872: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
1873: l_return_status VARCHAR2(1);
1874: l_control_rec QP_GLOBALS.Control_Rec_Type;
1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

1873: l_return_status VARCHAR2(1);
1874: l_control_rec QP_GLOBALS.Control_Rec_Type;
1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

1874: l_control_rec QP_GLOBALS.Control_Rec_Type;
1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1879: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1880: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1896: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1896: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1897: l_installed_status VARCHAR2(1);

Line 1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1896: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1897: l_installed_status VARCHAR2(1);
1898: -- Blanket Agreement

Line 1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1896: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1897: l_installed_status VARCHAR2(1);
1898: -- Blanket Agreement
1899: l_qual_exists VARCHAR2(1) := 'N';

Line 1896: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1895: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1896: l_p_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1897: l_installed_status VARCHAR2(1);
1898: -- Blanket Agreement
1899: l_qual_exists VARCHAR2(1) := 'N';
1900: BEGIN

Line 2382: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

2378: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2379: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2380: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2381: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2382: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

2379: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2380: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2381: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2382: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

2380: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2381: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2382: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

Line 2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

2381: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2382: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2392: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2393: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2392: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2393: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2394: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

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

2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2392: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2393: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2394: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2395: )

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

2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2392: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2393: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2394: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2395: )
2396: IS

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

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

Line 2400: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

2396: IS
2397: l_api_version_number CONSTANT NUMBER := 1.0;
2398: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
2399: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2400: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2401: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2402: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
2403: BEGIN
2404:

Line 2402: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

2398: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
2399: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2400: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2401: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2402: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
2403: BEGIN
2404:
2405: -- Standard call to check for call compatibility
2406:

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

2607: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2608: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2609: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2610: , p_list_header_id IN NUMBER
2611: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2612: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2613: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2614: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2615: )

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

2608: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2609: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2610: , p_list_header_id IN NUMBER
2611: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2612: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2613: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2614: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2615: )
2616: IS

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

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

Line 2619: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

2615: )
2616: IS
2617: l_api_version_number CONSTANT NUMBER := 1.0;
2618: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2619: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2620: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2621: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2622: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2623: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 2620: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

2616: IS
2617: l_api_version_number CONSTANT NUMBER := 1.0;
2618: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2619: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2620: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2621: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2622: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2623: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2624: BEGIN

Line 2622: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

2618: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2619: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2620: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2621: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2622: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2623: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2624: BEGIN
2625:
2626: -- Standard call to check for call compatibility

Line 2623: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

2619: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2620: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2621: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2622: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2623: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2624: BEGIN
2625:
2626: -- Standard call to check for call compatibility
2627: