[Home] [Help]
PACKAGE: APPS.OZF_OFFR_QUAL_PVT
Source
1 PACKAGE OZF_Offr_Qual_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvoqfs.pls 120.0 2005/06/01 02:40:45 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Offr_Qual_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
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 -- ozf_offr_qual_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- qualifier_id
29 -- creation_date
30 -- created_by
31 -- last_update_date
32 -- last_updated_by
33 -- last_update_login
34 -- qualifier_grouping_no
35 -- qualifier_context
36 -- qualifier_attribute
37 -- qualifier_attr_value
38 -- start_date_active
39 -- end_date_active
40 -- offer_id
41 -- offer_discount_line_id
42 -- context
43 -- attribute1
44 -- attribute2
45 -- attribute3
46 -- attribute4
47 -- attribute5
48 -- attribute6
49 -- attribute7
50 -- attribute8
51 -- attribute9
52 -- attribute10
53 -- attribute11
54 -- attribute12
55 -- attribute13
56 -- attribute14
57 -- attribute15
58 -- active_flag
59 --
60 -- Required
61 --
62 -- Defaults
63 --
64 -- Note: This is automatic generated record definition, it includes all columns
65 -- defined in the table, developer must manually add or delete some of the attributes.
66 --
67 -- End of Comments
68
69 --===================================================================
70 TYPE ozf_offr_qual_rec_type IS RECORD
71 (
72 qualifier_id NUMBER,
73 creation_date DATE,
74 created_by NUMBER,
75 last_update_date DATE,
76 last_updated_by NUMBER,
77 last_update_login NUMBER,
78 qualifier_grouping_no NUMBER,
79 qualifier_context VARCHAR2(30),
80 qualifier_attribute VARCHAR2(30),
81 qualifier_attr_value VARCHAR2(240),
82 start_date_active DATE,
83 end_date_active DATE,
84 offer_id NUMBER,
85 offer_discount_line_id NUMBER,
86 context VARCHAR2(30),
87 attribute1 VARCHAR2(240),
88 attribute2 VARCHAR2(240),
89 attribute3 VARCHAR2(240),
90 attribute4 VARCHAR2(240),
91 attribute5 VARCHAR2(240),
92 attribute6 VARCHAR2(240),
93 attribute7 VARCHAR2(240),
94 attribute8 VARCHAR2(240),
95 attribute9 VARCHAR2(240),
96 attribute10 VARCHAR2(240),
97 attribute11 VARCHAR2(240),
98 attribute12 VARCHAR2(240),
99 attribute13 VARCHAR2(240),
100 attribute14 VARCHAR2(240),
101 attribute15 VARCHAR2(240),
102 active_flag VARCHAR2(1),
103 object_version_number NUMBER
104 );
105
106 g_miss_ozf_offr_qual_rec ozf_offr_qual_rec_type := NULL;
107 TYPE ozf_offr_qual_tbl_type IS TABLE OF ozf_offr_qual_rec_type INDEX BY BINARY_INTEGER;
108 g_miss_ozf_offr_qual_tbl ozf_offr_qual_tbl_type;
109
110 -- ==============================================================================
111 -- Start of Comments
112 -- ==============================================================================
113 -- API Name
114 -- Create_Offr_Qual
115 -- Type
116 -- Private
117 -- Pre-Req
118 --
119 -- Parameters
120 --
121 -- IN
122 -- p_api_version_number IN NUMBER Required
123 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126 -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
127 --
128 -- OUT
129 -- x_return_status OUT VARCHAR2
130 -- x_msg_count OUT NUMBER
131 -- x_msg_data OUT VARCHAR2
132 -- Version : Current version 1.0
133 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
134 -- and basic operation, developer must manually add parameters and business logic as necessary.
135 --
136 -- History
137 --
138 -- NOTE
139 --
140 -- End of Comments
141 -- ==============================================================================
142
143 PROCEDURE Create_Offr_Qual(
144 p_api_version_number IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146 p_commit IN VARCHAR2 := FND_API.G_FALSE,
147 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152
153 p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type ,
154 x_qualifier_id OUT NOCOPY NUMBER
155 );
156
157 -- ==============================================================================
158 -- Start of Comments
159 -- ==============================================================================
160 -- API Name
161 -- Update_Offr_Qual
162 -- Type
163 -- Private
164 -- Pre-Req
165 --
166 -- Parameters
167 --
168 -- IN
169 -- p_api_version_number IN NUMBER Required
170 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173 -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
174 --
175 -- OUT
176 -- x_return_status OUT VARCHAR2
177 -- x_msg_count OUT NUMBER
178 -- x_msg_data OUT VARCHAR2
179 -- Version : Current version 1.0
180 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
181 -- and basic operation, developer must manually add parameters and business logic as necessary.
182 --
183 -- History
184 --
185 -- NOTE
186 --
187 -- End of Comments
188 -- ==============================================================================
189
190 PROCEDURE Update_Offr_Qual(
191 p_api_version_number IN NUMBER,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193 p_commit IN VARCHAR2 := FND_API.G_FALSE,
194 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199
200 p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type
201 );
202
203 -- ==============================================================================
204 -- Start of Comments
205 -- ==============================================================================
206 -- API Name
207 -- Delete_Offr_Qual
208 -- Type
209 -- Private
210 -- Pre-Req
211 --
212 -- Parameters
213 --
214 -- IN
215 -- p_api_version_number IN NUMBER Required
216 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219 -- p_qualifier_id IN NUMBER
220 -- p_object_version_number IN NUMBER Optional Default = NULL
221 --
222 -- OUT
223 -- x_return_status OUT VARCHAR2
224 -- x_msg_count OUT NUMBER
225 -- x_msg_data OUT VARCHAR2
226 -- Version : Current version 1.0
227 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
228 -- and basic operation, developer must manually add parameters and business logic as necessary.
229 --
230 -- History
231 --
232 -- NOTE
233 --
234 -- End of Comments
235 -- ==============================================================================
236
237 PROCEDURE Delete_Offr_Qual(
238 p_api_version_number IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240 p_commit IN VARCHAR2 := FND_API.G_FALSE,
241 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_qualifier_id IN NUMBER,
246 p_object_version_number IN NUMBER
247 );
248
249 -- ==============================================================================
250 -- Start of Comments
251 -- ==============================================================================
252 -- API Name
253 -- Lock_Offr_Qual
254 -- Type
255 -- Private
256 -- Pre-Req
257 --
258 -- Parameters
259 --
260 -- IN
261 -- p_api_version_number IN NUMBER Required
262 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
263 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
264 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
265 -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
266 --
267 -- OUT
268 -- x_return_status OUT VARCHAR2
269 -- x_msg_count OUT NUMBER
270 -- x_msg_data OUT VARCHAR2
271 -- Version : Current version 1.0
272 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
273 -- and basic operation, developer must manually add parameters and business logic as necessary.
274 --
275 -- History
276 --
277 -- NOTE
278 --
279 -- End of Comments
280 -- ==============================================================================
281
282 PROCEDURE Lock_Offr_Qual(
283 p_api_version_number IN NUMBER,
284 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2,
289
290 p_qualifier_id IN NUMBER,
291 p_object_version IN NUMBER
292 );
293
294
295 -- ==============================================================================
296 -- Start of Comments
297 -- ==============================================================================
298 -- API Name
299 -- Validate_Offr_Qual
300 --
301 -- Version : Current version 1.0
302 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
303 -- For create: G_CREATE, for update: G_UPDATE
304 -- Note: 1. This is automated generated item level validation procedure.
305 -- The actual validation detail is needed to be added.
306 -- 2. We can also validate table instead of record. There will be an option for user to choose.
307 --
308 -- History
309 --
310 -- NOTE
311 --
312 -- End of Comments
313 -- ==============================================================================
314
315
316 PROCEDURE Validate_Offr_Qual(
317 p_api_version_number IN NUMBER,
318 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320 p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type,
321 p_validation_mode IN VARCHAR2,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_count OUT NOCOPY NUMBER,
324 x_msg_data OUT NOCOPY VARCHAR2
325 );
326
327 -- ==============================================================================
328 -- Start of Comments
329 -- ==============================================================================
330 -- API Name
331 -- Ozf_Offr_Qual_Rec_Type_Items
332 --
333 -- Version : Current version 1.0
334 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
335 -- For create: G_CREATE, for update: G_UPDATE
336 -- Note: 1. This is automated generated item level validation procedure.
337 -- The actual validation detail is needed to be added.
338 -- 2. Validate the unique keys, lookups here
339 --
340 -- History
341 --
342 -- NOTE
343 --
344 -- End of Comments
345 -- ==============================================================================
346
347
348 PROCEDURE Check_Ozf_Offr_Qual_Items (
349 p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type,
350 p_validation_mode IN VARCHAR2,
351 x_return_status OUT NOCOPY VARCHAR2
352 );
353
354 -- ==============================================================================
355 -- Start of Comments
356 -- ==============================================================================
357 -- API Name
358 -- Validate_Ozf_Offr_Qual_Rec
359 --
360 -- Version : Current version 1.0
361 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
362 -- For create: G_CREATE, for update: G_UPDATE
363 -- Note: 1. This is automated generated item level validation procedure.
364 -- The actual validation detail is needed to be added.
365 -- 2. Developer can manually added inter-field level validation.
366 --
367 -- History
368 --
369 -- NOTE
370 --
371 -- End of Comments
372 -- ==============================================================================
373
374
375 PROCEDURE Validate_Ozf_Offr_Qual_Rec (
376 p_api_version_number IN NUMBER,
377 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378 x_return_status OUT NOCOPY VARCHAR2,
379 x_msg_count OUT NOCOPY NUMBER,
380 x_msg_data OUT NOCOPY VARCHAR2,
381 p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type
382 );
383
384 END OZF_Offr_Qual_PVT;