DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_MISSING_COSTS

Line 2758: INSERT INTO pa_alloc_missing_costs (

2754: , p_task_id IN NUMBER
2755: , p_amount IN NUMBER ) IS
2756: BEGIN
2757: pa_debug.set_err_stack('Insert missing project costs');
2758: INSERT INTO pa_alloc_missing_costs (
2759: RUN_ID
2760: , TYPE_CODE
2761: , CREATION_DATE
2762: , CREATED_BY

Line 9976: -- Delete Transactions from pa_alloc_missing_costs

9972: /*Code Changes for Bug No.2984871 start */
9973: Commit;
9974: /*Code Changes for Bug No.2984871 end */
9975: End Loop;
9976: -- Delete Transactions from pa_alloc_missing_costs
9977: Delete from pa_alloc_missing_costs
9978: where run_id = p_run_id ;
9979: -- Delete Transactions from pa_alloc_exceptions
9980: Delete from pa_alloc_exceptions

Line 9977: Delete from pa_alloc_missing_costs

9973: Commit;
9974: /*Code Changes for Bug No.2984871 end */
9975: End Loop;
9976: -- Delete Transactions from pa_alloc_missing_costs
9977: Delete from pa_alloc_missing_costs
9978: where run_id = p_run_id ;
9979: -- Delete Transactions from pa_alloc_exceptions
9980: Delete from pa_alloc_exceptions
9981: where run_id = p_run_id ;

Line 10126: -- Delete Transactions from pa_alloc_missing_costs

10122: /*Code Changes for Bug No.2984871 start */
10123: Commit;
10124: /*Code Changes for Bug No.2984871 end */
10125: End Loop;
10126: -- Delete Transactions from pa_alloc_missing_costs
10127: Delete from pa_alloc_missing_costs
10128: where run_id = l_run_id ;
10129: -- Delete Transactions from pa_alloc_exceptions
10130: Delete from pa_alloc_exceptions

Line 10127: Delete from pa_alloc_missing_costs

10123: Commit;
10124: /*Code Changes for Bug No.2984871 end */
10125: End Loop;
10126: -- Delete Transactions from pa_alloc_missing_costs
10127: Delete from pa_alloc_missing_costs
10128: where run_id = l_run_id ;
10129: -- Delete Transactions from pa_alloc_exceptions
10130: Delete from pa_alloc_exceptions
10131: where run_id = l_run_id ;