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_GRP dependencies on QP_MODIFIERS_PUB

Line 11: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type

7:
8: -- Forward declaration of Procedure Id_To_Value
9:
10: PROCEDURE Id_To_Value
11: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
12: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
13: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

Line 12: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

8: -- Forward declaration of Procedure Id_To_Value
9:
10: PROCEDURE Id_To_Value
11: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
12: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
13: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

Line 14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

10: PROCEDURE Id_To_Value
11: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
12: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
13: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

Line 15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

11: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
12: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
13: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
19: );

Line 16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

12: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
13: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
19: );
20:

Line 18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

14: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
15: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
16: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
19: );
20:
21: -- Forward declaration of procedure Value_To_Id
22:

Line 25: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type

21: -- Forward declaration of procedure Value_To_Id
22:
23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
26: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
27: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 26: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

22:
23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
26: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
27: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.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

Line 27: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
26: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
27: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.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 QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

Line 28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
26: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
27: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.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 QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

Line 31: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

27: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.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 QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

28: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.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 QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

Line 33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_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_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
37: );

Line 34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type

30: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
37: );
38:

Line 36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

32: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
34: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.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 */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
37: );
38:
39: -- Start of Comments
40: -- API name Process_Modifiers

Line 65: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

61: QP_GLOBALS.G_MISS_CONTROL_REC
62: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
64: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

Line 66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC

62: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
64: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL

Line 67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=

63: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
64: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=

Line 68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC

64: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=
72: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL

Line 69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

65: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=
72: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
73: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL

66: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=
72: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
73: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=

67: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type :=
68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=
72: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
73: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
75: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=

Line 72: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL

68: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
69: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
70: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
71: , p_MODIFIERS_val_tbl IN QP_Modifiers_PUB.Modifiers_Val_Tbl_Type :=
72: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
73: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
75: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
76: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL

Line 77: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

73: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
75: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
76: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
77: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

Line 78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL

74: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
75: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
76: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
77: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type

Line 79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=

75: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
76: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
77: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

Line 80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL

76: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
77: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type

Line 81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

77: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type
85: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type

78: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type
85: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
86: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

Line 83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

79: , p_PRICING_ATTR_val_tbl IN QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type :=
80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type
85: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
86: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
87: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

Line 84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type

80: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
81: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
82: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type
85: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
86: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
87: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
88: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type

Line 87: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

83: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type
85: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
86: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
87: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
88: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type
89: )
90: IS
91: l_api_version_number CONSTANT NUMBER := 1.0;

Line 88: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type

84: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Val_Tbl_Type
85: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
86: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
87: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
88: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type
89: )
90: IS
91: l_api_version_number CONSTANT NUMBER := 1.0;
92: l_api_name CONSTANT VARCHAR2(30):= 'Process_Modifiers';

Line 95: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

91: l_api_version_number CONSTANT NUMBER := 1.0;
92: l_api_name CONSTANT VARCHAR2(30):= 'Process_Modifiers';
93: l_control_rec QP_GLOBALS.Control_Rec_Type;
94: l_return_status VARCHAR2(1);
95: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
96: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
97: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
99: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 96: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

92: l_api_name CONSTANT VARCHAR2(30):= 'Process_Modifiers';
93: l_control_rec QP_GLOBALS.Control_Rec_Type;
94: l_return_status VARCHAR2(1);
95: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
96: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
97: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
99: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
100: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 97: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

93: l_control_rec QP_GLOBALS.Control_Rec_Type;
94: l_return_status VARCHAR2(1);
95: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
96: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
97: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
99: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
100: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
101: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

94: l_return_status VARCHAR2(1);
95: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
96: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
97: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
99: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
100: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
101: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
102: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 101: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

97: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
99: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
100: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
101: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
102: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
103: l_qp_status VARCHAR2(1);
104: l_list_source_code VARCHAR2(10); -- bug#3599792
105: BEGIN

Line 102: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

98: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
99: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
100: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
101: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
102: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
103: l_qp_status VARCHAR2(1);
104: l_list_source_code VARCHAR2(10); -- bug#3599792
105: BEGIN
106:

Line 331: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=

327: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
328: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
329: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
330: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
331: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=

Line 332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC

328: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
329: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
330: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
331: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL

Line 333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=

329: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
330: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
331: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=

Line 334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC

330: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
331: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
338: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL

Line 335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=

331: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
338: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
339: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL

332: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
338: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
339: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
340: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=

333: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
338: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
339: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
340: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
341: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=

Line 338: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL

334: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
335: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
336: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
337: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
338: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
339: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
340: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
341: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
342: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL

Line 343: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=

339: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
340: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
341: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
342: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
343: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type

Line 344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL

340: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
341: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
342: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
343: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

Line 345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=

341: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
342: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
343: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type

Line 346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL

342: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
343: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

Line 347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type

343: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
351: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

344: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
351: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
352: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

Line 349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type

345: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
351: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
352: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

Line 350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

346: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
347: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
348: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
351: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
352: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
354: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

Line 353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

349: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
351: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
352: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
354: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
355: )
356: IS
357: l_api_version_number CONSTANT NUMBER := 1.0;

Line 354: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

350: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
351: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
352: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
354: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
355: )
356: IS
357: l_api_version_number CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';

Line 360: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

356: IS
357: l_api_version_number CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
359: l_return_status VARCHAR2(1);
360: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
361: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
362: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
364: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 361: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

357: l_api_version_number CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
359: l_return_status VARCHAR2(1);
360: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
361: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
362: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
364: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
365: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 362: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

358: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
359: l_return_status VARCHAR2(1);
360: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
361: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
362: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
364: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
365: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
366: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;

359: l_return_status VARCHAR2(1);
360: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
361: l_p_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
362: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
364: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
365: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
366: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
367: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 366: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

362: l_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
364: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
365: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
366: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
367: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
368: BEGIN
369:
370: oe_debug_pub.add('BEGIN lock_modifiers in Public');

Line 367: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

363: l_p_MODIFIERS_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
364: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
365: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
366: l_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
367: l_p_PRICING_ATTR_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
368: BEGIN
369:
370: oe_debug_pub.add('BEGIN lock_modifiers in Public');
371: -- Standard call to check for call compatibility

Line 527: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type

523: , p_list_header_id IN NUMBER :=
524: FND_API.G_MISS_NUM
525: , p_list_header IN VARCHAR2 :=
526: FND_API.G_MISS_CHAR
527: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
528: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
529: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
531: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 528: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

524: FND_API.G_MISS_NUM
525: , p_list_header IN VARCHAR2 :=
526: FND_API.G_MISS_CHAR
527: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
528: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
529: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
531: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
532: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

Line 529: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type

525: , p_list_header IN VARCHAR2 :=
526: FND_API.G_MISS_CHAR
527: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
528: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
529: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
531: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
532: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
533: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

Line 530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

526: FND_API.G_MISS_CHAR
527: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
528: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
529: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
531: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
532: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
533: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
534: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

Line 533: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

529: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
531: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
532: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
533: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
534: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
535: )
536: IS
537: l_api_version_number CONSTANT NUMBER := 1.0;

Line 534: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

530: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
531: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
532: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
533: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
534: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
535: )
536: IS
537: l_api_version_number CONSTANT NUMBER := 1.0;
538: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';

Line 540: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

536: IS
537: l_api_version_number CONSTANT NUMBER := 1.0;
538: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
539: l_list_header_id NUMBER := p_list_header_id;
540: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
541: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
542: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
543: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
544: BEGIN

Line 541: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

537: l_api_version_number CONSTANT NUMBER := 1.0;
538: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
539: l_list_header_id NUMBER := p_list_header_id;
540: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
541: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
542: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
543: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
544: BEGIN
545:

Line 543: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

539: l_list_header_id NUMBER := p_list_header_id;
540: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
541: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
542: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
543: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
544: BEGIN
545:
546: oe_debug_pub.add('BEGIN get_modifiers in Public');
547: -- Standard call to check for call compatibility

Line 703: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type

699:
700: -- Procedure Id_To_Value
701:
702: PROCEDURE Id_To_Value
703: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
704: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
705: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

Line 704: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

700: -- Procedure Id_To_Value
701:
702: PROCEDURE Id_To_Value
703: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
704: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
705: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
708: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

Line 706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

702: PROCEDURE Id_To_Value
703: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
704: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
705: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
708: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
709: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
710: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

Line 707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

703: ( p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
704: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
705: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
708: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
709: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
710: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
711: )

Line 708: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

704: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
705: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
708: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
709: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
710: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
711: )
712: IS

Line 710: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

706: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
707: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
708: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
709: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
710: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
711: )
712: IS
713: BEGIN
714:

Line 762: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type

758: -- Procedure Value_To_Id
759:
760: PROCEDURE Value_To_Id
761: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
762: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
763: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
764: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 763: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type

759:
760: PROCEDURE Value_To_Id
761: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
762: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
763: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
764: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

Line 764: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type

760: PROCEDURE Value_To_Id
761: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
762: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
763: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
764: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

Line 765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type

761: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
762: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type
763: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
764: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

Line 768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

764: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
770: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
771: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
772: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type

765: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
770: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
771: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
772: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

Line 770: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type

766: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
770: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
771: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
772: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
774: )

Line 771: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type

767: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
768: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
770: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
771: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
772: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
774: )
775: IS

Line 773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

769: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
770: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
771: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
772: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
774: )
775: IS
776: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
777: l_MODIFIERS_rec QP_MODIFIERS_PUB.Modifiers_Rec_Type;

Line 776: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;

772: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
774: )
775: IS
776: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
777: l_MODIFIERS_rec QP_MODIFIERS_PUB.Modifiers_Rec_Type;
778: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
779: l_PRICING_ATTR_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
780: l_index BINARY_INTEGER;

Line 777: l_MODIFIERS_rec QP_MODIFIERS_PUB.Modifiers_Rec_Type;

773: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
774: )
775: IS
776: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
777: l_MODIFIERS_rec QP_MODIFIERS_PUB.Modifiers_Rec_Type;
778: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
779: l_PRICING_ATTR_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
780: l_index BINARY_INTEGER;
781: BEGIN

Line 779: l_PRICING_ATTR_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;

775: IS
776: l_MODIFIER_LIST_rec QP_MODIFIERS_PUB.Modifier_List_Rec_Type;
777: l_MODIFIERS_rec QP_MODIFIERS_PUB.Modifiers_Rec_Type;
778: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
779: l_PRICING_ATTR_rec QP_MODIFIERS_PUB.Pricing_Attr_Rec_Type;
780: l_index BINARY_INTEGER;
781: BEGIN
782:
783: oe_debug_pub.add('START value_to_id in Public');