APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_CAT_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 2996: DELETE FROM icx_cat_batch_jobs

2992: WHILE l_continue LOOP
2993:
2994: l_err_loc := 210;
2995:
2996: DELETE FROM icx_cat_batch_jobs
2997: WHERE submission_datetime <= (sysdate - l_number_of_days)
2998: AND rownum <= l_commit_size
2999: RETURNING job_number BULK COLLECT INTO l_job_number_tbl;
3000:

Line 3310: UPDATE icx_cat_batch_jobs

3306: BEGIN
3307:
3308: l_err_loc := 100;
3309:
3310: UPDATE icx_cat_batch_jobs
3311: SET job_status = p_job_status,
3312: last_updated_by = fnd_global.user_id,
3313: last_update_date = sysdate,
3314: last_update_login = fnd_global.login_id