APPS.ICX_POR_TRACK_VALIDATE_JOB_S dependencies on ICX_POR_FAILED_LINES
Line 187: DELETE FROM ICX_POR_FAILED_LINES WHERE JOB_NUMBER = p_jobno;
183:
184: FUNCTION delete_job(p_jobno in number) return varchar2 is
185: BEGIN
186: DELETE FROM ICX_POR_BATCH_JOBS WHERE JOB_NUMBER = p_jobno; 187: DELETE FROM ICX_POR_FAILED_LINES WHERE JOB_NUMBER = p_jobno; 188: DELETE FROM ICX_POR_FAILED_LINE_MESSAGES WHERE JOB_NUMBER = p_jobno;
189: COMMIT;
190: return 'Y';
191: