APPS.GMF_VIB dependencies on GMF_XLA_EXTRACT_HEADERS

Line 2616: SELECT count(*) FROM gmf_xla_extract_headers

2612: v.consume_layer_id IS NOT NULL;
2613:
2614: -- Bug 11839588
2615: CURSOR check_posted_close_events IS
2616: SELECT count(*) FROM gmf_xla_extract_headers
2617: WHERE entity_code = 'PRODUCTION'
2618: AND event_class_code = 'BATCH_CLOSE'
2619: AND transaction_id = p_batch_id
2620: AND accounted_flag IS NULL;

Line 2623: SELECT event_id, ledger_id FROM gmf_xla_extract_headers

2619: AND transaction_id = p_batch_id
2620: AND accounted_flag IS NULL;
2621: -- Bug 11839588 12982011 13099547 get ledger_id as well.
2622: CURSOR check_batch_close_events IS
2623: SELECT event_id, ledger_id FROM gmf_xla_extract_headers
2624: WHERE entity_code = 'PRODUCTION'
2625: AND event_class_code = 'BATCH_CLOSE'
2626: AND transaction_id = p_batch_id;
2627:

Line 2726: WHERE Header_id = (SELECT header_id FROM gmf_xla_extract_headers

2722: p_message => ' Deleting event and extract data for Batch Close Event '||l_event.event_id,
2723: p_error_type => 'E');
2724:
2725: DELETE FROM gmf_xla_extract_lines
2726: WHERE Header_id = (SELECT header_id FROM gmf_xla_extract_headers
2727: WHERE entity_code = 'PRODUCTION'
2728: AND event_class_code = 'BATCH_CLOSE'
2729: AND transaction_id = p_batch_id
2730: AND event_id = l_event.event_id);

Line 2736: DELETE FROM gmf_xla_extract_headers

2732: IF g_debug <= gme_debug.g_log_statement THEN
2733: gme_debug.put_line ('deleting batch close events extract header ');
2734: END IF;
2735:
2736: DELETE FROM gmf_xla_extract_headers
2737: WHERE entity_code = 'PRODUCTION'
2738: AND event_class_code = 'BATCH_CLOSE'
2739: AND transaction_id = p_batch_id
2740: AND event_id = l_event.event_id;