DBA Data[Home] [Help]

APPS.GMF_ALLOC_PROC dependencies on GMF_XLA_EXTRACT_LINES

Line 403: DELETE FROM gmf_xla_extract_lines

399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module, 'Deleting Expense Allocation Events Extract Lines ');
401: END IF;
402:
403: DELETE FROM gmf_xla_extract_lines
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

Line 411: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from gmf_xla_extract_lines. ' );

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:
413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module, 'Deleting Expense Allocation Events Extract Headers ');
415: END IF;

Line 423: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from gmf_xla_extract_lines. ' );

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