APPS.FV_UTILITY dependencies on XLA_EVENTS_INT_GT

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