[Home] [Help]
PACKAGE: APPS.OZF_PROMOTIONAL_OFFERS_PVT
Source
1 PACKAGE OZF_Promotional_Offers_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvopos.pls 120.2 2011/03/03 11:36:13 nirprasa ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Promotional_Offers_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- 17-Oct-2002 RSSHARMA added last_recal_date and buyer_name
12 -- Tue May 03 2005:3/35 PM RSSHARMA Added sales_method_flag field
13 -- Thu Mar 03 2011 nirprasa, ER11806714 Added percent_discount field
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- offers_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- offer_id
29 -- qp_list_header_id
30 -- offer_type
31 -- offer_code
32 -- activity_media_id
33 -- reusable
34 -- user_status_id
35 -- owner_id
36 -- wf_item_key
37 -- customer_reference
38 -- buying_group_contact_id
39 -- last_update_date
40 -- last_updated_by
41 -- creation_date
42 -- created_by
43 -- last_update_login
44 -- object_version_number
45 -- perf_date_from
46 -- perf_date_to
47 -- status_code
48 -- status_date
49 -- modifier_level_code
50 -- order_value_discount_type
51 -- offer_amount
52 -- lumpsum_amount
53 -- lumpsum_payment_type
54 -- custom_setup_id
55 -- security_group_id
56 -- budget_amount_tc
57 -- budget_amount_fc
58 -- transaction_currency_Code
59 -- functional_currency_code
60 -- distribution_type
61 -- qualifier_id
62 -- qualifier_type
63 -- account_closed_flag
64 -- budget_offer_yn
65 -- autopay_flag
66 -- autopay_days
67 -- autopay_method
68 -- autopay_party_attr
69 -- autopay_party_id
70 -- tier_level
71 -- na_rule_header_id
72 -- beneficiary_account_id
73 --
74 --
75 -- Required
76 --
77 -- Defaults
78 --
79 -- Note: This is automatic generated record definition, it includes all columns
80 -- defined in the table, developer must manually add or delete some of the attributes.
81 --
82 -- End of Comments
83
84 --===================================================================
85 TYPE offers_rec_type IS RECORD
86 (
87 offer_id NUMBER := FND_API.G_MISS_NUM,
88 qp_list_header_id NUMBER := FND_API.G_MISS_NUM,
89 offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
90 offer_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
91 activity_media_id NUMBER := FND_API.G_MISS_NUM,
92 reusable VARCHAR2(1) := FND_API.G_MISS_CHAR,
93 user_status_id NUMBER := FND_API.G_MISS_NUM,
94 owner_id NUMBER := FND_API.G_MISS_NUM,
95 wf_item_key VARCHAR2(120) := FND_API.G_MISS_CHAR,
96 customer_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
97 buying_group_contact_id NUMBER := FND_API.G_MISS_NUM,
98 last_update_date DATE := FND_API.G_MISS_DATE,
99 last_updated_by NUMBER := FND_API.G_MISS_NUM,
100 creation_date DATE := FND_API.G_MISS_DATE,
101 created_by NUMBER := FND_API.G_MISS_NUM,
102 last_update_login NUMBER := FND_API.G_MISS_NUM,
103 object_version_number NUMBER := FND_API.G_MISS_NUM,
104 perf_date_from DATE := FND_API.G_MISS_DATE,
105 perf_date_to DATE := FND_API.G_MISS_DATE,
106 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107 status_date DATE := FND_API.G_MISS_DATE,
108 modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109 order_value_discount_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110 offer_amount NUMBER := FND_API.G_MISS_NUM,
111 lumpsum_amount NUMBER := FND_API.G_MISS_NUM,
112 lumpsum_payment_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113 custom_setup_id NUMBER := FND_API.G_MISS_NUM,
114 security_group_id NUMBER := FND_API.G_MISS_NUM,
115 budget_amount_tc NUMBER := FND_API.G_MISS_NUM,
116 budget_amount_fc NUMBER := FND_API.G_MISS_NUM,
117 transaction_currency_Code VARCHAR2(15) := FND_API.G_MISS_CHAR,
118 functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119 distribution_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
120 qualifier_id NUMBER := FND_API.G_MISS_NUM,
121 qualifier_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122 account_closed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123 budget_offer_yn VARCHAR2(1) := FND_API.G_MISS_CHAR,
124 break_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
125 retroactive VARCHAR2(1) := FND_API.G_MISS_CHAR,
126 volume_offer_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
127 budget_source_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
128 budget_source_id NUMBER := FND_API.G_MISS_NUM,
129 confidential_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130 source_from_parent VARCHAR2(1) := FND_API.G_MISS_CHAR,
131 buyer_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
132 last_recal_date DATE := FND_API.G_MISS_DATE,
133 autopay_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134 autopay_days NUMBER := FND_API.G_MISS_NUM,
135 autopay_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
136 autopay_party_attr VARCHAR2(30) := FND_API.G_MISS_CHAR,
137 autopay_party_id NUMBER := FND_API.G_MISS_NUM,
138 tier_level VARCHAR2(30) := FND_API.G_MISS_CHAR,
139 na_rule_header_id NUMBER := FND_API.G_MISS_NUM,
140 beneficiary_account_id NUMBER := FND_API.G_MISS_NUM,
141 sales_method_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
142 org_id NUMBER := FND_API.G_MISS_NUM,
143 percent_discount NUMBER := FND_API.G_MISS_NUM /*nirprasa, added for ER11806714*/
144 );
145
146 g_miss_offers_rec offers_rec_type;
147 TYPE offers_tbl_type IS TABLE OF offers_rec_type INDEX BY BINARY_INTEGER;
148 g_miss_offers_tbl offers_tbl_type;
149
150 -- ==============================================================================
151 -- Start of Comments
152 -- ==============================================================================
153 -- API Name
154 -- Create_Offers
155 -- Type
156 -- Private
157 -- Pre-Req
158 --
159 -- Parameters
160 --
161 -- IN
162 -- p_api_version_number IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166 -- p_offers_rec IN offers_rec_type Required
167 --
168 -- OUT
169 -- x_return_status OUT VARCHAR2
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2
172 -- Version : Current version 1.0
173 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
174 -- and basic operation, developer must manually add parameters and business logic as necessary.
175 --
176 -- End of Comments
177 -- ==============================================================================
178 --
179
180 PROCEDURE Create_Offers(
181 p_api_version_number IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183 p_commit IN VARCHAR2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189
190 p_offers_rec IN offers_rec_type := g_miss_offers_rec,
191 x_offer_id OUT NOCOPY NUMBER
192 );
193
194 -- ==============================================================================
195 -- Start of Comments
196 -- ==============================================================================
197 -- API Name
198 -- Update_Offers
199 -- Type
200 -- Private
201 -- Pre-Req
202 --
203 -- Parameters
204 --
205 -- IN
206 -- p_api_version_number IN NUMBER Required
207 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210 -- p_offers_rec IN offers_rec_type Required
211 --
212 -- OUT
213 -- x_return_status OUT VARCHAR2
214 -- x_msg_count OUT NUMBER
215 -- x_msg_data OUT VARCHAR2
216 -- Version : Current version 1.0
217 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
218 -- and basic operation, developer must manually add parameters and business logic as necessary.
219 --
220 -- End of Comments
221 -- ==============================================================================
222 --
223
224 PROCEDURE Update_Offers(
225 p_api_version_number IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227 p_commit IN VARCHAR2 := FND_API.G_FALSE,
228 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233
234 p_offers_rec IN offers_rec_type,
235 x_object_version_number OUT NOCOPY NUMBER
236 );
237
238 -- ==============================================================================
239 -- Start of Comments
240 -- ==============================================================================
241 -- API Name
242 -- Delete_Offers
243 -- Type
244 -- Private
245 -- Pre-Req
246 --
247 -- Parameters
248 --
249 -- IN
250 -- p_api_version_number IN NUMBER Required
251 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254 -- p_OFFER_ID IN NUMBER
255 -- p_object_version_number IN NUMBER Optional Default = NULL
256 --
257 -- OUT
258 -- x_return_status OUT VARCHAR2
259 -- x_msg_count OUT NUMBER
260 -- x_msg_data OUT VARCHAR2
261 -- Version : Current version 1.0
262 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
263 -- and basic operation, developer must manually add parameters and business logic as necessary.
264 --
265 -- End of Comments
266 -- ==============================================================================
267 --
268
269 PROCEDURE Delete_Offers(
270 p_api_version_number IN NUMBER,
271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272 p_commit IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_offer_id IN NUMBER,
278 p_object_version_number IN NUMBER
279 );
280
281 -- ==============================================================================
282 -- Start of Comments
283 -- ==============================================================================
284 -- API Name
285 -- Lock_Offers
286 -- Type
287 -- Private
288 -- Pre-Req
289 --
290 -- Parameters
291 --
292 -- IN
293 -- p_api_version_number IN NUMBER Required
294 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297 -- p_offers_rec IN offers_rec_type Required
298 --
299 -- OUT
300 -- x_return_status OUT VARCHAR2
301 -- x_msg_count OUT NUMBER
302 -- x_msg_data OUT VARCHAR2
303 -- Version : Current version 1.0
304 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
305 -- and basic operation, developer must manually add parameters and business logic as necessary.
306 --
307 -- End of Comments
308 -- ==============================================================================
309 --
310
311 PROCEDURE Lock_Offers(
312 p_api_version_number IN NUMBER,
313 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318
319 p_offer_id IN NUMBER,
320 p_object_version IN NUMBER
321 );
322
323
324 -- Start of Comments
325 --
326 -- validation procedures
327 --
328 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
329 -- For create: G_CREATE, for update: G_UPDATE
330 -- Note: 1. This is automated generated item level validation procedure.
331 -- The actual validation detail is needed to be added.
332 -- 2. We can also validate table instead of record. There will be an option for user to choose.
333 -- End of Comments
334
335 PROCEDURE Validate_offers(
336 p_api_version_number IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339 p_offers_rec IN offers_rec_type,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2
343 );
344
345 -- Start of Comments
346 --
347 -- validation procedures
348 --
349 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
350 -- For create: G_CREATE, for update: G_UPDATE
351 -- Note: 1. This is automated generated item level validation procedure.
352 -- The actual validation detail is needed to be added.
353 -- 2. Validate the unique keys, lookups here
354 -- End of Comments
355
359 x_return_status OUT NOCOPY VARCHAR2
356 PROCEDURE Check_offers_Items (
357 P_offers_rec IN offers_rec_type,
358 p_validation_mode IN VARCHAR2,
360 );
361
362 -- Start of Comments
363 --
364 -- Record level validation procedures
365 --
366 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
367 -- For create: G_CREATE, for update: G_UPDATE
368 -- Note: 1. This is automated generated item level validation procedure.
369 -- The actual validation detail is needed to be added.
370 -- 2. Developer can manually added inter-field level validation.
371 -- End of Comments
372
373 PROCEDURE Validate_offers_rec(
374 p_api_version_number IN NUMBER,
375 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_offers_rec IN offers_rec_type
380 );
381
382
383 END OZF_Promotional_Offers_PVT;