DBA Data[Home] [Help]

APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_POR_BATCH_JOBS

Line 2927: -- (icx_por_batch_jobs, icx_cat_batch_jobs, icx_por_failed_line_messages,

2923: END validate_descriptor;
2924:
2925:
2926: -- procedure to delete old jobs from the tables
2927: -- (icx_por_batch_jobs, icx_cat_batch_jobs, icx_por_failed_line_messages,
2928: -- icx_por_failed_lines, icx_por_contract_references, icx_cat_parse_errors)
2929: PROCEDURE purge_loader_tables
2930: IS
2931: l_err_loc PLS_INTEGER;

Line 2951: DELETE FROM icx_por_batch_jobs

2947: WHILE l_continue LOOP
2948:
2949: l_err_loc := 120;
2950:
2951: DELETE FROM icx_por_batch_jobs
2952: WHERE submission_datetime <= (sysdate - l_number_of_days)
2953: AND rownum <= l_commit_size
2954: RETURNING job_number BULK COLLECT INTO l_job_number_tbl;
2955: