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_MODIFIERS_PUB 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_MODIFIER_LIST_rec IN Modifier_List_Rec_Type
12: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
13: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_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 Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_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 */ 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_MODIFIER_LIST_rec IN Modifier_List_Rec_Type
26: , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type
27: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN Modifiers_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 Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type

Line 30: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

26: , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type
27: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN Modifiers_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 Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_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 Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_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 */ 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_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
68: G_MISS_MODIFIERS_TBL
69: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
70: G_MISS_MODIFIERS_VAL_TBL
71: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
72: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=

Line 72: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

68: G_MISS_MODIFIERS_TBL
69: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
70: G_MISS_MODIFIERS_VAL_TBL
71: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
72: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL

Line 73: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=

69: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
70: G_MISS_MODIFIERS_VAL_TBL
71: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
72: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=

Line 74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL

70: G_MISS_MODIFIERS_VAL_TBL
71: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
72: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
78: G_MISS_PRICING_ATTR_VAL_TBL

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

79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
80: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
81: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
82: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_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 */ Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ 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_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
81: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
82: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_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 */ Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
87: )
88: IS

Line 97: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

93: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;
94: l_p_MODIFIER_LIST_rec Modifier_List_Rec_Type;
95: l_MODIFIERS_tbl Modifiers_Tbl_Type;
96: l_p_MODIFIERS_tbl Modifiers_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 Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
101: l_qp_status VARCHAR2(1);

Line 98: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

94: l_p_MODIFIER_LIST_rec Modifier_List_Rec_Type;
95: l_MODIFIERS_tbl Modifiers_Tbl_Type;
96: l_p_MODIFIERS_tbl Modifiers_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 Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
101: l_qp_status VARCHAR2(1);
102: l_request_type_code VARCHAR2(3);

Line 402: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

398: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
399: G_MISS_MODIFIERS_TBL
400: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
401: G_MISS_MODIFIERS_VAL_TBL
402: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
403: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
404: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
405: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
406: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=

Line 403: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

399: G_MISS_MODIFIERS_TBL
400: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
401: G_MISS_MODIFIERS_VAL_TBL
402: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
403: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
404: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
405: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
406: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
407: G_MISS_PRICING_ATTR_TBL

Line 404: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=

400: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
401: G_MISS_MODIFIERS_VAL_TBL
402: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
403: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
404: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
405: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
406: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
407: G_MISS_PRICING_ATTR_TBL
408: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=

Line 405: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL

401: G_MISS_MODIFIERS_VAL_TBL
402: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
403: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
404: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
405: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
406: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
407: G_MISS_PRICING_ATTR_TBL
408: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
409: G_MISS_PRICING_ATTR_VAL_TBL

Line 414: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

410: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
411: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
412: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
413: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
414: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
415: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
416: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
417: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
418: )

Line 415: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

411: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
412: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
413: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
414: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
415: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
416: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
417: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
418: )
419: IS

Line 427: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

423: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;
424: l_p_MODIFIER_LIST_rec Modifier_List_Rec_Type;
425: l_MODIFIERS_tbl Modifiers_Tbl_Type;
426: l_p_MODIFIERS_tbl Modifiers_Tbl_Type;
427: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
428: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
429: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
430: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
431: BEGIN

Line 428: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

424: l_p_MODIFIER_LIST_rec Modifier_List_Rec_Type;
425: l_MODIFIERS_tbl Modifiers_Tbl_Type;
426: l_p_MODIFIERS_tbl Modifiers_Tbl_Type;
427: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
428: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
429: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
430: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
431: BEGIN
432:

Line 603: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

599: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
600: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
601: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
602: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
603: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
604: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
605: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
606: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
607: )

Line 604: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

600: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
601: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
602: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
603: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
604: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
605: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
606: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
607: )
608: IS

Line 614: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

610: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
611: l_list_header_id NUMBER := p_list_header_id;
612: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
613: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
614: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
615: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
616: BEGIN
617:
618: oe_debug_pub.add('BEGIN get_modifiers in Public');

Line 787: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

783:
784: PROCEDURE Id_To_Value
785: ( p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type
786: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
787: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
788: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
789: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
790: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
791: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

Line 791: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

787: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
788: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
789: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
790: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
791: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
792: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
793: )
794: IS
795: BEGIN

Line 848: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

844: , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type
845: , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type
846: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
847: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type
848: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
849: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
850: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
851: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
852: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type

Line 849: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

845: , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type
846: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
847: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type
848: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
849: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
850: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
851: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
852: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
853: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type

Line 854: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

850: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
851: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
852: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
853: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
854: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
855: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
856: )
857: IS
858: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;

Line 860: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

856: )
857: IS
858: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;
859: l_MODIFIERS_rec Modifiers_Rec_Type;
860: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
861: l_PRICING_ATTR_rec Pricing_Attr_Rec_Type;
862: l_index BINARY_INTEGER;
863: BEGIN
864: