DBA Data[Home] [Help]

APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_POR_FAILED_LINE_MESSAGES

Line 490: INSERT INTO icx_por_failed_line_messages

486: l_err_loc PLS_INTEGER;
487: BEGIN
488: l_err_loc := 100;
489:
490: INSERT INTO icx_por_failed_line_messages
491: (job_number, descriptor_key, message_name, line_number, request_id, program_id,
492: program_application_id, program_login_id)
493: VALUES (p_request_id, p_descriptor_key, p_message_name, p_line_number, p_request_id,
494: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

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 2966: DELETE FROM icx_por_failed_line_messages

2962:
2963: l_err_loc := 150;
2964:
2965: FORALL i IN 1..l_job_number_tbl.COUNT
2966: DELETE FROM icx_por_failed_line_messages
2967: WHERE job_number = l_job_number_tbl(i);
2968:
2969: l_err_loc := 160;
2970:

Line 3011: DELETE FROM icx_por_failed_line_messages

3007:
3008: l_err_loc := 240;
3009:
3010: FORALL i IN 1..l_job_number_tbl.COUNT
3011: DELETE FROM icx_por_failed_line_messages
3012: WHERE job_number = l_job_number_tbl(i);
3013:
3014: l_err_loc := 250;
3015: