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_GT

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 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 277: INSERT INTO xla_events_gt

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

Line 377: INSERT INTO xla_events_gt

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

Line 3852: (SELECT event_id FROM xla_events_gt);

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

Line 3867: FROM xla_events_gt xe,

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

Line 3892: FROM xla_events_gt xe,

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

Line 3912: FROM xla_events_gt evt

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

Line 3931: FROM xla_events_gt evt

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

Line 3951: FROM xla_events_gt xe,

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

Line 3972: FROM xla_events_gt

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

Line 3998: (SELECT event_id FROM xla_events_gt);

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

Line 4009: (SELECT event_id FROM xla_events_gt);

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

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

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

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

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:

Line 6939: DELETE FROM XLA_EVENTS_GT;

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

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

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;

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 6973: INSERT INTO xla_events_gt

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

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

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:

Line 7088: FROM xla_events_gt;

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

Line 7527: ,xla_events_gt xeg

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

Line 7658: ,xla_events_gt tmp

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