DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_MISSING_COSTS

Line 2748: INSERT INTO pa_alloc_missing_costs (

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

Line 9871: -- Delete Transactions from pa_alloc_missing_costs

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

Line 9872: Delete from pa_alloc_missing_costs

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 ;

Line 10021: -- Delete Transactions from pa_alloc_missing_costs

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

Line 10022: Delete from pa_alloc_missing_costs

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 ;