APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_POR_FAILED_LINES

Line 458: INSERT INTO icx_por_failed_lines

454: l_err_loc PLS_INTEGER;
455: BEGIN
456: l_err_loc := 100;
457:
458: INSERT INTO icx_por_failed_lines
459: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
460: request_id, program_id, program_application_id, program_login_id)
461: VALUES (p_request_id, p_line_number, p_action, p_row_type, p_descriptor_key,
462: p_descriptor_value, p_request_id, fnd_global.conc_program_id,

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 2972: DELETE FROM icx_por_failed_lines

2968:
2969: l_err_loc := 160;
2970:
2971: FORALL i IN 1..l_job_number_tbl.COUNT
2972: DELETE FROM icx_por_failed_lines
2973: WHERE job_number = l_job_number_tbl(i);
2974:
2975: l_err_loc := 170;
2976:

Line 3017: DELETE FROM icx_por_failed_lines

3013:
3014: l_err_loc := 250;
3015:
3016: FORALL i IN 1..l_job_number_tbl.COUNT
3017: DELETE FROM icx_por_failed_lines
3018: WHERE job_number = l_job_number_tbl(i);
3019:
3020: l_err_loc := 260;
3021: