2744: , p_task_id IN NUMBER
2745: , p_amount IN NUMBER ) IS
2746: BEGIN
2747: pa_debug.set_err_stack('Insert missing project costs');
2748: INSERT INTO pa_alloc_missing_costs (
2749: RUN_ID
2750: , TYPE_CODE
2751: , CREATION_DATE
2752: , CREATED_BY
9867: /*Code Changes for Bug No.2984871 start */
9868: Commit;
9869: /*Code Changes for Bug No.2984871 end */
9870: End Loop;
9871: -- Delete Transactions from pa_alloc_missing_costs
9872: Delete from pa_alloc_missing_costs
9873: where run_id = p_run_id ;
9874: -- Delete Transactions from pa_alloc_exceptions
9875: Delete from pa_alloc_exceptions
9868: Commit;
9869: /*Code Changes for Bug No.2984871 end */
9870: End Loop;
9871: -- Delete Transactions from pa_alloc_missing_costs
9872: Delete from pa_alloc_missing_costs
9873: where run_id = p_run_id ;
9874: -- Delete Transactions from pa_alloc_exceptions
9875: Delete from pa_alloc_exceptions
9876: where run_id = p_run_id ;
10017: /*Code Changes for Bug No.2984871 start */
10018: Commit;
10019: /*Code Changes for Bug No.2984871 end */
10020: End Loop;
10021: -- Delete Transactions from pa_alloc_missing_costs
10022: Delete from pa_alloc_missing_costs
10023: where run_id = l_run_id ;
10024: -- Delete Transactions from pa_alloc_exceptions
10025: Delete from pa_alloc_exceptions
10018: Commit;
10019: /*Code Changes for Bug No.2984871 end */
10020: End Loop;
10021: -- Delete Transactions from pa_alloc_missing_costs
10022: Delete from pa_alloc_missing_costs
10023: where run_id = l_run_id ;
10024: -- Delete Transactions from pa_alloc_exceptions
10025: Delete from pa_alloc_exceptions
10026: where run_id = l_run_id ;