1 PACKAGE OZF_Adj_New_Line_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvanls.pls 120.0 2006/03/30 13:53:47 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Adj_New_Line_PVT
7 -- Purpose
8 --
9 -- History
10 --
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 -- adj_new_line_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- offer_adj_new_line_id
26 -- offer_adjustment_id
27 -- volume_from
28 -- volume_to
29 -- volume_type
30 -- discount
31 -- discount_type
32 -- tier_type
33 -- creation_date
34 -- created_by
35 -- last_update_date
36 -- last_updated_by
37 -- last_update_login
38 -- object_version_number
39 --
40 -- Required
41 --
42 -- Defaults
43 --
44 -- Note: This is automatic generated record definition, it includes all columns
45 -- defined in the table, developer must manually add or delete some of the attributes.
46 --
47 -- End of Comments
48
49 --===================================================================
50 TYPE adj_new_line_rec_type IS RECORD
51 (
52 offer_adj_new_line_id NUMBER ,
53 offer_adjustment_id NUMBER ,
54 volume_from NUMBER ,
55 volume_to NUMBER ,
56 volume_type VARCHAR2(30) ,
57 discount NUMBER ,
58 discount_type VARCHAR2(30) ,
59 tier_type VARCHAR2(30) ,
60 td_discount NUMBER ,
61 td_discount_type VARCHAR2(30) ,
62 quantity NUMBER ,
63 benefit_price_list_line_id NUMBER ,
64 parent_adj_line_id NUMBER ,
65 start_date_active DATE,
66 end_date_active DATE,
67 creation_date DATE ,
68 created_by NUMBER ,
69 last_update_date DATE ,
70 last_updated_by NUMBER ,
71 last_update_login NUMBER ,
72 object_version_number NUMBER
73 );
74
75 g_miss_adj_new_line_rec adj_new_line_rec_type;
76 TYPE adj_new_line_tbl_type IS TABLE OF adj_new_line_rec_type INDEX BY BINARY_INTEGER;
77 g_miss_adj_new_line_tbl adj_new_line_tbl_type;
78
79 TYPE adj_new_disc_rec_type IS RECORD
80 (
81 offer_adj_new_line_id NUMBER ,
82 offer_adjustment_id NUMBER ,
83 volume_from NUMBER ,
84 volume_to NUMBER ,
85 volume_type VARCHAR2(30) ,
86 discount NUMBER ,
87 discount_type VARCHAR2(30) ,
88 tier_type VARCHAR2(30) ,
89 td_discount NUMBER ,
90 td_discount_type VARCHAR2(30) ,
91 quantity NUMBER ,
92 benefit_price_list_line_id NUMBER ,
93 parent_adj_line_id NUMBER ,
94 offer_adj_new_product_id NUMBER ,
95 product_context VARCHAR2(30) ,
96 product_attribute VARCHAR2(30) ,
97 product_attr_value VARCHAR2(240) ,
98 excluder_flag VARCHAR2(1) ,
99 uom_code VARCHAR2(30) ,
100 start_date_active DATE,
101 end_date_active DATE,
102 creation_date DATE ,
103 created_by NUMBER ,
104 last_update_date DATE ,
105 last_updated_by NUMBER ,
106 last_update_login NUMBER ,
107 object_version_number NUMBER ,
108 prod_obj_version_number NUMBER
109 );
110
111 g_miss_adj_new_disc_rec adj_new_disc_rec_type;
112 TYPE adj_new_disc_tbl_type IS TABLE OF adj_new_disc_rec_type INDEX BY BINARY_INTEGER;
113 g_miss_adj_new_disc_tbl adj_new_disc_tbl_type;
114
115
116 -- ==============================================================================
117 -- Start of Comments
118 -- ==============================================================================
119 -- API Name
120 -- Create_Adj_New_Line
121 -- Type
122 -- Private
123 -- Pre-Req
124 --
125 -- Parameters
126 --
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132 -- p_adj_new_line_rec IN adj_new_line_rec_type Required
133 --
134 -- OUT
135 -- x_return_status OUT VARCHAR2
136 -- x_msg_count OUT NUMBER
137 -- x_msg_data OUT VARCHAR2
138 -- Version : Current version 1.0
139 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
140 -- and basic operation, developer must manually add parameters and business logic as necessary.
141 --
142 -- End of Comments
143 -- ==============================================================================
144 --
145
146 PROCEDURE Create_Adj_New_Line(
147 p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155
156 p_adj_new_line_rec IN adj_new_line_rec_type := g_miss_adj_new_line_rec,
157 x_offer_adj_new_line_id OUT NOCOPY NUMBER
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Update_Adj_New_Line
165 -- Type
166 -- Private
167 -- Pre-Req
168 --
169 -- Parameters
170 --
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_adj_new_line_rec IN adj_new_line_rec_type Required
177 --
178 -- OUT
179 -- x_return_status OUT NOCOPY VARCHAR2
180 -- x_msg_count OUT NOCOPY NUMBER
181 -- x_msg_data OUT NOCOPY VARCHAR2
182 -- Version : Current version 1.0
183 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
184 -- and basic operation, developer must manually add parameters and business logic as necessary.
185 --
186 -- End of Comments
187 -- ==============================================================================
188 --
189
190 PROCEDURE Update_Adj_New_Line(
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_adj_new_line_rec IN adj_new_line_rec_type,
201 x_object_version_number OUT NOCOPY NUMBER
202 );
203
204 -- ==============================================================================
205 -- Start of Comments
206 -- ==============================================================================
207 -- API Name
208 -- Delete_Adj_New_Line
209 -- Type
210 -- Private
211 -- Pre-Req
212 --
213 -- Parameters
214 --
215 -- IN
216 -- p_api_version_number IN NUMBER Required
217 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220 -- p_OFFER_ADJ_NEW_LINE_ID IN NUMBER
221 -- p_object_version_number IN NUMBER Optional Default = NULL
222 --
223 -- OUT
224 -- x_return_status OUT NOCOPY VARCHAR2
225 -- x_msg_count OUT NOCOPY NUMBER
226 -- x_msg_data OUT NOCOPY VARCHAR2
227 -- Version : Current version 1.0
228 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
229 -- and basic operation, developer must manually add parameters and business logic as necessary.
230 --
231 -- End of Comments
232 -- ==============================================================================
233 --
234
235 PROCEDURE Delete_Adj_New_Line(
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_adj_new_line_id IN NUMBER,
244 p_object_version_number IN NUMBER
245 );
246
247 -- ==============================================================================
248 -- Start of Comments
249 -- ==============================================================================
250 -- API Name
251 -- Lock_Adj_New_Line
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_adj_new_line_rec IN adj_new_line_rec_type Required
264 --
265 -- OUT
266 -- x_return_status OUT NOCOPY VARCHAR2
267 -- x_msg_count OUT NOCOPY NUMBER
268 -- x_msg_data OUT NOCOPY 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 -- End of Comments
274 -- ==============================================================================
275 --
276
277 PROCEDURE Lock_Adj_New_Line(
278 p_api_version_number IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284
285 p_offer_adj_new_line_id IN NUMBER,
286 p_object_version IN NUMBER
287 );
288
289
290 -- Start of Comments
291 --
292 -- validation procedures
293 --
294 -- p_validation_mode is a constant defined in AMS_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. We can also validate table instead of record. There will be an option for user to choose.
299 -- End of Comments
300
301
302 PROCEDURE Validate_adj_new_line(
303 p_api_version_number IN NUMBER,
304 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
307 p_adj_new_line_rec IN adj_new_line_rec_type,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2
311 );
312
313 -- Start of Comments
314 --
315 -- validation procedures
316 --
317 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
318 -- For create: G_CREATE, for update: G_UPDATE
319 -- Note: 1. This is automated generated item level validation procedure.
320 -- The actual validation detail is needed to be added.
321 -- 2. Validate the unique keys, lookups here
322 -- End of Comments
323
324 PROCEDURE Check_adj_new_line_Items (
325 P_adj_new_line_rec IN adj_new_line_rec_type,
326 p_validation_mode IN VARCHAR2,
327 x_return_status OUT NOCOPY VARCHAR2
328 );
329
330 -- Start of Comments
331 --
332 -- Record level validation procedures
333 --
334 -- p_validation_mode is a constant defined in AMS_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. Developer can manually added inter-field level validation.
339 -- End of Comments
340
341 PROCEDURE Validate_adj_new_line_rec(
342 p_api_version_number IN NUMBER,
343 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_adj_new_line_rec IN adj_new_line_rec_type
348 );
349
350 PROCEDURE Create_Adj_New_Disc(
351 p_api_version_number IN NUMBER,
352 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353 p_commit IN VARCHAR2 := FND_API.G_FALSE,
354 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER,
358 x_msg_data OUT NOCOPY VARCHAR2,
359
360 p_adj_new_disc_rec IN adj_new_disc_rec_type := g_miss_adj_new_disc_rec,
361 x_offer_adj_new_line_id OUT NOCOPY NUMBER
362 );
363
364 PROCEDURE Update_Adj_New_Disc(
365 p_api_version_number IN NUMBER,
366 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367 p_commit IN VARCHAR2 := FND_API.G_FALSE,
368 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369
370 x_return_status OUT NOCOPY VARCHAR2,
371 x_msg_count OUT NOCOPY NUMBER,
372 x_msg_data OUT NOCOPY VARCHAR2,
373
374 p_adj_new_disc_rec IN adj_new_disc_rec_type,
375 x_object_version_number OUT NOCOPY NUMBER
376 );
377
378
379 END OZF_Adj_New_Line_PVT;