DBA Data[Home] [Help]

APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_POR_CONTRACT_REFERENCES

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 2978: DELETE FROM icx_por_contract_references

2974:
2975: l_err_loc := 170;
2976:
2977: FORALL i IN 1..l_job_number_tbl.COUNT
2978: DELETE FROM icx_por_contract_references
2979: WHERE job_number = l_job_number_tbl(i);
2980:
2981: l_err_loc := 180;
2982: