[Home] [Help]
PACKAGE: APPS.OZF_AE_LINE_PVT
Source
1 PACKAGE OZF_Ae_Line_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvaels.pls 115.4 2003/11/19 08:22:47 upoluri ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Ae_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 -- ae_line_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- ae_line_id
26 -- object_version_number
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- request_id
33 -- program_application_id
34 -- program_update_date
35 -- program_id
36 -- accounted_cr
37 -- accounted_dr
38 -- accounting_error_code
39 -- ae_header_id
40 -- ae_line_number
41 -- ae_line_type_code
42 -- applied_from_trx_hdr_id
43 -- applied_from_trx_hdr_table
44 -- applied_to_trx_hdr_id
45 -- applied_to_trx_hdr_table
46 -- code_combination_id
47 -- currency_code
48 -- currency_conversion_date
49 -- currency_conversion_rate
50 -- currency_conversion_type
51 -- description
52 -- entered_cr
53 -- entered_dr
54 -- gl_sl_link_id
55 -- gl_transfer_error_code
56 -- org_id
57 -- reference1
58 -- reference2
59 -- reference3
60 -- reference4
61 -- reference5
62 -- reference6
63 -- reference7
64 -- reference8
65 -- reference9
66 -- reference10
67 -- source_id
68 -- source_table
69 -- stat_amount
70 -- subledger_doc_sequence_id
71 -- subledger_doc_sequence_value
72 -- taxable_accounted_cr
73 -- taxable_accounted_dr
74 -- taxable_entered_cr
75 -- taxable_entered_dr
76 -- tax_code_id
77 -- tax_link_id
78 -- third_party_id
79 -- third_party_sub_id
80 -- third_party_type
81 -- ussgl_transaction_code
82 -- attribute_category
83 -- attribute1
84 -- attribute2
85 -- attribute3
86 -- attribute4
87 -- attribute5
88 -- attribute6
89 -- attribute7
90 -- attribute8
91 -- attribute9
92 -- attribute10
93 -- attribute11
94 -- attribute12
95 -- attribute13
96 -- attribute14
97 -- attribute15
98 --
99 -- Required
100 --
101 -- Defaults
102 --
103 -- Note: This is automatic generated record definition, it includes all columns
104 -- defined in the table, developer must manually add or delete some of the attributes.
105 --
106 -- End of Comments
107
108 --===================================================================
109 TYPE ae_line_rec_type IS RECORD
110 (
111 ae_line_id NUMBER,-- := FND_API.G_MISS_NUM,
112 object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
113 last_update_date DATE,-- := FND_API.G_MISS_DATE,
114 last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
115 creation_date DATE,-- := FND_API.G_MISS_DATE,
116 created_by NUMBER,-- := FND_API.G_MISS_NUM,
117 last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
118 request_id NUMBER,-- := FND_API.G_MISS_NUM,
119 program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
120 program_update_date DATE,-- := FND_API.G_MISS_DATE,
121 program_id NUMBER,-- := FND_API.G_MISS_NUM,
122 accounted_cr NUMBER,-- := FND_API.G_MISS_NUM,
123 accounted_dr NUMBER,-- := FND_API.G_MISS_NUM,
124 accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
125 ae_header_id NUMBER,-- := FND_API.G_MISS_NUM,
126 ae_line_number NUMBER,-- := FND_API.G_MISS_NUM,
127 ae_line_type_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
128 applied_from_trx_hdr_id NUMBER,-- := FND_API.G_MISS_NUM,
129 applied_from_trx_hdr_table VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
130 applied_to_trx_hdr_id NUMBER,-- := FND_API.G_MISS_NUM,
131 applied_to_trx_hdr_table VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
132 code_combination_id NUMBER,-- := FND_API.G_MISS_NUM,
133 currency_code VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
134 currency_conversion_date DATE,-- := FND_API.G_MISS_DATE,
135 currency_conversion_rate NUMBER,-- := FND_API.G_MISS_NUM,
136 currency_conversion_type VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
137 description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
138 entered_cr NUMBER,-- := FND_API.G_MISS_NUM,
139 entered_dr NUMBER,-- := FND_API.G_MISS_NUM,
140 gl_sl_link_id NUMBER,-- := FND_API.G_MISS_NUM,
141 gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
142 org_id NUMBER,-- := FND_API.G_MISS_NUM,
143 reference1 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
144 reference2 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
145 reference3 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
146 reference4 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
147 reference5 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
148 reference6 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
149 reference7 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
150 reference8 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
151 reference9 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
152 reference10 VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
153 source_id NUMBER,-- := FND_API.G_MISS_NUM,
154 source_table VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
155 stat_amount NUMBER,-- := FND_API.G_MISS_NUM,
156 subledger_doc_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
157 subledger_doc_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
158 taxable_accounted_cr NUMBER,-- := FND_API.G_MISS_NUM,
159 taxable_accounted_dr NUMBER,-- := FND_API.G_MISS_NUM,
160 taxable_entered_cr NUMBER,-- := FND_API.G_MISS_NUM,
161 taxable_entered_dr NUMBER,-- := FND_API.G_MISS_NUM,
162 tax_code_id NUMBER,-- := FND_API.G_MISS_NUM,
163 tax_link_id NUMBER,-- := FND_API.G_MISS_NUM,
164 third_party_id NUMBER,-- := FND_API.G_MISS_NUM,
165 third_party_sub_id NUMBER,-- := FND_API.G_MISS_NUM,
166 third_party_type VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
167 ussgl_transaction_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
168 attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
169 attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
170 attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
171 attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
172 attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
173 attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
174 attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
175 attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
176 attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
177 attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
178 attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
179 attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
180 attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
181 attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
182 attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
183 attribute15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
184 );
185
186 g_miss_ae_line_rec ae_line_rec_type;
187 TYPE ae_line_tbl_type IS TABLE OF ae_line_rec_type;
188 g_miss_ae_line_tbl ae_line_tbl_type;
189 TYPE number_tbl_type IS TABLE OF NUMBER;
190
191 -- ==============================================================================
192 -- Start of Comments
193 -- ==============================================================================
194 -- API Name
195 -- Create_Ae_Line
196 -- Type
197 -- Private
198 -- Pre-Req
199 --
200 -- Parameters
201 --
202 -- IN
203 -- p_api_version_number IN NUMBER Required
204 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
206 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
207 -- p_ae_line_tbl IN ae_line_tbl_type Required
208 --
209 -- OUT
210 -- x_return_status OUT VARCHAR2
211 -- x_msg_count OUT NUMBER
212 -- x_msg_data OUT VARCHAR2
213 -- Version : Current version 1.0
214 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
215 -- and basic operation, developer must manually add parameters and business logic as necessary.
216 --
217 -- End of Comments
218 -- ==============================================================================
219 --
220
221 PROCEDURE Create_Ae_Line(
222 p_api_version_number IN NUMBER,
223 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224 p_commit IN VARCHAR2 := FND_API.G_FALSE,
225 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230
231 p_ae_line_tbl IN ae_line_tbl_type := g_miss_ae_line_tbl,
232 x_ae_line_id OUT NOCOPY number_tbl_type
233 );
234
235 -- ==============================================================================
236 -- Start of Comments
237 -- ==============================================================================
238 -- API Name
239 -- Update_Ae_Line
240 -- Type
241 -- Private
242 -- Pre-Req
243 --
244 -- Parameters
245 --
246 -- IN
247 -- p_api_version_number IN NUMBER Required
248 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
249 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
250 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254 -- x_return_status OUT VARCHAR2
251 -- p_ae_line_rec IN ae_line_rec_type Required
252 --
253 -- OUT
255 -- x_msg_count OUT NUMBER
256 -- x_msg_data OUT VARCHAR2
257 -- Version : Current version 1.0
258 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
259 -- and basic operation, developer must manually add parameters and business logic as necessary.
260 --
261 -- End of Comments
262 -- ==============================================================================
263 --
264
265 PROCEDURE Update_Ae_Line(
266 p_api_version_number IN NUMBER,
267 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268 p_commit IN VARCHAR2 := FND_API.G_FALSE,
269 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274
275 p_ae_line_rec IN ae_line_rec_type,
276 x_object_version_number OUT NOCOPY NUMBER
277 );
278
279 -- ==============================================================================
280 -- Start of Comments
281 -- ==============================================================================
282 -- API Name
283 -- Delete_Ae_Line
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_AE_LINE_ID IN NUMBER
296 -- p_object_version_number IN NUMBER Optional Default = NULL
297 --
298 -- OUT
299 -- x_return_status OUT VARCHAR2
300 -- x_msg_count OUT NUMBER
301 -- x_msg_data OUT VARCHAR2
302 -- Version : Current version 1.0
303 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
304 -- and basic operation, developer must manually add parameters and business logic as necessary.
305 --
306 -- End of Comments
307 -- ==============================================================================
308 --
309
310 PROCEDURE Delete_Ae_Line(
311 p_api_version_number IN NUMBER,
312 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313 p_commit IN VARCHAR2 := FND_API.G_FALSE,
314 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_ae_line_id IN NUMBER,
319 p_object_version_number IN NUMBER
320 );
321
322 -- ==============================================================================
323 -- Start of Comments
324 -- ==============================================================================
325 -- API Name
326 -- Lock_Ae_Line
327 -- Type
328 -- Private
329 -- Pre-Req
330 --
331 -- Parameters
332 --
333 -- IN
334 -- p_api_version_number IN NUMBER Required
335 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
336 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
337 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
338 -- p_ae_line_rec IN ae_line_rec_type Required
339 --
340 -- OUT
341 -- x_return_status OUT VARCHAR2
342 -- x_msg_count OUT NUMBER
343 -- x_msg_data OUT VARCHAR2
344 -- Version : Current version 1.0
345 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
346 -- and basic operation, developer must manually add parameters and business logic as necessary.
347 --
348 -- End of Comments
349 -- ==============================================================================
350 --
351
352 PROCEDURE Lock_Ae_Line(
353 p_api_version_number IN NUMBER,
354 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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_ae_line_id IN NUMBER,
361 p_object_version IN NUMBER
362 );
363
364
365 -- Start of Comments
366 --
367 -- validation procedures
368 --
369 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
370 -- For create: G_CREATE, for update: G_UPDATE
371 -- Note: 1. This is automated generated item level validation procedure.
372 -- The actual validation detail is needed to be added.
373 -- 2. We can also validate table instead of record. There will be an option for user to choose.
374 -- End of Comments
375
376 PROCEDURE Validate_ae_line(
377 p_api_version_number IN NUMBER,
378 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
379 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380 p_ae_line_rec IN ae_line_rec_type,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2
384 );
385
386 -- Start of Comments
387 --
388 -- validation procedures
389 --
390 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
391 -- For create: G_CREATE, for update: G_UPDATE
392 -- Note: 1. This is automated generated item level validation procedure.
393 -- The actual validation detail is needed to be added.
394 -- 2. Validate the unique keys, lookups here
395 -- End of Comments
396
397 PROCEDURE Check_ae_line_Items (
398 P_ae_line_rec IN ae_line_rec_type,
399 p_validation_mode IN VARCHAR2,
400 x_return_status OUT NOCOPY VARCHAR2
401 );
402
403 -- Start of Comments
404 --
405 -- Record level validation procedures
406 --
407 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
408 -- For create: G_CREATE, for update: G_UPDATE
409 -- Note: 1. This is automated generated item level validation procedure.
410 -- The actual validation detail is needed to be added.
411 -- 2. Developer can manually added inter-field level validation.
412 -- End of Comments
413
414 PROCEDURE Validate_ae_line_rec(
415 p_api_version_number IN NUMBER,
416 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417 x_return_status OUT NOCOPY VARCHAR2,
418 x_msg_count OUT NOCOPY NUMBER,
419 x_msg_data OUT NOCOPY VARCHAR2,
420 p_ae_line_rec IN ae_line_rec_type
421 );
422 END OZF_Ae_Line_PVT;