DBA Data[Home] [Help]

APPS.GMF_ALLOC_PROC dependencies on XLA_EVENTS_INT_GT

Line 371: INSERT INTO xla_events_int_gt

367: FOR l_event IN events_To_Delete LOOP
368:
369: l_event_count := l_event_count + 1;
370:
371: INSERT INTO xla_events_int_gt
372: (entity_id
373: ,application_id
374: ,ledger_id
375: ,entity_code

Line 408: AND event_id IN (select event_id from xla_events_int_gt)

404: WHERE Header_id IN (SELECT header_id FROM gmf_xla_extract_headers
405: WHERE entity_code = 'REVALUATION'
406: AND event_class_code = 'GLCOSTALOC'
407: AND accounted_flag IS NOT NULL
408: AND event_id IN (select event_id from xla_events_int_gt)
409: );
410:
411: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from gmf_xla_extract_lines. ' );
412:

Line 421: AND event_id IN (select event_id from xla_events_int_gt);

417: DELETE FROM gmf_xla_extract_headers
418: WHERE entity_code = 'REVALUATION'
419: AND event_class_code = 'GLCOSTALOC'
420: AND accounted_flag IS NOT NULL
421: AND event_id IN (select event_id from xla_events_int_gt);
422:
423: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from gmf_xla_extract_lines. ' );
424:
425: IF (l_event_count >= 1) THEN

Line 428: delete from xla_events_int_gt ;

424:
425: IF (l_event_count >= 1) THEN
426: alloc_log_msg( C_LOG_FILE, ' Calling xla_events_pkg.delete_bulk_events api to delete '|| l_event_count ||' invalid events.');
427: xla_events_pkg.delete_bulk_events( p_application_id => 555);
428: delete from xla_events_int_gt ;
429: END IF;
430: -- End Bug 12561766
431:
432: DELETE FROM