eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_EVENTS

Line 29: | based ON xla_events. |

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 |

Line 90: | XLA_EVENTS_GT TABLE. |

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. |

Line 92: | XLA_EVENTS_GT TABLE. |

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 |

Line 101: | XLA_EVENTS_GT TABLE. |

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 |

Line 103: | - Modified INSERT INTO XLA_EVENTS_GT. |

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 |

Line 126: | STATEMENT so that INDEX XLA_EVENTS_U1 |

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. |

Line 172: | 01/04/2005 S. Singhania Bug 4364612. WHILE loading xla_events_gt, |

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 |

Line 177: | 01/06/2005 W. Shen Modify insert into xla_events_gt to insert|

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 |

Line 268: FROM xla_events evt

264: C_LOCK_EVENTS_STR CONSTANT VARCHAR2(32000) :=
265: '
266: SELECT /*+ leading(tab,evt) use_nl(evt) */
267: evt.event_id
268: FROM xla_events evt
269: ,xla_event_types_b xet
270: ,TABLE(CAST(:1 AS xla_array_number_type)) tab
271: WHERE evt.application_id = :2
272: AND evt.event_date <= :3

Line 286: INSERT INTO xla_events_gt

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

Line 360: FROM xla_events evt

356: ,evt.reference_date_1
357: ,evt.reference_date_2
358: ,evt.reference_date_3
359: ,evt.reference_date_4
360: FROM xla_events evt
361: ,xla_transaction_entities ent
362: ,xla_event_types_b xet
363: ,xla_event_class_attrs eca
364: WHERE evt.application_id = :1

Line 388: INSERT INTO xla_events_gt

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

Line 462: FROM xla_events evt

458: ,evt.reference_date_1
459: ,evt.reference_date_2
460: ,evt.reference_date_3
461: ,evt.reference_date_4
462: FROM xla_events evt
463: ,xla_transaction_entities ent
464: ,xla_event_types_b xet
465: ,xla_event_class_attrs eca
466: WHERE evt.application_id = :1

Line 484: FROM xla_events evt2

480: AND evt.event_status_code IN
481: (''U'', DECODE(:4, ''F'',''N'',''U''))
482: AND evt.event_number <
483: (SELECT NVL(MIN(evt2.event_number), evt.event_number + 1)
484: FROM xla_events evt2
485: ,xla_transaction_entities_upg ent2
486: ,xla_event_types_b xet2
487: ,xla_event_class_attrs eca2
488: WHERE evt2.application_id = evt.application_id

Line 1432: (SELECT 1 FROM xla_events xe, xla_ae_headers xah WHERE

1428: -- Set retcode as warning when ever CmboEdit returns Invalid CCID's -- 7502532
1429: IF ( nvl(fnd_profile.value('XLA_FSAH_EXT_CCID_VAL'),'N') = 'Y') THEN
1430: BEGIN
1431: SELECT 1 INTO l_code FROM dual WHERE EXISTS
1432: (SELECT 1 FROM xla_events xe, xla_ae_headers xah WHERE
1433: xe.application_id= p_application_id AND
1434: xe.application_id=xah.application_id AND
1435: xe.process_status_code in ('I','R') AND
1436: xe.event_status_code ='U' AND

Line 2870: , xla_events xe

2866: CURSOR c_lock_entity_events IS
2867: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XTE) */
2868: xe.event_id
2869: FROM xla_transaction_entities xte
2870: , xla_events xe
2871: , xla_acct_prog_events_gt xap
2872: WHERE xte.application_id = xe.application_id
2873: AND xte.entity_id = xe.entity_id
2874: AND xe.application_id = p_application_id

Line 2881: , xla_events xe

2877:
2878: CURSOR c_entities IS
2879: SELECT distinct entity_id
2880: FROM xla_acct_prog_events_gt xap
2881: , xla_events xe
2882: WHERE xe.application_id = p_application_id
2883: AND xe.event_id = xap.event_id;
2884:
2885: -- Retrieve list of ledgers to be processed

Line 2895: l_event_source_info xla_events_pub_pkg.t_event_source_info;

2891: l_request_id INTEGER;
2892: l_array_event_id t_array_integer;
2893: l_ret_flag_bal_update BOOLEAN;
2894: l_transfer_mode VARCHAR2(30);
2895: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2896:
2897: l_log_module VARCHAR2(240);
2898: BEGIN
2899: IF g_log_enabled THEN

Line 3129: UPDATE xla_events xe

3125: IF (g_accounting_mode IN ('D','F')) THEN
3126: delete_batch_je;
3127:
3128: FORALL i IN 1..l_array_event_id.COUNT
3129: UPDATE xla_events xe
3130: SET process_status_code = 'U'
3131: WHERE xe.on_hold_flag = 'N'
3132: AND xe.process_status_code <> 'P'
3133: AND xe.event_type_code not in ('FULL_MERGE', 'PARTIAL_MERGE')

Line 3169: xla_events ,

3165:
3166: FOR x IN (
3167: SELECT DISTINCT xla_evt_class_orders_gt.processing_order
3168: FROM xla_acct_prog_events_gt ,
3169: xla_events ,
3170: xla_event_types_b ,
3171: xla_transaction_entities,
3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id

Line 3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id

3169: xla_events ,
3170: xla_event_types_b ,
3171: xla_transaction_entities,
3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id

Line 3174: AND xla_events.application_id = p_application_id

3170: xla_event_types_b ,
3171: xla_transaction_entities,
3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code

Line 3176: AND xla_events.entity_id = xla_transaction_entities.entity_id

3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code
3180: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

Line 3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code

3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code
3180: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
3181: AND xla_events.process_status_code <> 'P' --condition added, bug8680284
3182: ORDER BY xla_evt_class_orders_gt.processing_order ASC)
3183: LOOP

Line 3181: AND xla_events.process_status_code <> 'P' --condition added, bug8680284

3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code
3180: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
3181: AND xla_events.process_status_code <> 'P' --condition added, bug8680284
3182: ORDER BY xla_evt_class_orders_gt.processing_order ASC)
3183: LOOP
3184:
3185: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3508: FROM xla_events xe

3504:
3505:
3506: INSERT INTO xla_acct_prog_events_gt (event_id, ledger_id)
3507: SELECT xe.event_id, xte.ledger_id
3508: FROM xla_events xe
3509: , xla_transaction_entities xte
3510: WHERE xte.application_id = p_application_id
3511: AND xte.entity_id = p_entity_id
3512: AND xe.application_id = p_application_id

Line 3863: FROM xla_events

3859: ----------------------------------------------------------------------------
3860: SELECT COUNT(1) INTO l_acct_batch_entries FROM DUAL
3861: WHERE EXISTS
3862: (SELECT 'Y'
3863: FROM xla_events
3864: WHERE application_id = g_application_id
3865: AND request_id = g_report_request_id
3866: AND process_status_code IN ('P')
3867: );

Line 4120: (SELECT event_id FROM xla_events_gt);

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

Line 4135: FROM xla_events_gt xe,

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

Line 4160: FROM xla_events_gt xe,

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

Line 4182: FROM xla_events_gt evt

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);

Line 4201: FROM xla_events_gt evt

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);

Line 4221: FROM xla_events_gt xe,

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

Line 4242: FROM xla_events_gt

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

Line 4268: (SELECT event_id FROM xla_events_gt);

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

Line 4279: (SELECT event_id FROM xla_events_gt);

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

Line 4608: 'SELECT /+ index(evt,XLA_EVENTS_N3) / MIN(nvl(xjc.processing_unit_size, :1))

4604: -- Retrieve Processing Unit Size at Event Class Level
4605: -------------------------------------------------------------------------------
4606: --bug6369888 changed cursor to merge into single query.
4607: l_cur_event_stmt :=
4608: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ MIN(nvl(xjc.processing_unit_size, :1))
4609: FROM xla_events evt,
4610: xla_transaction_entities ent,
4611: xla_event_types_b xet,
4612: xla_event_class_attrs eca,

Line 4609: FROM xla_events evt,

4605: -------------------------------------------------------------------------------
4606: --bug6369888 changed cursor to merge into single query.
4607: l_cur_event_stmt :=
4608: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ MIN(nvl(xjc.processing_unit_size, :1))
4609: FROM xla_events evt,
4610: xla_transaction_entities ent,
4611: xla_event_types_b xet,
4612: xla_event_class_attrs eca,
4613: xla_evt_class_orders_gt xpo,

Line 4640: 'SELECT /+ leading(evt) use_nl(ent) index(evt,XLA_EVENTS_N3) / -- Bug 5529420 reverted bug6369888 modified hint bug9192859

4636: AND xjc.event_class_code = xpo.event_class_code '
4637: ||g_security_condition;
4638:
4639: l_cur_entity_stmt :=
4640: 'SELECT /*+ leading(evt) use_nl(ent) index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 reverted bug6369888 modified hint bug9192859
4641: DISTINCT evt.entity_id
4642: FROM xla_events evt
4643: ,xla_transaction_entities ent
4644: ,xla_event_types_b xet

Line 4642: FROM xla_events evt

4638:
4639: l_cur_entity_stmt :=
4640: 'SELECT /*+ leading(evt) use_nl(ent) index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 reverted bug6369888 modified hint bug9192859
4641: DISTINCT evt.entity_id
4642: FROM xla_events evt
4643: ,xla_transaction_entities ent
4644: ,xla_event_types_b xet
4645: ,xla_event_class_attrs eca
4646: ,xla_evt_class_orders_gt xpo

Line 6534: -- Second insert into xla_events_gt is for process order -1

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: ----------------------------------------------------------------------------------------------------

Line 6574: (p_msg => 'Number of events in XLA_EVENTS_GT = '||l_event_count

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:

Line 7264: FROM xla_events a

7260: -- 5054831 -----------------------------------
7261: l_array_event_dates t_array_date;
7262: CURSOR c_events IS
7263: SELECT distinct event_date
7264: FROM xla_events a
7265: ,xla_acct_prog_events_gt b
7266: WHERE a.application_id = g_application_id
7267: AND a.event_id = b.event_id
7268: AND a.process_status_code = 'U'

Line 7293: FOR i in (select a.* from xla_acct_prog_events_gt b, xla_events a WHERE a.application_id = g_application_id

7289: ,p_event_ledger_id => g_ledger_id);
7290:
7291: -- 5054831 -----------------------------
7292: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7293: FOR i in (select a.* from xla_acct_prog_events_gt b, xla_events a WHERE a.application_id = g_application_id
7294: AND a.event_id = b.event_id
7295: AND a.process_status_code = 'U'
7296: AND a.event_status_code IN ('U',DECODE(g_accounting_mode,'F','N','U'))
7297: AND a.on_hold_flag = 'N'

Line 7317: DELETE FROM XLA_EVENTS_GT;

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

Line 7320: (p_msg => '# rows deleted XLA_EVENTS_GT = '||SQL%ROWCOUNT

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;

Line 7348: -- Insert into xla_events_gt for the entity in xla_acct_prog_events_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

Line 7351: INSERT INTO xla_events_gt

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

Line 7434: SELECT xla_events.event_id

7430: AND xev.on_hold_flag = 'N'
7431: AND xev.event_type_code not in ('FULL_MERGE', 'PARTIAL_MERGE')
7432: AND xap.ledger_id = g_ledger_id
7433: AND xap.event_id IN (
7434: SELECT xla_events.event_id
7435: FROM xla_acct_prog_events_gt ,
7436: xla_events ,
7437: xla_event_types_b ,
7438: xla_transaction_entities,

Line 7436: xla_events ,

7432: AND xap.ledger_id = g_ledger_id
7433: AND xap.event_id IN (
7434: SELECT xla_events.event_id
7435: FROM xla_acct_prog_events_gt ,
7436: xla_events ,
7437: xla_event_types_b ,
7438: xla_transaction_entities,
7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id

Line 7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id

7436: xla_events ,
7437: xla_event_types_b ,
7438: xla_transaction_entities,
7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id

Line 7441: AND xla_events.application_id = g_application_id

7437: xla_event_types_b ,
7438: xla_transaction_entities,
7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code

Line 7443: AND xla_events.entity_id = xla_transaction_entities.entity_id

7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7447: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

Line 7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code

7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7447: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7448: AND xla_events.process_status_code <> 'P' --condition added, bug8680284
7449: AND xla_evt_class_orders_gt.processing_order = l_processing_order
7450: )

Line 7448: AND xla_events.process_status_code <> 'P' --condition added, bug8680284

7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7447: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7448: AND xla_events.process_status_code <> 'P' --condition added, bug8680284
7449: AND xla_evt_class_orders_gt.processing_order = l_processing_order
7450: )
7451: ORDER BY xev.entity_id, xev.event_number;
7452:

Line 7456: (p_msg => '# rows inserted into xla_events_gt = '||SQL%ROWCOUNT

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:

Line 7467: FROM xla_events_gt;

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');

Line 7558: , xla_events xe

7554: CURSOR c_headers IS
7555: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XAH) */
7556: xah.ae_header_id
7557: FROM xla_ae_headers xah
7558: , xla_events xe
7559: , xla_acct_prog_events_gt xap
7560: WHERE xah.application_id = xe.application_id
7561: AND xah.event_id = xe.event_id
7562: AND xah.accounting_entry_status_code <> 'F'

Line 7581: SELECT /+ leading(xap,xe) use_nl(xe) index(xe,XLA_EVENTS_U1) /

7577: ,p_level => C_LEVEL_PROCEDURE
7578: ,p_module => l_log_module);
7579: END IF;
7580:
7581: SELECT /*+ leading(xap,xe) use_nl(xe) index(xe,XLA_EVENTS_U1) */
7582: xe.event_id
7583: BULK COLLECT INTO l_array_event_id
7584: FROM xla_events xe
7585: , xla_acct_prog_events_gt xap

Line 7584: FROM xla_events xe

7580:
7581: SELECT /*+ leading(xap,xe) use_nl(xe) index(xe,XLA_EVENTS_U1) */
7582: xe.event_id
7583: BULK COLLECT INTO l_array_event_id
7584: FROM xla_events xe
7585: , xla_acct_prog_events_gt xap
7586: WHERE xe.application_id = g_application_id
7587: AND xe.process_status_code <> 'P'
7588: AND xe.event_id = xap.event_id;

Line 7906: ,xla_events_gt xeg

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

Line 8016: -- Following updates event status in xla_events.

8012: END IF;
8013: END IF;
8014:
8015: ----------------------------------------------------------------------------
8016: -- Following updates event status in xla_events.
8017: -- Statement updated to fix Bug # 3051978
8018: -- Statement updated to fix Bug # 4961401
8019: ----------------------------------------------------------------------------
8020: UPDATE (SELECT /*+ leading(tmp) index(evt, XLA_EVENTS_U1) use_nl(evt)*/ --4769388

Line 8020: UPDATE (SELECT /+ leading(tmp) index(evt, XLA_EVENTS_U1) use_nl(evt)/ --4769388

8016: -- Following updates event status in xla_events.
8017: -- Statement updated to fix Bug # 3051978
8018: -- Statement updated to fix Bug # 4961401
8019: ----------------------------------------------------------------------------
8020: UPDATE (SELECT /*+ leading(tmp) index(evt, XLA_EVENTS_U1) use_nl(evt)*/ --4769388
8021: evt.event_status_code
8022: ,evt.process_status_code
8023: ,evt.last_update_date
8024: ,evt.last_updated_by

Line 8038: FROM xla_events evt

8034: ELSE 'U' END new_event_status_code
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: )

Line 8039: ,xla_events_gt tmp

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

Line 8063: UPDATE xla_events xe

8059: -- Start of 12411043
8060: /*
8061: -- Start of 8411568
8062:
8063: UPDATE xla_events xe
8064: SET xe.event_status_code = 'P'
8065: ,xe.process_status_code = 'P'
8066: ,xe.last_update_date = sysdate
8067: ,xe.last_updated_by = xla_environment_pkg.g_usr_id

Line 8080: ,xla_events_gt xle

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