[Home] [Help]
PACKAGE BODY: APPS.ZX_SIM_TRX_DISTRIBUTION
Source
1 PACKAGE BODY ZX_SIM_TRX_DISTRIBUTION AS
2 /* $Header: zxritsimitdistb.pls 120.16.12010000.1 2008/07/28 13:37:19 appldev ship $ */
3
4 g_current_runtime_level NUMBER;
5 g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6 g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7 g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8 g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9
10 TYPE var1_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
11 trx_line_type_tab var1_tab;
12
13 PROCEDURE Insert_row
14 (p_application_id NUMBER,
15 p_entity_code VARCHAR2,
16 p_event_class_code VARCHAR2,
17 --p_event_type_code VARCHAR2,
18 p_trx_id NUMBER,
19 p_hdr_trx_user_key1 VARCHAR2,
20 p_hdr_trx_user_key2 VARCHAR2,
21 p_hdr_trx_user_key3 VARCHAR2,
22 p_hdr_trx_user_key4 VARCHAR2,
23 p_hdr_trx_user_key5 VARCHAR2,
24 p_hdr_trx_user_key6 VARCHAR2,
25 p_trx_line_id NUMBER,
26 p_line_trx_user_key1 VARCHAR2,
27 p_line_trx_user_key2 VARCHAR2,
28 p_line_trx_user_key3 VARCHAR2,
29 p_line_trx_user_key4 VARCHAR2,
30 p_line_trx_user_key5 VARCHAR2,
31 p_line_trx_user_key6 VARCHAR2,
32 p_trx_level_type VARCHAR2,
33 p_trx_line_dist_id NUMBER,
34 p_dist_trx_user_key1 VARCHAR2,
35 p_dist_trx_user_key2 VARCHAR2,
36 p_dist_trx_user_key3 VARCHAR2,
37 p_dist_trx_user_key4 VARCHAR2,
38 p_dist_trx_user_key5 VARCHAR2,
39 p_dist_trx_user_key6 VARCHAR2,
40 p_dist_level_action VARCHAR2,
41 p_trx_line_dist_date DATE,
42 p_item_dist_number NUMBER,
43 p_dist_intended_use VARCHAR2,
44 p_tax_inclusion_flag VARCHAR2,
45 p_tax_code VARCHAR2,
46 p_applied_from_tax_dist_id NUMBER,
47 p_adjusted_doc_tax_dist_id NUMBER,
48 p_task_id NUMBER,
49 p_award_id NUMBER,
50 p_project_id NUMBER,
51 p_expenditure_type VARCHAR2,
52 p_expenditure_organization_id NUMBER,
53 p_expenditure_item_date DATE,
54 p_trx_line_dist_amt NUMBER,
55 p_trx_line_dist_qty NUMBER,
56 p_trx_line_quantity NUMBER,
57 p_account_ccid NUMBER,
58 p_account_string VARCHAR2,
59 p_ref_doc_application_id NUMBER,
60 p_ref_doc_entity_code VARCHAR2,
61 p_ref_doc_event_class_code VARCHAR2,
62 p_ref_doc_trx_id NUMBER,
63 p_ref_doc_hdr_trx_user_key1 VARCHAR2,
64 p_ref_doc_hdr_trx_user_key2 VARCHAR2,
65 p_ref_doc_hdr_trx_user_key3 VARCHAR2,
66 p_ref_doc_hdr_trx_user_key4 VARCHAR2,
67 p_ref_doc_hdr_trx_user_key5 VARCHAR2,
68 p_ref_doc_hdr_trx_user_key6 VARCHAR2,
69 p_ref_doc_line_id NUMBER,
70 p_ref_doc_lin_trx_user_key1 VARCHAR2,
71 p_ref_doc_lin_trx_user_key2 VARCHAR2,
72 p_ref_doc_lin_trx_user_key3 VARCHAR2,
73 p_ref_doc_lin_trx_user_key4 VARCHAR2,
74 p_ref_doc_lin_trx_user_key5 VARCHAR2,
75 p_ref_doc_lin_trx_user_key6 VARCHAR2,
76 p_ref_doc_dist_id NUMBER,
77 p_ref_doc_dist_trx_user_key1 VARCHAR2,
78 p_ref_doc_dist_trx_user_key2 VARCHAR2,
79 p_ref_doc_dist_trx_user_key3 VARCHAR2,
80 p_ref_doc_dist_trx_user_key4 VARCHAR2,
81 p_ref_doc_dist_trx_user_key5 VARCHAR2,
82 p_ref_doc_dist_trx_user_key6 VARCHAR2,
83 p_ref_doc_curr_conv_rate NUMBER,
84 p_numeric1 NUMBER,
85 p_numeric2 NUMBER,
86 p_numeric3 NUMBER,
87 p_numeric4 NUMBER,
88 p_numeric5 NUMBER,
89 p_char1 VARCHAR2,
90 p_char2 VARCHAR2,
91 p_char3 VARCHAR2,
92 p_char4 VARCHAR2,
93 p_char5 VARCHAR2,
94 p_date1 DATE,
95 p_date2 DATE,
96 p_date3 DATE,
97 p_date4 DATE,
98 p_date5 DATE,
99 p_trx_line_dist_tax_amt NUMBER,
100 p_historical_flag VARCHAR2,
101 p_applied_from_application_id NUMBER,
102 p_appl_from_event_class_code VARCHAR2, --p_applied_from_event_class_code
103 p_applied_from_entity_code VARCHAR2,
104 p_applied_from_trx_id NUMBER,
105 p_app_from_hdr_trx_user_key1 VARCHAR2,
106 p_app_from_hdr_trx_user_key2 VARCHAR2,
107 p_app_from_hdr_trx_user_key3 VARCHAR2,
108 p_app_from_hdr_trx_user_key4 VARCHAR2,
109 p_app_from_hdr_trx_user_key5 VARCHAR2,
110 p_app_from_hdr_trx_user_key6 VARCHAR2,
111 p_applied_from_line_id NUMBER,
112 p_app_from_lin_trx_user_key1 VARCHAR2,
113 p_app_from_lin_trx_user_key2 VARCHAR2,
114 p_app_from_lin_trx_user_key3 VARCHAR2,
115 p_app_from_lin_trx_user_key4 VARCHAR2,
116 p_app_from_lin_trx_user_key5 VARCHAR2,
117 p_app_from_lin_trx_user_key6 VARCHAR2,
118 p_applied_from_dist_id NUMBER,
119 p_app_from_dst_trx_user_key1 VARCHAR2,
120 p_app_from_dst_trx_user_key2 VARCHAR2,
121 p_app_from_dst_trx_user_key3 VARCHAR2,
122 p_app_from_dst_trx_user_key4 VARCHAR2,
123 p_app_from_dst_trx_user_key5 VARCHAR2,
124 p_app_from_dst_trx_user_key6 VARCHAR2,
125 p_adj_doc_application_id NUMBER, --p_adjusted_doc_application_id
126 p_adj_doc_event_class_code VARCHAR2, --p_adjusted_doc_event_class_code
127 p_adjusted_doc_entity_code VARCHAR2,
128 p_adjusted_doc_trx_id NUMBER,
129 p_adj_doc_hdr_trx_user_key1 VARCHAR2,
130 p_adj_doc_hdr_trx_user_key2 VARCHAR2,
131 p_adj_doc_hdr_trx_user_key3 VARCHAR2,
132 p_adj_doc_hdr_trx_user_key4 VARCHAR2,
133 p_adj_doc_hdr_trx_user_key5 VARCHAR2,
134 p_adj_doc_hdr_trx_user_key6 VARCHAR2,
135 p_adjusted_doc_line_id NUMBER,
136 p_adj_doc_lin_trx_user_key1 VARCHAR2,
137 p_adj_doc_lin_trx_user_key2 VARCHAR2,
138 p_adj_doc_lin_trx_user_key3 VARCHAR2,
139 p_adj_doc_lin_trx_user_key4 VARCHAR2,
140 p_adj_doc_lin_trx_user_key5 VARCHAR2,
141 p_adj_doc_lin_trx_user_key6 VARCHAR2,
142 p_adjusted_doc_dist_id NUMBER,
143 p_adj_doc_dst_trx_user_key1 VARCHAR2,
144 p_adj_doc_dst_trx_user_key2 VARCHAR2,
145 p_adj_doc_dst_trx_user_key3 VARCHAR2,
146 p_adj_doc_dst_trx_user_key4 VARCHAR2,
147 p_adj_doc_dst_trx_user_key5 VARCHAR2,
148 p_adj_doc_dst_trx_user_key6 VARCHAR2,
149 p_appl_to_doc_curr_conv_rate NUMBER, --p_applied_to_doc_curr_conv_rate
150 p_tax_variance_calc_flag VARCHAR2,
151 p_ref_doc_trx_line_dist_qty NUMBER,
152 p_price_diff NUMBER,
153 p_unit_price NUMBER,
154 p_currency_exchange_rate NUMBER,
155 p_ref_doc_trx_level_type VARCHAR2,
156 p_applied_from_trx_level_type VARCHAR2,
157 p_adjusted_doc_trx_level_type VARCHAR2,
158 p_overriding_recovery_rate NUMBER,
159 p_object_version_number NUMBER,
160 p_created_by NUMBER,
161 p_creation_date DATE,
162 p_last_updated_by NUMBER,
163 p_last_update_date DATE,
164 p_last_update_login NUMBER) IS
165
166 l_return_status VARCHAR2(1000);
167 l_msg_count NUMBER;
168 l_msg_data VARCHAR2(1000);
169 sid NUMBER;
170 p_error_buffer VARCHAR2(100);
171 l_tax_event_type_code VARCHAR2(30);
172
173 BEGIN
174
175 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
176
177 IF (g_level_procedure >= g_current_runtime_level ) THEN
178 FND_LOG.STRING(g_level_procedure,
179 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.BEGIN',
180 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (+)');
181 FND_LOG.STRING(g_level_procedure,
182 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
183 'Insert into ZX_SIM_TRX_DISTS (+)');
184 END IF;
185
186 INSERT INTO ZX_SIM_TRX_DISTS (APPLICATION_ID,
187 ENTITY_CODE,
188 EVENT_CLASS_CODE,
189 --EVENT_TYPE_CODE,
190 TRX_ID,
191 HDR_TRX_USER_KEY1,
192 HDR_TRX_USER_KEY2,
193 HDR_TRX_USER_KEY3,
194 HDR_TRX_USER_KEY4,
195 HDR_TRX_USER_KEY5,
196 HDR_TRX_USER_KEY6,
197 TRX_LINE_ID,
198 LINE_TRX_USER_KEY1,
199 LINE_TRX_USER_KEY2,
200 LINE_TRX_USER_KEY3,
201 LINE_TRX_USER_KEY4,
202 LINE_TRX_USER_KEY5,
203 LINE_TRX_USER_KEY6,
204 TRX_LEVEL_TYPE,
205 TRX_LINE_DIST_ID,
206 DIST_TRX_USER_KEY1,
207 DIST_TRX_USER_KEY2,
208 DIST_TRX_USER_KEY3,
209 DIST_TRX_USER_KEY4,
210 DIST_TRX_USER_KEY5,
211 DIST_TRX_USER_KEY6,
212 DIST_LEVEL_ACTION,
213 TRX_LINE_DIST_DATE,
214 ITEM_DIST_NUMBER,
215 DIST_INTENDED_USE,
216 TAX_INCLUSION_FLAG,
217 TAX_CODE,
218 APPLIED_FROM_TAX_DIST_ID,
219 ADJUSTED_DOC_TAX_DIST_ID,
220 TASK_ID,
221 AWARD_ID,
222 PROJECT_ID,
223 EXPENDITURE_TYPE,
224 EXPENDITURE_ORGANIZATION_ID,
225 EXPENDITURE_ITEM_DATE,
226 TRX_LINE_DIST_AMT,
227 TRX_LINE_DIST_QTY,
228 TRX_LINE_QUANTITY,
229 ACCOUNT_CCID,
230 ACCOUNT_STRING,
231 REF_DOC_APPLICATION_ID,
232 REF_DOC_ENTITY_CODE,
233 REF_DOC_EVENT_CLASS_CODE,
234 REF_DOC_TRX_ID,
235 REF_DOC_HDR_TRX_USER_KEY1,
236 REF_DOC_HDR_TRX_USER_KEY2,
237 REF_DOC_HDR_TRX_USER_KEY3,
238 REF_DOC_HDR_TRX_USER_KEY4,
239 REF_DOC_HDR_TRX_USER_KEY5,
240 REF_DOC_HDR_TRX_USER_KEY6,
241 REF_DOC_LINE_ID,
242 REF_DOC_LIN_TRX_USER_KEY1,
243 REF_DOC_LIN_TRX_USER_KEY2,
244 REF_DOC_LIN_TRX_USER_KEY3,
245 REF_DOC_LIN_TRX_USER_KEY4,
246 REF_DOC_LIN_TRX_USER_KEY5,
247 REF_DOC_LIN_TRX_USER_KEY6,
248 REF_DOC_DIST_ID,
249 REF_DOC_DIST_TRX_USER_KEY1,
250 REF_DOC_DIST_TRX_USER_KEY2,
251 REF_DOC_DIST_TRX_USER_KEY3,
252 REF_DOC_DIST_TRX_USER_KEY4,
253 REF_DOC_DIST_TRX_USER_KEY5,
254 REF_DOC_DIST_TRX_USER_KEY6,
255 REF_DOC_CURR_CONV_RATE,
256 NUMERIC1,
257 NUMERIC2,
258 NUMERIC3,
259 NUMERIC4,
260 NUMERIC5,
261 CHAR1,
262 CHAR2,
263 CHAR3,
264 CHAR4,
265 CHAR5,
266 DATE1,
267 DATE2,
268 DATE3,
269 DATE4,
270 DATE5,
271 TRX_LINE_DIST_TAX_AMT,
272 HISTORICAL_FLAG,
273 APPLIED_FROM_APPLICATION_ID,
274 APPLIED_FROM_EVENT_CLASS_CODE,
275 APPLIED_FROM_ENTITY_CODE,
276 APPLIED_FROM_TRX_ID,
277 APP_FROM_HDR_TRX_USER_KEY1,
278 APP_FROM_HDR_TRX_USER_KEY2,
279 APP_FROM_HDR_TRX_USER_KEY3,
280 APP_FROM_HDR_TRX_USER_KEY4,
281 APP_FROM_HDR_TRX_USER_KEY5,
282 APP_FROM_HDR_TRX_USER_KEY6,
283 APPLIED_FROM_LINE_ID,
284 APP_FROM_LIN_TRX_USER_KEY1,
285 APP_FROM_LIN_TRX_USER_KEY2,
286 APP_FROM_LIN_TRX_USER_KEY3,
287 APP_FROM_LIN_TRX_USER_KEY4,
288 APP_FROM_LIN_TRX_USER_KEY5,
289 APP_FROM_LIN_TRX_USER_KEY6,
290 APPLIED_FROM_DIST_ID,
291 APP_FROM_DST_TRX_USER_KEY1,
292 APP_FROM_DST_TRX_USER_KEY2,
293 APP_FROM_DST_TRX_USER_KEY3,
294 APP_FROM_DST_TRX_USER_KEY4,
295 APP_FROM_DST_TRX_USER_KEY5,
296 APP_FROM_DST_TRX_USER_KEY6,
297 ADJUSTED_DOC_APPLICATION_ID,
298 ADJUSTED_DOC_EVENT_CLASS_CODE,
299 ADJUSTED_DOC_ENTITY_CODE,
300 ADJUSTED_DOC_TRX_ID,
301 ADJ_DOC_HDR_TRX_USER_KEY1,
302 ADJ_DOC_HDR_TRX_USER_KEY2,
303 ADJ_DOC_HDR_TRX_USER_KEY3,
304 ADJ_DOC_HDR_TRX_USER_KEY4,
305 ADJ_DOC_HDR_TRX_USER_KEY5,
306 ADJ_DOC_HDR_TRX_USER_KEY6,
307 ADJUSTED_DOC_LINE_ID,
308 ADJ_DOC_LIN_TRX_USER_KEY1,
309 ADJ_DOC_LIN_TRX_USER_KEY2,
310 ADJ_DOC_LIN_TRX_USER_KEY3,
311 ADJ_DOC_LIN_TRX_USER_KEY4,
312 ADJ_DOC_LIN_TRX_USER_KEY5,
313 ADJ_DOC_LIN_TRX_USER_KEY6,
314 ADJUSTED_DOC_DIST_ID,
315 ADJ_DOC_DST_TRX_USER_KEY1,
316 ADJ_DOC_DST_TRX_USER_KEY2,
317 ADJ_DOC_DST_TRX_USER_KEY3,
318 ADJ_DOC_DST_TRX_USER_KEY4,
319 ADJ_DOC_DST_TRX_USER_KEY5,
320 ADJ_DOC_DST_TRX_USER_KEY6,
321 APPLIED_TO_DOC_CURR_CONV_RATE,
322 TAX_VARIANCE_CALC_FLAG,
326 CURRENCY_EXCHANGE_RATE,
323 REF_DOC_TRX_LINE_DIST_QTY,
324 PRICE_DIFF,
325 UNIT_PRICE,
327 REF_DOC_TRX_LEVEL_TYPE,
328 APPLIED_FROM_TRX_LEVEL_TYPE,
329 ADJUSTED_DOC_TRX_LEVEL_TYPE,
330 OVERRIDING_RECOVERY_RATE,
331 OBJECT_VERSION_NUMBER,
332 CREATED_BY,
333 CREATION_DATE,
334 LAST_UPDATED_BY,
335 LAST_UPDATE_DATE,
336 LAST_UPDATE_LOGIN)
337 VALUES (p_application_id,
338 p_entity_code,
339 p_event_class_code,
340 --p_event_type_code,
341 p_trx_id,
342 p_hdr_trx_user_key1,
343 p_hdr_trx_user_key2,
344 p_hdr_trx_user_key3,
345 p_hdr_trx_user_key4,
346 p_hdr_trx_user_key5,
347 p_hdr_trx_user_key6,
348 p_trx_line_id,
349 p_line_trx_user_key1,
350 p_line_trx_user_key2,
351 p_line_trx_user_key3,
352 p_line_trx_user_key4,
353 p_line_trx_user_key5,
354 p_line_trx_user_key6,
355 p_trx_level_type,
356 p_trx_line_dist_id,
357 p_dist_trx_user_key1,
358 p_dist_trx_user_key2,
359 p_dist_trx_user_key3,
360 p_dist_trx_user_key4,
361 p_dist_trx_user_key5,
362 p_dist_trx_user_key6,
363 p_dist_level_action,
364 p_trx_line_dist_date,
365 p_item_dist_number,
366 p_dist_intended_use,
367 p_tax_inclusion_flag,
368 p_tax_code,
369 p_applied_from_tax_dist_id,
370 p_adjusted_doc_tax_dist_id,
371 p_task_id,
372 p_award_id,
373 p_project_id,
374 p_expenditure_type,
375 p_expenditure_organization_id,
376 p_expenditure_item_date,
377 p_trx_line_dist_amt,
378 p_trx_line_dist_qty,
379 p_trx_line_quantity,
380 p_account_ccid,
381 p_account_string,
382 p_ref_doc_application_id,
383 p_ref_doc_entity_code,
384 p_ref_doc_event_class_code,
385 p_ref_doc_trx_id,
386 p_ref_doc_hdr_trx_user_key1,
387 p_ref_doc_hdr_trx_user_key2,
388 p_ref_doc_hdr_trx_user_key3,
389 p_ref_doc_hdr_trx_user_key4,
390 p_ref_doc_hdr_trx_user_key5,
391 p_ref_doc_hdr_trx_user_key6,
392 p_ref_doc_line_id,
393 p_ref_doc_lin_trx_user_key1,
394 p_ref_doc_lin_trx_user_key2,
395 p_ref_doc_lin_trx_user_key3,
396 p_ref_doc_lin_trx_user_key4,
397 p_ref_doc_lin_trx_user_key5,
398 p_ref_doc_lin_trx_user_key6,
399 p_ref_doc_dist_id,
400 p_ref_doc_dist_trx_user_key1,
401 p_ref_doc_dist_trx_user_key2,
402 p_ref_doc_dist_trx_user_key3,
403 p_ref_doc_dist_trx_user_key4,
404 p_ref_doc_dist_trx_user_key5,
405 p_ref_doc_dist_trx_user_key6,
406 p_ref_doc_curr_conv_rate,
407 p_numeric1,
408 p_numeric2,
409 p_numeric3,
410 p_numeric4,
411 p_numeric5,
412 p_char1,
413 p_char2,
414 p_char3,
415 p_char4,
416 p_char5,
417 p_date1,
418 p_date2,
419 p_date3,
420 p_date4,
421 p_date5,
422 p_trx_line_dist_tax_amt,
426 p_applied_from_entity_code,
423 p_historical_flag,
424 p_applied_from_application_id,
425 p_appl_from_event_class_code,
427 p_applied_from_trx_id,
428 p_app_from_hdr_trx_user_key1,
429 p_app_from_hdr_trx_user_key2,
430 p_app_from_hdr_trx_user_key3,
431 p_app_from_hdr_trx_user_key4,
432 p_app_from_hdr_trx_user_key5,
433 p_app_from_hdr_trx_user_key6,
434 p_applied_from_line_id,
435 p_app_from_lin_trx_user_key1,
436 p_app_from_lin_trx_user_key2,
437 p_app_from_lin_trx_user_key3,
438 p_app_from_lin_trx_user_key4,
439 p_app_from_lin_trx_user_key5,
440 p_app_from_lin_trx_user_key6,
441 p_applied_from_dist_id,
442 p_app_from_dst_trx_user_key1,
443 p_app_from_dst_trx_user_key2,
444 p_app_from_dst_trx_user_key3,
445 p_app_from_dst_trx_user_key4,
446 p_app_from_dst_trx_user_key5,
447 p_app_from_dst_trx_user_key6,
448 p_adj_doc_application_id,
449 p_adj_doc_event_class_code,
450 p_adjusted_doc_entity_code,
451 p_adjusted_doc_trx_id,
452 p_adj_doc_hdr_trx_user_key1,
453 p_adj_doc_hdr_trx_user_key2,
454 p_adj_doc_hdr_trx_user_key3,
455 p_adj_doc_hdr_trx_user_key4,
456 p_adj_doc_hdr_trx_user_key5,
457 p_adj_doc_hdr_trx_user_key6,
458 p_adjusted_doc_line_id,
459 p_adj_doc_lin_trx_user_key1,
460 p_adj_doc_lin_trx_user_key2,
461 p_adj_doc_lin_trx_user_key3,
462 p_adj_doc_lin_trx_user_key4,
463 p_adj_doc_lin_trx_user_key5,
464 p_adj_doc_lin_trx_user_key6,
465 p_adjusted_doc_dist_id,
466 p_adj_doc_dst_trx_user_key1,
467 p_adj_doc_dst_trx_user_key2,
468 p_adj_doc_dst_trx_user_key3,
469 p_adj_doc_dst_trx_user_key4,
470 p_adj_doc_dst_trx_user_key5,
471 p_adj_doc_dst_trx_user_key6,
472 p_appl_to_doc_curr_conv_rate,
473 p_tax_variance_calc_flag,
474 p_ref_doc_trx_line_dist_qty,
475 p_price_diff,
476 p_unit_price,
477 p_currency_exchange_rate,
478 p_ref_doc_trx_level_type,
479 p_applied_from_trx_level_type,
480 p_adjusted_doc_trx_level_type,
481 p_overriding_recovery_rate,
482 1, --p_object_version_number,
483 p_created_by,
484 p_creation_date,
485 p_last_updated_by,
486 p_last_update_date,
487 p_last_update_login);
488
489 IF (g_level_procedure >= g_current_runtime_level ) THEN
490 FND_LOG.STRING(g_level_procedure,
491 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
492 'Insert into ZX_SIM_TRX_DISTS (-)');
493 FND_LOG.STRING(g_level_procedure,
494 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.END',
495 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (-)');
496 END IF;
497
498 END Insert_row;
499
500 PROCEDURE Update_row
501 (p_application_id NUMBER,
502 p_entity_code VARCHAR2,
503 p_event_class_code VARCHAR2,
504 --p_event_type_code VARCHAR2,
505 p_trx_id NUMBER,
506 p_hdr_trx_user_key1 VARCHAR2,
507 p_hdr_trx_user_key2 VARCHAR2,
508 p_hdr_trx_user_key3 VARCHAR2,
509 p_hdr_trx_user_key4 VARCHAR2,
510 p_hdr_trx_user_key5 VARCHAR2,
511 p_hdr_trx_user_key6 VARCHAR2,
512 p_trx_line_id NUMBER,
513 p_line_trx_user_key1 VARCHAR2,
514 p_line_trx_user_key2 VARCHAR2,
515 p_line_trx_user_key3 VARCHAR2,
516 p_line_trx_user_key4 VARCHAR2,
517 p_line_trx_user_key5 VARCHAR2,
518 p_line_trx_user_key6 VARCHAR2,
519 p_trx_level_type VARCHAR2,
520 p_trx_line_dist_id NUMBER,
521 p_dist_trx_user_key1 VARCHAR2,
522 p_dist_trx_user_key2 VARCHAR2,
526 p_dist_trx_user_key6 VARCHAR2,
523 p_dist_trx_user_key3 VARCHAR2,
524 p_dist_trx_user_key4 VARCHAR2,
525 p_dist_trx_user_key5 VARCHAR2,
527 p_dist_level_action VARCHAR2,
528 p_trx_line_dist_date DATE,
529 p_item_dist_number NUMBER,
530 p_dist_intended_use VARCHAR2,
531 p_tax_inclusion_flag VARCHAR2,
532 p_tax_code VARCHAR2,
533 p_applied_from_tax_dist_id NUMBER,
534 p_adjusted_doc_tax_dist_id NUMBER,
535 p_task_id NUMBER,
536 p_award_id NUMBER,
537 p_project_id NUMBER,
538 p_expenditure_type VARCHAR2,
539 p_expenditure_organization_id NUMBER,
540 p_expenditure_item_date DATE,
541 p_trx_line_dist_amt NUMBER,
542 p_trx_line_dist_qty NUMBER,
543 p_trx_line_quantity NUMBER,
544 p_account_ccid NUMBER,
545 p_account_string VARCHAR2,
546 p_ref_doc_application_id NUMBER,
547 p_ref_doc_entity_code VARCHAR2,
548 p_ref_doc_event_class_code VARCHAR2,
549 p_ref_doc_trx_id NUMBER,
550 p_ref_doc_hdr_trx_user_key1 VARCHAR2,
551 p_ref_doc_hdr_trx_user_key2 VARCHAR2,
552 p_ref_doc_hdr_trx_user_key3 VARCHAR2,
553 p_ref_doc_hdr_trx_user_key4 VARCHAR2,
554 p_ref_doc_hdr_trx_user_key5 VARCHAR2,
555 p_ref_doc_hdr_trx_user_key6 VARCHAR2,
556 p_ref_doc_line_id NUMBER,
557 p_ref_doc_lin_trx_user_key1 VARCHAR2,
558 p_ref_doc_lin_trx_user_key2 VARCHAR2,
559 p_ref_doc_lin_trx_user_key3 VARCHAR2,
560 p_ref_doc_lin_trx_user_key4 VARCHAR2,
561 p_ref_doc_lin_trx_user_key5 VARCHAR2,
562 p_ref_doc_lin_trx_user_key6 VARCHAR2,
563 p_ref_doc_dist_id NUMBER,
564 p_ref_doc_dist_trx_user_key1 VARCHAR2,
565 p_ref_doc_dist_trx_user_key2 VARCHAR2,
566 p_ref_doc_dist_trx_user_key3 VARCHAR2,
567 p_ref_doc_dist_trx_user_key4 VARCHAR2,
568 p_ref_doc_dist_trx_user_key5 VARCHAR2,
569 p_ref_doc_dist_trx_user_key6 VARCHAR2,
570 p_ref_doc_curr_conv_rate NUMBER,
571 p_numeric1 NUMBER,
572 p_numeric2 NUMBER,
573 p_numeric3 NUMBER,
574 p_numeric4 NUMBER,
575 p_numeric5 NUMBER,
576 p_char1 VARCHAR2,
577 p_char2 VARCHAR2,
578 p_char3 VARCHAR2,
579 p_char4 VARCHAR2,
580 p_char5 VARCHAR2,
581 p_date1 DATE,
582 p_date2 DATE,
583 p_date3 DATE,
584 p_date4 DATE,
585 p_date5 DATE,
586 p_trx_line_dist_tax_amt NUMBER,
587 p_historical_flag VARCHAR2,
588 p_applied_from_application_id NUMBER,
589 p_appl_from_event_class_code VARCHAR2, --p_applied_from_event_class_code
590 p_applied_from_entity_code VARCHAR2,
591 p_applied_from_trx_id NUMBER,
592 p_app_from_hdr_trx_user_key1 VARCHAR2,
593 p_app_from_hdr_trx_user_key2 VARCHAR2,
594 p_app_from_hdr_trx_user_key3 VARCHAR2,
595 p_app_from_hdr_trx_user_key4 VARCHAR2,
596 p_app_from_hdr_trx_user_key5 VARCHAR2,
597 p_app_from_hdr_trx_user_key6 VARCHAR2,
598 p_applied_from_line_id NUMBER,
599 p_app_from_lin_trx_user_key1 VARCHAR2,
600 p_app_from_lin_trx_user_key2 VARCHAR2,
601 p_app_from_lin_trx_user_key3 VARCHAR2,
602 p_app_from_lin_trx_user_key4 VARCHAR2,
603 p_app_from_lin_trx_user_key5 VARCHAR2,
604 p_app_from_lin_trx_user_key6 VARCHAR2,
605 p_applied_from_dist_id NUMBER,
606 p_app_from_dst_trx_user_key1 VARCHAR2,
607 p_app_from_dst_trx_user_key2 VARCHAR2,
608 p_app_from_dst_trx_user_key3 VARCHAR2,
609 p_app_from_dst_trx_user_key4 VARCHAR2,
610 p_app_from_dst_trx_user_key5 VARCHAR2,
611 p_app_from_dst_trx_user_key6 VARCHAR2,
612 p_adj_doc_application_id NUMBER, --p_adjusted_doc_application_id
613 p_adj_doc_event_class_code VARCHAR2, --p_adjusted_doc_event_class_code
614 p_adjusted_doc_entity_code VARCHAR2,
615 p_adjusted_doc_trx_id NUMBER,
616 p_adj_doc_hdr_trx_user_key1 VARCHAR2,
617 p_adj_doc_hdr_trx_user_key2 VARCHAR2,
618 p_adj_doc_hdr_trx_user_key3 VARCHAR2,
619 p_adj_doc_hdr_trx_user_key4 VARCHAR2,
620 p_adj_doc_hdr_trx_user_key5 VARCHAR2,
621 p_adj_doc_hdr_trx_user_key6 VARCHAR2,
622 p_adjusted_doc_line_id NUMBER,
623 p_adj_doc_lin_trx_user_key1 VARCHAR2,
624 p_adj_doc_lin_trx_user_key2 VARCHAR2,
625 p_adj_doc_lin_trx_user_key3 VARCHAR2,
626 p_adj_doc_lin_trx_user_key4 VARCHAR2,
627 p_adj_doc_lin_trx_user_key5 VARCHAR2,
628 p_adj_doc_lin_trx_user_key6 VARCHAR2,
629 p_adjusted_doc_dist_id NUMBER,
630 p_adj_doc_dst_trx_user_key1 VARCHAR2,
634 p_adj_doc_dst_trx_user_key5 VARCHAR2,
631 p_adj_doc_dst_trx_user_key2 VARCHAR2,
632 p_adj_doc_dst_trx_user_key3 VARCHAR2,
633 p_adj_doc_dst_trx_user_key4 VARCHAR2,
635 p_adj_doc_dst_trx_user_key6 VARCHAR2,
636 p_appl_to_doc_curr_conv_rate NUMBER, --p_applied_to_doc_curr_conv_rate
637 p_tax_variance_calc_flag VARCHAR2,
638 p_ref_doc_trx_line_dist_qty NUMBER,
639 p_price_diff NUMBER,
640 p_unit_price NUMBER,
641 p_currency_exchange_rate NUMBER,
642 p_ref_doc_trx_level_type VARCHAR2,
643 p_applied_from_trx_level_type VARCHAR2,
644 p_adjusted_doc_trx_level_type VARCHAR2,
645 p_overriding_recovery_rate NUMBER,
646 p_object_version_number NUMBER,
647 p_created_by NUMBER,
648 p_creation_date DATE,
649 p_last_updated_by NUMBER,
650 p_last_update_date DATE,
651 p_last_update_login NUMBER) IS
652
653 l_return_status VARCHAR2(30);
654 l_msg_count NUMBER;
655 l_msg_data VARCHAR2(240);
656 p_error_buffer VARCHAR2(100);
657
658 BEGIN
659 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
660
661 IF (g_level_procedure >= g_current_runtime_level ) THEN
662 FND_LOG.STRING(g_level_procedure,
663 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.BEGIN',
664 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (+)');
665 FND_LOG.STRING(g_level_procedure,
666 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
667 'Update ZX_SIM_TRX_DISTS (+)');
668 END IF;
669
670 /*****************
671 UPDATE ZX_TRANSACTION
672 SET EVENT_TYPE_CODE = p_event_type_code
673 WHERE APPLICATION_ID = p_application_id
674 AND ENTITY_CODE = p_entity_code
675 AND EVENT_CLASS_CODE = p_event_class_code
676 AND TRX_ID = p_trx_id
677 AND EVENT_TYPE_CODE = 'STANDARD UPDATED';
678
679 **************/
680
681 UPDATE ZX_SIM_TRX_DISTS
682 SET APPLICATION_ID = p_application_id,
683 ENTITY_CODE = p_entity_code,
684 EVENT_CLASS_CODE = p_event_class_code,
685 --EVENT_TYPE_CODE = p_event_type_code,
686 TRX_ID = p_trx_id,
687 HDR_TRX_USER_KEY1 = p_hdr_trx_user_key1,
688 HDR_TRX_USER_KEY2 = p_hdr_trx_user_key2,
689 HDR_TRX_USER_KEY3 = p_hdr_trx_user_key3,
690 HDR_TRX_USER_KEY4 = p_hdr_trx_user_key4,
691 HDR_TRX_USER_KEY5 = p_hdr_trx_user_key5,
692 HDR_TRX_USER_KEY6 = p_hdr_trx_user_key6,
693 TRX_LINE_ID = p_trx_line_id,
694 LINE_TRX_USER_KEY1 = p_line_trx_user_key1,
695 LINE_TRX_USER_KEY2 = p_line_trx_user_key2,
696 LINE_TRX_USER_KEY3 = p_line_trx_user_key3,
697 LINE_TRX_USER_KEY4 = p_line_trx_user_key4,
698 LINE_TRX_USER_KEY5 = p_line_trx_user_key5,
699 LINE_TRX_USER_KEY6 = p_line_trx_user_key6,
700 TRX_LEVEL_TYPE = p_trx_level_type,
701 TRX_LINE_DIST_ID = p_trx_line_dist_id,
702 DIST_TRX_USER_KEY1 = p_dist_trx_user_key1,
703 DIST_TRX_USER_KEY2 = p_dist_trx_user_key2,
704 DIST_TRX_USER_KEY3 = p_dist_trx_user_key3,
705 DIST_TRX_USER_KEY4 = p_dist_trx_user_key4,
706 DIST_TRX_USER_KEY5 = p_dist_trx_user_key5,
707 DIST_TRX_USER_KEY6 = p_dist_trx_user_key6,
708 DIST_LEVEL_ACTION = p_dist_level_action,
709 TRX_LINE_DIST_DATE = p_trx_line_dist_date,
710 ITEM_DIST_NUMBER = p_item_dist_number,
711 DIST_INTENDED_USE = p_dist_intended_use,
712 TAX_INCLUSION_FLAG = p_tax_inclusion_flag,
713 TAX_CODE = p_tax_code,
714 APPLIED_FROM_TAX_DIST_ID = p_applied_from_tax_dist_id,
715 ADJUSTED_DOC_TAX_DIST_ID = p_adjusted_doc_tax_dist_id,
716 TASK_ID = p_task_id,
717 AWARD_ID = p_award_id,
718 PROJECT_ID = p_project_id,
719 EXPENDITURE_TYPE = p_expenditure_type,
720 EXPENDITURE_ORGANIZATION_ID = p_expenditure_organization_id,
721 EXPENDITURE_ITEM_DATE = p_expenditure_item_date,
722 TRX_LINE_DIST_AMT = p_trx_line_dist_amt,
723 TRX_LINE_DIST_QTY = p_trx_line_dist_qty,
724 TRX_LINE_QUANTITY = p_trx_line_quantity,
725 ACCOUNT_CCID = p_account_ccid,
726 ACCOUNT_STRING = p_account_string,
727 REF_DOC_APPLICATION_ID = p_ref_doc_application_id,
728 REF_DOC_ENTITY_CODE = p_ref_doc_entity_code,
729 REF_DOC_EVENT_CLASS_CODE = p_ref_doc_event_class_code,
730 REF_DOC_TRX_ID = p_ref_doc_trx_id,
731 REF_DOC_HDR_TRX_USER_KEY1 = p_ref_doc_hdr_trx_user_key1,
732 REF_DOC_HDR_TRX_USER_KEY2 = p_ref_doc_hdr_trx_user_key2,
736 REF_DOC_HDR_TRX_USER_KEY6 = p_ref_doc_hdr_trx_user_key6,
733 REF_DOC_HDR_TRX_USER_KEY3 = p_ref_doc_hdr_trx_user_key3,
734 REF_DOC_HDR_TRX_USER_KEY4 = p_ref_doc_hdr_trx_user_key4,
735 REF_DOC_HDR_TRX_USER_KEY5 = p_ref_doc_hdr_trx_user_key5,
737 REF_DOC_LINE_ID = p_ref_doc_line_id,
738 REF_DOC_LIN_TRX_USER_KEY1 = p_ref_doc_lin_trx_user_key1,
739 REF_DOC_LIN_TRX_USER_KEY2 = p_ref_doc_lin_trx_user_key2,
740 REF_DOC_LIN_TRX_USER_KEY3 = p_ref_doc_lin_trx_user_key3,
741 REF_DOC_LIN_TRX_USER_KEY4 = p_ref_doc_lin_trx_user_key4,
742 REF_DOC_LIN_TRX_USER_KEY5 = p_ref_doc_lin_trx_user_key5,
743 REF_DOC_LIN_TRX_USER_KEY6 = p_ref_doc_lin_trx_user_key6,
744 REF_DOC_DIST_ID = p_ref_doc_dist_id,
745 REF_DOC_DIST_TRX_USER_KEY1 = p_ref_doc_dist_trx_user_key1,
746 REF_DOC_DIST_TRX_USER_KEY2 = p_ref_doc_dist_trx_user_key2,
747 REF_DOC_DIST_TRX_USER_KEY3 = p_ref_doc_dist_trx_user_key3,
748 REF_DOC_DIST_TRX_USER_KEY4 = p_ref_doc_dist_trx_user_key4,
749 REF_DOC_DIST_TRX_USER_KEY5 = p_ref_doc_dist_trx_user_key5,
750 REF_DOC_DIST_TRX_USER_KEY6 = p_ref_doc_dist_trx_user_key6,
751 REF_DOC_CURR_CONV_RATE = p_ref_doc_curr_conv_rate,
752 NUMERIC1 = p_numeric1,
753 NUMERIC2 = p_numeric2,
754 NUMERIC3 = p_numeric3,
755 NUMERIC4 = p_numeric4,
756 NUMERIC5 = p_numeric5,
757 CHAR1 = p_char1,
758 CHAR2 = p_char2,
759 CHAR3 = p_char3,
760 CHAR4 = p_char4,
761 CHAR5 = p_char5,
762 DATE1 = p_date1,
763 DATE2 = p_date2,
764 DATE3 = p_date3,
765 DATE4 = p_date4,
766 DATE5 = p_date5,
767 TRX_LINE_DIST_TAX_AMT = p_trx_line_dist_tax_amt,
768 HISTORICAL_FLAG = p_historical_flag,
769 APPLIED_FROM_APPLICATION_ID = p_applied_from_application_id,
770 APPLIED_FROM_EVENT_CLASS_CODE = p_appl_from_event_class_code,
771 APPLIED_FROM_ENTITY_CODE = p_applied_from_entity_code,
772 APPLIED_FROM_TRX_ID = p_applied_from_trx_id,
773 APP_FROM_HDR_TRX_USER_KEY1 = p_app_from_hdr_trx_user_key1,
774 APP_FROM_HDR_TRX_USER_KEY2 = p_app_from_hdr_trx_user_key2,
775 APP_FROM_HDR_TRX_USER_KEY3 = p_app_from_hdr_trx_user_key3,
776 APP_FROM_HDR_TRX_USER_KEY4 = p_app_from_hdr_trx_user_key4,
777 APP_FROM_HDR_TRX_USER_KEY5 = p_app_from_hdr_trx_user_key5,
778 APP_FROM_HDR_TRX_USER_KEY6 = p_app_from_hdr_trx_user_key6,
779 APPLIED_FROM_LINE_ID = p_applied_from_line_id,
780 APP_FROM_LIN_TRX_USER_KEY1 = p_app_from_lin_trx_user_key1,
781 APP_FROM_LIN_TRX_USER_KEY2 = p_app_from_lin_trx_user_key2,
782 APP_FROM_LIN_TRX_USER_KEY3 = p_app_from_lin_trx_user_key3,
783 APP_FROM_LIN_TRX_USER_KEY4 = p_app_from_lin_trx_user_key4,
784 APP_FROM_LIN_TRX_USER_KEY5 = p_app_from_lin_trx_user_key5,
785 APP_FROM_LIN_TRX_USER_KEY6 = p_app_from_lin_trx_user_key6,
786 APPLIED_FROM_DIST_ID = p_applied_from_dist_id,
787 APP_FROM_DST_TRX_USER_KEY1 = p_app_from_dst_trx_user_key1,
788 APP_FROM_DST_TRX_USER_KEY2 = p_app_from_dst_trx_user_key2,
789 APP_FROM_DST_TRX_USER_KEY3 = p_app_from_dst_trx_user_key3,
790 APP_FROM_DST_TRX_USER_KEY4 = p_app_from_dst_trx_user_key4,
791 APP_FROM_DST_TRX_USER_KEY5 = p_app_from_dst_trx_user_key5,
792 APP_FROM_DST_TRX_USER_KEY6 = p_app_from_dst_trx_user_key6,
793 ADJUSTED_DOC_APPLICATION_ID = p_adj_doc_application_id,
794 ADJUSTED_DOC_EVENT_CLASS_CODE = p_adj_doc_event_class_code,
795 ADJUSTED_DOC_ENTITY_CODE = p_adjusted_doc_entity_code,
796 ADJUSTED_DOC_TRX_ID = p_adjusted_doc_trx_id,
797 ADJ_DOC_HDR_TRX_USER_KEY1 = p_adj_doc_hdr_trx_user_key1,
798 ADJ_DOC_HDR_TRX_USER_KEY2 = p_adj_doc_hdr_trx_user_key2,
799 ADJ_DOC_HDR_TRX_USER_KEY3 = p_adj_doc_hdr_trx_user_key3,
800 ADJ_DOC_HDR_TRX_USER_KEY4 = p_adj_doc_hdr_trx_user_key4,
801 ADJ_DOC_HDR_TRX_USER_KEY5 = p_adj_doc_hdr_trx_user_key5,
802 ADJ_DOC_HDR_TRX_USER_KEY6 = p_adj_doc_hdr_trx_user_key6,
803 ADJUSTED_DOC_LINE_ID = p_adjusted_doc_line_id,
804 ADJ_DOC_LIN_TRX_USER_KEY1 = p_adj_doc_lin_trx_user_key1,
805 ADJ_DOC_LIN_TRX_USER_KEY2 = p_adj_doc_lin_trx_user_key2,
806 ADJ_DOC_LIN_TRX_USER_KEY3 = p_adj_doc_lin_trx_user_key3,
807 ADJ_DOC_LIN_TRX_USER_KEY4 = p_adj_doc_lin_trx_user_key4,
808 ADJ_DOC_LIN_TRX_USER_KEY5 = p_adj_doc_lin_trx_user_key5,
809 ADJ_DOC_LIN_TRX_USER_KEY6 = p_adj_doc_lin_trx_user_key6,
810 ADJUSTED_DOC_DIST_ID = p_adjusted_doc_dist_id,
811 ADJ_DOC_DST_TRX_USER_KEY1 = p_adj_doc_dst_trx_user_key1,
812 ADJ_DOC_DST_TRX_USER_KEY2 = p_adj_doc_dst_trx_user_key2,
813 ADJ_DOC_DST_TRX_USER_KEY3 = p_adj_doc_dst_trx_user_key3,
814 ADJ_DOC_DST_TRX_USER_KEY4 = p_adj_doc_dst_trx_user_key4,
815 ADJ_DOC_DST_TRX_USER_KEY5 = p_adj_doc_dst_trx_user_key5,
816 ADJ_DOC_DST_TRX_USER_KEY6 = p_adj_doc_dst_trx_user_key6,
817 APPLIED_TO_DOC_CURR_CONV_RATE = p_appl_to_doc_curr_conv_rate,
818 TAX_VARIANCE_CALC_FLAG = p_tax_variance_calc_flag,
819 REF_DOC_TRX_LINE_DIST_QTY = p_ref_doc_trx_line_dist_qty,
820 PRICE_DIFF = p_price_diff,
821 UNIT_PRICE = p_unit_price,
822 CURRENCY_EXCHANGE_RATE = p_currency_exchange_rate,
823 REF_DOC_TRX_LEVEL_TYPE = p_ref_doc_trx_level_type,
824 APPLIED_FROM_TRX_LEVEL_type = p_applied_from_trx_level_type,
825 ADJUSTED_DOC_TRX_LEVEL_TYPE = p_adjusted_doc_trx_level_type,
826 OVERRIDING_RECOVERY_RATE = p_overriding_recovery_rate,
827 OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1),
828 CREATED_BY = p_created_by,
829 CREATION_DATE = p_creation_date,
830 LAST_UPDATED_BY = p_last_updated_by,
831 LAST_UPDATE_DATE = p_last_update_date,
832 LAST_UPDATE_LOGIN = p_last_update_login
833 WHERE APPLICATION_ID = p_application_id
834 AND ENTITY_CODE = p_entity_code
835 AND EVENT_CLASS_CODE = p_event_class_code
836 AND TRX_ID = p_trx_id
837 AND TRX_LINE_ID = p_trx_line_id
838 AND TRX_LEVEL_TYPE = p_trx_level_type
839 AND TRX_LINE_DIST_ID = p_trx_line_dist_id;
840
841 IF (g_level_procedure >= g_current_runtime_level ) THEN
842 FND_LOG.STRING(g_level_procedure,
843 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
844 'Update ZX_SIM_TRX_DISTS (-)');
845 FND_LOG.STRING(g_level_procedure,
846 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.END',
847 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (-)');
848 END IF;
849
850 END Update_row;
851
852 PROCEDURE Delete_row
853 (p_application_id NUMBER,
854 p_entity_code VARCHAR2,
855 p_event_class_code VARCHAR2,
856 --p_event_type_code VARCHAR2,
857 p_trx_id NUMBER,
858 p_hdr_trx_user_key1 VARCHAR2,
859 p_hdr_trx_user_key2 VARCHAR2,
860 p_hdr_trx_user_key3 VARCHAR2,
861 p_hdr_trx_user_key4 VARCHAR2,
862 p_hdr_trx_user_key5 VARCHAR2,
863 p_hdr_trx_user_key6 VARCHAR2,
864 p_trx_line_id NUMBER,
865 p_line_trx_user_key1 VARCHAR2,
866 p_line_trx_user_key2 VARCHAR2,
867 p_line_trx_user_key3 VARCHAR2,
868 p_line_trx_user_key4 VARCHAR2,
869 p_line_trx_user_key5 VARCHAR2,
870 p_line_trx_user_key6 VARCHAR2,
871 p_trx_level_type VARCHAR2,
872 p_trx_line_dist_id NUMBER,
873 p_dist_trx_user_key1 VARCHAR2,
874 p_dist_trx_user_key2 VARCHAR2,
875 p_dist_trx_user_key3 VARCHAR2,
876 p_dist_trx_user_key4 VARCHAR2,
877 p_dist_trx_user_key5 VARCHAR2,
878 p_dist_trx_user_key6 VARCHAR2,
879 p_dist_level_action VARCHAR2,
880 p_trx_line_dist_date DATE,
881 p_item_dist_number NUMBER,
882 p_dist_intended_use VARCHAR2,
883 p_tax_inclusion_flag VARCHAR2,
884 p_tax_code VARCHAR2,
885 p_applied_from_tax_dist_id NUMBER,
886 p_adjusted_doc_tax_dist_id NUMBER,
887 p_task_id NUMBER,
888 p_award_id NUMBER,
889 p_project_id NUMBER,
890 p_expenditure_type VARCHAR2,
891 p_expenditure_organization_id NUMBER,
892 p_expenditure_item_date DATE,
893 p_trx_line_dist_amt NUMBER,
894 p_trx_line_dist_qty NUMBER,
895 p_trx_line_quantity NUMBER,
896 p_account_ccid NUMBER,
897 p_account_string VARCHAR2,
898 p_ref_doc_application_id NUMBER,
899 p_ref_doc_entity_code VARCHAR2,
900 p_ref_doc_event_class_code VARCHAR2,
901 p_ref_doc_trx_id NUMBER,
902 p_ref_doc_hdr_trx_user_key1 VARCHAR2,
903 p_ref_doc_hdr_trx_user_key2 VARCHAR2,
904 p_ref_doc_hdr_trx_user_key3 VARCHAR2,
905 p_ref_doc_hdr_trx_user_key4 VARCHAR2,
906 p_ref_doc_hdr_trx_user_key5 VARCHAR2,
907 p_ref_doc_hdr_trx_user_key6 VARCHAR2,
908 p_ref_doc_line_id NUMBER,
909 p_ref_doc_lin_trx_user_key1 VARCHAR2,
910 p_ref_doc_lin_trx_user_key2 VARCHAR2,
911 p_ref_doc_lin_trx_user_key3 VARCHAR2,
912 p_ref_doc_lin_trx_user_key4 VARCHAR2,
913 p_ref_doc_lin_trx_user_key5 VARCHAR2,
914 p_ref_doc_lin_trx_user_key6 VARCHAR2,
915 p_ref_doc_dist_id NUMBER,
916 p_ref_doc_dist_trx_user_key1 VARCHAR2,
917 p_ref_doc_dist_trx_user_key2 VARCHAR2,
918 p_ref_doc_dist_trx_user_key3 VARCHAR2,
919 p_ref_doc_dist_trx_user_key4 VARCHAR2,
920 p_ref_doc_dist_trx_user_key5 VARCHAR2,
921 p_ref_doc_dist_trx_user_key6 VARCHAR2,
922 p_ref_doc_curr_conv_rate NUMBER,
923 p_numeric1 NUMBER,
924 p_numeric2 NUMBER,
925 p_numeric3 NUMBER,
926 p_numeric4 NUMBER,
927 p_numeric5 NUMBER,
928 p_char1 VARCHAR2,
929 p_char2 VARCHAR2,
930 p_char3 VARCHAR2,
931 p_char4 VARCHAR2,
932 p_char5 VARCHAR2,
933 p_date1 DATE,
934 p_date2 DATE,
935 p_date3 DATE,
936 p_date4 DATE,
937 p_date5 DATE,
938 p_trx_line_dist_tax_amt NUMBER,
939 p_historical_flag VARCHAR2,
940 p_applied_from_application_id NUMBER,
941 p_appl_from_event_class_code VARCHAR2, --p_applied_from_event_class_code
942 p_applied_from_entity_code VARCHAR2,
943 p_applied_from_trx_id NUMBER,
944 p_app_from_hdr_trx_user_key1 VARCHAR2,
945 p_app_from_hdr_trx_user_key2 VARCHAR2,
946 p_app_from_hdr_trx_user_key3 VARCHAR2,
947 p_app_from_hdr_trx_user_key4 VARCHAR2,
948 p_app_from_hdr_trx_user_key5 VARCHAR2,
949 p_app_from_hdr_trx_user_key6 VARCHAR2,
950 p_applied_from_line_id NUMBER,
951 p_app_from_lin_trx_user_key1 VARCHAR2,
952 p_app_from_lin_trx_user_key2 VARCHAR2,
953 p_app_from_lin_trx_user_key3 VARCHAR2,
954 p_app_from_lin_trx_user_key4 VARCHAR2,
955 p_app_from_lin_trx_user_key5 VARCHAR2,
956 p_app_from_lin_trx_user_key6 VARCHAR2,
957 p_applied_from_dist_id NUMBER,
958 p_app_from_dst_trx_user_key1 VARCHAR2,
959 p_app_from_dst_trx_user_key2 VARCHAR2,
960 p_app_from_dst_trx_user_key3 VARCHAR2,
961 p_app_from_dst_trx_user_key4 VARCHAR2,
962 p_app_from_dst_trx_user_key5 VARCHAR2,
963 p_app_from_dst_trx_user_key6 VARCHAR2,
964 p_adj_doc_application_id NUMBER, --p_adjusted_doc_application_id
965 p_adj_doc_event_class_code VARCHAR2, --p_adjusted_doc_event_class_code
966 p_adjusted_doc_entity_code VARCHAR2,
967 p_adjusted_doc_trx_id NUMBER,
968 p_adj_doc_hdr_trx_user_key1 VARCHAR2,
969 p_adj_doc_hdr_trx_user_key2 VARCHAR2,
970 p_adj_doc_hdr_trx_user_key3 VARCHAR2,
971 p_adj_doc_hdr_trx_user_key4 VARCHAR2,
975 p_adj_doc_lin_trx_user_key1 VARCHAR2,
972 p_adj_doc_hdr_trx_user_key5 VARCHAR2,
973 p_adj_doc_hdr_trx_user_key6 VARCHAR2,
974 p_adjusted_doc_line_id NUMBER,
976 p_adj_doc_lin_trx_user_key2 VARCHAR2,
977 p_adj_doc_lin_trx_user_key3 VARCHAR2,
978 p_adj_doc_lin_trx_user_key4 VARCHAR2,
979 p_adj_doc_lin_trx_user_key5 VARCHAR2,
980 p_adj_doc_lin_trx_user_key6 VARCHAR2,
981 p_adjusted_doc_dist_id NUMBER,
982 p_adj_doc_dst_trx_user_key1 VARCHAR2,
983 p_adj_doc_dst_trx_user_key2 VARCHAR2,
984 p_adj_doc_dst_trx_user_key3 VARCHAR2,
985 p_adj_doc_dst_trx_user_key4 VARCHAR2,
986 p_adj_doc_dst_trx_user_key5 VARCHAR2,
987 p_adj_doc_dst_trx_user_key6 VARCHAR2,
988 p_appl_to_doc_curr_conv_rate NUMBER, --p_applied_to_doc_curr_conv_rate
989 p_tax_variance_calc_flag VARCHAR2,
990 p_ref_doc_trx_line_dist_qty NUMBER,
991 p_price_diff NUMBER,
992 p_unit_price NUMBER,
993 p_currency_exchange_rate NUMBER,
994 p_ref_doc_trx_level_type VARCHAR2,
995 p_applied_from_trx_level_type VARCHAR2,
996 p_adjusted_doc_trx_level_type VARCHAR2,
997 p_overriding_recovery_rate NUMBER,
998 p_object_version_number NUMBER,
999 p_created_by NUMBER,
1000 p_creation_date DATE,
1001 p_last_updated_by NUMBER,
1002 p_last_update_date DATE,
1003 p_last_update_login NUMBER) IS
1004
1005 l_return_status VARCHAR2(30);
1006 l_msg_count NUMBER;
1007 l_msg_data VARCHAR2(240);
1008 p_error_buffer VARCHAR2(100);
1009
1010 BEGIN
1011 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1012
1013 IF (g_level_procedure >= g_current_runtime_level ) THEN
1014 FND_LOG.STRING(g_level_procedure,
1015 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.BEGIN',
1016 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (+)');
1017 FND_LOG.STRING(g_level_procedure,
1018 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1019 'Delete from ZX_SIM_TRX_DISTRIBUTION (+)');
1020 END IF;
1021
1022 /* Delete code */
1023
1024 IF (g_level_procedure >= g_current_runtime_level ) THEN
1025 FND_LOG.STRING(g_level_procedure,
1026 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1027 'Delete from ZX_SIM_TRX_DISTRIBUTION (-)');
1028 FND_LOG.STRING(g_level_procedure,
1029 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.END',
1030 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (-)');
1031 END IF;
1032
1033 END Delete_row;
1034
1035 PROCEDURE Lock_row
1036 (p_application_id NUMBER,
1037 p_entity_code VARCHAR2,
1038 p_event_class_code VARCHAR2,
1039 --p_event_type_code VARCHAR2,
1040 p_trx_id NUMBER,
1041 p_hdr_trx_user_key1 VARCHAR2,
1042 p_hdr_trx_user_key2 VARCHAR2,
1043 p_hdr_trx_user_key3 VARCHAR2,
1044 p_hdr_trx_user_key4 VARCHAR2,
1045 p_hdr_trx_user_key5 VARCHAR2,
1046 p_hdr_trx_user_key6 VARCHAR2,
1047 p_trx_line_id NUMBER,
1048 p_line_trx_user_key1 VARCHAR2,
1049 p_line_trx_user_key2 VARCHAR2,
1050 p_line_trx_user_key3 VARCHAR2,
1051 p_line_trx_user_key4 VARCHAR2,
1052 p_line_trx_user_key5 VARCHAR2,
1053 p_line_trx_user_key6 VARCHAR2,
1054 p_trx_level_type VARCHAR2,
1055 p_trx_line_dist_id NUMBER,
1056 p_dist_trx_user_key1 VARCHAR2,
1057 p_dist_trx_user_key2 VARCHAR2,
1058 p_dist_trx_user_key3 VARCHAR2,
1059 p_dist_trx_user_key4 VARCHAR2,
1060 p_dist_trx_user_key5 VARCHAR2,
1061 p_dist_trx_user_key6 VARCHAR2,
1062 p_dist_level_action VARCHAR2,
1063 p_trx_line_dist_date DATE,
1064 p_item_dist_number NUMBER,
1065 p_dist_intended_use VARCHAR2,
1066 p_tax_inclusion_flag VARCHAR2,
1067 p_tax_code VARCHAR2,
1068 p_applied_from_tax_dist_id NUMBER,
1069 p_adjusted_doc_tax_dist_id NUMBER,
1070 p_task_id NUMBER,
1071 p_award_id NUMBER,
1072 p_project_id NUMBER,
1073 p_expenditure_type VARCHAR2,
1074 p_expenditure_organization_id NUMBER,
1075 p_expenditure_item_date DATE,
1076 p_trx_line_dist_amt NUMBER,
1077 p_trx_line_dist_qty NUMBER,
1078 p_trx_line_quantity NUMBER,
1079 p_account_ccid NUMBER,
1080 p_account_string VARCHAR2,
1081 p_ref_doc_application_id NUMBER,
1082 p_ref_doc_entity_code VARCHAR2,
1083 p_ref_doc_event_class_code VARCHAR2,
1084 p_ref_doc_trx_id NUMBER,
1085 p_ref_doc_hdr_trx_user_key1 VARCHAR2,
1086 p_ref_doc_hdr_trx_user_key2 VARCHAR2,
1087 p_ref_doc_hdr_trx_user_key3 VARCHAR2,
1088 p_ref_doc_hdr_trx_user_key4 VARCHAR2,
1089 p_ref_doc_hdr_trx_user_key5 VARCHAR2,
1090 p_ref_doc_hdr_trx_user_key6 VARCHAR2,
1091 p_ref_doc_line_id NUMBER,
1092 p_ref_doc_lin_trx_user_key1 VARCHAR2,
1093 p_ref_doc_lin_trx_user_key2 VARCHAR2,
1094 p_ref_doc_lin_trx_user_key3 VARCHAR2,
1095 p_ref_doc_lin_trx_user_key4 VARCHAR2,
1096 p_ref_doc_lin_trx_user_key5 VARCHAR2,
1097 p_ref_doc_lin_trx_user_key6 VARCHAR2,
1098 p_ref_doc_dist_id NUMBER,
1099 p_ref_doc_dist_trx_user_key1 VARCHAR2,
1100 p_ref_doc_dist_trx_user_key2 VARCHAR2,
1101 p_ref_doc_dist_trx_user_key3 VARCHAR2,
1102 p_ref_doc_dist_trx_user_key4 VARCHAR2,
1103 p_ref_doc_dist_trx_user_key5 VARCHAR2,
1104 p_ref_doc_dist_trx_user_key6 VARCHAR2,
1105 p_ref_doc_curr_conv_rate NUMBER,
1106 p_numeric1 NUMBER,
1107 p_numeric2 NUMBER,
1108 p_numeric3 NUMBER,
1109 p_numeric4 NUMBER,
1110 p_numeric5 NUMBER,
1111 p_char1 VARCHAR2,
1112 p_char2 VARCHAR2,
1113 p_char3 VARCHAR2,
1114 p_char4 VARCHAR2,
1115 p_char5 VARCHAR2,
1116 p_date1 DATE,
1117 p_date2 DATE,
1118 p_date3 DATE,
1119 p_date4 DATE,
1120 p_date5 DATE,
1121 p_trx_line_dist_tax_amt NUMBER,
1122 p_historical_flag VARCHAR2,
1123 p_applied_from_application_id NUMBER,
1124 p_appl_from_event_class_code VARCHAR2, --p_applied_from_event_class_code
1125 p_applied_from_entity_code VARCHAR2,
1126 p_applied_from_trx_id NUMBER,
1127 p_app_from_hdr_trx_user_key1 VARCHAR2,
1128 p_app_from_hdr_trx_user_key2 VARCHAR2,
1129 p_app_from_hdr_trx_user_key3 VARCHAR2,
1130 p_app_from_hdr_trx_user_key4 VARCHAR2,
1131 p_app_from_hdr_trx_user_key5 VARCHAR2,
1132 p_app_from_hdr_trx_user_key6 VARCHAR2,
1133 p_applied_from_line_id NUMBER,
1134 p_app_from_lin_trx_user_key1 VARCHAR2,
1135 p_app_from_lin_trx_user_key2 VARCHAR2,
1136 p_app_from_lin_trx_user_key3 VARCHAR2,
1137 p_app_from_lin_trx_user_key4 VARCHAR2,
1138 p_app_from_lin_trx_user_key5 VARCHAR2,
1139 p_app_from_lin_trx_user_key6 VARCHAR2,
1140 p_applied_from_dist_id NUMBER,
1141 p_app_from_dst_trx_user_key1 VARCHAR2,
1142 p_app_from_dst_trx_user_key2 VARCHAR2,
1143 p_app_from_dst_trx_user_key3 VARCHAR2,
1144 p_app_from_dst_trx_user_key4 VARCHAR2,
1145 p_app_from_dst_trx_user_key5 VARCHAR2,
1146 p_app_from_dst_trx_user_key6 VARCHAR2,
1147 p_adj_doc_application_id NUMBER, --p_adjusted_doc_application_id
1148 p_adj_doc_event_class_code VARCHAR2, --p_adjusted_doc_event_class_code
1149 p_adjusted_doc_entity_code VARCHAR2,
1150 p_adjusted_doc_trx_id NUMBER,
1151 p_adj_doc_hdr_trx_user_key1 VARCHAR2,
1152 p_adj_doc_hdr_trx_user_key2 VARCHAR2,
1153 p_adj_doc_hdr_trx_user_key3 VARCHAR2,
1154 p_adj_doc_hdr_trx_user_key4 VARCHAR2,
1155 p_adj_doc_hdr_trx_user_key5 VARCHAR2,
1159 p_adj_doc_lin_trx_user_key2 VARCHAR2,
1156 p_adj_doc_hdr_trx_user_key6 VARCHAR2,
1157 p_adjusted_doc_line_id NUMBER,
1158 p_adj_doc_lin_trx_user_key1 VARCHAR2,
1160 p_adj_doc_lin_trx_user_key3 VARCHAR2,
1161 p_adj_doc_lin_trx_user_key4 VARCHAR2,
1162 p_adj_doc_lin_trx_user_key5 VARCHAR2,
1163 p_adj_doc_lin_trx_user_key6 VARCHAR2,
1164 p_adjusted_doc_dist_id NUMBER,
1165 p_adj_doc_dst_trx_user_key1 VARCHAR2,
1166 p_adj_doc_dst_trx_user_key2 VARCHAR2,
1167 p_adj_doc_dst_trx_user_key3 VARCHAR2,
1168 p_adj_doc_dst_trx_user_key4 VARCHAR2,
1169 p_adj_doc_dst_trx_user_key5 VARCHAR2,
1170 p_adj_doc_dst_trx_user_key6 VARCHAR2,
1171 p_appl_to_doc_curr_conv_rate NUMBER, --p_applied_to_doc_curr_conv_rate
1172 p_tax_variance_calc_flag VARCHAR2,
1173 p_ref_doc_trx_line_dist_qty NUMBER,
1174 p_price_diff NUMBER,
1175 p_unit_price NUMBER,
1176 p_currency_exchange_rate NUMBER,
1177 p_ref_doc_trx_level_type VARCHAR2,
1178 p_applied_from_trx_level_type VARCHAR2,
1179 p_adjusted_doc_trx_level_type VARCHAR2,
1180 p_overriding_recovery_rate NUMBER,
1181 p_object_version_number NUMBER,
1182 p_created_by NUMBER,
1183 p_creation_date DATE,
1184 p_last_updated_by NUMBER,
1185 p_last_update_date DATE,
1186 p_last_update_login NUMBER) IS
1187
1188 CURSOR C IS
1189 SELECT APPLICATION_ID,
1190 ENTITY_CODE,
1191 EVENT_CLASS_CODE,
1192 --EVENT_TYPE_CODE,
1193 TRX_ID,
1194 HDR_TRX_USER_KEY1,
1195 HDR_TRX_USER_KEY2,
1196 HDR_TRX_USER_KEY3,
1197 HDR_TRX_USER_KEY4,
1198 HDR_TRX_USER_KEY5,
1199 HDR_TRX_USER_KEY6,
1200 TRX_LINE_ID,
1201 LINE_TRX_USER_KEY1,
1202 LINE_TRX_USER_KEY2,
1203 LINE_TRX_USER_KEY3,
1204 LINE_TRX_USER_KEY4,
1205 LINE_TRX_USER_KEY5,
1206 LINE_TRX_USER_KEY6,
1207 TRX_LEVEL_TYPE,
1208 TRX_LINE_DIST_ID,
1209 DIST_TRX_USER_KEY1,
1210 DIST_TRX_USER_KEY2,
1211 DIST_TRX_USER_KEY3,
1212 DIST_TRX_USER_KEY4,
1213 DIST_TRX_USER_KEY5,
1214 DIST_TRX_USER_KEY6,
1215 DIST_LEVEL_ACTION,
1216 TRX_LINE_DIST_DATE,
1217 ITEM_DIST_NUMBER,
1218 DIST_INTENDED_USE,
1219 TAX_INCLUSION_FLAG,
1220 TAX_CODE,
1221 APPLIED_FROM_TAX_DIST_ID,
1222 ADJUSTED_DOC_TAX_DIST_ID,
1223 TASK_ID,
1224 AWARD_ID,
1225 PROJECT_ID,
1226 EXPENDITURE_TYPE,
1227 EXPENDITURE_ORGANIZATION_ID,
1228 EXPENDITURE_ITEM_DATE,
1229 TRX_LINE_DIST_AMT,
1230 TRX_LINE_DIST_QTY,
1231 TRX_LINE_QUANTITY,
1232 ACCOUNT_CCID,
1233 ACCOUNT_STRING,
1234 REF_DOC_APPLICATION_ID,
1235 REF_DOC_ENTITY_CODE,
1236 REF_DOC_EVENT_CLASS_CODE,
1237 REF_DOC_TRX_ID,
1238 REF_DOC_HDR_TRX_USER_KEY1,
1239 REF_DOC_HDR_TRX_USER_KEY2,
1240 REF_DOC_HDR_TRX_USER_KEY3,
1241 REF_DOC_HDR_TRX_USER_KEY4,
1242 REF_DOC_HDR_TRX_USER_KEY5,
1243 REF_DOC_HDR_TRX_USER_KEY6,
1244 REF_DOC_LINE_ID,
1245 REF_DOC_LIN_TRX_USER_KEY1,
1246 REF_DOC_LIN_TRX_USER_KEY2,
1247 REF_DOC_LIN_TRX_USER_KEY3,
1248 REF_DOC_LIN_TRX_USER_KEY4,
1249 REF_DOC_LIN_TRX_USER_KEY5,
1250 REF_DOC_LIN_TRX_USER_KEY6,
1251 REF_DOC_DIST_ID,
1252 REF_DOC_DIST_TRX_USER_KEY1,
1253 REF_DOC_DIST_TRX_USER_KEY2,
1254 REF_DOC_DIST_TRX_USER_KEY3,
1255 REF_DOC_DIST_TRX_USER_KEY4,
1256 REF_DOC_DIST_TRX_USER_KEY5,
1257 REF_DOC_DIST_TRX_USER_KEY6,
1258 REF_DOC_CURR_CONV_RATE,
1259 NUMERIC1,
1260 NUMERIC2,
1261 NUMERIC3,
1262 NUMERIC4,
1263 NUMERIC5,
1264 CHAR1,
1265 CHAR2,
1266 CHAR3,
1267 CHAR4,
1268 CHAR5,
1269 DATE1,
1270 DATE2,
1271 DATE3,
1272 DATE4,
1273 DATE5,
1274 TRX_LINE_DIST_TAX_AMT,
1275 HISTORICAL_FLAG,
1276 APPLIED_FROM_APPLICATION_ID,
1277 APPLIED_FROM_EVENT_CLASS_CODE,
1278 APPLIED_FROM_ENTITY_CODE,
1279 APPLIED_FROM_TRX_ID,
1280 APP_FROM_HDR_TRX_USER_KEY1,
1281 APP_FROM_HDR_TRX_USER_KEY2,
1282 APP_FROM_HDR_TRX_USER_KEY3,
1283 APP_FROM_HDR_TRX_USER_KEY4,
1284 APP_FROM_HDR_TRX_USER_KEY5,
1285 APP_FROM_HDR_TRX_USER_KEY6,
1286 APPLIED_FROM_LINE_ID,
1287 APP_FROM_LIN_TRX_USER_KEY1,
1288 APP_FROM_LIN_TRX_USER_KEY2,
1289 APP_FROM_LIN_TRX_USER_KEY3,
1290 APP_FROM_LIN_TRX_USER_KEY4,
1291 APP_FROM_LIN_TRX_USER_KEY5,
1292 APP_FROM_LIN_TRX_USER_KEY6,
1293 APPLIED_FROM_DIST_ID,
1294 APP_FROM_DST_TRX_USER_KEY1,
1295 APP_FROM_DST_TRX_USER_KEY2,
1296 APP_FROM_DST_TRX_USER_KEY3,
1297 APP_FROM_DST_TRX_USER_KEY4,
1298 APP_FROM_DST_TRX_USER_KEY5,
1299 APP_FROM_DST_TRX_USER_KEY6,
1300 ADJUSTED_DOC_APPLICATION_ID,
1301 ADJUSTED_DOC_EVENT_CLASS_CODE,
1302 ADJUSTED_DOC_ENTITY_CODE,
1303 ADJUSTED_DOC_TRX_ID,
1304 ADJ_DOC_HDR_TRX_USER_KEY1,
1305 ADJ_DOC_HDR_TRX_USER_KEY2,
1306 ADJ_DOC_HDR_TRX_USER_KEY3,
1307 ADJ_DOC_HDR_TRX_USER_KEY4,
1308 ADJ_DOC_HDR_TRX_USER_KEY5,
1309 ADJ_DOC_HDR_TRX_USER_KEY6,
1310 ADJUSTED_DOC_LINE_ID,
1311 ADJ_DOC_LIN_TRX_USER_KEY1,
1312 ADJ_DOC_LIN_TRX_USER_KEY2,
1313 ADJ_DOC_LIN_TRX_USER_KEY3,
1314 ADJ_DOC_LIN_TRX_USER_KEY4,
1315 ADJ_DOC_LIN_TRX_USER_KEY5,
1316 ADJ_DOC_LIN_TRX_USER_KEY6,
1317 ADJUSTED_DOC_DIST_ID,
1318 ADJ_DOC_DST_TRX_USER_KEY1,
1319 ADJ_DOC_DST_TRX_USER_KEY2,
1320 ADJ_DOC_DST_TRX_USER_KEY3,
1321 ADJ_DOC_DST_TRX_USER_KEY4,
1322 ADJ_DOC_DST_TRX_USER_KEY5,
1323 ADJ_DOC_DST_TRX_USER_KEY6,
1324 APPLIED_TO_DOC_CURR_CONV_RATE,
1325 TAX_VARIANCE_CALC_FLAG,
1326 REF_DOC_TRX_LINE_DIST_QTY,
1327 PRICE_DIFF,
1328 UNIT_PRICE,
1329 CURRENCY_EXCHANGE_RATE,
1330 REF_DOC_TRX_LEVEL_TYPE,
1331 APPLIED_FROM_TRX_LEVEL_TYPE,
1332 ADJUSTED_DOC_TRX_LEVEL_TYPE,
1333 OVERRIDING_RECOVERY_RATE,
1334 OBJECT_VERSION_NUMBER,
1335 CREATED_BY,
1336 CREATION_DATE,
1337 LAST_UPDATED_BY,
1338 LAST_UPDATE_DATE,
1339 LAST_UPDATE_LOGIN
1340 FROM ZX_SIM_TRX_DISTS
1341 WHERE APPLICATION_ID = p_application_id
1342 AND ENTITY_CODE = p_entity_code
1343 AND EVENT_CLASS_CODE = p_event_class_code
1344 AND TRX_LINE_ID = p_trx_line_id
1345 AND TRX_LEVEL_TYPE = p_trx_level_type
1346 AND TRX_LINE_DIST_ID = p_trx_line_dist_id
1347 AND TRX_ID = p_trx_id
1348 FOR UPDATE OF APPLICATION_ID,
1349 ENTITY_CODE,
1350 EVENT_CLASS_CODE,
1351 TRX_LINE_ID,
1352 TRX_LEVEL_TYPE,
1353 TRX_LINE_DIST_ID,
1354 TRX_ID
1355 NOWAIT;
1356
1357 Recinfo C%ROWTYPE;
1358 debug_info VARCHAR2(100);
1359 p_error_buffer VARCHAR2(100);
1360
1361 BEGIN
1362
1363 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1364 IF (g_level_procedure >= g_current_runtime_level ) THEN
1365 FND_LOG.STRING(g_level_procedure,
1366 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.BEGIN',
1367 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (+)');
1368 END IF;
1369
1370 debug_info := 'Open cursor C';
1371 OPEN C;
1372 debug_info := 'Fetch cursor C';
1373 FETCH C INTO Recinfo;
1374
1375 IF (C%NOTFOUND) THEN
1376 debug_info := 'Close cursor C - DATA NOTFOUND';
1377 CLOSE C;
1378 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1379 APP_EXCEPTION.Raise_Exception;
1380 END IF;
1381
1382 debug_info := 'Close cursor C';
1383 CLOSE C;
1384
1385 IF ((Recinfo.APPLICATION_ID = p_APPLICATION_ID) AND
1386 (Recinfo.ENTITY_CODE = p_ENTITY_CODE) AND
1387 (Recinfo.EVENT_CLASS_CODE = p_EVENT_CLASS_CODE) AND
1388 ((Recinfo.TRX_ID = p_TRX_ID) OR
1389 ((Recinfo.TRX_ID IS NULL) AND
1390 (p_TRX_ID IS NULL))) AND
1391 ((Recinfo.HDR_TRX_USER_KEY1 = p_HDR_TRX_USER_KEY1) OR
1392 ((Recinfo.HDR_TRX_USER_KEY1 IS NULL) AND
1393 (p_HDR_TRX_USER_KEY1 IS NULL))) AND
1394 ((Recinfo.HDR_TRX_USER_KEY2 = p_HDR_TRX_USER_KEY2) OR
1395 ((Recinfo.HDR_TRX_USER_KEY2 IS NULL) AND
1396 (p_HDR_TRX_USER_KEY2 IS NULL))) AND
1397 ((Recinfo.HDR_TRX_USER_KEY3 = p_HDR_TRX_USER_KEY3) OR
1398 ((Recinfo.HDR_TRX_USER_KEY3 IS NULL) AND
1399 (p_HDR_TRX_USER_KEY3 IS NULL))) AND
1400 ((Recinfo.HDR_TRX_USER_KEY4 = p_HDR_TRX_USER_KEY4) OR
1401 ((Recinfo.HDR_TRX_USER_KEY4 IS NULL) AND
1402 (p_HDR_TRX_USER_KEY4 IS NULL))) AND
1403 ((Recinfo.HDR_TRX_USER_KEY5 = p_HDR_TRX_USER_KEY5) OR
1404 ((Recinfo.HDR_TRX_USER_KEY5 IS NULL) AND
1405 (p_HDR_TRX_USER_KEY5 IS NULL))) AND
1406 ((Recinfo.HDR_TRX_USER_KEY6 = p_HDR_TRX_USER_KEY6) OR
1407 ((Recinfo.HDR_TRX_USER_KEY6 IS NULL) AND
1408 (p_HDR_TRX_USER_KEY6 IS NULL))) AND
1409 ((Recinfo.TRX_LINE_ID = p_TRX_LINE_ID) OR
1410 ((Recinfo.TRX_LINE_ID IS NULL) AND
1411 (p_TRX_LINE_ID IS NULL))) AND
1412 ((Recinfo.LINE_TRX_USER_KEY1 = p_LINE_TRX_USER_KEY1) OR
1413 ((Recinfo.LINE_TRX_USER_KEY1 IS NULL) AND
1414 (p_LINE_TRX_USER_KEY1 IS NULL))) AND
1415 ((Recinfo.LINE_TRX_USER_KEY2 = p_LINE_TRX_USER_KEY2) OR
1416 ((Recinfo.LINE_TRX_USER_KEY2 IS NULL) AND
1417 (p_LINE_TRX_USER_KEY2 IS NULL))) AND
1418 ((Recinfo.LINE_TRX_USER_KEY3 = p_LINE_TRX_USER_KEY3) OR
1419 ((Recinfo.LINE_TRX_USER_KEY3 IS NULL) AND
1420 (p_LINE_TRX_USER_KEY3 IS NULL))) AND
1421 ((Recinfo.LINE_TRX_USER_KEY4 = p_LINE_TRX_USER_KEY4) OR
1422 ((Recinfo.LINE_TRX_USER_KEY4 IS NULL) AND
1423 (p_LINE_TRX_USER_KEY4 IS NULL))) AND
1424 ((Recinfo.LINE_TRX_USER_KEY5 = p_LINE_TRX_USER_KEY5) OR
1425 ((Recinfo.LINE_TRX_USER_KEY5 IS NULL) AND
1426 (p_LINE_TRX_USER_KEY5 IS NULL))) AND
1427 ((Recinfo.LINE_TRX_USER_KEY6 = p_LINE_TRX_USER_KEY6) OR
1428 ((Recinfo.LINE_TRX_USER_KEY6 IS NULL) AND
1429 (p_LINE_TRX_USER_KEY6 IS NULL))) AND
1430 (Recinfo.TRX_LEVEL_TYPE = p_TRX_LEVEL_TYPE) AND
1431 ((Recinfo.TRX_LINE_DIST_ID = p_TRX_LINE_DIST_ID) OR
1432 ((Recinfo.TRX_LINE_DIST_ID IS NULL) AND
1433 (p_TRX_LINE_DIST_ID IS NULL))) AND
1434 ((Recinfo.DIST_TRX_USER_KEY1 = p_DIST_TRX_USER_KEY1) OR
1435 ((Recinfo.DIST_TRX_USER_KEY1 IS NULL) AND
1436 (p_DIST_TRX_USER_KEY1 IS NULL))) AND
1437 ((Recinfo.DIST_TRX_USER_KEY2 = p_DIST_TRX_USER_KEY2) OR
1438 ((Recinfo.DIST_TRX_USER_KEY2 IS NULL) AND
1439 (p_DIST_TRX_USER_KEY2 IS NULL))) AND
1440 ((Recinfo.DIST_TRX_USER_KEY3 = p_DIST_TRX_USER_KEY3) OR
1441 ((Recinfo.DIST_TRX_USER_KEY3 IS NULL) AND
1442 (p_DIST_TRX_USER_KEY3 IS NULL))) AND
1443 ((Recinfo.DIST_TRX_USER_KEY4 = p_DIST_TRX_USER_KEY4) OR
1444 ((Recinfo.DIST_TRX_USER_KEY4 IS NULL) AND
1445 (p_DIST_TRX_USER_KEY4 IS NULL))) AND
1446 ((Recinfo.DIST_TRX_USER_KEY5 = p_DIST_TRX_USER_KEY5) OR
1447 ((Recinfo.DIST_TRX_USER_KEY5 IS NULL) AND
1448 (p_DIST_TRX_USER_KEY5 IS NULL))) AND
1449 ((Recinfo.DIST_TRX_USER_KEY6 = p_DIST_TRX_USER_KEY6) OR
1450 ((Recinfo.DIST_TRX_USER_KEY6 IS NULL) AND
1451 (p_DIST_TRX_USER_KEY6 IS NULL))) AND
1452 (Recinfo.DIST_LEVEL_ACTION = p_DIST_LEVEL_ACTION) AND
1453 (Recinfo.TRX_LINE_DIST_DATE = p_TRX_LINE_DIST_DATE) AND
1454 ((Recinfo.ITEM_DIST_NUMBER = p_ITEM_DIST_NUMBER) OR
1455 ((Recinfo.ITEM_DIST_NUMBER IS NULL) AND
1456 (p_ITEM_DIST_NUMBER IS NULL))) AND
1457 (Recinfo.DIST_INTENDED_USE = p_DIST_INTENDED_USE) AND
1458 ((Recinfo.TAX_INCLUSION_FLAG = p_TAX_INCLUSION_FLAG) OR
1459 ((Recinfo.TAX_INCLUSION_FLAG IS NULL) AND
1460 (p_TAX_INCLUSION_FLAG IS NULL))) AND
1461 ((Recinfo.TAX_CODE = p_TAX_CODE) OR
1462 ((Recinfo.TAX_CODE IS NULL) AND
1463 (p_TAX_CODE IS NULL))) AND
1464 ((Recinfo.APPLIED_FROM_TAX_DIST_ID = p_APPLIED_FROM_TAX_DIST_ID) OR
1465 ((Recinfo.APPLIED_FROM_TAX_DIST_ID IS NULL) AND
1466 (p_APPLIED_FROM_TAX_DIST_ID IS NULL))) AND
1467 ((Recinfo.ADJUSTED_DOC_TAX_DIST_ID = p_ADJUSTED_DOC_TAX_DIST_ID) OR
1468 ((Recinfo.ADJUSTED_DOC_TAX_DIST_ID IS NULL) AND
1469 (p_ADJUSTED_DOC_TAX_DIST_ID IS NULL))) AND
1470 ((Recinfo.TASK_ID = p_TASK_ID) OR
1471 ((Recinfo.TASK_ID IS NULL) AND
1472 (p_TASK_ID IS NULL))) AND
1473 ((Recinfo.AWARD_ID = p_AWARD_ID) OR
1474 ((Recinfo.AWARD_ID IS NULL) AND
1475 (p_AWARD_ID IS NULL))) AND
1476 ((Recinfo.PROJECT_ID = p_PROJECT_ID) OR
1477 ((Recinfo.PROJECT_ID IS NULL) AND
1478 (p_PROJECT_ID IS NULL))) AND
1479 ((Recinfo.EXPENDITURE_TYPE = p_EXPENDITURE_TYPE) OR
1480 ((Recinfo.EXPENDITURE_TYPE IS NULL) AND
1481 (p_EXPENDITURE_TYPE IS NULL))) AND
1482 ((Recinfo.EXPENDITURE_ORGANIZATION_ID = p_EXPENDITURE_ORGANIZATION_ID) OR
1483 ((Recinfo.EXPENDITURE_ORGANIZATION_ID IS NULL) AND
1484 (p_EXPENDITURE_ORGANIZATION_ID IS NULL))) AND
1485 ((Recinfo.EXPENDITURE_ITEM_DATE = p_EXPENDITURE_ITEM_DATE) OR
1486 ((Recinfo.EXPENDITURE_ITEM_DATE IS NULL) AND
1487 (p_EXPENDITURE_ITEM_DATE IS NULL))) AND
1488 ((Recinfo.TRX_LINE_DIST_AMT = p_TRX_LINE_DIST_AMT) OR
1489 ((Recinfo.TRX_LINE_DIST_AMT IS NULL) AND
1490 (p_TRX_LINE_DIST_AMT IS NULL))) AND
1491 ((Recinfo.TRX_LINE_DIST_QTY = p_TRX_LINE_DIST_QTY) OR
1492 ((Recinfo.TRX_LINE_DIST_QTY IS NULL) AND
1493 (p_TRX_LINE_DIST_QTY IS NULL))) AND
1494 ((Recinfo.TRX_LINE_QUANTITY = p_TRX_LINE_QUANTITY) OR
1495 ((Recinfo.TRX_LINE_QUANTITY IS NULL) AND
1496 (p_TRX_LINE_QUANTITY IS NULL))) AND
1497 ((Recinfo.ACCOUNT_CCID = p_ACCOUNT_CCID) OR
1498 ((Recinfo.ACCOUNT_CCID IS NULL) AND
1499 (p_ACCOUNT_CCID IS NULL))) AND
1500 ((Recinfo.ACCOUNT_STRING = p_ACCOUNT_STRING) OR
1501 ((Recinfo.ACCOUNT_STRING IS NULL) AND
1502 (p_ACCOUNT_STRING IS NULL))) AND
1503 ((Recinfo.REF_DOC_APPLICATION_ID = p_REF_DOC_APPLICATION_ID) OR
1504 ((Recinfo.REF_DOC_APPLICATION_ID IS NULL) AND
1505 (p_REF_DOC_APPLICATION_ID IS NULL))) AND
1506 ((Recinfo.REF_DOC_ENTITY_CODE = p_REF_DOC_ENTITY_CODE) OR
1507 ((Recinfo.REF_DOC_ENTITY_CODE IS NULL) AND
1508 (p_REF_DOC_ENTITY_CODE IS NULL))) AND
1509 ((Recinfo.REF_DOC_EVENT_CLASS_CODE = p_REF_DOC_EVENT_CLASS_CODE) OR
1510 ((Recinfo.REF_DOC_EVENT_CLASS_CODE IS NULL) AND
1511 (p_REF_DOC_EVENT_CLASS_CODE IS NULL))) AND
1512 ((Recinfo.REF_DOC_TRX_ID = p_REF_DOC_TRX_ID) OR
1513 ((Recinfo.REF_DOC_TRX_ID IS NULL) AND
1514 (p_REF_DOC_TRX_ID IS NULL))) AND
1515 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY1 = p_REF_DOC_HDR_TRX_USER_KEY1) OR
1516 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY1 IS NULL) AND
1517 (p_REF_DOC_HDR_TRX_USER_KEY1 IS NULL))) AND
1518 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY2 = p_REF_DOC_HDR_TRX_USER_KEY2) OR
1519 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY2 IS NULL) AND
1520 (p_REF_DOC_HDR_TRX_USER_KEY2 IS NULL))) AND
1521 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY3 = p_REF_DOC_HDR_TRX_USER_KEY3) OR
1522 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY3 IS NULL) AND
1523 (p_REF_DOC_HDR_TRX_USER_KEY3 IS NULL))) AND
1524 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY4 = p_REF_DOC_HDR_TRX_USER_KEY4) OR
1525 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY4 IS NULL) AND
1526 (p_REF_DOC_HDR_TRX_USER_KEY4 IS NULL))) AND
1527 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY5 = p_REF_DOC_HDR_TRX_USER_KEY5) OR
1528 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY5 IS NULL) AND
1529 (p_REF_DOC_HDR_TRX_USER_KEY5 IS NULL))) AND
1530 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY6 = p_REF_DOC_HDR_TRX_USER_KEY6) OR
1531 ((Recinfo.REF_DOC_HDR_TRX_USER_KEY6 IS NULL) AND
1532 (p_REF_DOC_HDR_TRX_USER_KEY6 IS NULL))) AND
1533 ((Recinfo.REF_DOC_LINE_ID = p_REF_DOC_LINE_ID) OR
1534 ((Recinfo.REF_DOC_LINE_ID IS NULL) AND
1535 (p_REF_DOC_LINE_ID IS NULL))) AND
1536 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY1 = p_REF_DOC_LIN_TRX_USER_KEY1) OR
1537 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY1 IS NULL) AND
1538 (p_REF_DOC_LIN_TRX_USER_KEY1 IS NULL))) AND
1539 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY2 = p_REF_DOC_LIN_TRX_USER_KEY2) OR
1540 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY2 IS NULL) AND
1541 (p_REF_DOC_LIN_TRX_USER_KEY2 IS NULL))) AND
1542 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY3 = p_REF_DOC_LIN_TRX_USER_KEY3) OR
1543 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY3 IS NULL) AND
1544 (p_REF_DOC_LIN_TRX_USER_KEY3 IS NULL))) AND
1545 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY4 = p_REF_DOC_LIN_TRX_USER_KEY4) OR
1546 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY4 IS NULL) AND
1547 (p_REF_DOC_LIN_TRX_USER_KEY4 IS NULL))) AND
1548 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY5 = p_REF_DOC_LIN_TRX_USER_KEY5) OR
1549 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY5 IS NULL) AND
1550 (p_REF_DOC_LIN_TRX_USER_KEY5 IS NULL))) AND
1551 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY6 = p_REF_DOC_LIN_TRX_USER_KEY6) OR
1552 ((Recinfo.REF_DOC_LIN_TRX_USER_KEY6 IS NULL) AND
1553 (p_REF_DOC_LIN_TRX_USER_KEY6 IS NULL))) AND
1554 ((Recinfo.REF_DOC_DIST_ID = p_REF_DOC_DIST_ID) OR
1555 ((Recinfo.REF_DOC_DIST_ID IS NULL) AND
1556 (p_REF_DOC_DIST_ID IS NULL))) AND
1557 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY1 = p_REF_DOC_DIST_TRX_USER_KEY1) OR
1558 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY1 IS NULL) AND
1559 (p_REF_DOC_DIST_TRX_USER_KEY1 IS NULL))) AND
1563 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY3 = p_REF_DOC_DIST_TRX_USER_KEY3) OR
1560 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY2 = p_REF_DOC_DIST_TRX_USER_KEY2) OR
1561 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY2 IS NULL) AND
1562 (p_REF_DOC_DIST_TRX_USER_KEY2 IS NULL))) AND
1564 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY3 IS NULL) AND
1565 (p_REF_DOC_DIST_TRX_USER_KEY3 IS NULL))) AND
1566 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY4 = p_REF_DOC_DIST_TRX_USER_KEY4) OR
1567 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY4 IS NULL) AND
1568 (p_REF_DOC_DIST_TRX_USER_KEY4 IS NULL))) AND
1569 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY5 = p_REF_DOC_DIST_TRX_USER_KEY5) OR
1570 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY5 IS NULL) AND
1571 (p_REF_DOC_DIST_TRX_USER_KEY5 IS NULL))) AND
1572 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY6 = p_REF_DOC_DIST_TRX_USER_KEY6) OR
1573 ((Recinfo.REF_DOC_DIST_TRX_USER_KEY6 IS NULL) AND
1574 (p_REF_DOC_DIST_TRX_USER_KEY6 IS NULL))) AND
1575 ((Recinfo.REF_DOC_CURR_CONV_RATE = p_REF_DOC_CURR_CONV_RATE) OR
1576 ((Recinfo.REF_DOC_CURR_CONV_RATE IS NULL) AND
1577 (p_REF_DOC_CURR_CONV_RATE IS NULL))) AND
1578 ((Recinfo.NUMERIC1 = p_NUMERIC1) OR
1579 ((Recinfo.NUMERIC1 IS NULL) AND
1580 (p_NUMERIC1 IS NULL))) AND
1581 ((Recinfo.NUMERIC2 = p_NUMERIC2) OR
1582 ((Recinfo.NUMERIC2 IS NULL) AND
1583 (p_NUMERIC2 IS NULL))) AND
1584 ((Recinfo.NUMERIC3 = p_NUMERIC3) OR
1585 ((Recinfo.NUMERIC3 IS NULL) AND
1586 (p_NUMERIC3 IS NULL))) AND
1587 ((Recinfo.NUMERIC4 = p_NUMERIC4) OR
1588 ((Recinfo.NUMERIC4 IS NULL) AND
1589 (p_NUMERIC4 IS NULL))) AND
1590 ((Recinfo.NUMERIC5 = p_NUMERIC5) OR
1591 ((Recinfo.NUMERIC5 IS NULL) AND
1592 (p_NUMERIC5 IS NULL))) AND
1593 ((Recinfo.CHAR1 = p_CHAR1) OR
1594 ((Recinfo.CHAR1 IS NULL) AND
1595 (p_CHAR1 IS NULL))) AND
1596 ((Recinfo.CHAR2 = p_CHAR2) OR
1597 ((Recinfo.CHAR2 IS NULL) AND
1598 (p_CHAR2 IS NULL))) AND
1599 ((Recinfo.CHAR3 = p_CHAR3) OR
1600 ((Recinfo.CHAR3 IS NULL) AND
1601 (p_CHAR3 IS NULL))) AND
1602 ((Recinfo.CHAR4 = p_CHAR4) OR
1603 ((Recinfo.CHAR4 IS NULL) AND
1604 (p_CHAR4 IS NULL))) AND
1605 ((Recinfo.CHAR5 = p_CHAR5) OR
1606 ((Recinfo.CHAR5 IS NULL) AND
1607 (p_CHAR5 IS NULL))) AND
1608 ((Recinfo.DATE1 = p_DATE1) OR
1609 ((Recinfo.DATE1 IS NULL) AND
1610 (p_DATE1 IS NULL))) AND
1611 ((Recinfo.DATE2 = p_DATE2) OR
1612 ((Recinfo.DATE2 IS NULL) AND
1613 (p_DATE2 IS NULL))) AND
1614 ((Recinfo.DATE3 = p_DATE3) OR
1615 ((Recinfo.DATE3 IS NULL) AND
1616 (p_DATE3 IS NULL))) AND
1617 ((Recinfo.DATE4 = p_DATE4) OR
1618 ((Recinfo.DATE4 IS NULL) AND
1619 (p_DATE4 IS NULL))) AND
1620 ((Recinfo.DATE5 = p_DATE5) OR
1621 ((Recinfo.DATE5 IS NULL) AND
1622 (p_DATE5 IS NULL))) AND
1623 ((Recinfo.TRX_LINE_DIST_TAX_AMT = p_TRX_LINE_DIST_TAX_AMT) OR
1624 ((Recinfo.TRX_LINE_DIST_TAX_AMT IS NULL) AND
1625 (p_TRX_LINE_DIST_TAX_AMT IS NULL))) AND
1626 ((Recinfo.HISTORICAL_FLAG = p_HISTORICAL_FLAG) OR
1627 ((Recinfo.HISTORICAL_FLAG IS NULL) AND
1628 (p_HISTORICAL_FLAG IS NULL))) AND
1629 ((Recinfo.APPLIED_FROM_APPLICATION_ID = p_APPLIED_FROM_APPLICATION_ID) OR
1630 ((Recinfo.APPLIED_FROM_APPLICATION_ID IS NULL) AND
1631 (p_APPLIED_FROM_APPLICATION_ID IS NULL))) AND
1632 ((Recinfo.APPLIED_FROM_EVENT_CLASS_CODE = p_APPL_FROM_EVENT_CLASS_CODE) OR
1633 ((Recinfo.APPLIED_FROM_EVENT_CLASS_CODE IS NULL) AND
1634 (p_APPL_FROM_EVENT_CLASS_CODE IS NULL))) AND
1635 ((Recinfo.APPLIED_FROM_ENTITY_CODE = p_APPLIED_FROM_ENTITY_CODE) OR
1636 ((Recinfo.APPLIED_FROM_ENTITY_CODE IS NULL) AND
1637 (p_APPLIED_FROM_ENTITY_CODE IS NULL))) AND
1638 ((Recinfo.APPLIED_FROM_TRX_ID = p_APPLIED_FROM_TRX_ID) OR
1639 ((Recinfo.APPLIED_FROM_TRX_ID IS NULL) AND
1640 (p_APPLIED_FROM_TRX_ID IS NULL))) AND
1641 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY1 = p_APP_FROM_HDR_TRX_USER_KEY1) OR
1642 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY1 IS NULL) AND
1643 (p_APP_FROM_HDR_TRX_USER_KEY1 IS NULL))) AND
1644 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY2 = p_APP_FROM_HDR_TRX_USER_KEY2) OR
1645 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY2 IS NULL) AND
1646 (p_APP_FROM_HDR_TRX_USER_KEY2 IS NULL))) AND
1647 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY3 = p_APP_FROM_HDR_TRX_USER_KEY3) OR
1648 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY3 IS NULL) AND
1649 (p_APP_FROM_HDR_TRX_USER_KEY3 IS NULL))) AND
1650 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY4 = p_APP_FROM_HDR_TRX_USER_KEY4) OR
1651 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY4 IS NULL) AND
1652 (p_APP_FROM_HDR_TRX_USER_KEY4 IS NULL))) AND
1653 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY5 = p_APP_FROM_HDR_TRX_USER_KEY5) OR
1654 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY5 IS NULL) AND
1655 (p_APP_FROM_HDR_TRX_USER_KEY5 IS NULL))) AND
1656 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY6 = p_APP_FROM_HDR_TRX_USER_KEY6) OR
1657 ((Recinfo.APP_FROM_HDR_TRX_USER_KEY6 IS NULL) AND
1658 (p_APP_FROM_HDR_TRX_USER_KEY6 IS NULL))) AND
1659 ((Recinfo.APPLIED_FROM_LINE_ID = p_APPLIED_FROM_LINE_ID) OR
1660 ((Recinfo.APPLIED_FROM_LINE_ID IS NULL) AND
1661 (p_APPLIED_FROM_LINE_ID IS NULL))) AND
1662 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY1 = p_APP_FROM_LIN_TRX_USER_KEY1) OR
1663 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY1 IS NULL) AND
1664 (p_APP_FROM_LIN_TRX_USER_KEY1 IS NULL))) AND
1665 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY2 = p_APP_FROM_LIN_TRX_USER_KEY2) OR
1666 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY2 IS NULL) AND
1667 (p_APP_FROM_LIN_TRX_USER_KEY2 IS NULL))) AND
1668 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY3 = p_APP_FROM_LIN_TRX_USER_KEY3) OR
1669 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY3 IS NULL) AND
1670 (p_APP_FROM_LIN_TRX_USER_KEY3 IS NULL))) AND
1671 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY4 = p_APP_FROM_LIN_TRX_USER_KEY4) OR
1672 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY4 IS NULL) AND
1673 (p_APP_FROM_LIN_TRX_USER_KEY4 IS NULL))) AND
1674 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY5 = p_APP_FROM_LIN_TRX_USER_KEY5) OR
1675 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY5 IS NULL) AND
1676 (p_APP_FROM_LIN_TRX_USER_KEY5 IS NULL))) AND
1677 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY6 = p_APP_FROM_LIN_TRX_USER_KEY6) OR
1678 ((Recinfo.APP_FROM_LIN_TRX_USER_KEY6 IS NULL) AND
1679 (p_APP_FROM_LIN_TRX_USER_KEY6 IS NULL))) AND
1680 ((Recinfo.APPLIED_FROM_DIST_ID = p_APPLIED_FROM_DIST_ID) OR
1681 ((Recinfo.APPLIED_FROM_DIST_ID IS NULL) AND
1682 (p_APPLIED_FROM_DIST_ID IS NULL))) AND
1683 ((Recinfo.APP_FROM_DST_TRX_USER_KEY1 = p_APP_FROM_DST_TRX_USER_KEY1) OR
1684 ((Recinfo.APP_FROM_DST_TRX_USER_KEY1 IS NULL) AND
1685 (p_APP_FROM_DST_TRX_USER_KEY1 IS NULL))) AND
1686 ((Recinfo.APP_FROM_DST_TRX_USER_KEY2 = p_APP_FROM_DST_TRX_USER_KEY2) OR
1687 ((Recinfo.APP_FROM_DST_TRX_USER_KEY2 IS NULL) AND
1688 (p_APP_FROM_DST_TRX_USER_KEY2 IS NULL))) AND
1689 ((Recinfo.APP_FROM_DST_TRX_USER_KEY3 = p_APP_FROM_DST_TRX_USER_KEY3) OR
1690 ((Recinfo.APP_FROM_DST_TRX_USER_KEY3 IS NULL) AND
1691 (p_APP_FROM_DST_TRX_USER_KEY3 IS NULL))) AND
1692 ((Recinfo.APP_FROM_DST_TRX_USER_KEY4 = p_APP_FROM_DST_TRX_USER_KEY4) OR
1693 ((Recinfo.APP_FROM_DST_TRX_USER_KEY4 IS NULL) AND
1694 (p_APP_FROM_DST_TRX_USER_KEY4 IS NULL))) AND
1695 ((Recinfo.APP_FROM_DST_TRX_USER_KEY5 = p_APP_FROM_DST_TRX_USER_KEY5) OR
1696 ((Recinfo.APP_FROM_DST_TRX_USER_KEY5 IS NULL) AND
1697 (p_APP_FROM_DST_TRX_USER_KEY5 IS NULL))) AND
1698 ((Recinfo.APP_FROM_DST_TRX_USER_KEY6 = p_APP_FROM_DST_TRX_USER_KEY6) OR
1699 ((Recinfo.APP_FROM_DST_TRX_USER_KEY6 IS NULL) AND
1700 (p_APP_FROM_DST_TRX_USER_KEY6 IS NULL))) AND
1701 ((Recinfo.ADJUSTED_DOC_APPLICATION_ID = p_ADJ_DOC_APPLICATION_ID) OR
1702 ((Recinfo.ADJUSTED_DOC_APPLICATION_ID IS NULL) AND
1703 (p_ADJ_DOC_APPLICATION_ID IS NULL))) AND
1704 ((Recinfo.ADJUSTED_DOC_EVENT_CLASS_CODE = p_ADJ_DOC_EVENT_CLASS_CODE) OR
1705 ((Recinfo.ADJUSTED_DOC_EVENT_CLASS_CODE IS NULL) AND
1706 (p_ADJ_DOC_EVENT_CLASS_CODE IS NULL))) AND
1707 ((Recinfo.ADJUSTED_DOC_ENTITY_CODE = p_ADJUSTED_DOC_ENTITY_CODE) OR
1708 ((Recinfo.ADJUSTED_DOC_ENTITY_CODE IS NULL) AND
1709 (p_ADJUSTED_DOC_ENTITY_CODE IS NULL))) AND
1710 ((Recinfo.ADJUSTED_DOC_TRX_ID = p_ADJUSTED_DOC_TRX_ID) OR
1711 ((Recinfo.ADJUSTED_DOC_TRX_ID IS NULL) AND
1712 (p_ADJUSTED_DOC_TRX_ID IS NULL))) AND
1713 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY1 = p_ADJ_DOC_HDR_TRX_USER_KEY1) OR
1714 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY1 IS NULL) AND
1715 (p_ADJ_DOC_HDR_TRX_USER_KEY1 IS NULL))) AND
1716 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY2 = p_ADJ_DOC_HDR_TRX_USER_KEY2) OR
1717 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY2 IS NULL) AND
1718 (p_ADJ_DOC_HDR_TRX_USER_KEY2 IS NULL))) AND
1719 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY3 = p_ADJ_DOC_HDR_TRX_USER_KEY3) OR
1720 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY3 IS NULL) AND
1721 (p_ADJ_DOC_HDR_TRX_USER_KEY3 IS NULL))) AND
1722 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY4 = p_ADJ_DOC_HDR_TRX_USER_KEY4) OR
1723 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY4 IS NULL) AND
1724 (p_ADJ_DOC_HDR_TRX_USER_KEY4 IS NULL))) AND
1725 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY5 = p_ADJ_DOC_HDR_TRX_USER_KEY5) OR
1726 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY5 IS NULL) AND
1727 (p_ADJ_DOC_HDR_TRX_USER_KEY5 IS NULL))) AND
1728 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY6 = p_ADJ_DOC_HDR_TRX_USER_KEY6) OR
1729 ((Recinfo.ADJ_DOC_HDR_TRX_USER_KEY6 IS NULL) AND
1730 (p_ADJ_DOC_HDR_TRX_USER_KEY6 IS NULL))) AND
1731 ((Recinfo.ADJUSTED_DOC_LINE_ID = p_ADJUSTED_DOC_LINE_ID) OR
1732 ((Recinfo.ADJUSTED_DOC_LINE_ID IS NULL) AND
1733 (p_ADJUSTED_DOC_LINE_ID IS NULL))) AND
1734 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY1 = p_ADJ_DOC_LIN_TRX_USER_KEY1) OR
1735 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY1 IS NULL) AND
1736 (p_ADJ_DOC_LIN_TRX_USER_KEY1 IS NULL))) AND
1737 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY2 = p_ADJ_DOC_LIN_TRX_USER_KEY2) OR
1738 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY2 IS NULL) AND
1739 (p_ADJ_DOC_LIN_TRX_USER_KEY2 IS NULL))) AND
1740 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY3 = p_ADJ_DOC_LIN_TRX_USER_KEY3) OR
1741 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY3 IS NULL) AND
1742 (p_ADJ_DOC_LIN_TRX_USER_KEY3 IS NULL))) AND
1743 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY4 = p_ADJ_DOC_LIN_TRX_USER_KEY4) OR
1744 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY4 IS NULL) AND
1745 (p_ADJ_DOC_LIN_TRX_USER_KEY4 IS NULL))) AND
1746 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY5 = p_ADJ_DOC_LIN_TRX_USER_KEY5) OR
1747 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY5 IS NULL) AND
1748 (p_ADJ_DOC_LIN_TRX_USER_KEY5 IS NULL))) AND
1749 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY6 = p_ADJ_DOC_LIN_TRX_USER_KEY6) OR
1750 ((Recinfo.ADJ_DOC_LIN_TRX_USER_KEY6 IS NULL) AND
1751 (p_ADJ_DOC_LIN_TRX_USER_KEY6 IS NULL))) AND
1752 ((Recinfo.ADJUSTED_DOC_DIST_ID = p_ADJUSTED_DOC_DIST_ID) OR
1753 ((Recinfo.ADJUSTED_DOC_DIST_ID IS NULL) AND
1754 (p_ADJUSTED_DOC_DIST_ID IS NULL))) AND
1755 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY1 = p_ADJ_DOC_DST_TRX_USER_KEY1) OR
1756 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY1 IS NULL) AND
1757 (p_ADJ_DOC_DST_TRX_USER_KEY1 IS NULL))) AND
1758 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY2 = p_ADJ_DOC_DST_TRX_USER_KEY2) OR
1759 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY2 IS NULL) AND
1760 (p_ADJ_DOC_DST_TRX_USER_KEY2 IS NULL))) AND
1761 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY3 = p_ADJ_DOC_DST_TRX_USER_KEY3) OR
1762 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY3 IS NULL) AND
1763 (p_ADJ_DOC_DST_TRX_USER_KEY3 IS NULL))) AND
1764 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY4 = p_ADJ_DOC_DST_TRX_USER_KEY4) OR
1765 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY4 IS NULL) AND
1766 (p_ADJ_DOC_DST_TRX_USER_KEY4 IS NULL))) AND
1767 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY5 = p_ADJ_DOC_DST_TRX_USER_KEY5) OR
1768 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY5 IS NULL) AND
1769 (p_ADJ_DOC_DST_TRX_USER_KEY5 IS NULL))) AND
1770 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY6 = p_ADJ_DOC_DST_TRX_USER_KEY6) OR
1771 ((Recinfo.ADJ_DOC_DST_TRX_USER_KEY6 IS NULL) AND
1772 (p_ADJ_DOC_DST_TRX_USER_KEY6 IS NULL))) AND
1773 ((Recinfo.APPLIED_TO_DOC_CURR_CONV_RATE = p_APPL_TO_DOC_CURR_CONV_RATE) OR
1774 ((Recinfo.APPLIED_TO_DOC_CURR_CONV_RATE IS NULL) AND
1775 (p_APPL_TO_DOC_CURR_CONV_RATE IS NULL))) AND
1776 ((Recinfo.TAX_VARIANCE_CALC_FLAG = p_TAX_VARIANCE_CALC_FLAG) OR
1777 ((Recinfo.TAX_VARIANCE_CALC_FLAG IS NULL) AND
1778 (p_TAX_VARIANCE_CALC_FLAG IS NULL))) AND
1779 ((Recinfo.REF_DOC_TRX_LINE_DIST_QTY = p_REF_DOC_TRX_LINE_DIST_QTY ) OR
1780 ((Recinfo.REF_DOC_TRX_LINE_DIST_QTY IS NULL) AND
1781 (p_REF_DOC_TRX_LINE_DIST_QTY IS NULL))) AND
1782 ((Recinfo.PRICE_DIFF = p_PRICE_DIFF ) OR
1783 ((Recinfo.PRICE_DIFF IS NULL) AND
1784 (p_PRICE_DIFF IS NULL))) AND
1785 ((Recinfo.UNIT_PRICE = p_UNIT_PRICE ) OR
1786 ((Recinfo.UNIT_PRICE IS NULL) AND
1787 (p_UNIT_PRICE IS NULL))) AND
1788 ((Recinfo.CURRENCY_EXCHANGE_RATE = p_CURRENCY_EXCHANGE_RATE ) OR
1789 ((Recinfo.CURRENCY_EXCHANGE_RATE IS NULL) AND
1790 (p_CURRENCY_EXCHANGE_RATE IS NULL))) AND
1791 ((Recinfo.REF_DOC_TRX_LEVEL_TYPE = p_REF_DOC_TRX_LEVEL_TYPE ) OR
1792 ((Recinfo.REF_DOC_TRX_LEVEL_TYPE IS NULL) AND
1793 (p_REF_DOC_TRX_LEVEL_TYPE IS NULL))) AND
1794 ((Recinfo.APPLIED_FROM_TRX_LEVEL_TYPE = p_APPLIED_FROM_TRX_LEVEL_TYPE ) OR
1795 ((Recinfo.APPLIED_FROM_TRX_LEVEL_TYPE IS NULL) AND
1796 (p_APPLIED_FROM_TRX_LEVEL_TYPE IS NULL))) AND
1797 ((Recinfo.ADJUSTED_DOC_TRX_LEVEL_TYPE = p_ADJUSTED_DOC_TRX_LEVEL_TYPE ) OR
1798 ((Recinfo.ADJUSTED_DOC_TRX_LEVEL_TYPE IS NULL) AND
1799 (p_ADJUSTED_DOC_TRX_LEVEL_TYPE IS NULL))) AND
1800 ((Recinfo.OVERRIDING_RECOVERY_RATE = p_OVERRIDING_RECOVERY_RATE ) OR
1804 (Recinfo.CREATED_BY = p_CREATED_BY) AND
1801 ((Recinfo.OVERRIDING_RECOVERY_RATE IS NULL) AND
1802 (p_OVERRIDING_RECOVERY_RATE IS NULL))) AND
1803 (Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) AND
1805 (Recinfo.CREATION_DATE = p_CREATION_DATE) AND
1806 (Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) AND
1807 (Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) AND
1808 ((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR
1809 ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND
1810 (p_LAST_UPDATE_LOGIN IS NULL))) ) THEN
1811 return;
1812 ELSE
1813 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1814 APP_EXCEPTION.Raise_Exception;
1815 END IF;
1816
1817 IF (g_level_procedure >= g_current_runtime_level ) THEN
1818 FND_LOG.STRING(g_level_procedure,
1819 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.END',
1820 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (-)');
1821 END IF;
1822
1823 EXCEPTION
1824 WHEN OTHERS THEN
1825 p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1826
1827 FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1828 FND_MSG_PUB.Add;
1829
1830 IF (g_level_unexpected >= g_current_runtime_level ) THEN
1831 FND_LOG.STRING(g_level_unexpected,
1832 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_Row',
1833 p_error_buffer);
1834 END IF;
1835
1836 END Lock_Row;
1837
1838 PROCEDURE Insert_Temporary_Table
1839 (p_application_id NUMBER,
1840 p_entity_code VARCHAR2,
1841 p_event_class_code VARCHAR2,
1842 p_event_type_code VARCHAR2,
1843 p_trx_line_id NUMBER,
1844 p_trx_line_dist_id NUMBER,
1845 p_trx_id NUMBER,
1846 p_ledger_id NUMBER,
1847 p_reporting_currency_code VARCHAR2,
1848 p_currency_conversion_date DATE,
1849 p_currency_conversion_type VARCHAR2,
1850 p_currency_conversion_rate NUMBER,
1851 p_minimum_accountable_unit NUMBER,
1852 p_precision NUMBER) IS
1853
1854 l_return_status VARCHAR2(1000);
1855 l_msg_count NUMBER;
1856 l_msg_data VARCHAR2(1000);
1857 sid NUMBER;
1858 p_error_buffer VARCHAR2(100);
1859 debug_info VARCHAR2(100);
1860
1861 l_event_class_rec ZX_API_PUB.event_class_rec_type;
1862
1863 BEGIN
1864
1865 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1866
1867 IF (g_level_procedure >= g_current_runtime_level ) THEN
1868 FND_LOG.STRING(g_level_procedure,
1869 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.BEGIN',
1870 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (+)');
1871
1872 END IF;
1873
1874 DELETE ZX_TRX_HEADERS_GT
1875 WHERE APPLICATION_ID = p_application_id
1876 AND ENTITY_CODE = p_entity_code
1877 AND EVENT_CLASS_CODE = p_event_class_code
1878 AND TRX_ID = p_trx_id;
1879
1880 IF (g_level_procedure >= g_current_runtime_level ) THEN
1881 FND_LOG.STRING(g_level_procedure,
1882 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
1883 'Insert into zx_trx_headers_gt (+)');
1884 END IF;
1885
1886 INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,
1887 INTERNAL_ORG_LOCATION_ID,
1888 APPLICATION_ID,
1889 ENTITY_CODE,
1890 EVENT_CLASS_CODE,
1891 EVENT_TYPE_CODE,
1892 TRX_ID,
1893 TRX_DATE,
1894 --TRX_DOC_REVISION,
1895 LEDGER_ID,
1896 TRX_CURRENCY_CODE,
1897 CURRENCY_CONVERSION_DATE,
1898 CURRENCY_CONVERSION_RATE,
1899 CURRENCY_CONVERSION_TYPE,
1900 MINIMUM_ACCOUNTABLE_UNIT,
1901 PRECISION,
1902 LEGAL_ENTITY_ID,
1903 ROUNDING_SHIP_TO_PARTY_ID,
1904 ROUNDING_SHIP_FROM_PARTY_ID,
1905 ROUNDING_BILL_TO_PARTY_ID,
1906 ROUNDING_BILL_FROM_PARTY_ID,
1907 RNDG_SHIP_TO_PARTY_SITE_ID,
1908 RNDG_SHIP_FROM_PARTY_SITE_ID,
1909 RNDG_BILL_TO_PARTY_SITE_ID,
1910 RNDG_BILL_FROM_PARTY_SITE_ID,
1911 ESTABLISHMENT_ID,
1912 RECEIVABLES_TRX_TYPE_ID,
1913 --RELATED_DOC_APPLICATION_ID,
1917 --REL_DOC_HDR_TRX_USER_KEY1,
1914 --RELATED_DOC_ENTITY_CODE,
1915 --RELATED_DOC_EVENT_CLASS_CODE,
1916 --RELATED_DOC_TRX_ID,
1918 --REL_DOC_HDR_TRX_USER_KEY2,
1919 --REL_DOC_HDR_TRX_USER_KEY3,
1920 --REL_DOC_HDR_TRX_USER_KEY4,
1921 --REL_DOC_HDR_TRX_USER_KEY5,
1922 --REL_DOC_HDR_TRX_USER_KEY6,
1923 --RELATED_DOC_NUMBER,
1924 --RELATED_DOC_DATE,
1925 DEFAULT_TAXATION_COUNTRY,
1926 Quote_Flag,
1927 CTRL_TOTAL_HDR_TX_AMT,
1928 TRX_NUMBER,
1929 TRX_DESCRIPTION,
1930 --TRX_COMMUNICATED_DATE,
1931 --BATCH_SOURCE_ID,
1932 --BATCH_SOURCE_NAME,
1933 --DOC_SEQ_ID,
1934 --DOC_SEQ_NAME,
1935 --DOC_SEQ_VALUE,
1936 --TRX_DUE_DATE,
1937 --TRX_TYPE_DESCRIPTION,
1938 --BILLING_TRADING_PARTNER_NAME,
1939 --BILLING_TRADING_PARTNER_NUMBER,
1940 --Billing_Tp_Tax_Reporting_Flag,
1941 --BILLING_TP_TAXPAYER_ID,
1942 DOCUMENT_SUB_TYPE,
1943 SUPPLIER_TAX_INVOICE_NUMBER,
1944 SUPPLIER_TAX_INVOICE_DATE,
1945 SUPPLIER_EXCHANGE_RATE,
1946 TAX_INVOICE_DATE,
1947 TAX_INVOICE_NUMBER,
1948 FIRST_PTY_ORG_ID,
1949 PORT_OF_ENTRY_CODE,
1950 TAX_REPORTING_FLAG,
1951 SHIP_TO_CUST_ACCT_SITE_USE_ID,
1952 BILL_TO_CUST_ACCT_SITE_USE_ID,
1953 PROVNL_TAX_DETERMINATION_DATE,
1954 APPLIED_TO_TRX_NUMBER,
1955 SHIP_THIRD_PTY_ACCT_ID,
1956 BILL_THIRD_PTY_ACCT_ID,
1957 SHIP_THIRD_PTY_ACCT_SITE_ID,
1958 BILL_THIRD_PTY_ACCT_SITE_ID,
1959 VALIDATION_CHECK_FLAG,
1960 --TAX_EVENT_CLASS_CODE,
1961 TAX_EVENT_TYPE_CODE
1962 --DOC_EVENT_STATUS,
1963 --RDNG_SHIP_TO_PTY_TX_PROF_ID,
1964 --RDNG_SHIP_FROM_PTY_TX_PROF_ID,
1965 --RDNG_BILL_TO_PTY_TX_PROF_ID,
1966 --RDNG_BILL_FROM_PTY_TX_PROF_ID,
1967 --RDNG_SHIP_TO_PTY_TX_P_ST_ID,
1968 --RDNG_SHIP_FROM_PTY_TX_P_ST_ID,
1969 --RDNG_BILL_TO_PTY_TX_P_ST_ID,
1970 --RDNG_BILL_FROM_PTY_TX_P_ST_ID
1971 )
1972 SELECT internal_organization_id,
1973 internal_org_location_id,
1974 application_id,
1975 entity_code,
1976 event_class_code,
1977 event_type_code,
1978 trx_id,
1979 trx_date,
1980 --p_trx_doc_revision,
1981 ledger_id,
1982 trx_currency_code,
1983 currency_conversion_date,
1984 currency_conversion_rate,
1985 currency_conversion_type,
1986 minimum_accountable_unit,
1987 precision,
1988 legal_entity_id,
1989 rounding_ship_to_party_id,
1990 rounding_ship_from_party_id,
1991 rounding_bill_to_party_id,
1992 rounding_bill_from_party_id,
1993 rndg_ship_to_party_site_id,
1994 rndg_ship_from_party_site_id,
1995 rndg_bill_to_party_site_id,
1996 rndg_bill_from_party_site_id,
1997 establishment_id,
1998 receivables_trx_type_id,
1999 --p_related_doc_application_id,
2000 --p_related_doc_entity_code,
2001 --p_related_doc_evt_class_code, --reduced size p_related_doc_event_class_code
2002 --p_related_doc_trx_id,
2003 --p_rel_doc_hdr_trx_user_key1,
2004 --p_rel_doc_hdr_trx_user_key2,
2005 --p_rel_doc_hdr_trx_user_key3,
2006 --p_rel_doc_hdr_trx_user_key4,
2007 --p_rel_doc_hdr_trx_user_key5,
2008 --p_rel_doc_hdr_trx_user_key6,
2009 --p_related_doc_number,
2010 --p_related_doc_date,
2011 default_taxation_country,
2012 Quote_Flag,
2013 ctrl_total_hdr_tx_amt,
2014 trx_number,
2015 trx_description,
2016 --p_trx_communicated_date,
2017 --p_batch_source_id,
2018 --p_batch_source_name,
2019 --p_doc_seq_id,
2020 --p_doc_seq_name,
2021 --p_doc_seq_value,
2022 --p_trx_due_date,
2023 --p_trx_type_description,
2024 --p_billing_trad_partner_name, --reduced size p_billing_trading_partner_name
2025 --p_billing_trad_partner_number, --reduced size p_billing_trading_partner_number
2026 --p_billing_tp_tax_report_flg, --reduced size p_Billing_Tp_Tax_Reporting_Flag
2027 --p_billing_tp_taxpayer_id,
2028 document_sub_type,
2029 supplier_tax_invoice_number,
2030 supplier_tax_invoice_date,
2031 supplier_exchange_rate,
2032 tax_invoice_date,
2033 tax_invoice_number,
2034 first_pty_org_id,
2035 PORT_OF_ENTRY_CODE,
2036 TAX_REPORTING_FLAG,
2040 APPLIED_TO_TRX_NUMBER,
2037 SHIP_TO_CUST_ACCT_SITE_USE_ID,
2038 BILL_TO_CUST_ACCT_SITE_USE_ID,
2039 PROVNL_TAX_DETERMINATION_DATE,
2041 SHIP_THIRD_PTY_ACCT_ID,
2042 BILL_THIRD_PTY_ACCT_ID,
2043 SHIP_THIRD_PTY_ACCT_SITE_ID,
2044 BILL_THIRD_PTY_ACCT_SITE_ID,
2045 VALIDATION_CHECK_FLAG,
2046 --p_tax_event_class_code,
2047 tax_event_type_code--p_tax_event_type_code,
2048 --p_doc_event_status,
2049 --p_rdng_ship_to_pty_tx_prof_id,
2050 --p_rdng_ship_fr_pty_tx_prof_id, --reduced size p_rdng_ship_from_pty_tx_prof_id
2051 --p_rdng_bill_to_pty_tx_prof_id,
2052 --p_rdng_bill_fr_pty_tx_prof_id, --reduced size p_rdng_bill_from_pty_tx_prof_id
2053 --p_rdng_ship_to_pty_tx_p_st_id,
2054 --p_rdng_ship_fr_pty_tx_p_st_id, --reduced size p_rdng_ship_from_pty_tx_p_st_id
2055 --p_rdng_bill_to_pty_tx_p_st_id,
2056 --p_rdng_bill_fr_pty_tx_p_st_id); --reduced size p_rdng_bill_from_pty_tx_p_st_id
2057 FROM ZX_TRANSACTION
2058 WHERE APPLICATION_ID = p_application_id
2059 AND ENTITY_CODE = p_entity_code
2060 AND EVENT_CLASS_CODE = p_event_class_code
2061 AND TRX_ID = p_trx_id;
2062
2063 IF (g_level_procedure >= g_current_runtime_level ) THEN
2064 FND_LOG.STRING(g_level_procedure,
2065 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2066 'Insert into zx_trx_headers_gt (-)');
2067 END IF;
2068
2069 IF (g_level_procedure >= g_current_runtime_level ) THEN
2070 FND_LOG.STRING(g_level_procedure,
2071 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
2072 'Insert into ZX_ITM_DISTRIBUTIONS_GT (+)');
2073 END IF;
2074
2075 INSERT INTO ZX_ITM_DISTRIBUTIONS_GT (APPLICATION_ID,
2076 ENTITY_CODE,
2077 EVENT_CLASS_CODE,
2078 --EVENT_TYPE_CODE,
2079 TRX_ID,
2080 HDR_TRX_USER_KEY1,
2081 HDR_TRX_USER_KEY2,
2082 HDR_TRX_USER_KEY3,
2083 HDR_TRX_USER_KEY4,
2084 HDR_TRX_USER_KEY5,
2085 HDR_TRX_USER_KEY6,
2086 TRX_LINE_ID,
2087 LINE_TRX_USER_KEY1,
2088 LINE_TRX_USER_KEY2,
2089 LINE_TRX_USER_KEY3,
2090 LINE_TRX_USER_KEY4,
2091 LINE_TRX_USER_KEY5,
2092 LINE_TRX_USER_KEY6,
2093 TRX_LEVEL_TYPE,
2094 TRX_LINE_DIST_ID,
2095 DIST_TRX_USER_KEY1,
2096 DIST_TRX_USER_KEY2,
2097 DIST_TRX_USER_KEY3,
2098 DIST_TRX_USER_KEY4,
2099 DIST_TRX_USER_KEY5,
2100 DIST_TRX_USER_KEY6,
2101 DIST_LEVEL_ACTION,
2102 TRX_LINE_DIST_DATE,
2103 ITEM_DIST_NUMBER,
2104 DIST_INTENDED_USE,
2105 TAX_INCLUSION_FLAG,
2106 TAX_CODE,
2107 APPLIED_FROM_TAX_DIST_ID,
2108 ADJUSTED_DOC_TAX_DIST_ID,
2109 TASK_ID,
2110 AWARD_ID,
2111 PROJECT_ID,
2112 EXPENDITURE_TYPE,
2113 EXPENDITURE_ORGANIZATION_ID,
2114 EXPENDITURE_ITEM_DATE,
2115 TRX_LINE_DIST_AMT,
2116 TRX_LINE_DIST_QTY,
2117 TRX_LINE_QUANTITY,
2118 ACCOUNT_CCID,
2119 ACCOUNT_STRING,
2120 REF_DOC_APPLICATION_ID,
2121 REF_DOC_ENTITY_CODE,
2122 REF_DOC_EVENT_CLASS_CODE,
2126 REF_DOC_HDR_TRX_USER_KEY3,
2123 REF_DOC_TRX_ID,
2124 REF_DOC_HDR_TRX_USER_KEY1,
2125 REF_DOC_HDR_TRX_USER_KEY2,
2127 REF_DOC_HDR_TRX_USER_KEY4,
2128 REF_DOC_HDR_TRX_USER_KEY5,
2129 REF_DOC_HDR_TRX_USER_KEY6,
2130 REF_DOC_LINE_ID,
2131 REF_DOC_LIN_TRX_USER_KEY1,
2132 REF_DOC_LIN_TRX_USER_KEY2,
2133 REF_DOC_LIN_TRX_USER_KEY3,
2134 REF_DOC_LIN_TRX_USER_KEY4,
2135 REF_DOC_LIN_TRX_USER_KEY5,
2136 REF_DOC_LIN_TRX_USER_KEY6,
2137 REF_DOC_DIST_ID,
2138 REF_DOC_DIST_TRX_USER_KEY1,
2139 REF_DOC_DIST_TRX_USER_KEY2,
2140 REF_DOC_DIST_TRX_USER_KEY3,
2141 REF_DOC_DIST_TRX_USER_KEY4,
2142 REF_DOC_DIST_TRX_USER_KEY5,
2143 REF_DOC_DIST_TRX_USER_KEY6,
2144 REF_DOC_CURR_CONV_RATE,
2145 NUMERIC1,
2146 NUMERIC2,
2147 NUMERIC3,
2148 NUMERIC4,
2149 NUMERIC5,
2150 CHAR1,
2151 CHAR2,
2152 CHAR3,
2153 CHAR4,
2154 CHAR5,
2155 DATE1,
2156 DATE2,
2157 DATE3,
2158 DATE4,
2159 DATE5,
2160 TRX_LINE_DIST_TAX_AMT,
2161 HISTORICAL_FLAG,
2162 APPLIED_FROM_APPLICATION_ID,
2163 APPLIED_FROM_EVENT_CLASS_CODE,
2164 APPLIED_FROM_ENTITY_CODE,
2165 APPLIED_FROM_TRX_ID,
2166 APP_FROM_HDR_TRX_USER_KEY1,
2167 APP_FROM_HDR_TRX_USER_KEY2,
2168 APP_FROM_HDR_TRX_USER_KEY3,
2169 APP_FROM_HDR_TRX_USER_KEY4,
2170 APP_FROM_HDR_TRX_USER_KEY5,
2171 APP_FROM_HDR_TRX_USER_KEY6,
2172 APPLIED_FROM_LINE_ID,
2173 APP_FROM_LIN_TRX_USER_KEY1,
2174 APP_FROM_LIN_TRX_USER_KEY2,
2175 APP_FROM_LIN_TRX_USER_KEY3,
2176 APP_FROM_LIN_TRX_USER_KEY4,
2177 APP_FROM_LIN_TRX_USER_KEY5,
2178 APP_FROM_LIN_TRX_USER_KEY6,
2179 APPLIED_FROM_DIST_ID,
2180 APP_FROM_DST_TRX_USER_KEY1,
2181 APP_FROM_DST_TRX_USER_KEY2,
2182 APP_FROM_DST_TRX_USER_KEY3,
2183 APP_FROM_DST_TRX_USER_KEY4,
2184 APP_FROM_DST_TRX_USER_KEY5,
2185 APP_FROM_DST_TRX_USER_KEY6,
2186 ADJUSTED_DOC_APPLICATION_ID,
2187 ADJUSTED_DOC_EVENT_CLASS_CODE,
2188 ADJUSTED_DOC_ENTITY_CODE,
2189 ADJUSTED_DOC_TRX_ID,
2190 ADJ_DOC_HDR_TRX_USER_KEY1,
2191 ADJ_DOC_HDR_TRX_USER_KEY2,
2192 ADJ_DOC_HDR_TRX_USER_KEY3,
2193 ADJ_DOC_HDR_TRX_USER_KEY4,
2194 ADJ_DOC_HDR_TRX_USER_KEY5,
2195 ADJ_DOC_HDR_TRX_USER_KEY6,
2196 ADJUSTED_DOC_LINE_ID,
2197 ADJ_DOC_LIN_TRX_USER_KEY1,
2198 ADJ_DOC_LIN_TRX_USER_KEY2,
2199 ADJ_DOC_LIN_TRX_USER_KEY3,
2200 ADJ_DOC_LIN_TRX_USER_KEY4,
2201 ADJ_DOC_LIN_TRX_USER_KEY5,
2202 ADJ_DOC_LIN_TRX_USER_KEY6,
2203 ADJUSTED_DOC_DIST_ID,
2204 ADJ_DOC_DST_TRX_USER_KEY1,
2205 ADJ_DOC_DST_TRX_USER_KEY2,
2206 ADJ_DOC_DST_TRX_USER_KEY3,
2207 ADJ_DOC_DST_TRX_USER_KEY4,
2208 ADJ_DOC_DST_TRX_USER_KEY5,
2209 ADJ_DOC_DST_TRX_USER_KEY6,
2210 APPLIED_TO_DOC_CURR_CONV_RATE,
2211 REF_DOC_TRX_LINE_DIST_QTY,
2212 PRICE_DIFF,
2213 UNIT_PRICE,
2214 CURRENCY_EXCHANGE_RATE,
2215 REF_DOC_TRX_LEVEL_TYPE,
2216 APPLIED_FROM_TRX_LEVEL_TYPE,
2217 ADJUSTED_DOC_TRX_LEVEL_TYPE,
2218 OVERRIDING_RECOVERY_RATE,
2219 TAX_VARIANCE_CALC_FLAG)
2220 SELECT application_id,
2221 entity_code,
2222 event_class_code,
2223 --event_type_code,
2224 trx_id,
2225 hdr_trx_user_key1,
2226 hdr_trx_user_key2,
2227 hdr_trx_user_key3,
2228 hdr_trx_user_key4,
2229 hdr_trx_user_key5,
2230 hdr_trx_user_key6,
2231 trx_line_id,
2232 line_trx_user_key1,
2233 line_trx_user_key2,
2234 line_trx_user_key3,
2235 line_trx_user_key4,
2236 line_trx_user_key5,
2237 line_trx_user_key6,
2238 trx_level_type,
2239 trx_line_dist_id,
2240 dist_trx_user_key1,
2241 dist_trx_user_key2,
2242 dist_trx_user_key3,
2243 dist_trx_user_key4,
2244 dist_trx_user_key5,
2245 dist_trx_user_key6,
2246 dist_level_action,
2247 trx_line_dist_date,
2248 item_dist_number,
2249 dist_intended_use,
2250 tax_inclusion_flag,
2251 tax_code,
2252 applied_from_tax_dist_id,
2253 adjusted_doc_tax_dist_id,
2254 task_id,
2255 award_id,
2256 project_id,
2257 expenditure_type,
2258 expenditure_organization_id,
2259 expenditure_item_date,
2260 trx_line_dist_amt,
2261 trx_line_dist_qty,
2262 trx_line_quantity,
2263 account_ccid,
2264 account_string,
2265 ref_doc_application_id,
2266 ref_doc_entity_code,
2267 ref_doc_event_class_code,
2268 ref_doc_trx_id,
2269 ref_doc_hdr_trx_user_key1,
2270 ref_doc_hdr_trx_user_key2,
2271 ref_doc_hdr_trx_user_key3,
2272 ref_doc_hdr_trx_user_key4,
2273 ref_doc_hdr_trx_user_key5,
2274 ref_doc_hdr_trx_user_key6,
2275 ref_doc_line_id,
2276 ref_doc_lin_trx_user_key1,
2277 ref_doc_lin_trx_user_key2,
2278 ref_doc_lin_trx_user_key3,
2279 ref_doc_lin_trx_user_key4,
2280 ref_doc_lin_trx_user_key5,
2281 ref_doc_lin_trx_user_key6,
2282 ref_doc_dist_id,
2283 ref_doc_dist_trx_user_key1,
2284 ref_doc_dist_trx_user_key2,
2285 ref_doc_dist_trx_user_key3,
2286 ref_doc_dist_trx_user_key4,
2287 ref_doc_dist_trx_user_key5,
2288 ref_doc_dist_trx_user_key6,
2289 ref_doc_curr_conv_rate,
2290 numeric1,
2291 numeric2,
2292 numeric3,
2293 numeric4,
2294 numeric5,
2295 char1,
2296 char2,
2297 char3,
2298 char4,
2299 char5,
2300 date1,
2301 date2,
2302 date3,
2303 date4,
2304 date5,
2305 trx_line_dist_tax_amt,
2306 historical_flag,
2307 applied_from_application_id,
2308 applied_from_event_class_code,
2309 applied_from_entity_code,
2310 applied_from_trx_id,
2311 app_from_hdr_trx_user_key1,
2312 app_from_hdr_trx_user_key2,
2313 app_from_hdr_trx_user_key3,
2314 app_from_hdr_trx_user_key4,
2315 app_from_hdr_trx_user_key5,
2316 app_from_hdr_trx_user_key6,
2317 applied_from_line_id,
2318 app_from_lin_trx_user_key1,
2319 app_from_lin_trx_user_key2,
2320 app_from_lin_trx_user_key3,
2321 app_from_lin_trx_user_key4,
2322 app_from_lin_trx_user_key5,
2323 app_from_lin_trx_user_key6,
2324 applied_from_dist_id,
2325 app_from_dst_trx_user_key1,
2326 app_from_dst_trx_user_key2,
2327 app_from_dst_trx_user_key3,
2328 app_from_dst_trx_user_key4,
2329 app_from_dst_trx_user_key5,
2330 app_from_dst_trx_user_key6,
2331 adjusted_doc_application_id,
2332 adjusted_doc_event_class_code,
2333 adjusted_doc_entity_code,
2334 adjusted_doc_trx_id,
2335 adj_doc_hdr_trx_user_key1,
2336 adj_doc_hdr_trx_user_key2,
2337 adj_doc_hdr_trx_user_key3,
2338 adj_doc_hdr_trx_user_key4,
2339 adj_doc_hdr_trx_user_key5,
2340 adj_doc_hdr_trx_user_key6,
2341 adjusted_doc_line_id,
2342 adj_doc_lin_trx_user_key1,
2343 adj_doc_lin_trx_user_key2,
2344 adj_doc_lin_trx_user_key3,
2345 adj_doc_lin_trx_user_key4,
2346 adj_doc_lin_trx_user_key5,
2347 adj_doc_lin_trx_user_key6,
2348 adjusted_doc_dist_id,
2349 adj_doc_dst_trx_user_key1,
2350 adj_doc_dst_trx_user_key2,
2354 adj_doc_dst_trx_user_key6,
2351 adj_doc_dst_trx_user_key3,
2352 adj_doc_dst_trx_user_key4,
2353 adj_doc_dst_trx_user_key5,
2355 applied_to_doc_curr_conv_rate,
2356 REF_DOC_TRX_LINE_DIST_QTY,
2357 PRICE_DIFF,
2358 UNIT_PRICE,
2359 CURRENCY_EXCHANGE_RATE,
2360 REF_DOC_TRX_LEVEL_TYPE,
2361 APPLIED_FROM_TRX_LEVEL_TYPE,
2362 ADJUSTED_DOC_TRX_LEVEL_TYPE,
2363 OVERRIDING_RECOVERY_RATE,
2364 tax_variance_calc_flag
2365 FROM ZX_SIM_TRX_DISTS
2366 WHERE APPLICATION_ID = p_application_id
2367 AND ENTITY_CODE = p_entity_code
2368 AND EVENT_CLASS_CODE = p_event_class_code
2369 AND TRX_ID = p_trx_id
2370 AND TRX_LINE_ID = p_trx_line_id;
2371
2372 IF (g_level_procedure >= g_current_runtime_level ) THEN
2373 FND_LOG.STRING(g_level_procedure,
2374 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2375 'Insert into ZX_ITM_DISTRIBUTIONS_GT (-)');
2376 END IF;
2377
2378 BEGIN
2379
2380 IF (g_level_procedure >= g_current_runtime_level ) THEN
2381 FND_LOG.STRING(g_level_procedure,
2382 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2383 'API zx_api_pub.Determine_recovery for Insert_Temporary_Table (+)');
2384 END IF;
2385
2386 ZX_API_PUB.Determine_recovery (p_api_version => 1.0,
2387 p_init_msg_list => NULL,
2388 p_commit => NULL,
2389 p_validation_level => NULL,
2390 x_return_status => l_return_status,
2391 x_msg_count => l_msg_count,
2392 x_msg_data => l_msg_data);
2393
2394 IF (g_level_procedure >= g_current_runtime_level ) THEN
2395 FND_LOG.STRING(g_level_procedure,
2396 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2397 'API zx_api_pub.Determine_recovery for Insert_Temporary_Table (-)');
2398 END IF;
2399
2400
2401 IF (g_level_procedure >= g_current_runtime_level ) THEN
2402 FND_LOG.STRING(g_level_procedure,
2403 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2404 'Return Status = ' || l_return_status);
2405
2406 FND_LOG.STRING(g_level_procedure,
2407 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2408 'Message Count = ' || l_msg_count);
2409
2410 FND_LOG.STRING(g_level_procedure,
2411 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2412 'Message data = ' || l_msg_data);
2413 END IF;
2414 END;
2415
2416 IF (g_level_procedure >= g_current_runtime_level ) THEN
2417 FND_LOG.STRING(g_level_procedure,
2418 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.END',
2419 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (-)');
2420 END IF;
2421
2422 EXCEPTION
2423 WHEN OTHERS THEN
2424 l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2425 p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2426
2427 FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2428 FND_MSG_PUB.Add;
2429
2430 IF (g_level_unexpected >= g_current_runtime_level ) THEN
2431 FND_LOG.STRING(g_level_unexpected,
2432 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2433 p_error_buffer);
2434 END IF;
2435 END Insert_Temporary_Table;
2436
2437 PROCEDURE Update_Transaction_Lines
2438 (p_application_id NUMBER,
2439 p_entity_code VARCHAR2,
2440 p_event_class_code VARCHAR2,
2441 p_event_type_code VARCHAR2,
2442 p_trx_line_id NUMBER,
2443 p_trx_line_dist_id NUMBER,
2444 p_trx_id NUMBER,
2445 p_ledger_id NUMBER,
2446 p_reporting_currency_code VARCHAR2,
2447 p_currency_conversion_date DATE,
2448 p_currency_conversion_type VARCHAR2,
2449 p_currency_conversion_rate NUMBER,
2450 p_minimum_accountable_unit NUMBER,
2451 p_precision NUMBER) IS
2452
2453 l_return_status VARCHAR2(1000);
2454 l_msg_count NUMBER;
2455 l_msg_data VARCHAR2(1000);
2456 sid NUMBER;
2457 p_error_buffer VARCHAR2(100);
2458 debug_info VARCHAR2(100);
2459
2460 BEGIN
2461
2462 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2463 IF (g_level_procedure >= g_current_runtime_level ) THEN
2464 FND_LOG.STRING(g_level_procedure,
2465 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines.BEGIN',
2466 'ZX_SIM_TRX_DISTRIBUTION: Update_Transaction_Lines (+)');
2467 END IF;
2468
2469
2470 IF (g_level_procedure >= g_current_runtime_level ) THEN
2471 FND_LOG.STRING(g_level_procedure,
2472 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
2473 'Update ZX_ITM_DISTRIBUTIONS_GT (+)');
2474 END IF;
2475
2476 IF (g_level_procedure >= g_current_runtime_level ) THEN
2477 FND_LOG.STRING(g_level_procedure,
2478 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
2479 'Insert into zx_trx_headers_gt (+)');
2480 END IF;
2481
2482 INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,
2483 INTERNAL_ORG_LOCATION_ID,
2484 APPLICATION_ID,
2485 ENTITY_CODE,
2486 EVENT_CLASS_CODE,
2487 EVENT_TYPE_CODE,
2488 TRX_ID,
2489 TRX_DATE,
2490 --TRX_DOC_REVISION,
2491 LEDGER_ID,
2492 TRX_CURRENCY_CODE,
2493 CURRENCY_CONVERSION_DATE,
2494 CURRENCY_CONVERSION_RATE,
2495 CURRENCY_CONVERSION_TYPE,
2496 MINIMUM_ACCOUNTABLE_UNIT,
2497 PRECISION,
2498 LEGAL_ENTITY_ID,
2499 ROUNDING_SHIP_TO_PARTY_ID,
2500 ROUNDING_SHIP_FROM_PARTY_ID,
2501 ROUNDING_BILL_TO_PARTY_ID,
2502 ROUNDING_BILL_FROM_PARTY_ID,
2503 RNDG_SHIP_TO_PARTY_SITE_ID,
2504 RNDG_SHIP_FROM_PARTY_SITE_ID,
2505 RNDG_BILL_TO_PARTY_SITE_ID,
2506 RNDG_BILL_FROM_PARTY_SITE_ID,
2507 ESTABLISHMENT_ID,
2508 RECEIVABLES_TRX_TYPE_ID,
2509 --RELATED_DOC_APPLICATION_ID,
2510 --RELATED_DOC_ENTITY_CODE,
2511 --RELATED_DOC_EVENT_CLASS_CODE,
2512 --RELATED_DOC_TRX_ID,
2513 --REL_DOC_HDR_TRX_USER_KEY1,
2514 --REL_DOC_HDR_TRX_USER_KEY2,
2515 --REL_DOC_HDR_TRX_USER_KEY3,
2516 --REL_DOC_HDR_TRX_USER_KEY4,
2517 --REL_DOC_HDR_TRX_USER_KEY5,
2518 --REL_DOC_HDR_TRX_USER_KEY6,
2519 --RELATED_DOC_NUMBER,
2520 --RELATED_DOC_DATE,
2521 DEFAULT_TAXATION_COUNTRY,
2522 Quote_Flag,
2523 CTRL_TOTAL_HDR_TX_AMT,
2524 TRX_NUMBER,
2525 TRX_DESCRIPTION,
2526 --TRX_COMMUNICATED_DATE,
2527 --BATCH_SOURCE_ID,
2528 --BATCH_SOURCE_NAME,
2529 --DOC_SEQ_ID,
2530 --DOC_SEQ_NAME,
2531 --DOC_SEQ_VALUE,
2532 --TRX_DUE_DATE,
2533 --TRX_TYPE_DESCRIPTION,
2534 --BILLING_TRADING_PARTNER_NAME,
2538 DOCUMENT_SUB_TYPE,
2535 --BILLING_TRADING_PARTNER_NUMBER,
2536 --Billing_Tp_Tax_Reporting_Flag,
2537 --BILLING_TP_TAXPAYER_ID,
2539 SUPPLIER_TAX_INVOICE_NUMBER,
2540 SUPPLIER_TAX_INVOICE_DATE,
2541 SUPPLIER_EXCHANGE_RATE,
2542 TAX_INVOICE_DATE,
2543 TAX_INVOICE_NUMBER,
2544 FIRST_PTY_ORG_ID,
2545 PORT_OF_ENTRY_CODE,
2546 TAX_REPORTING_FLAG,
2547 SHIP_TO_CUST_ACCT_SITE_USE_ID,
2548 BILL_TO_CUST_ACCT_SITE_USE_ID,
2549 PROVNL_TAX_DETERMINATION_DATE,
2550 APPLIED_TO_TRX_NUMBER,
2551 SHIP_THIRD_PTY_ACCT_ID,
2552 BILL_THIRD_PTY_ACCT_ID,
2553 SHIP_THIRD_PTY_ACCT_SITE_ID,
2554 BILL_THIRD_PTY_ACCT_SITE_ID,
2555 VALIDATION_CHECK_FLAG,
2556 --TAX_EVENT_CLASS_CODE,
2557 TAX_EVENT_TYPE_CODE
2558 --DOC_EVENT_STATUS,
2559 --RDNG_SHIP_TO_PTY_TX_PROF_ID,
2560 --RDNG_SHIP_FROM_PTY_TX_PROF_ID,
2561 --RDNG_BILL_TO_PTY_TX_PROF_ID,
2562 --RDNG_BILL_FROM_PTY_TX_PROF_ID,
2563 --RDNG_SHIP_TO_PTY_TX_P_ST_ID,
2564 --RDNG_SHIP_FROM_PTY_TX_P_ST_ID,
2565 --RDNG_BILL_TO_PTY_TX_P_ST_ID,
2566 --RDNG_BILL_FROM_PTY_TX_P_ST_ID
2567 )
2568 SELECT internal_organization_id,
2569 internal_org_location_id,
2570 application_id,
2571 entity_code,
2572 event_class_code,
2573 event_type_code,
2574 trx_id,
2575 trx_date,
2576 --p_trx_doc_revision,
2577 ledger_id,
2578 trx_currency_code,
2579 currency_conversion_date,
2580 currency_conversion_rate,
2581 currency_conversion_type,
2582 minimum_accountable_unit,
2583 precision,
2584 legal_entity_id,
2585 rounding_ship_to_party_id,
2586 rounding_ship_from_party_id,
2587 rounding_bill_to_party_id,
2588 rounding_bill_from_party_id,
2589 rndg_ship_to_party_site_id,
2590 rndg_ship_from_party_site_id,
2591 rndg_bill_to_party_site_id,
2592 rndg_bill_from_party_site_id,
2593 establishment_id,
2594 receivables_trx_type_id,
2595 --p_related_doc_application_id,
2596 --p_related_doc_entity_code,
2597 --p_related_doc_evt_class_code, --reduced size p_related_doc_event_class_code
2598 --p_related_doc_trx_id,
2599 --p_rel_doc_hdr_trx_user_key1,
2600 --p_rel_doc_hdr_trx_user_key2,
2601 --p_rel_doc_hdr_trx_user_key3,
2602 --p_rel_doc_hdr_trx_user_key4,
2603 --p_rel_doc_hdr_trx_user_key5,
2604 --p_rel_doc_hdr_trx_user_key6,
2605 --p_related_doc_number,
2606 --p_related_doc_date,
2607 default_taxation_country,
2608 Quote_Flag,
2609 ctrl_total_hdr_tx_amt,
2610 trx_number,
2611 trx_description,
2612 --p_trx_communicated_date,
2613 --p_batch_source_id,
2614 --p_batch_source_name,
2618 --p_trx_due_date,
2615 --p_doc_seq_id,
2616 --p_doc_seq_name,
2617 --p_doc_seq_value,
2619 --p_trx_type_description,
2620 --p_billing_trad_partner_name, --reduced size p_billing_trading_partner_name
2621 --p_billing_trad_partner_number, --reduced size p_billing_trading_partner_number
2622 --p_billing_tp_tax_report_flg, --reduced size p_Billing_Tp_Tax_Reporting_Flag
2623 --p_billing_tp_taxpayer_id,
2624 document_sub_type,
2625 supplier_tax_invoice_number,
2626 supplier_tax_invoice_date,
2627 supplier_exchange_rate,
2628 tax_invoice_date,
2629 tax_invoice_number,
2630 first_pty_org_id,
2631 PORT_OF_ENTRY_CODE,
2632 TAX_REPORTING_FLAG,
2633 SHIP_TO_CUST_ACCT_SITE_USE_ID,
2634 BILL_TO_CUST_ACCT_SITE_USE_ID,
2635 PROVNL_TAX_DETERMINATION_DATE,
2636 APPLIED_TO_TRX_NUMBER,
2637 SHIP_THIRD_PTY_ACCT_ID,
2638 BILL_THIRD_PTY_ACCT_ID,
2639 SHIP_THIRD_PTY_ACCT_SITE_ID,
2640 BILL_THIRD_PTY_ACCT_SITE_ID,
2641 VALIDATION_CHECK_FLAG,
2642 --p_tax_event_class_code,
2643 tax_event_type_code--p_tax_event_type_code,
2644 --p_doc_event_status,
2645 --p_rdng_ship_to_pty_tx_prof_id,
2646 --p_rdng_ship_fr_pty_tx_prof_id, --reduced size p_rdng_ship_from_pty_tx_prof_id
2647 --p_rdng_bill_to_pty_tx_prof_id,
2648 --p_rdng_bill_fr_pty_tx_prof_id, --reduced size p_rdng_bill_from_pty_tx_prof_id
2649 --p_rdng_ship_to_pty_tx_p_st_id,
2650 --p_rdng_ship_fr_pty_tx_p_st_id, --reduced size p_rdng_ship_from_pty_tx_p_st_id
2651 --p_rdng_bill_to_pty_tx_p_st_id,
2652 --p_rdng_bill_fr_pty_tx_p_st_id); --reduced size p_rdng_bill_from_pty_tx_p_st_id
2653 FROM ZX_TRANSACTION
2654 WHERE APPLICATION_ID = p_application_id
2655 AND ENTITY_CODE = p_entity_code
2656 AND EVENT_CLASS_CODE = p_event_class_code
2657 AND TRX_ID = p_trx_id;
2658
2659 IF (g_level_procedure >= g_current_runtime_level ) THEN
2660 FND_LOG.STRING(g_level_procedure,
2661 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2662 'Insert into zx_trx_headers_gt (-)');
2663 END IF;
2664
2665 IF (g_level_procedure >= g_current_runtime_level ) THEN
2666 FND_LOG.STRING(g_level_procedure,
2667 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
2668 'Insert ZX_ITM_DISTRIBUTIONS_GT (+)');
2669 END IF;
2670
2671 INSERT INTO ZX_ITM_DISTRIBUTIONS_GT (APPLICATION_ID,
2672 ENTITY_CODE,
2673 EVENT_CLASS_CODE,
2674 --EVENT_TYPE_CODE,
2675 TRX_ID,
2676 HDR_TRX_USER_KEY1,
2677 HDR_TRX_USER_KEY2,
2678 HDR_TRX_USER_KEY3,
2679 HDR_TRX_USER_KEY4,
2680 HDR_TRX_USER_KEY5,
2681 HDR_TRX_USER_KEY6,
2682 TRX_LINE_ID,
2683 LINE_TRX_USER_KEY1,
2684 LINE_TRX_USER_KEY2,
2685 LINE_TRX_USER_KEY3,
2686 LINE_TRX_USER_KEY4,
2687 LINE_TRX_USER_KEY5,
2688 LINE_TRX_USER_KEY6,
2689 TRX_LEVEL_TYPE,
2690 TRX_LINE_DIST_ID,
2691 DIST_TRX_USER_KEY1,
2692 DIST_TRX_USER_KEY2,
2693 DIST_TRX_USER_KEY3,
2694 DIST_TRX_USER_KEY4,
2695 DIST_TRX_USER_KEY5,
2696 DIST_TRX_USER_KEY6,
2697 DIST_LEVEL_ACTION,
2701 TAX_INCLUSION_FLAG,
2698 TRX_LINE_DIST_DATE,
2699 ITEM_DIST_NUMBER,
2700 DIST_INTENDED_USE,
2702 TAX_CODE,
2703 APPLIED_FROM_TAX_DIST_ID,
2704 ADJUSTED_DOC_TAX_DIST_ID,
2705 TASK_ID,
2706 AWARD_ID,
2707 PROJECT_ID,
2708 EXPENDITURE_TYPE,
2709 EXPENDITURE_ORGANIZATION_ID,
2710 EXPENDITURE_ITEM_DATE,
2711 TRX_LINE_DIST_AMT,
2712 TRX_LINE_DIST_QTY,
2713 TRX_LINE_QUANTITY,
2714 ACCOUNT_CCID,
2715 ACCOUNT_STRING,
2716 REF_DOC_APPLICATION_ID,
2717 REF_DOC_ENTITY_CODE,
2718 REF_DOC_EVENT_CLASS_CODE,
2719 REF_DOC_TRX_ID,
2720 REF_DOC_HDR_TRX_USER_KEY1,
2721 REF_DOC_HDR_TRX_USER_KEY2,
2722 REF_DOC_HDR_TRX_USER_KEY3,
2723 REF_DOC_HDR_TRX_USER_KEY4,
2724 REF_DOC_HDR_TRX_USER_KEY5,
2725 REF_DOC_HDR_TRX_USER_KEY6,
2726 REF_DOC_LINE_ID,
2727 REF_DOC_LIN_TRX_USER_KEY1,
2728 REF_DOC_LIN_TRX_USER_KEY2,
2729 REF_DOC_LIN_TRX_USER_KEY3,
2730 REF_DOC_LIN_TRX_USER_KEY4,
2731 REF_DOC_LIN_TRX_USER_KEY5,
2732 REF_DOC_LIN_TRX_USER_KEY6,
2733 REF_DOC_DIST_ID,
2734 REF_DOC_DIST_TRX_USER_KEY1,
2735 REF_DOC_DIST_TRX_USER_KEY2,
2736 REF_DOC_DIST_TRX_USER_KEY3,
2737 REF_DOC_DIST_TRX_USER_KEY4,
2738 REF_DOC_DIST_TRX_USER_KEY5,
2739 REF_DOC_DIST_TRX_USER_KEY6,
2740 REF_DOC_CURR_CONV_RATE,
2741 NUMERIC1,
2742 NUMERIC2,
2743 NUMERIC3,
2744 NUMERIC4,
2745 NUMERIC5,
2746 CHAR1,
2747 CHAR2,
2748 CHAR3,
2749 CHAR4,
2750 CHAR5,
2751 DATE1,
2752 DATE2,
2753 DATE3,
2754 DATE4,
2755 DATE5,
2756 TRX_LINE_DIST_TAX_AMT,
2757 HISTORICAL_FLAG,
2758 APPLIED_FROM_APPLICATION_ID,
2759 APPLIED_FROM_EVENT_CLASS_CODE,
2760 APPLIED_FROM_ENTITY_CODE,
2761 APPLIED_FROM_TRX_ID,
2762 APP_FROM_HDR_TRX_USER_KEY1,
2763 APP_FROM_HDR_TRX_USER_KEY2,
2764 APP_FROM_HDR_TRX_USER_KEY3,
2765 APP_FROM_HDR_TRX_USER_KEY4,
2766 APP_FROM_HDR_TRX_USER_KEY5,
2767 APP_FROM_HDR_TRX_USER_KEY6,
2768 APPLIED_FROM_LINE_ID,
2769 APP_FROM_LIN_TRX_USER_KEY1,
2770 APP_FROM_LIN_TRX_USER_KEY2,
2771 APP_FROM_LIN_TRX_USER_KEY3,
2772 APP_FROM_LIN_TRX_USER_KEY4,
2773 APP_FROM_LIN_TRX_USER_KEY5,
2774 APP_FROM_LIN_TRX_USER_KEY6,
2775 APPLIED_FROM_DIST_ID,
2776 APP_FROM_DST_TRX_USER_KEY1,
2777 APP_FROM_DST_TRX_USER_KEY2,
2778 APP_FROM_DST_TRX_USER_KEY3,
2779 APP_FROM_DST_TRX_USER_KEY4,
2780 APP_FROM_DST_TRX_USER_KEY5,
2781 APP_FROM_DST_TRX_USER_KEY6,
2782 ADJUSTED_DOC_APPLICATION_ID,
2783 ADJUSTED_DOC_EVENT_CLASS_CODE,
2787 ADJ_DOC_HDR_TRX_USER_KEY2,
2784 ADJUSTED_DOC_ENTITY_CODE,
2785 ADJUSTED_DOC_TRX_ID,
2786 ADJ_DOC_HDR_TRX_USER_KEY1,
2788 ADJ_DOC_HDR_TRX_USER_KEY3,
2789 ADJ_DOC_HDR_TRX_USER_KEY4,
2790 ADJ_DOC_HDR_TRX_USER_KEY5,
2791 ADJ_DOC_HDR_TRX_USER_KEY6,
2792 ADJUSTED_DOC_LINE_ID,
2793 ADJ_DOC_LIN_TRX_USER_KEY1,
2794 ADJ_DOC_LIN_TRX_USER_KEY2,
2795 ADJ_DOC_LIN_TRX_USER_KEY3,
2796 ADJ_DOC_LIN_TRX_USER_KEY4,
2797 ADJ_DOC_LIN_TRX_USER_KEY5,
2798 ADJ_DOC_LIN_TRX_USER_KEY6,
2799 ADJUSTED_DOC_DIST_ID,
2800 ADJ_DOC_DST_TRX_USER_KEY1,
2801 ADJ_DOC_DST_TRX_USER_KEY2,
2802 ADJ_DOC_DST_TRX_USER_KEY3,
2803 ADJ_DOC_DST_TRX_USER_KEY4,
2804 ADJ_DOC_DST_TRX_USER_KEY5,
2805 ADJ_DOC_DST_TRX_USER_KEY6,
2806 APPLIED_TO_DOC_CURR_CONV_RATE,
2807 REF_DOC_TRX_LINE_DIST_QTY,
2808 PRICE_DIFF,
2809 UNIT_PRICE,
2810 CURRENCY_EXCHANGE_RATE,
2811 REF_DOC_TRX_LEVEL_TYPE,
2812 APPLIED_FROM_TRX_LEVEL_TYPE,
2813 ADJUSTED_DOC_TRX_LEVEL_TYPE,
2814 OVERRIDING_RECOVERY_RATE,
2815 TAX_VARIANCE_CALC_FLAG)
2816 SELECT application_id,
2817 entity_code,
2818 event_class_code,
2819 --event_type_code,
2820 trx_id,
2821 hdr_trx_user_key1,
2822 hdr_trx_user_key2,
2823 hdr_trx_user_key3,
2824 hdr_trx_user_key4,
2825 hdr_trx_user_key5,
2826 hdr_trx_user_key6,
2827 trx_line_id,
2828 line_trx_user_key1,
2829 line_trx_user_key2,
2830 line_trx_user_key3,
2831 line_trx_user_key4,
2832 line_trx_user_key5,
2833 line_trx_user_key6,
2834 trx_level_type,
2835 trx_line_dist_id,
2836 dist_trx_user_key1,
2837 dist_trx_user_key2,
2838 dist_trx_user_key3,
2839 dist_trx_user_key4,
2840 dist_trx_user_key5,
2841 dist_trx_user_key6,
2842 dist_level_action,
2843 trx_line_dist_date,
2844 item_dist_number,
2845 dist_intended_use,
2846 tax_inclusion_flag,
2847 tax_code,
2848 applied_from_tax_dist_id,
2849 adjusted_doc_tax_dist_id,
2850 task_id,
2851 award_id,
2852 project_id,
2853 expenditure_type,
2854 expenditure_organization_id,
2855 expenditure_item_date,
2856 trx_line_dist_amt,
2857 trx_line_dist_qty,
2858 trx_line_quantity,
2859 account_ccid,
2860 account_string,
2861 ref_doc_application_id,
2862 ref_doc_entity_code,
2863 ref_doc_event_class_code,
2864 ref_doc_trx_id,
2865 ref_doc_hdr_trx_user_key1,
2866 ref_doc_hdr_trx_user_key2,
2867 ref_doc_hdr_trx_user_key3,
2868 ref_doc_hdr_trx_user_key4,
2869 ref_doc_hdr_trx_user_key5,
2870 ref_doc_hdr_trx_user_key6,
2871 ref_doc_line_id,
2872 ref_doc_lin_trx_user_key1,
2873 ref_doc_lin_trx_user_key2,
2874 ref_doc_lin_trx_user_key3,
2875 ref_doc_lin_trx_user_key4,
2876 ref_doc_lin_trx_user_key5,
2877 ref_doc_lin_trx_user_key6,
2878 ref_doc_dist_id,
2879 ref_doc_dist_trx_user_key1,
2880 ref_doc_dist_trx_user_key2,
2881 ref_doc_dist_trx_user_key3,
2882 ref_doc_dist_trx_user_key4,
2883 ref_doc_dist_trx_user_key5,
2884 ref_doc_dist_trx_user_key6,
2885 ref_doc_curr_conv_rate,
2886 numeric1,
2887 numeric2,
2888 numeric3,
2889 numeric4,
2890 numeric5,
2891 char1,
2892 char2,
2893 char3,
2894 char4,
2895 char5,
2896 date1,
2897 date2,
2898 date3,
2899 date4,
2900 date5,
2901 trx_line_dist_tax_amt,
2902 historical_flag,
2903 applied_from_application_id,
2904 applied_from_event_class_code,
2905 applied_from_entity_code,
2906 applied_from_trx_id,
2907 app_from_hdr_trx_user_key1,
2908 app_from_hdr_trx_user_key2,
2909 app_from_hdr_trx_user_key3,
2910 app_from_hdr_trx_user_key4,
2911 app_from_hdr_trx_user_key5,
2912 app_from_hdr_trx_user_key6,
2913 applied_from_line_id,
2914 app_from_lin_trx_user_key1,
2915 app_from_lin_trx_user_key2,
2916 app_from_lin_trx_user_key3,
2917 app_from_lin_trx_user_key4,
2918 app_from_lin_trx_user_key5,
2919 app_from_lin_trx_user_key6,
2920 applied_from_dist_id,
2921 app_from_dst_trx_user_key1,
2922 app_from_dst_trx_user_key2,
2923 app_from_dst_trx_user_key3,
2924 app_from_dst_trx_user_key4,
2925 app_from_dst_trx_user_key5,
2926 app_from_dst_trx_user_key6,
2927 adjusted_doc_application_id,
2928 adjusted_doc_event_class_code,
2929 adjusted_doc_entity_code,
2930 adjusted_doc_trx_id,
2931 adj_doc_hdr_trx_user_key1,
2932 adj_doc_hdr_trx_user_key2,
2933 adj_doc_hdr_trx_user_key3,
2934 adj_doc_hdr_trx_user_key4,
2935 adj_doc_hdr_trx_user_key5,
2936 adj_doc_hdr_trx_user_key6,
2937 adjusted_doc_line_id,
2938 adj_doc_lin_trx_user_key1,
2939 adj_doc_lin_trx_user_key2,
2940 adj_doc_lin_trx_user_key3,
2941 adj_doc_lin_trx_user_key4,
2942 adj_doc_lin_trx_user_key5,
2943 adj_doc_lin_trx_user_key6,
2944 adjusted_doc_dist_id,
2945 adj_doc_dst_trx_user_key1,
2946 adj_doc_dst_trx_user_key2,
2947 adj_doc_dst_trx_user_key3,
2948 adj_doc_dst_trx_user_key4,
2949 adj_doc_dst_trx_user_key5,
2950 adj_doc_dst_trx_user_key6,
2951 applied_to_doc_curr_conv_rate,
2952 REF_DOC_TRX_LINE_DIST_QTY,
2953 PRICE_DIFF,
2954 UNIT_PRICE,
2955 CURRENCY_EXCHANGE_RATE,
2956 REF_DOC_TRX_LEVEL_TYPE,
2957 APPLIED_FROM_TRX_LEVEL_TYPE,
2958 ADJUSTED_DOC_TRX_LEVEL_TYPE,
2959 OVERRIDING_RECOVERY_RATE,
2960 tax_variance_calc_flag
2961 FROM ZX_SIM_TRX_DISTS
2962 WHERE APPLICATION_ID = p_application_id
2963 AND ENTITY_CODE = p_entity_code
2964 AND EVENT_CLASS_CODE = p_event_class_code
2965 AND TRX_ID = p_trx_id;
2966
2967 IF (g_level_procedure >= g_current_runtime_level ) THEN
2968 FND_LOG.STRING(g_level_procedure,
2969 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
2970 'Insert ZX_ITM_DISTRIBUTIONS_GT (-)');
2971 END IF;
2972
2973 BEGIN
2974
2975 IF (g_level_procedure >= g_current_runtime_level ) THEN
2976 FND_LOG.STRING(g_level_procedure,
2977 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
2978 'API zx_api_pub.Determine_recovery for Update_Temporary_Table (+)');
2979 END IF;
2980
2981
2982 ZX_API_PUB.Determine_recovery (p_api_version => 1.0,
2983 p_init_msg_list => NULL,
2984 p_commit => NULL,
2985 p_validation_level => NULL,
2986 x_return_status => l_return_status,
2987 x_msg_count => l_msg_count,
2988 x_msg_data => l_msg_data);
2989
2990 IF (g_level_procedure >= g_current_runtime_level ) THEN
2991 FND_LOG.STRING(g_level_procedure,
2992 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
2993 'API zx_api_pub.Determine_recovery for Update_Temporary_Table (-)');
2994 END IF;
2995
2996
2997 IF (g_level_procedure >= g_current_runtime_level ) THEN
2998 FND_LOG.STRING(g_level_procedure,
2999 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3000 'Return Status = ' || l_return_status);
3001
3002 FND_LOG.STRING(g_level_procedure,
3003 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3004 'Message Count = ' || l_msg_count);
3005
3006 FND_LOG.STRING(g_level_procedure,
3007 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3008 'Message data = ' || l_msg_data);
3009 END IF;
3010 END;
3011 IF (g_level_procedure >= g_current_runtime_level ) THEN
3012 FND_LOG.STRING(g_level_procedure,
3013 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
3014 'Update ZX_ITM_DISTRIBUTIONS_GT (-)');
3015 END IF;
3016
3017 EXCEPTION
3018 WHEN OTHERS THEN
3019 l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3020 p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3021
3022 FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3023 FND_MSG_PUB.Add;
3024
3025 IF (g_level_unexpected >= g_current_runtime_level ) THEN
3026 FND_LOG.STRING(g_level_unexpected,
3027 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
3028 p_error_buffer);
3029 END IF;
3030 END Update_Transaction_Lines;
3031
3032 END ZX_SIM_TRX_DISTRIBUTION;