APPS.ICX_POR_TRACK_VALIDATE_JOB_S dependencies on ICX_POR_FAILED_LINE_MESSAGES

Line 188: DELETE FROM ICX_POR_FAILED_LINE_MESSAGES WHERE JOB_NUMBER = p_jobno;

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:
192: EXCEPTION