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
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
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
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: );
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:
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:
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
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
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
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
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
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
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: );
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:
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
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 :=
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
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 :=
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
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 :=
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
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 :=
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
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
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
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
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
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
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
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
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
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;
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';
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;
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;
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;
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;
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
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:
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 :=
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
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 :=
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
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 :=
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
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 :=
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
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
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
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
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
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
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
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
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
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;
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';
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;
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;
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;
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;
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');
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
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
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
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
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
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;
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';
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
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:
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
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
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
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
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: )
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
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:
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
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
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
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
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
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
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: )
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
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;
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;
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
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');