APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_ENIGMA_RT_INTERFACE

Line 142: FROM AHL_ENIGMA_RT_INTERFACE RT

138: RT.REVISION_DATE,
139: RT.CONTEXT,
140: RT.PUBLISH_DATE,
141: RT.DESCRIPTION
142: FROM AHL_ENIGMA_RT_INTERFACE RT
143: WHERE ISRECOVERABLE = 'Y';
144:
145: -- This cursor is used to fetch the details of the operartion that exists in the staging table
146: -- with isrecoverable = 'Y'

Line 300: DELETE FROM AHL_ENIGMA_RT_INTERFACE

296: );
297: END LOOP;
298: CLOSE get_route_data;
299:
300: DELETE FROM AHL_ENIGMA_RT_INTERFACE
301: WHERE ISRECOVERABLE = 'Y'
302: AND PROCESS_DATE <= timebefore;
303:
304:

Line 661: INSERT INTO AHL_ENIGMA_RT_INTERFACE

657: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into interface table');
658: fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);
659: END IF;
660:
661: INSERT INTO AHL_ENIGMA_RT_INTERFACE
662: (
663: CONTEXT,
664: PUBLISH_DATE,
665: ENIGMA_ROUTE_ID,