67: x_return_status OUT NOCOPY VARCHAR2
68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2
70: , p_listLineId IN NUMBER
71: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
72: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
73: , p_offerAdjustmentId IN NUMBER
74: );
75:
68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2
70: , p_listLineId IN NUMBER
71: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
72: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
73: , p_offerAdjustmentId IN NUMBER
74: );
75:
76: PROCEDURE create_new_qp_lines
78: x_return_status OUT NOCOPY VARCHAR2
79: ,x_msg_count OUT NOCOPY NUMBER
80: ,x_msg_data OUT NOCOPY VARCHAR2
81: ,p_offerAdjustmentId IN NUMBER
82: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
83: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
84: );
85: PROCEDURE create_modifier_from_line
86: (
79: ,x_msg_count OUT NOCOPY NUMBER
80: ,x_msg_data OUT NOCOPY VARCHAR2
81: ,p_offerAdjustmentId IN NUMBER
82: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
83: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
84: );
85: PROCEDURE create_modifier_from_line
86: (
87: x_return_status OUT NOCOPY VARCHAR2
88: , x_msg_count OUT NOCOPY NUMBER
89: , x_msg_data OUT NOCOPY VARCHAR2
90: , p_offerAdjustmentId IN NUMBER
91: , p_listLineId IN NUMBER
92: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
93: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
94: );
95: PROCEDURE create_new_products
96: (
89: , x_msg_data OUT NOCOPY VARCHAR2
90: , p_offerAdjustmentId IN NUMBER
91: , p_listLineId IN NUMBER
92: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
93: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
94: );
95: PROCEDURE create_new_products
96: (
97: x_return_status OUT NOCOPY VARCHAR2
104: x_return_status OUT NOCOPY VARCHAR2
105: ,x_msg_count OUT NOCOPY NUMBER
106: ,x_msg_data OUT NOCOPY VARCHAR2
107: ,p_offerAdjustmentId IN NUMBER
108: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
109: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
110: );
111:
112: PROCEDURE create_new_exclusions
105: ,x_msg_count OUT NOCOPY NUMBER
106: ,x_msg_data OUT NOCOPY VARCHAR2
107: ,p_offerAdjustmentId IN NUMBER
108: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
109: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
110: );
111:
112: PROCEDURE create_new_exclusions
113: (
126: , x_msg_data OUT NOCOPY VARCHAR2
127: );
128: PROCEDURE populate_discounts
129: (
130: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
131: , p_list_line_id IN NUMBER
132: );
133: PROCEDURE populate_pricing_attributes
134: (
131: , p_list_line_id IN NUMBER
132: );
133: PROCEDURE populate_pricing_attributes
134: (
135: x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
136: , p_list_line_id IN NUMBER
137: , p_index IN NUMBER
138: );
139: PROCEDURE merge_pricing_attributes
137: , p_index IN NUMBER
138: );
139: PROCEDURE merge_pricing_attributes
140: (
141: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
142: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
143: );
144: PROCEDURE merge_modifiers
145: (
138: );
139: PROCEDURE merge_pricing_attributes
140: (
141: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
142: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
143: );
144: PROCEDURE merge_modifiers
145: (
146: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
142: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
143: );
144: PROCEDURE merge_modifiers
145: (
146: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
147: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
148: );
149: PROCEDURE populate_pbh_line
150: (
143: );
144: PROCEDURE merge_modifiers
145: (
146: px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
147: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
148: );
149: PROCEDURE populate_pbh_line
150: (
151: x_return_status OUT NOCOPY VARCHAR2
151: x_return_status OUT NOCOPY VARCHAR2
152: , x_msg_count OUT NOCOPY NUMBER
153: , x_msg_data OUT NOCOPY VARCHAR2
154: , p_listLineId IN NUMBER
155: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
156: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
157: );
158: PROCEDURE relate_lines
159: (
152: , x_msg_count OUT NOCOPY NUMBER
153: , x_msg_data OUT NOCOPY VARCHAR2
154: , p_listLineId IN NUMBER
155: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
156: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
157: );
158: PROCEDURE relate_lines
159: (
160: p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type
156: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
157: );
158: PROCEDURE relate_lines
159: (
160: p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type
161: , p_offer_adjustment_id IN NUMBER
162: , x_return_status OUT NOCOPY VARCHAR2
163: , x_msg_count OUT NOCOPY NUMBER
164: , x_msg_data OUT NOCOPY VARCHAR2