DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_ADJ dependencies on QP_MODIFIERS_PUB

Line 71: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

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:

Line 72: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 82: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

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: (

Line 83: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 92: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

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: (

Line 93: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 108: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

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

Line 109: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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: (

Line 130: x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

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: (

Line 135: x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

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

Line 141: px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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: (

Line 142: , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 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: (

Line 147: , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_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: (
151: x_return_status OUT NOCOPY VARCHAR2

Line 155: , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type

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: (

Line 156: , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type

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

Line 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