[Home] [Help]
25: | updating EVENTS TABLE. PROCEDURE |
26: | modified : BATCH_ACCOUNTING |
27: | Modified THE CURSOR TO REF CURSOR IN |
28: | ENQUEUE_MESSAGES. included filters |
29: | based ON xla_events. |
30: | 06/17/2003 S. Singhania Changed THE NAME OF THE VIEW used |
31: | XLA_EVENT_ENTITIES_V TO |
32: | XLA_ENTITY_EVENTS_V |
33: | 06/26/2003 S. Singhania Bug fix FOR bug # 3022532. (TABLE NAME |
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 |
122: | pre-processing PROCEDURE |
123: | 12/19/2003 S. Singhania Modified THE CURSOR's where clause in |
124: | ENQUEUE_MESSAGES. Bug 3327641 |
125: | 01/12/2004 S. Singhania Bug # 3365680. Added hint TO THE UPDATE |
126: | STATEMENT so that INDEX XLA_EVENTS_U1 |
127: | IS always used. |
128: | 01/26/2004 W. Shen Bug # 3339505. replace THE program hook |
129: | WITH workflow business event. |
130: | 02/13/2004 S. Singhania FIXED NOCOPY warnings. |
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 |
257: C_LOCK_EVENTS_STR CONSTANT VARCHAR2(32000) :=
258: '
259: SELECT /*+ leading(tab,evt) use_nl(evt) */
260: evt.event_id
261: FROM xla_events evt
262: ,xla_event_types_b xet
263: ,TABLE(CAST(:1 AS xla_array_number_type)) tab
264: WHERE evt.application_id = :2
265: AND evt.event_date <= :3
273: FOR UPDATE OF evt.event_id skip locked
274: ';
275:
276: C_CURR_INS_EVENTS CONSTANT VARCHAR2(32000) := '
277: INSERT INTO xla_events_gt
278: (entity_id
279: ,application_id
280: ,ledger_id
281: ,legal_entity_id
347: ,evt.reference_date_1
348: ,evt.reference_date_2
349: ,evt.reference_date_3
350: ,evt.reference_date_4
351: FROM xla_events evt
352: ,xla_transaction_entities ent
353: ,xla_event_types_b xet
354: ,xla_event_class_attrs eca
355: WHERE evt.application_id = :1
373: -- Unprocessed Event Number of Process Order -1 must be lower than
374: -- those of all Process Order higher than the current Process Order.
375: --
376: C_ANYTIME_INS_EVENTS CONSTANT VARCHAR2(32000) := '
377: INSERT INTO xla_events_gt
378: (entity_id
379: ,application_id
380: ,ledger_id
381: ,legal_entity_id
447: ,evt.reference_date_1
448: ,evt.reference_date_2
449: ,evt.reference_date_3
450: ,evt.reference_date_4
451: FROM xla_events evt
452: ,xla_transaction_entities ent
453: ,xla_event_types_b xet
454: ,xla_event_class_attrs eca
455: WHERE evt.application_id = :1
468: AND evt.event_status_code IN
469: (''U'', DECODE(:4, ''F'',''N'',''U''))
470: AND evt.event_number <
471: (SELECT NVL(MIN(evt2.event_number), evt.event_number + 1)
472: FROM xla_events evt2
473: ,xla_transaction_entities_upg ent2
474: ,xla_event_types_b xet2
475: ,xla_event_class_attrs eca2
476: WHERE evt2.application_id = evt.application_id
2646: CURSOR c_lock_entity_events IS
2647: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XTE) */
2648: xe.event_id
2649: FROM xla_transaction_entities xte
2650: , xla_events xe
2651: , xla_acct_prog_events_gt xap
2652: WHERE xte.application_id = xe.application_id
2653: AND xte.entity_id = xe.entity_id
2654: AND xe.application_id = p_application_id
2657:
2658: CURSOR c_entities IS
2659: SELECT distinct entity_id
2660: FROM xla_acct_prog_events_gt xap
2661: , xla_events xe
2662: WHERE xe.application_id = p_application_id
2663: AND xe.event_id = xap.event_id;
2664:
2665: -- Retrieve list of ledgers to be processed
2671: l_request_id INTEGER;
2672: l_array_event_id t_array_integer;
2673: l_ret_flag_bal_update BOOLEAN;
2674: l_transfer_mode VARCHAR2(30);
2675: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2676:
2677: l_log_module VARCHAR2(240);
2678: BEGIN
2679: IF g_log_enabled THEN
2903: IF (g_accounting_mode IN ('D','F')) THEN
2904: delete_batch_je;
2905:
2906: FORALL i IN 1..l_array_event_id.COUNT
2907: UPDATE xla_events xe
2908: SET process_status_code = 'U'
2909: WHERE xe.on_hold_flag = 'N'
2910: AND xe.process_status_code <> 'P'
2911: AND xe.event_type_code not in ('FULL_MERGE', 'PARTIAL_MERGE')
2943:
2944: FOR x IN (
2945: SELECT DISTINCT xla_evt_class_orders_gt.processing_order
2946: FROM xla_acct_prog_events_gt ,
2947: xla_events ,
2948: xla_event_types_b ,
2949: xla_transaction_entities,
2950: xla_evt_class_orders_gt
2951: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
2947: xla_events ,
2948: xla_event_types_b ,
2949: xla_transaction_entities,
2950: xla_evt_class_orders_gt
2951: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
2952: AND xla_events.application_id = p_application_id
2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2948: xla_event_types_b ,
2949: xla_transaction_entities,
2950: xla_evt_class_orders_gt
2951: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
2952: AND xla_events.application_id = p_application_id
2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2950: xla_evt_class_orders_gt
2951: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
2952: AND xla_events.application_id = p_application_id
2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code
2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code
2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
2959: ORDER BY xla_evt_class_orders_gt.processing_order ASC)
2960: LOOP
2961:
3267:
3268:
3269: INSERT INTO xla_acct_prog_events_gt (event_id, ledger_id)
3270: SELECT xe.event_id, xte.ledger_id
3271: FROM xla_events xe
3272: , xla_transaction_entities xte
3273: WHERE xte.application_id = p_application_id
3274: AND xte.entity_id = p_entity_id
3275: AND xe.application_id = p_application_id
3620: ----------------------------------------------------------------------------
3621: SELECT COUNT(1) INTO l_acct_batch_entries FROM DUAL
3622: WHERE EXISTS
3623: (SELECT 'Y'
3624: FROM xla_events
3625: WHERE application_id = g_application_id
3626: AND request_id = g_report_request_id
3627: AND process_status_code IN ('P')
3628: );
3848: -- Delete from xla_accounting_errors
3849: --
3850: DELETE FROM xla_accounting_errors
3851: WHERE event_id IN
3852: (SELECT event_id FROM xla_events_gt);
3853:
3854: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3855: trace
3856: (p_msg => 'Number of errors deleted = '||SQL%ROWCOUNT
3863: --
3864: DELETE FROM xla_distribution_links
3865: WHERE ae_header_id IN
3866: (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ xh.ae_header_id
3867: FROM xla_events_gt xe,
3868: xla_ae_headers xh
3869: WHERE xe.process_status_code in ('D','E','R','I')
3870: AND xh.application_id = xe.application_id
3871: AND xh.event_id = xe.event_id
3888: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
3889: FROM xla_ae_segment_values
3890: WHERE ae_header_id IN
3891: (SELECT xh.ae_header_id
3892: FROM xla_events_gt xe,
3893: xla_ae_headers xh
3894: WHERE xe.process_status_code in ('D','E','R', 'I')
3895: AND xh.application_id = xe.application_id
3896: AND xh.event_id = xe.event_id
3908: --
3909: DELETE FROM xla_ae_line_acs
3910: WHERE ae_header_id IN
3911: (SELECT aeh.ae_header_id
3912: FROM xla_events_gt evt
3913: ,xla_ae_headers aeh
3914: WHERE evt.process_status_code in ('D','E','R','I')
3915: AND aeh.application_id = evt.application_id
3916: AND aeh.event_id = evt.event_id);
3927: --
3928: DELETE FROM xla_ae_header_acs
3929: WHERE ae_header_id IN
3930: (SELECT aeh.ae_header_id
3931: FROM xla_events_gt evt
3932: ,xla_ae_headers aeh
3933: WHERE evt.process_status_code in ('D','E','R','I')
3934: AND aeh.application_id = evt.application_id
3935: AND aeh.event_id = evt.event_id);
3947: DELETE FROM xla_ae_lines
3948: WHERE application_id = g_application_id
3949: AND ae_header_id IN
3950: (SELECT xh.ae_header_id
3951: FROM xla_events_gt xe,
3952: xla_ae_headers xh
3953: WHERE xe.process_status_code in ('D','E','R','I')
3954: AND xh.application_id = xe.application_id
3955: AND xh.event_id = xe.event_id
3968: DELETE /*+ index(aeh, xla_ae_headers_n2) */
3969: FROM xla_ae_headers aeh
3970: WHERE application_id = g_application_id
3971: AND event_id IN (SELECT event_id
3972: FROM xla_events_gt
3973: WHERE process_status_code IN ('D','E','R','I'));
3974:
3975: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3976: trace
3994: IF ( nvl(fnd_profile.value('XLA_DIAGNOSTIC_MODE'),'N') = 'Y') THEN
3995:
3996: DELETE FROM xla_diag_sources
3997: WHERE event_id IN
3998: (SELECT event_id FROM xla_events_gt);
3999:
4000: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4001: trace
4002: (p_msg => 'Number of Extract sources rows deleted = '||SQL%ROWCOUNT
4005: END IF;
4006:
4007: DELETE FROM xla_diag_events
4008: WHERE event_id IN
4009: (SELECT event_id FROM xla_events_gt);
4010:
4011: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4012: trace
4013: (p_msg => 'Number of Extract events deleted = '||SQL%ROWCOUNT
4334: -- Retrieve Processing Unit Size at Event Class Level
4335: -------------------------------------------------------------------------------
4336: --bug6369888 changed cursor to merge into single query.
4337: l_cur_event_stmt :=
4338: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ MIN(nvl(xjc.processing_unit_size, :1))
4339: FROM xla_events evt,
4340: xla_transaction_entities ent,
4341: xla_event_types_b xet,
4342: xla_event_class_attrs eca,
4335: -------------------------------------------------------------------------------
4336: --bug6369888 changed cursor to merge into single query.
4337: l_cur_event_stmt :=
4338: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ MIN(nvl(xjc.processing_unit_size, :1))
4339: FROM xla_events evt,
4340: xla_transaction_entities ent,
4341: xla_event_types_b xet,
4342: xla_event_class_attrs eca,
4343: xla_evt_class_orders_gt xpo,
4366: AND xjc.event_class_code = xpo.event_class_code '
4367: ||g_security_condition;
4368:
4369: l_cur_entity_stmt :=
4370: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 reverted bug6369888
4371: DISTINCT evt.entity_id
4372: FROM xla_events evt
4373: ,xla_transaction_entities ent
4374: ,xla_event_types_b xet
4368:
4369: l_cur_entity_stmt :=
4370: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 reverted bug6369888
4371: DISTINCT evt.entity_id
4372: FROM xla_events evt
4373: ,xla_transaction_entities ent
4374: ,xla_event_types_b xet
4375: ,xla_event_class_attrs eca
4376: ,xla_evt_class_orders_gt xpo
6152: --- End of First Insert ----------------------------------------------------------------------------
6153:
6154: ----------------------------------------------------------------------------------------------------
6155: -- 4597150
6156: -- Second insert into xla_events_gt is for process order -1
6157: -- When all process orders are -1, events are inserted in
6158: -- the previous insert statement. In this case, l_class_anytime_order
6159: -- becomes null.
6160: ----------------------------------------------------------------------------------------------------
6192: CLOSE lock_events_cur;
6193:
6194: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6195: trace
6196: (p_msg => 'Number of events in XLA_EVENTS_GT = '||l_event_count
6197: ,p_level => C_LEVEL_STATEMENT
6198: ,p_module => l_log_module);
6199: END IF;
6200:
6882: -- 5054831 -----------------------------------
6883: l_array_event_dates t_array_date;
6884: CURSOR c_events IS
6885: SELECT distinct event_date
6886: FROM xla_events a
6887: ,xla_acct_prog_events_gt b
6888: WHERE a.application_id = g_application_id
6889: AND a.event_id = b.event_id
6890: AND a.process_status_code = 'U'
6911: ,p_event_ledger_id => g_ledger_id);
6912:
6913: -- 5054831 -----------------------------
6914: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6915: FOR i in (select a.* from xla_acct_prog_events_gt b, xla_events a WHERE a.application_id = g_application_id
6916: AND a.event_id = b.event_id
6917: AND a.process_status_code = 'U'
6918: AND a.event_status_code IN ('U',DECODE(g_accounting_mode,'F','N','U'))
6919: AND a.on_hold_flag = 'N'
6935: -- bug 7193986 start
6936: --
6937: -- Delete the events inserted from the previous run
6938: --
6939: DELETE FROM XLA_EVENTS_GT;
6940: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6941: trace
6942: (p_msg => '# rows deleted XLA_EVENTS_GT = '||SQL%ROWCOUNT
6943: ,p_level => C_LEVEL_PROCEDURE
6938: --
6939: DELETE FROM XLA_EVENTS_GT;
6940: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6941: trace
6942: (p_msg => '# rows deleted XLA_EVENTS_GT = '||SQL%ROWCOUNT
6943: ,p_level => C_LEVEL_PROCEDURE
6944: ,p_module => l_log_module);
6945: END IF;
6946: DELETE FROM XLA_AE_LINES_GT;
6966: END IF;
6967:
6968:
6969: --
6970: -- Insert into xla_events_gt for the entity in xla_acct_prog_events_gt
6971: -- for the p_application_id and p_ledger_id.
6972: --
6973: INSERT INTO xla_events_gt
6974: (entity_id
6969: --
6970: -- Insert into xla_events_gt for the entity in xla_acct_prog_events_gt
6971: -- for the p_application_id and p_ledger_id.
6972: --
6973: INSERT INTO xla_events_gt
6974: (entity_id
6975: ,application_id
6976: ,ledger_id
6977: ,legal_entity_id
7052: AND xev.on_hold_flag = 'N'
7053: AND xev.event_type_code not in ('FULL_MERGE', 'PARTIAL_MERGE')
7054: AND xap.ledger_id = g_ledger_id
7055: AND xap.event_id IN (
7056: SELECT xla_events.event_id
7057: FROM xla_acct_prog_events_gt ,
7058: xla_events ,
7059: xla_event_types_b ,
7060: xla_transaction_entities,
7054: AND xap.ledger_id = g_ledger_id
7055: AND xap.event_id IN (
7056: SELECT xla_events.event_id
7057: FROM xla_acct_prog_events_gt ,
7058: xla_events ,
7059: xla_event_types_b ,
7060: xla_transaction_entities,
7061: xla_evt_class_orders_gt
7062: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7058: xla_events ,
7059: xla_event_types_b ,
7060: xla_transaction_entities,
7061: xla_evt_class_orders_gt
7062: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7063: AND xla_events.application_id = g_application_id
7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7059: xla_event_types_b ,
7060: xla_transaction_entities,
7061: xla_evt_class_orders_gt
7062: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7063: AND xla_events.application_id = g_application_id
7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7061: xla_evt_class_orders_gt
7062: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7063: AND xla_events.application_id = g_application_id
7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7070: AND xla_evt_class_orders_gt.processing_order = l_processing_order
7071: )
7072: ORDER BY xev.entity_id, xev.event_number;
7073:
7074:
7075: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7076: trace
7077: (p_msg => '# rows inserted into xla_events_gt = '||SQL%ROWCOUNT
7078: ,p_level => C_LEVEL_PROCEDURE
7079: ,p_module => l_log_module);
7080: END IF;
7081:
7084:
7085:
7086: SELECT max(event_date)
7087: INTO l_max_event_date
7088: FROM xla_events_gt;
7089: --
7090: -- Call subledger extract API
7091: --
7092: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - executing extract hook');
7175: CURSOR c_headers IS
7176: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XAH) */
7177: xah.ae_header_id
7178: FROM xla_ae_headers xah
7179: , xla_events xe
7180: , xla_acct_prog_events_gt xap
7181: WHERE xah.application_id = xe.application_id
7182: AND xah.event_id = xe.event_id
7183: AND xah.accounting_entry_status_code <> 'F'
7198: ,p_level => C_LEVEL_PROCEDURE
7199: ,p_module => l_log_module);
7200: END IF;
7201:
7202: SELECT /*+ leading(xap,xe) use_nl(xe) index(xe,XLA_EVENTS_U1) */
7203: xe.event_id
7204: BULK COLLECT INTO l_array_event_id
7205: FROM xla_events xe
7206: , xla_acct_prog_events_gt xap
7201:
7202: SELECT /*+ leading(xap,xe) use_nl(xe) index(xe,XLA_EVENTS_U1) */
7203: xe.event_id
7204: BULK COLLECT INTO l_array_event_id
7205: FROM xla_events xe
7206: , xla_acct_prog_events_gt xap
7207: WHERE xe.application_id = g_application_id
7208: AND xe.process_status_code <> 'P'
7209: AND xe.event_id = xap.event_id;
7523: ,aeh.accounting_entry_type_code accounting_entry_type_code
7524: ,aeh.accounting_date gl_date
7525: ,aeh.completed_date completion_date
7526: FROM xla_ae_headers aeh
7527: ,xla_events_gt xeg
7528: ,xla_subledgers xsl
7529: WHERE aeh.application_id = xeg.application_id
7530: AND aeh.event_id = xeg.event_id
7531: AND xsl.application_id = xeg.application_id
7633: END IF;
7634: END IF;
7635:
7636: ----------------------------------------------------------------------------
7637: -- Following updates event status in xla_events.
7638: -- Statement updated to fix Bug # 3051978
7639: -- Statement updated to fix Bug # 4961401
7640: ----------------------------------------------------------------------------
7641: UPDATE (SELECT /*+ leading(tmp) index(evt, XLA_EVENTS_U1) use_nl(evt)*/ --4769388
7637: -- Following updates event status in xla_events.
7638: -- Statement updated to fix Bug # 3051978
7639: -- Statement updated to fix Bug # 4961401
7640: ----------------------------------------------------------------------------
7641: UPDATE (SELECT /*+ leading(tmp) index(evt, XLA_EVENTS_U1) use_nl(evt)*/ --4769388
7642: evt.event_status_code
7643: ,evt.process_status_code
7644: ,evt.last_update_date
7645: ,evt.last_updated_by
7653: WHEN tmp.process_status_code = 'P' THEN 'P'
7654: ELSE 'U' END new_event_status_code
7655: --,tmp.process_status_code new_process_status_code -- bug 4961401
7656: ,DECODE(evt.event_status_code,'N','P',tmp.process_status_code) new_process_status_code
7657: FROM xla_events evt
7658: ,xla_events_gt tmp
7659: WHERE evt.event_id = tmp.event_id
7660: AND evt.application_id = g_application_id
7661: )
7654: ELSE 'U' END new_event_status_code
7655: --,tmp.process_status_code new_process_status_code -- bug 4961401
7656: ,DECODE(evt.event_status_code,'N','P',tmp.process_status_code) new_process_status_code
7657: FROM xla_events evt
7658: ,xla_events_gt tmp
7659: WHERE evt.event_id = tmp.event_id
7660: AND evt.application_id = g_application_id
7661: )
7662: SET event_status_code = new_event_status_code