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.FV_UTILITY dependencies on XLA_EVENTS

Line 977: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%rowtype

973: ) IS
974:
975: l_module VARCHAR2(200) := g_module_name||'delete_fv_bc_orphan.';
976: l_event_count NUMBER;
977: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%rowtype
978: INDEX BY BINARY_INTEGER;
979: l_events_Tab Event_tab_type;
980:
981: CURSOR c_get_unprocessed_fv_events IS

Line 995: FROM xla_events xla,

991: xte.source_id_int_2,
992: xte.source_id_int_3,
993: xte.source_id_int_4,
994: xte.source_id_char_1
995: FROM xla_events xla,
996: xla_transaction_entities xte
997: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
998: AND xla.application_id = 8901
999: AND xla.event_date BETWEEN p_start_date AND p_end_date

Line 1015: DELETE FROM XLA_EVENTS_INT_GT;

1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);
1012:
1013: xla_security_pkg.set_security_context(8901);
1014:
1015: DELETE FROM XLA_EVENTS_INT_GT;
1016: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,
1017: '# of rows deleted from xla_events_int_gt: '|| SQL%ROWCOUNT );
1018: fnd_file.put_line(fnd_file.log,
1019: '-------------------------------------------------------');

Line 1017: '# of rows deleted from xla_events_int_gt: '|| SQL%ROWCOUNT );

1013: xla_security_pkg.set_security_context(8901);
1014:
1015: DELETE FROM XLA_EVENTS_INT_GT;
1016: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,
1017: '# of rows deleted from xla_events_int_gt: '|| SQL%ROWCOUNT );
1018: fnd_file.put_line(fnd_file.log,
1019: '-------------------------------------------------------');
1020: fnd_file.put_line(fnd_file.log,'Deleting Federal events, if any.');
1021: l_event_count := 0;

Line 1040: INSERT INTO XLA_EVENTS_INT_GT

1036: END LOOP;
1037:
1038: IF l_event_count > 0 THEN
1039: FORALL i IN 1..l_event_count
1040: INSERT INTO XLA_EVENTS_INT_GT
1041: VALUES l_events_tab(i) ;
1042: fnd_file.put_line(fnd_file.log,' # of rows inserted into xla_events_int_gt table: ' || l_event_count);
1043: fnd_file.put_line(fnd_file.log,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
1044:

Line 1042: fnd_file.put_line(fnd_file.log,' # of rows inserted into xla_events_int_gt table: ' || l_event_count);

1038: IF l_event_count > 0 THEN
1039: FORALL i IN 1..l_event_count
1040: INSERT INTO XLA_EVENTS_INT_GT
1041: VALUES l_events_tab(i) ;
1042: fnd_file.put_line(fnd_file.log,' # of rows inserted into xla_events_int_gt table: ' || l_event_count);
1043: fnd_file.put_line(fnd_file.log,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
1044:
1045: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 8901);
1046:

Line 1043: fnd_file.put_line(fnd_file.log,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');

1039: FORALL i IN 1..l_event_count
1040: INSERT INTO XLA_EVENTS_INT_GT
1041: VALUES l_events_tab(i) ;
1042: fnd_file.put_line(fnd_file.log,' # of rows inserted into xla_events_int_gt table: ' || l_event_count);
1043: fnd_file.put_line(fnd_file.log,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
1044:
1045: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 8901);
1046:
1047: fnd_file.put_line(fnd_file.log,'After Deletion of Federal Unprocessed Events');

Line 1045: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 8901);

1041: VALUES l_events_tab(i) ;
1042: fnd_file.put_line(fnd_file.log,' # of rows inserted into xla_events_int_gt table: ' || l_event_count);
1043: fnd_file.put_line(fnd_file.log,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
1044:
1045: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 8901);
1046:
1047: fnd_file.put_line(fnd_file.log,'After Deletion of Federal Unprocessed Events');
1048: fnd_file.put_line(fnd_file.log,'The following Federal BC unprocessed/Error events have been deleted');
1049: fnd_file.put_line(fnd_file.log ,'Event ID Event Status Code Process Status Code');

Line 1117: DELETE FROM XLA_EVENTS_GT;

1113: DELETE FROM XLA_BAL_STATUSES_GT;
1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1117: DELETE FROM XLA_EVENTS_GT;
1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1119: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;

Line 1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1117: DELETE FROM XLA_EVENTS_GT;
1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1119: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1145: DELETE FROM XLA_EVENTS_INT_GT;

1141: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1143: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);
1147: DELETE FROM XLA_REPORT_BALANCES_GT;
1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1149: DELETE FROM XLA_TB_BALANCES_GT;

Line 1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);

1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1143: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);
1147: DELETE FROM XLA_REPORT_BALANCES_GT;
1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1149: DELETE FROM XLA_TB_BALANCES_GT;
1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);