DBA Data[Home] [Help]

APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_ENIGMA_OP_INTERFACE

Line 163: FROM AHL_ENIGMA_OP_INTERFACE OP

159: OP.CONFIG_LETTER,
160: OP.PUBLISH_DATE,
161: OP.CONTEXT,
162: OP.DESCRIPTION
163: FROM AHL_ENIGMA_OP_INTERFACE OP
164: WHERE ISRECOVERABLE = 'Y';
165:
166: -- Declare local variables
167: l_api_name CONSTANT VARCHAR2(30) := 'Process_Route_Operations';

Line 265: DELETE FROM AHL_ENIGMA_OP_INTERFACE

261: );
262: END LOOP;
263: CLOSE get_op_data;
264:
265: DELETE FROM AHL_ENIGMA_OP_INTERFACE
266: WHERE ISRECOVERABLE = 'Y'
267: AND PROCESS_DATE <= timebefore;
268:
269: SELECT sysdate INTO timebefore from dual;

Line 1643: INSERT INTO AHL_ENIGMA_OP_INTERFACE

1639: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into op interface table');
1640: -- fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);
1641: -- END IF;
1642:
1643: INSERT INTO AHL_ENIGMA_OP_INTERFACE
1644: (
1645: ENIGMA_OP_ID,
1646: ATA_CODE,
1647: ENIGMA_DOC_ID,