1 PACKAGE OZF_Offer_Backdate_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvobds.pls 120.2 2006/03/29 18:03:46 rssharma ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Offer_Backdate_PVT
7 -- Purpose
8 --
9 -- History
10 -- Wed Mar 29 2006:5/47 PM RSSHARMA Added new procedures to close adjustments and changed update_offer_discounts for new adjustments functionality
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- offer_backdate_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- offer_adjustment_id
26 -- effective_date
27 -- approved_date
28 -- settlement_code
29 -- status_code
30 -- list_header_id
31 -- version
32 -- budget_adjusted_flag
33 -- comments
34 -- last_update_date
35 -- last_updated_by
36 -- creation_date
37 -- created_by
38 -- last_update_login
39 -- object_version_number
40 -- security_group_id
41 --
42 -- Required
43 --
44 -- Defaults
45 --
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50 -- Thu Aug 19 1999:6/43 AM RSSHARMA Added procedure process_vo_adjustments for processing volume offer adjustments
51
52 --===================================================================
53 TYPE offer_backdate_rec_type IS RECORD
54 (
55 offer_adjustment_id NUMBER,
56 effective_date DATE,
57 approved_date DATE,
58 settlement_code VARCHAR2(30),
59 status_code VARCHAR2(30),
60 list_header_id NUMBER,
61 version NUMBER,
62 budget_adjusted_flag VARCHAR2(1),
63 comments VARCHAR2(2000),
64 last_update_date DATE,
65 last_updated_by NUMBER,
66 creation_date DATE,
67 created_by NUMBER,
68 last_update_login NUMBER,
69 object_version_number NUMBER,
70 security_group_id NUMBER
71 );
72
73 g_miss_offer_backdate_rec offer_backdate_rec_type;
74 TYPE offer_backdate_tbl_type IS TABLE OF offer_backdate_rec_type INDEX BY BINARY_INTEGER;
75 g_miss_offer_backdate_tbl offer_backdate_tbl_type;
76
77 -- ==============================================================================
78 -- Start of Comments
79 -- ==============================================================================
80 -- API Name
81 -- Create_Offer_Backdate
82 -- Type
83 -- Private
84 -- Pre-Req
85 --
86 -- Parameters
87 --
88 -- IN
89 -- p_api_version_number IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93 -- p_offer_backdate_rec IN offer_backdate_rec_type Required
94 --
95 -- OUT NOCOPY
96 -- x_return_status OUT NOCOPY VARCHAR2
97 -- x_msg_count OUT NOCOPY NUMBER
98 -- x_msg_data OUT NOCOPY VARCHAR2
99 -- Version : Current version 1.0
100 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
101 -- and basic operation, developer must manually add parameters and business logic as necessary.
102 --
103 -- End of Comments
104 -- ==============================================================================
105 --
106
107 PROCEDURE Create_Offer_Backdate(
108 p_api_version_number IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116
117 p_offer_backdate_rec IN offer_backdate_rec_type := g_miss_offer_backdate_rec,
118 x_offer_adjustment_id OUT NOCOPY NUMBER
119 );
120
121 -- ==============================================================================
122 -- Start of Comments
123 -- ==============================================================================
124 -- API Name
125 -- Update_Offer_Backdate
126 -- Type
127 -- Private
128 -- Pre-Req
129 --
130 -- Parameters
131 --
132 -- IN
133 -- p_api_version_number IN NUMBER Required
134 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137 -- p_offer_backdate_rec IN offer_backdate_rec_type Required
138 --
139 -- OUT NOCOPY
140 -- x_return_status OUT NOCOPY VARCHAR2
141 -- x_msg_count OUT NOCOPY NUMBER
142 -- x_msg_data OUT NOCOPY VARCHAR2
143 -- Version : Current version 1.0
144 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
145 -- and basic operation, developer must manually add parameters and business logic as necessary.
146 --
147 -- End of Comments
148 -- ==============================================================================
149 --
150
151 PROCEDURE Update_Offer_Backdate(
152 p_api_version_number IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160
161 p_offer_backdate_rec IN offer_backdate_rec_type,
162 x_object_version_number OUT NOCOPY NUMBER
163 );
164
165 -- ==============================================================================
166 -- Start of Comments
167 -- ==============================================================================
168 -- API Name
169 -- Delete_Offer_Backdate
170 -- Type
171 -- Private
172 -- Pre-Req
173 --
174 -- Parameters
175 --
176 -- IN
177 -- p_api_version_number IN NUMBER Required
178 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181 -- p_OFFER_ADJUSTMENT_ID IN NUMBER
182 -- p_object_version_number IN NUMBER Optional Default = NULL
183 --
184 -- OUT
185 -- x_return_status OUT VARCHAR2
186 -- x_msg_count OUT NUMBER
187 -- x_msg_data OUT VARCHAR2
188 -- Version : Current version 1.0
189 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
190 -- and basic operation, developer must manually add parameters and business logic as necessary.
191 --
192 -- End of Comments
193 -- ==============================================================================
194 --
195
196 PROCEDURE Delete_Offer_Backdate(
197 p_api_version_number IN NUMBER,
198 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199 p_commit IN VARCHAR2 := FND_API.G_FALSE,
200 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_offer_adjustment_id IN NUMBER,
205 p_object_version_number IN NUMBER
206 );
207
208 -- ==============================================================================
209 -- Start of Comments
210 -- ==============================================================================
211 -- API Name
212 -- Lock_Offer_Backdate
213 -- Type
214 -- Private
215 -- Pre-Req
216 --
217 -- Parameters
218 --
219 -- IN
220 -- p_api_version_number IN NUMBER Required
221 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
222 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
223 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
224 -- p_offer_backdate_rec IN offer_backdate_rec_type Required
225 --
226 -- OUT
227 -- x_return_status OUT VARCHAR2
228 -- x_msg_count OUT NUMBER
229 -- x_msg_data OUT VARCHAR2
230 -- Version : Current version 1.0
231 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
232 -- and basic operation, developer must manually add parameters and business logic as necessary.
233 --
234 -- End of Comments
235 -- ==============================================================================
236 --
237
238 PROCEDURE Lock_Offer_Backdate(
239 p_api_version_number IN NUMBER,
240 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245
246 p_offer_adjustment_id IN NUMBER,
247 p_object_version IN NUMBER
248 );
249
250
251 -- Start of Comments
252 --
253 -- validation procedures
254 --
255 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
256 -- For create: G_CREATE, for update: G_UPDATE
257 -- Note: 1. This is automated generated item level validation procedure.
258 -- The actual validation detail is needed to be added.
259 -- 2. We can also validate table instead of record. There will be an option for user to choose.
260 -- End of Comments
261
262 PROCEDURE Validate_offer_backdate(
263 p_api_version_number IN NUMBER,
264 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
265 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266 p_offer_backdate_rec IN offer_backdate_rec_type,
267 p_validation_mode IN VARCHAR2,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2
271 );
272
273 -- Start of Comments
274 --
275 -- validation procedures
276 --
277 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
278 -- For create: G_CREATE, for update: G_UPDATE
279 -- Note: 1. This is automated generated item level validation procedure.
280 -- The actual validation detail is needed to be added.
281 -- 2. Validate the unique keys, lookups here
282 -- End of Comments
283
284 PROCEDURE Check_offer_backdate_Items (
285 P_offer_backdate_rec IN offer_backdate_rec_type,
286 p_validation_mode IN VARCHAR2,
287 x_return_status OUT NOCOPY VARCHAR2
288 );
289
290 -- Start of Comments
291 --
292 -- Record level validation procedures
293 --
294 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
295 -- For create: G_CREATE, for update: G_UPDATE
296 -- Note: 1. This is automated generated item level validation procedure.
297 -- The actual validation detail is needed to be added.
298 -- 2. Developer can manually added inter-field level validation.
299 -- End of Comments
300
301 PROCEDURE Validate_offer_backdate_rec(
302 p_api_version_number IN NUMBER,
303 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_offer_backdate_rec IN offer_backdate_rec_type
308 );
309
310 PROCEDURE Create_Initial_Adj(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
313 p_commit IN VARCHAR2 := FND_API.g_false,
314 p_obj_id IN NUMBER,
315 p_obj_type IN VARCHAR2,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2
319 );
320
321 PROCEDURE Update_Offer_Discounts
322 (
323 p_init_msg_list IN VARCHAR2 := FND_API.g_false
324 ,p_api_version IN NUMBER
325 ,p_commit IN VARCHAR2 := FND_API.g_false
326 ,x_return_status OUT NOCOPY VARCHAR2
327 ,x_msg_count OUT NOCOPY NUMBER
328 ,x_msg_data OUT NOCOPY VARCHAR2
329 ,p_offer_adjustment_id IN NUMBER
330 );
331
332 PROCEDURE process_vo_adjustments
333 (
334 p_init_msg_list IN VARCHAR2 := FND_API.g_false
335 ,p_api_version IN NUMBER
336 ,p_commit IN VARCHAR2 := FND_API.g_false
337 ,x_return_status OUT NOCOPY VARCHAR2
338 ,x_msg_count OUT NOCOPY NUMBER
339 ,x_msg_data OUT NOCOPY VARCHAR2
340 ,p_offer_adjustment_id IN NUMBER
341
342 );
343
344 PROCEDURE close_adjustment
345 (
346 p_offer_adjustment_id IN NUMBER
347 ,x_return_status OUT NOCOPY VARCHAR2
348 ,x_msg_count OUT NOCOPY NUMBER
349 ,x_msg_data OUT NOCOPY VARCHAR2
350 );
351
352 PROCEDURE getCloseAdjustmentParams
353 (
354 p_offer_adjustment_id IN NUMBER
355 ,x_return_status OUT NOCOPY VARCHAR2
356 ,x_msg_count OUT NOCOPY NUMBER
357 ,x_msg_data OUT NOCOPY VARCHAR2
358 ,x_newStatus OUT NOCOPY VARCHAR2
359 ,x_budgetAdjFlag OUT NOCOPY VARCHAR2
360 );
361 END OZF_Offer_Backdate_PVT;
362