[Home] [Help]
86: | request status. |
87: | - FOR this defined AND used EXCEPTION |
88: | 'normal_termination' |
89: | 10/31/2003 Shishir Joshi Bug 3220355. Modified INSERT INTO THE |
90: | XLA_EVENTS_GT TABLE. |
91: | 11/18/2003 S. Singhania Bug 3220355. Modified INSERT INTO THE |
92: | XLA_EVENTS_GT TABLE. |
93: | Removed THE NOWAIT FROM THE FOR UPDATE |
94: | statements IN THE batch MODE. |
88: | 'normal_termination' |
89: | 10/31/2003 Shishir Joshi Bug 3220355. Modified INSERT INTO THE |
90: | XLA_EVENTS_GT TABLE. |
91: | 11/18/2003 S. Singhania Bug 3220355. Modified INSERT INTO THE |
92: | XLA_EVENTS_GT TABLE. |
93: | Removed THE NOWAIT FROM THE FOR UPDATE |
94: | statements IN THE batch MODE. |
95: | (Bug # 2697222) |
96: | 11/19/2003 S. Singhania Initilaized 'g_report_request_id' IN THE |
97: | ACCOUNTING_PROGRAM_DOCUMENT so that THE|
98: | EVENTS are stamped correctly WITH THE |
99: | request_id IN THE OFFLINE MODE. |
100: | 11/24/2003 Shishir Joshi Bug 3275659. Modified INSERT INTO THE |
101: | XLA_EVENTS_GT TABLE. |
102: | 11/24/2003 S. Singhania Bug 3275659. |
103: | - Modified INSERT INTO XLA_EVENTS_GT. |
104: | - Added 'p_report_request_id' param TO |
105: | UNIT_PROCESSOR_BATCH |
99: | request_id IN THE OFFLINE MODE. |
100: | 11/24/2003 Shishir Joshi Bug 3275659. Modified INSERT INTO THE |
101: | XLA_EVENTS_GT TABLE. |
102: | 11/24/2003 S. Singhania Bug 3275659. |
103: | - Modified INSERT INTO XLA_EVENTS_GT. |
104: | - Added 'p_report_request_id' param TO |
105: | UNIT_PROCESSOR_BATCH |
106: | - Modified SPAWN_CHILD_PROCESSES TO |
107: | included THE NEW parameter WHILE |
168: | XLA_ACCTOUNTING_QTAB queue TABLE IN XLA |
169: | SCHEMA. |
170: | Made changes TO refer TO THE TYPE |
171: | XLA_QUEUE_MSG_TYPE IN APPS SCHEMA |
172: | 01/04/2005 S. Singhania Bug 4364612. WHILE loading xla_events_gt, |
173: | valuation method COLUMN IS populated. |
174: | 05/27/2005 V. Kumar Bug 4339454 Added handle_accounting_hook |
175: | procedure to replace business event by |
176: | APIS in accounting program |
173: | valuation method COLUMN IS populated. |
174: | 05/27/2005 V. Kumar Bug 4339454 Added handle_accounting_hook |
175: | procedure to replace business event by |
176: | APIS in accounting program |
177: | 01/06/2005 W. Shen Modify insert into xla_events_gt to insert|
178: | transaction_date |
179: | 06/06/2005 M. Asada Bug 4259032 Processing Unit Enhancement |
180: | 14/06/2005 V. Swapna Bug 4426342 Enabled business events for |
181: | all products |
282: ';
283:
284: -- 8423174 added join on BUDGETARY CONTROL FLAG to exclude Budgetary Events
285: C_CURR_INS_EVENTS CONSTANT VARCHAR2(32000) := '
286: INSERT INTO xla_events_gt
287: (entity_id
288: ,application_id
289: ,ledger_id
290: ,legal_entity_id
384: -- those of all Process Order higher than the current Process Order.
385: --
386: -- 8423174 added join on BUDGETARY CONTROL FLAG to exclude Budgetary Events
387: C_ANYTIME_INS_EVENTS CONSTANT VARCHAR2(32000) := '
388: INSERT INTO xla_events_gt
389: (entity_id
390: ,application_id
391: ,ledger_id
392: ,legal_entity_id
4116: -- Delete from xla_accounting_errors
4117: --
4118: DELETE FROM xla_accounting_errors
4119: WHERE event_id IN
4120: (SELECT event_id FROM xla_events_gt);
4121:
4122: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4123: trace
4124: (p_msg => 'Number of errors deleted = '||SQL%ROWCOUNT
4131: --
4132: DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM xla_distribution_links xdl
4133: WHERE ae_header_id IN
4134: (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ xh.ae_header_id
4135: FROM xla_events_gt xe,
4136: xla_ae_headers xh
4137: WHERE xe.process_status_code in ('D','E','R','I')
4138: AND xh.application_id = xe.application_id
4139: AND xh.event_id = xe.event_id
4156: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
4157: FROM xla_ae_segment_values
4158: WHERE ae_header_id IN
4159: (SELECT xh.ae_header_id
4160: FROM xla_events_gt xe,
4161: xla_ae_headers xh
4162: WHERE xe.process_status_code in ('D','E','R', 'I')
4163: AND xh.application_id = xe.application_id
4164: AND xh.event_id = xe.event_id
4178: FROM xla_ae_line_acs
4179:
4180: WHERE ae_header_id IN
4181: (SELECT/*+ cardinality(evt,10) unnest */ aeh.ae_header_id
4182: FROM xla_events_gt evt
4183: ,xla_ae_headers aeh
4184: WHERE evt.process_status_code in ('D','E','R','I')
4185: AND aeh.application_id = evt.application_id
4186: AND aeh.event_id = evt.event_id);
4197: --
4198: DELETE FROM xla_ae_header_acs
4199: WHERE ae_header_id IN
4200: (SELECT aeh.ae_header_id
4201: FROM xla_events_gt evt
4202: ,xla_ae_headers aeh
4203: WHERE evt.process_status_code in ('D','E','R','I')
4204: AND aeh.application_id = evt.application_id
4205: AND aeh.event_id = evt.event_id);
4217: DELETE FROM xla_ae_lines
4218: WHERE application_id = g_application_id
4219: AND ae_header_id IN
4220: (SELECT xh.ae_header_id
4221: FROM xla_events_gt xe,
4222: xla_ae_headers xh
4223: WHERE xe.process_status_code in ('D','E','R','I')
4224: AND xh.application_id = xe.application_id
4225: AND xh.event_id = xe.event_id
4238: DELETE /*+ index(aeh, xla_ae_headers_n2) */
4239: FROM xla_ae_headers aeh
4240: WHERE application_id = g_application_id
4241: AND event_id IN (SELECT event_id
4242: FROM xla_events_gt
4243: WHERE process_status_code IN ('D','E','R','I'));
4244:
4245: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4246: trace
4264: IF ( nvl(fnd_profile.value('XLA_DIAGNOSTIC_MODE'),'N') = 'Y') THEN
4265:
4266: DELETE FROM xla_diag_sources
4267: WHERE event_id IN
4268: (SELECT event_id FROM xla_events_gt);
4269:
4270: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4271: trace
4272: (p_msg => 'Number of Extract sources rows deleted = '||SQL%ROWCOUNT
4275: END IF;
4276:
4277: DELETE FROM xla_diag_events
4278: WHERE event_id IN
4279: (SELECT event_id FROM xla_events_gt);
4280:
4281: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4282: trace
4283: (p_msg => 'Number of Extract events deleted = '||SQL%ROWCOUNT
6530: --- End of First Insert ----------------------------------------------------------------------------
6531:
6532: ----------------------------------------------------------------------------------------------------
6533: -- 4597150
6534: -- Second insert into xla_events_gt is for process order -1
6535: -- When all process orders are -1, events are inserted in
6536: -- the previous insert statement. In this case, l_class_anytime_order
6537: -- becomes null.
6538: ----------------------------------------------------------------------------------------------------
6570: CLOSE lock_events_cur;
6571:
6572: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6573: trace
6574: (p_msg => 'Number of events in XLA_EVENTS_GT = '||l_event_count
6575: ,p_level => C_LEVEL_STATEMENT
6576: ,p_module => l_log_module);
6577: END IF;
6578:
7313: -- bug 7193986 start
7314: --
7315: -- Delete the events inserted from the previous run
7316: --
7317: DELETE FROM XLA_EVENTS_GT;
7318: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7319: trace
7320: (p_msg => '# rows deleted XLA_EVENTS_GT = '||SQL%ROWCOUNT
7321: ,p_level => C_LEVEL_PROCEDURE
7316: --
7317: DELETE FROM XLA_EVENTS_GT;
7318: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7319: trace
7320: (p_msg => '# rows deleted XLA_EVENTS_GT = '||SQL%ROWCOUNT
7321: ,p_level => C_LEVEL_PROCEDURE
7322: ,p_module => l_log_module);
7323: END IF;
7324: DELETE FROM XLA_AE_LINES_GT;
7344: END IF;
7345:
7346:
7347: --
7348: -- Insert into xla_events_gt for the entity in xla_acct_prog_events_gt
7349: -- for the p_application_id and p_ledger_id.
7350: --
7351: INSERT INTO xla_events_gt
7352: (entity_id
7347: --
7348: -- Insert into xla_events_gt for the entity in xla_acct_prog_events_gt
7349: -- for the p_application_id and p_ledger_id.
7350: --
7351: INSERT INTO xla_events_gt
7352: (entity_id
7353: ,application_id
7354: ,ledger_id
7355: ,legal_entity_id
7452:
7453:
7454: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7455: trace
7456: (p_msg => '# rows inserted into xla_events_gt = '||SQL%ROWCOUNT
7457: ,p_level => C_LEVEL_PROCEDURE
7458: ,p_module => l_log_module);
7459: END IF;
7460:
7463:
7464:
7465: SELECT max(event_date)
7466: INTO l_max_event_date
7467: FROM xla_events_gt;
7468: --
7469: -- Call subledger extract API
7470: --
7471: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - executing extract hook');
7902: ,aeh.accounting_entry_type_code accounting_entry_type_code
7903: ,aeh.accounting_date gl_date
7904: ,aeh.completed_date completion_date
7905: FROM xla_ae_headers aeh
7906: ,xla_events_gt xeg
7907: ,xla_subledgers xsl
7908: WHERE aeh.application_id = xeg.application_id
7909: AND aeh.event_id = xeg.event_id
7910: AND xsl.application_id = xeg.application_id
8035: --,tmp.process_status_code new_process_status_code -- bug 4961401
8036: ,DECODE(evt.event_status_code,'N','P',tmp.process_status_code) new_process_status_code
8037: ,tmp.reference_char_4 new_reference_char_4 --bug 13811614
8038: FROM xla_events evt
8039: ,xla_events_gt tmp
8040: WHERE evt.event_id = tmp.event_id
8041: AND evt.application_id = g_application_id
8042: )
8043: SET event_status_code = new_event_status_code
8076: ,xla_aad_line_defn_assgns xald
8077: ,xla_line_definitions_b xldb
8078: ,xla_ledger_relationships_v xlr
8079: ,xla_ledger_options xlo
8080: ,xla_events_gt xle
8081: WHERE glg.sla_accounting_method_code = xam.accounting_method_code
8082: AND glg.sla_accounting_method_type = xam.accounting_method_type_code
8083: AND xam.accounting_method_code = xamr.accounting_method_code
8084: AND xam.accounting_method_type_code = xamr.accounting_method_type_code