1 PACKAGE OZF_OFFER_ADJ_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvoajs.pls 120.1 2006/03/29 17:43 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --
7 -- Purpose
8 --
9 -- History
10 -- NOTE
11 --
12 -- End of Comments
13 -- ===============================================================
14 PROCEDURE process_old_discounts
15 (
16 x_return_status OUT NOCOPY VARCHAR2
17 ,x_msg_count OUT NOCOPY NUMBER
18 ,x_msg_data OUT NOCOPY VARCHAR2
19 ,p_offerAdjustmentId IN NUMBER
20 );
21 PROCEDURE process_new_products
22 (
23 x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25 ,x_msg_data OUT NOCOPY VARCHAR2
26 ,p_offerAdjustmentId IN NUMBER
27 );
28 /**
29 Processes an Adjustment.
30 For a given adjustment.
31 End dates old discounts and creates corresponding new discounts
32 Create new disocunts for new products added thru. Adjustments
33 Maps the old list_line_id to the new list_line_id
34 */
35 PROCEDURE process_adjustment
36 (
37 p_init_msg_list IN VARCHAR2 := FND_API.g_false
38 ,p_api_version IN NUMBER
39 ,p_commit IN VARCHAR2 := FND_API.g_false
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2
43 ,p_offerAdjustmentId IN NUMBER
44 );
45
46 PROCEDURE create_dis_line
47 (
48 x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 ,p_listLineId IN NUMBER
52 ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
53 ,x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
54 , x_listLineId OUT NOCOPY NUMBER
55 , p_offerAdjustmentLineId IN NUMBER
56 , p_offerAdjustmentId IN NUMBER
57 );
58 PROCEDURE copyListLine
59 (
60 x_return_status OUT NOCOPY VARCHAR2
61 , x_msg_count OUT NOCOPY NUMBER
62 , x_msg_data OUT NOCOPY VARCHAR2
63 , p_listLineId IN NUMBER
64 , x_listLineId OUT NOCOPY NUMBER
65 , p_offerAdjustmentLineId IN NUMBER
66 , p_offerAdjustmentId IN NUMBER
67 );
68 PROCEDURE process_old_dis_discount
69 (
70 x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 ,p_listLineId IN NUMBER
74 ,p_offerAdjustmentId IN NUMBER
75 , p_offerAdjustmentLineId IN NUMBER
76 );
77
78 PROCEDURE process_old_reg_discount
79 (
80 x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 ,p_offerAdjustmentId IN NUMBER
84 );
85
86 PROCEDURE copyPbhLine
87 (
88 x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 ,p_pbhListLineId IN NUMBER
92 ,p_offerAdjustmentId IN NUMBER
93 ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
94 );
95 PROCEDURE processOldPbhLines
96 (
97 x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 ,p_offerAdjustmentId IN NUMBER
101 );
102
103 PROCEDURE createPgLine
104 (
105 x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 , p_listLineId IN NUMBER
109 , x_listLineId OUT NOCOPY NUMBER
110 , p_offerAdjustmentLineId IN NUMBER
111 , p_offerAdjustmentId IN NUMBER
112 , x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
113 , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
114 );
115
116 PROCEDURE copyPGListLine
117 (
118 x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 , p_listLineId IN NUMBER
122 , x_listLineId OUT NOCOPY NUMBER
123 , p_offerAdjustmentLineId IN NUMBER
124 ,p_offerAdjustmentId IN NUMBER
125 );
126
127 PROCEDURE process_old_pg_discount
128 (
129 x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 ,p_offerAdjustmentId IN NUMBER
133 );
134
135 PROCEDURE endDateTdLine
136 (
137 x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 ,p_offerAdjustmentId IN NUMBER
141 , p_listLineId IN NUMBER
142 );
143
144 PROCEDURE createTdLine
145 (
146 x_return_status OUT NOCOPY VARCHAR2
147 ,x_msg_count OUT NOCOPY NUMBER
148 ,x_msg_data OUT NOCOPY VARCHAR2
149 ,p_offerAdjustmentId IN NUMBER
150 , p_listLineId IN NUMBER
151 , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
152 );
153
154 PROCEDURE copyListLineExclusion
155 (
156 x_return_status OUT NOCOPY VARCHAR2
157 ,x_msg_count OUT NOCOPY NUMBER
158 ,x_msg_data OUT NOCOPY VARCHAR2
159 ,p_fromListLineId IN NUMBER
160 ,p_toListLineId IN NUMBER
161 );
162
163 PROCEDURE copyTdLine
164 (
165 x_return_status OUT NOCOPY VARCHAR2
166 ,x_msg_count OUT NOCOPY NUMBER
167 ,x_msg_data OUT NOCOPY VARCHAR2
168 ,p_offerAdjustmentId IN NUMBER
169 , p_listLineId IN NUMBER
170 , x_listLineId IN NUMBER
171 , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
172 );
173
174 PROCEDURE process_old_td_discount
175 (
176 x_return_status OUT NOCOPY VARCHAR2
177 ,x_msg_count OUT NOCOPY NUMBER
178 ,x_msg_data OUT NOCOPY VARCHAR2
179 ,p_offerAdjustmentId IN NUMBER
180 );
181 PROCEDURE relateTdLines
182 (
183 x_return_status OUT NOCOPY VARCHAR2
184 ,x_msg_count OUT NOCOPY NUMBER
185 ,x_msg_data OUT NOCOPY VARCHAR2
186 ,p_offerAdjustmentId IN NUMBER
187 , p_listLineId IN NUMBER
188 , p_modifier_tbl IN QP_MODIFIERS_PUB.modifiers_tbl_type
189 );
190
191 PROCEDURE populateTdExclusion
192 (
193 x_return_status OUT NOCOPY VARCHAR2
194 ,x_msg_count OUT NOCOPY NUMBER
195 ,x_msg_data OUT NOCOPY VARCHAR2
196 , p_fromListLineId IN NUMBER
197 ,x_pricing_attr_tbl OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE
198 );
199
200 PROCEDURE processOldTdLine
201 (
202 x_return_status OUT NOCOPY VARCHAR2
203 ,x_msg_count OUT NOCOPY NUMBER
204 ,x_msg_data OUT NOCOPY VARCHAR2
205 ,p_offerAdjustmentId IN NUMBER
206 , p_listLineId IN NUMBER
207 );
208 /*PROCEDURE processNewStProducts
209 (
210 x_return_status OUT NOCOPY VARCHAR2
211 ,x_msg_count OUT NOCOPY NUMBER
212 ,x_msg_data OUT NOCOPY VARCHAR2
213 ,p_offerAdjNewLineId IN NUMBER
214 );
215 */
216 PROCEDURE createNewMtProduct
217 (
218 x_return_status OUT NOCOPY VARCHAR2
219 ,x_msg_count OUT NOCOPY NUMBER
220 ,x_msg_data OUT NOCOPY VARCHAR2
221 , p_offerAdjNewLineId IN NUMBER
222 , x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
223 );
224 PROCEDURE createNewBuyProduct
225 (
226 x_return_status OUT NOCOPY VARCHAR2
227 ,x_msg_count OUT NOCOPY NUMBER
228 ,x_msg_data OUT NOCOPY VARCHAR2
229 ,p_offerAdjNewLineId IN NUMBER
230 , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
231 );
232 PROCEDURE processNewBuyProduct
233 (
234 x_return_status OUT NOCOPY VARCHAR2
235 ,x_msg_count OUT NOCOPY NUMBER
236 ,x_msg_data OUT NOCOPY VARCHAR2
237 ,p_offerAdjNewLineId IN NUMBER
238 );
239
240 PROCEDURE processNewGetProduct
241 (
242 x_return_status OUT NOCOPY VARCHAR2
243 ,x_msg_count OUT NOCOPY NUMBER
244 ,x_msg_data OUT NOCOPY VARCHAR2
245 ,p_offerAdjNewLineId IN NUMBER
246 );
247 PROCEDURE processNewPgProducts
248 (
249 x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2
252 ,p_offerAdjustmentId IN NUMBER
253 );
254
255 END OZF_OFFER_ADJ_PVT;
256