DBA Data[Home] [Help]

APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_CAT_PARSE_ERRORS

Line 2928: -- icx_por_failed_lines, icx_por_contract_references, icx_cat_parse_errors)

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;
2932: l_number_of_days NUMBER;

Line 3023: DELETE FROM icx_cat_parse_errors

3019:
3020: l_err_loc := 260;
3021:
3022: FORALL i IN 1..l_job_number_tbl.COUNT
3023: DELETE FROM icx_cat_parse_errors
3024: WHERE request_id = l_job_number_tbl(i);
3025:
3026: l_err_loc := 270;
3027: