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 410: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

406: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
407: G_MISS_MODIFIERS_TBL
408: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
409: G_MISS_MODIFIERS_VAL_TBL
410: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
411: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
412: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
413: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
414: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=

Line 411: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

407: G_MISS_MODIFIERS_TBL
408: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
409: G_MISS_MODIFIERS_VAL_TBL
410: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
411: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
412: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
413: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
414: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
415: G_MISS_PRICING_ATTR_TBL

Line 412: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=

408: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
409: G_MISS_MODIFIERS_VAL_TBL
410: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
411: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
412: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
413: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
414: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
415: G_MISS_PRICING_ATTR_TBL
416: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=

Line 413: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL

409: G_MISS_MODIFIERS_VAL_TBL
410: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
411: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
412: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
413: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
414: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
415: G_MISS_PRICING_ATTR_TBL
416: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
417: G_MISS_PRICING_ATTR_VAL_TBL

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

418: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
419: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
420: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
421: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
422: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
423: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
424: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
425: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
426: )

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

419: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
420: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
421: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
422: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
423: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
424: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
425: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
426: )
427: IS

Line 435: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

431: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;
432: l_p_MODIFIER_LIST_rec Modifier_List_Rec_Type;
433: l_MODIFIERS_tbl Modifiers_Tbl_Type;
434: l_p_MODIFIERS_tbl Modifiers_Tbl_Type;
435: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
436: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
437: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
438: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
439: BEGIN

Line 436: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

432: l_p_MODIFIER_LIST_rec Modifier_List_Rec_Type;
433: l_MODIFIERS_tbl Modifiers_Tbl_Type;
434: l_p_MODIFIERS_tbl Modifiers_Tbl_Type;
435: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
436: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
437: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
438: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
439: BEGIN
440:

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

607: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
608: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
609: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
610: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
611: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
612: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
613: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
614: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
615: )

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

608: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
609: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
610: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
611: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
612: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
613: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
614: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
615: )
616: IS

Line 622: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

618: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
619: l_list_header_id NUMBER := p_list_header_id;
620: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
621: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
622: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
623: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
624: BEGIN
625:
626: oe_debug_pub.add('BEGIN get_modifiers in Public');

Line 795: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

791:
792: PROCEDURE Id_To_Value
793: ( p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type
794: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
795: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
796: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
797: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
798: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
799: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

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

795: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
796: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
797: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
798: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
799: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
800: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
801: )
802: IS
803: BEGIN

Line 856: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

852: , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type
853: , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type
854: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
855: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type
856: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
857: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
858: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
859: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
860: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type

Line 857: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

853: , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type
854: , p_MODIFIERS_tbl IN Modifiers_Tbl_Type
855: , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type
856: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
857: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
858: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
859: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
860: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
861: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type

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

858: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
859: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
860: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
861: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
862: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
863: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
864: )
865: IS
866: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;

Line 868: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

864: )
865: IS
866: l_MODIFIER_LIST_rec Modifier_List_Rec_Type;
867: l_MODIFIERS_rec Modifiers_Rec_Type;
868: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
869: l_PRICING_ATTR_rec Pricing_Attr_Rec_Type;
870: l_index BINARY_INTEGER;
871: BEGIN
872: