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_ACCT_PROG_EVENTS_GT

Line 2604: FROM xla_acct_prog_events_gt xpa

2600: IS
2601: -- Retrieve any ledgers that does not enable budgetary control
2602: CURSOR c_invalid_bc_ledgers IS
2603: SELECT gl.ledger_id, gl.name ledger_name
2604: FROM xla_acct_prog_events_gt xpa
2605: , gl_ledgers gl
2606: WHERE xpa.ledger_id = gl.ledger_id
2607: AND enable_budgetary_control_flag = 'N'
2608: AND ROWNUM = 1;

Line 2616: FROM xla_acct_prog_events_gt xap

2612: CURSOR c_invalid_ledger_id IS
2613: SELECT xgl.ledger_id
2614: , xgl.name ledger_name
2615: , xam.name slam_name
2616: FROM xla_acct_prog_events_gt xap
2617: , xla_gl_ledgers_v xgl
2618: , xla_acctg_methods_tl xam
2619: , xla_acctg_method_rules xar
2620: , xla_aad_line_defn_assgns xal

Line 2651: , xla_acct_prog_events_gt xap

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
2655: AND xe.event_id = xap.event_id

Line 2660: FROM xla_acct_prog_events_gt xap

2656: FOR UPDATE NOWAIT;
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:

Line 2668: FROM xla_acct_prog_events_gt;

2664:
2665: -- Retrieve list of ledgers to be processed
2666: CURSOR c_ledgers IS
2667: SELECT DISTINCT ledger_id
2668: FROM xla_acct_prog_events_gt;
2669:
2670: i INTEGER;
2671: l_request_id INTEGER;
2672: l_array_event_id t_array_integer;

Line 2844: -- xla_acct_prog_events_gt

2840: END IF;
2841:
2842: --
2843: -- Lock all entity and events in xla_entity_events_v that exists in the
2844: -- xla_acct_prog_events_gt
2845: --
2846: OPEN c_lock_entity_events;
2847: FETCH c_lock_entity_events BULK COLLECT INTO l_array_event_id;
2848: CLOSE c_lock_entity_events;

Line 2946: FROM xla_acct_prog_events_gt ,

2942: -- 7193986 start
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

Line 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

Line 3269: INSERT INTO xla_acct_prog_events_gt (event_id, ledger_id)

3265: -- this procedure is called directly to perform GL xfer
3266: xla_security_pkg.set_security_context(p_application_id);
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

Line 3290: (p_msg => 'Rows inserted into xla_acct_prog_events_gt = '||SQL%ROWCOUNT

3286:
3287:
3288: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3289: trace
3290: (p_msg => 'Rows inserted into xla_acct_prog_events_gt = '||SQL%ROWCOUNT
3291: ,p_level => C_LEVEL_STATEMENT
3292: ,p_module => l_log_module);
3293: END IF;
3294:

Line 6887: ,xla_acct_prog_events_gt b

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'
6891: AND a.event_status_code IN ('U',DECODE(g_accounting_mode,'F','N','U'))

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

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'

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

Line 7047: , xla_acct_prog_events_gt xap

7043: ,xev.reference_date_2
7044: ,xev.reference_date_3
7045: ,xev.reference_date_4
7046: FROM xla_entity_events_v xev
7047: , xla_acct_prog_events_gt xap
7048: WHERE xev.application_id = g_application_id
7049: AND xev.event_id = xap.event_id
7050: AND xev.process_status_code = 'U'
7051: AND xev.event_status_code IN ('U',DECODE(g_accounting_mode,'F','N','U'))

Line 7057: FROM xla_acct_prog_events_gt ,

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,
7061: xla_evt_class_orders_gt

Line 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

Line 7180: , xla_acct_prog_events_gt xap

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'
7184: AND xe.application_id = g_application_id

Line 7206: , xla_acct_prog_events_gt xap

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