1 PACKAGE Okl_Ael_Pvt AS
2 /* $Header: OKLSAELS.pls 120.2 2006/07/11 10:08:40 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ael_rec_type IS RECORD (
7 AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
8 code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9 AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10 currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11 org_id NUMBER := Okc_Api.G_MISS_NUM,
12 AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13 AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14 source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15 source_id NUMBER := Okc_Api.G_MISS_NUM,
16 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17 currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18 currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19 currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20 ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21 ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22 ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23 ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24 reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25 reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26 reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27 reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28 reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29 reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30 reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31 reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32 reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33 reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34 description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35 third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36 third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37 STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38 ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39 subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40 accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41 gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42 GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43 taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44 taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45 taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46 taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47 applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48 applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49 applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50 applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51 tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52 program_id NUMBER := Okc_Api.G_MISS_NUM,
53 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54 program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55 request_id NUMBER := Okc_Api.G_MISS_NUM,
56 created_by NUMBER := Okc_Api.G_MISS_NUM,
57 creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59 last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61 ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62 SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
63 TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
64 g_miss_ael_rec ael_rec_type;
65 TYPE ael_tbl_type IS TABLE OF ael_rec_type
66 INDEX BY BINARY_INTEGER;
67 TYPE aelv_rec_type IS RECORD (
68 AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
69 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70 AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71 currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72 code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73 org_id NUMBER := Okc_Api.G_MISS_NUM,
74 AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75 AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76 currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77 currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78 ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79 ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80 ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81 ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82 source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83 source_id NUMBER := Okc_Api.G_MISS_NUM,
84 reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85 reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86 reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87 reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88 reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89 reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90 reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91 reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92 reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93 reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94 description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95 third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96 third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97 STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98 ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99 subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100 accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101 gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102 GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103 taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104 taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105 taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106 taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107 applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108 applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109 applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110 applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111 tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112 currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113 program_id NUMBER := Okc_Api.G_MISS_NUM,
114 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115 program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116 request_id NUMBER := Okc_Api.G_MISS_NUM,
117 aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118 created_by NUMBER := Okc_Api.G_MISS_NUM,
119 creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121 last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123 ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124 SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
125 TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
126 g_miss_aelv_rec aelv_rec_type;
127 TYPE aelv_tbl_type IS TABLE OF aelv_rec_type
128 INDEX BY BINARY_INTEGER;
129 --gboomina bug#4648697.changes for perf start
130 --Added column arrarys for bulk insert
131 TYPE ae_line_id_typ IS TABLE OF okl_ae_lines.ae_line_id%TYPE
132 INDEX BY BINARY_INTEGER;
133 TYPE account_overlay_source_id_typ IS TABLE OF okl_ae_lines.account_overlay_source_id%TYPE
134 INDEX BY BINARY_INTEGER;
135 TYPE subledger_doc_seq_value_typ IS TABLE OF okl_ae_lines.subledger_doc_sequence_value%TYPE
136 INDEX BY BINARY_INTEGER;
137 TYPE tax_code_id_typ IS TABLE OF okl_ae_lines.tax_code_id%TYPE
138 INDEX BY BINARY_INTEGER;
139 TYPE ae_line_number_typ IS TABLE OF okl_ae_lines.ae_line_number%TYPE
140 INDEX BY BINARY_INTEGER;
141 TYPE code_combination_id_typ IS TABLE OF okl_ae_lines.code_combination_id%TYPE
142 INDEX BY BINARY_INTEGER;
143 TYPE ae_header_id_typ IS TABLE OF okl_ae_lines.ae_header_id%TYPE
144 INDEX BY BINARY_INTEGER;
145 TYPE currency_conversion_type_typ IS TABLE OF okl_ae_lines.currency_conversion_type%TYPE
146 INDEX BY BINARY_INTEGER;
147 TYPE ae_line_type_code_typ IS TABLE OF okl_ae_lines.ae_line_type_code%TYPE
148 INDEX BY BINARY_INTEGER;
149 TYPE source_table_typ IS TABLE OF okl_ae_lines.source_table%TYPE
150 INDEX BY BINARY_INTEGER;
151 TYPE source_id_typ IS TABLE OF okl_ae_lines.source_id%TYPE
152 INDEX BY BINARY_INTEGER;
153 TYPE object_version_number_typ IS TABLE OF okl_ae_lines.object_version_number%TYPE
154 INDEX BY BINARY_INTEGER;
155 TYPE currency_code_typ IS TABLE OF okl_ae_lines.currency_code%TYPE
156 INDEX BY BINARY_INTEGER;
157 TYPE currency_conversion_date_typ IS TABLE OF okl_ae_lines.currency_conversion_date%TYPE
158 INDEX BY BINARY_INTEGER;
159 TYPE currency_conversion_rate_typ IS TABLE OF okl_ae_lines.currency_conversion_rate%TYPE
160 INDEX BY BINARY_INTEGER;
161 TYPE entered_dr_typ IS TABLE OF okl_ae_lines.entered_dr%TYPE
162 INDEX BY BINARY_INTEGER;
163 TYPE entered_cr_typ IS TABLE OF okl_ae_lines.entered_cr%TYPE
164 INDEX BY BINARY_INTEGER;
165 TYPE accounted_dr_typ IS TABLE OF okl_ae_lines.accounted_dr%TYPE
166 INDEX BY BINARY_INTEGER;
167 TYPE accounted_cr_typ IS TABLE OF okl_ae_lines.accounted_cr%TYPE
168 INDEX BY BINARY_INTEGER;
169 TYPE reference1_typ IS TABLE OF okl_ae_lines.reference1%TYPE
170 INDEX BY BINARY_INTEGER;
171 TYPE reference2_typ IS TABLE OF okl_ae_lines.reference2%TYPE
172 INDEX BY BINARY_INTEGER;
173 TYPE reference3_typ IS TABLE OF okl_ae_lines.reference3%TYPE
174 INDEX BY BINARY_INTEGER;
175 TYPE reference4_typ IS TABLE OF okl_ae_lines.reference4%TYPE
176 INDEX BY BINARY_INTEGER;
177 TYPE reference5_typ IS TABLE OF okl_ae_lines.reference5%TYPE
178 INDEX BY BINARY_INTEGER;
179 TYPE reference6_typ IS TABLE OF okl_ae_lines.reference6%TYPE
180 INDEX BY BINARY_INTEGER;
181 TYPE reference7_typ IS TABLE OF okl_ae_lines.reference7%TYPE
182 INDEX BY BINARY_INTEGER;
183 TYPE reference8_typ IS TABLE OF okl_ae_lines.reference8%TYPE
184 INDEX BY BINARY_INTEGER;
185 TYPE reference9_typ IS TABLE OF okl_ae_lines.reference9%TYPE
186 INDEX BY BINARY_INTEGER;
187 TYPE reference10_typ IS TABLE OF okl_ae_lines.reference10%TYPE
188 INDEX BY BINARY_INTEGER;
189 TYPE description_typ IS TABLE OF okl_ae_lines.description%TYPE
190 INDEX BY BINARY_INTEGER;
191 TYPE third_party_id_typ IS TABLE OF okl_ae_lines.third_party_id%TYPE
192 INDEX BY BINARY_INTEGER;
193 TYPE third_party_sub_id_typ IS TABLE OF okl_ae_lines.third_party_sub_id%TYPE
194 INDEX BY BINARY_INTEGER;
195 TYPE stat_amount_typ IS TABLE OF okl_ae_lines.stat_amount%TYPE
196 INDEX BY BINARY_INTEGER;
197 TYPE ussgl_transaction_code_typ IS TABLE OF okl_ae_lines.ussgl_transaction_code%TYPE
198 INDEX BY BINARY_INTEGER;
199 TYPE subledger_doc_sequence_id_typ IS TABLE OF okl_ae_lines.subledger_doc_sequence_id%TYPE
200 INDEX BY BINARY_INTEGER;
201 TYPE accounting_error_code_typ IS TABLE OF okl_ae_lines.accounting_error_code%TYPE
202 INDEX BY BINARY_INTEGER;
203 TYPE gl_transfer_error_code_typ IS TABLE OF okl_ae_lines.gl_transfer_error_code%TYPE
204 INDEX BY BINARY_INTEGER;
205 TYPE gl_sl_link_id_typ IS TABLE OF okl_ae_lines.gl_sl_link_id%TYPE
206 INDEX BY BINARY_INTEGER;
207 TYPE taxable_entered_dr_typ IS TABLE OF okl_ae_lines.taxable_entered_dr%TYPE
208 INDEX BY BINARY_INTEGER;
209 TYPE taxable_entered_cr_typ IS TABLE OF okl_ae_lines.taxable_entered_cr%TYPE
210 INDEX BY BINARY_INTEGER;
211 TYPE taxable_accounted_dr_typ IS TABLE OF okl_ae_lines.taxable_accounted_dr%TYPE
212 INDEX BY BINARY_INTEGER;
213 TYPE taxable_accounted_cr_typ IS TABLE OF okl_ae_lines.taxable_accounted_cr%TYPE
214 INDEX BY BINARY_INTEGER;
215 TYPE applied_from_trx_hdr_tab_typ IS TABLE OF okl_ae_lines.applied_from_trx_hdr_table%TYPE
216 INDEX BY BINARY_INTEGER;
217 TYPE applied_from_trx_hdr_id_typ IS TABLE OF okl_ae_lines.applied_from_trx_hdr_id%TYPE
218 INDEX BY BINARY_INTEGER;
219 TYPE applied_to_trx_hdr_table_typ IS TABLE OF okl_ae_lines.applied_to_trx_hdr_table%TYPE
220 INDEX BY BINARY_INTEGER;
221 TYPE applied_to_trx_hdr_id_typ IS TABLE OF okl_ae_lines.applied_to_trx_hdr_id%TYPE
222 INDEX BY BINARY_INTEGER;
223 TYPE tax_link_id_typ IS TABLE OF okl_ae_lines.tax_link_id%TYPE
224 INDEX BY BINARY_INTEGER;
225 TYPE org_id_typ IS TABLE OF okl_ae_lines.org_id%TYPE
226 INDEX BY BINARY_INTEGER;
227 TYPE program_id_typ IS TABLE OF okl_ae_lines.program_id%TYPE
228 INDEX BY BINARY_INTEGER;
229 TYPE program_application_id_typ IS TABLE OF okl_ae_lines.program_application_id%TYPE
230 INDEX BY BINARY_INTEGER;
231 TYPE program_update_date_typ IS TABLE OF okl_ae_lines.program_update_date%TYPE
232 INDEX BY BINARY_INTEGER;
233 TYPE request_id_typ IS TABLE OF okl_ae_lines.request_id%TYPE
234 INDEX BY BINARY_INTEGER;
235 TYPE created_by_typ IS TABLE OF okl_ae_lines.created_by%TYPE
236 INDEX BY BINARY_INTEGER;
237 TYPE creation_date_typ IS TABLE OF okl_ae_lines.creation_date%TYPE
238 INDEX BY BINARY_INTEGER;
239 TYPE last_updated_by_typ IS TABLE OF okl_ae_lines.last_updated_by%TYPE
240 INDEX BY BINARY_INTEGER;
241 TYPE last_update_date_typ IS TABLE OF okl_ae_lines.last_update_date%TYPE
242 INDEX BY BINARY_INTEGER;
243 TYPE last_update_login_typ IS TABLE OF okl_ae_lines.last_update_login%TYPE
244 INDEX BY BINARY_INTEGER;
245 --gboomina bug#4648697.changes for perf end
246
247 ---------------------------------------------------------------------------
248 -- GLOBAL MESSAGE CONSTANTS
249 ---------------------------------------------------------------------------
250 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
251 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
259 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
260 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
261 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
262 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
263 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
264 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_AEL_ELEMENT_NOT_UNIQUE';
265
266 ---------------------------------------------------------------------------
267 -- GLOBAL VARIABLES
268 ---------------------------------------------------------------------------
269 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AEL_PVT';
270 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
271 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
272
273 ---------------------------------------------------------------------------
274 -- Procedures and Functions
275 ---------------------------------------------------------------------------
276
277 PROCEDURE qc;
278 PROCEDURE change_version;
279 PROCEDURE api_copy;
280 PROCEDURE insert_row(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286 p_aelv_rec IN aelv_rec_type,
287 x_aelv_rec OUT NOCOPY aelv_rec_type);
288
289 PROCEDURE insert_row(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_aelv_tbl IN aelv_tbl_type,
296 x_aelv_tbl OUT NOCOPY aelv_tbl_type);
297
298 --gboomina bug#4648697.changes for perf start
299 --added new procedure for bulk insert
300 PROCEDURE insert_row_perf(
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_aelv_tbl IN aelv_tbl_type,
307 x_aelv_tbl OUT NOCOPY aelv_tbl_type);
308 --gboomina bug#4648697.changes for perf end
309
310 PROCEDURE lock_row(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_aelv_rec IN aelv_rec_type);
317
318 PROCEDURE lock_row(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_aelv_tbl IN aelv_tbl_type);
325
326 PROCEDURE update_row(
327 p_api_version IN NUMBER,
328 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 p_aelv_rec IN aelv_rec_type,
333 x_aelv_rec OUT NOCOPY aelv_rec_type);
334
335 PROCEDURE update_row(
336 p_api_version IN NUMBER,
337 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_aelv_tbl IN aelv_tbl_type,
342 x_aelv_tbl OUT NOCOPY aelv_tbl_type);
343
344 PROCEDURE delete_row(
345 p_api_version IN NUMBER,
346 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
347 x_return_status OUT NOCOPY VARCHAR2,
348 x_msg_count OUT NOCOPY NUMBER,
349 x_msg_data OUT NOCOPY VARCHAR2,
350 p_aelv_rec IN aelv_rec_type);
351
352 PROCEDURE delete_row(
353 p_api_version IN NUMBER,
354 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_count OUT NOCOPY NUMBER,
357 x_msg_data OUT NOCOPY VARCHAR2,
358 p_aelv_tbl IN aelv_tbl_type);
359
360 PROCEDURE validate_row(
361 p_api_version IN NUMBER,
362 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
363 x_return_status OUT NOCOPY VARCHAR2,
364 x_msg_count OUT NOCOPY NUMBER,
365 x_msg_data OUT NOCOPY VARCHAR2,
366 p_aelv_rec IN aelv_rec_type);
367
368 PROCEDURE validate_row(
369 p_api_version IN NUMBER,
370 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2,
374 p_aelv_tbl IN aelv_tbl_type);
375
376 END Okl_Ael_Pvt;
[Home] [Help]