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