eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_EXCEPTIONS

Line 673: INSERT INTO pa_alloc_exceptions (

669: , p_task_id IN NUMBER
670: , p_exception_code IN VARCHAR2 ) IS
671: BEGIN
672: pa_debug.set_err_stack('ins_alloc_exceptions');
673: INSERT INTO pa_alloc_exceptions (
674: RUN_ID
675: , RULE_ID
676: , LEVEL_CODE
677: , EXCEPTION_TYPE

Line 9697: --- If generate allocations completes well, pa_alloc_exceptions will have no errors for the run and

9693:
9694: /**** added for bug 6243121 ***/
9695:
9696: --- Alloc Exceptions status is used in report to populate 'Release status' of the release allocations run.
9697: --- If generate allocations completes well, pa_alloc_exceptions will have no errors for the run and
9698: --- run status is updated to 'RS' even if transaction import fails. Hence adding this code to reflect the
9699: --- transaction import result into pa_alloc_exceptions. Also added code in allocation_run to
9700: --- update the run_status_code conditionally based on whether any errors exist or not.
9701:

Line 9699: --- transaction import result into pa_alloc_exceptions. Also added code in allocation_run to

9695:
9696: --- Alloc Exceptions status is used in report to populate 'Release status' of the release allocations run.
9697: --- If generate allocations completes well, pa_alloc_exceptions will have no errors for the run and
9698: --- run status is updated to 'RS' even if transaction import fails. Hence adding this code to reflect the
9699: --- transaction import result into pa_alloc_exceptions. Also added code in allocation_run to
9700: --- update the run_status_code conditionally based on whether any errors exist or not.
9701:
9702: begin
9703: for r1 in c_alloc_txn_err(p_run_id) loop

Line 9979: -- Delete Transactions from pa_alloc_exceptions

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 ;
9982: -- Delete Transactions from pa_alloc_runs
9983: Delete from pa_alloc_runs

Line 9980: Delete from pa_alloc_exceptions

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 ;
9982: -- Delete Transactions from pa_alloc_runs
9983: Delete from pa_alloc_runs
9984: where run_id = p_run_id ;

Line 10129: -- Delete Transactions from pa_alloc_exceptions

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 ;
10132: -- Delete Transactions from pa_alloc_runs
10133: Delete from pa_alloc_runs

Line 10130: Delete from pa_alloc_exceptions

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 ;
10132: -- Delete Transactions from pa_alloc_runs
10133: Delete from pa_alloc_runs
10134: where run_id = l_run_id ;