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