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_PRICE_LIST_GRP dependencies on QP_QUALIFIER_RULES_PUB

Line 13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

9:
10: PROCEDURE Id_To_Value
11: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
19: );
20:
21: -- Forward declaration of procedure Value_To_Id

Line 29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

25: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
37: );
38:
39: -- Start of Comments

Line 71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=

69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

Line 83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
87: )

Line 84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
87: )
88: IS

Line 97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

93: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
101: l_installed_status VARCHAR2(1);

Line 98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
101: l_installed_status VARCHAR2(1);
102: l_request_type_code VARCHAR2(3);

Line 292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=

290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

Line 304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
307: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
308: )

Line 305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
307: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
308: )
309: IS

Line 317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

313: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
320: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
321: BEGIN

Line 318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
320: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
321: BEGIN
322:

Line 482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

478: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
485: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
486: )

Line 483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
485: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
486: )
487: IS

Line 493: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

489: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
490: l_list_header_id NUMBER := p_list_header_id;
491: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
492: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
493: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
494: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
495: BEGIN
496:
497: -- Standard call to check for call compatibility

Line 654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

650:
651: PROCEDURE Id_To_Value
652: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
659: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
660: )
661: IS
662: BEGIN

Line 714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

710: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
722: )
723: IS
724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 726: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

722: )
723: IS
724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
725: l_PRICE_LIST_LINE_rec QP_Price_list_PUB.Price_List_Line_Rec_Type;
726: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
727: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
728: l_index BINARY_INTEGER;
729: BEGIN
730: