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 666: INSERT INTO pa_alloc_exceptions (

662: , p_task_id IN NUMBER
663: , p_exception_code IN VARCHAR2 ) IS
664: BEGIN
665: pa_debug.set_err_stack('ins_alloc_exceptions');
666: INSERT INTO pa_alloc_exceptions (
667: RUN_ID
668: , RULE_ID
669: , LEVEL_CODE
670: , EXCEPTION_TYPE

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

9588:
9589: /**** added for bug 6243121 ***/
9590:
9591: --- Alloc Exceptions status is used in report to populate 'Release status' of the release allocations run.
9592: --- If generate allocations completes well, pa_alloc_exceptions will have no errors for the run and
9593: --- run status is updated to 'RS' even if transaction import fails. Hence adding this code to reflect the
9594: --- transaction import result into pa_alloc_exceptions. Also added code in allocation_run to
9595: --- update the run_status_code conditionally based on whether any errors exist or not.
9596:

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

9590:
9591: --- Alloc Exceptions status is used in report to populate 'Release status' of the release allocations run.
9592: --- If generate allocations completes well, pa_alloc_exceptions will have no errors for the run and
9593: --- run status is updated to 'RS' even if transaction import fails. Hence adding this code to reflect the
9594: --- transaction import result into pa_alloc_exceptions. Also added code in allocation_run to
9595: --- update the run_status_code conditionally based on whether any errors exist or not.
9596:
9597: begin
9598: for r1 in c_alloc_txn_err(p_run_id) loop

Line 9874: -- Delete Transactions from pa_alloc_exceptions

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 ;
9877: -- Delete Transactions from pa_alloc_runs
9878: Delete from pa_alloc_runs

Line 9875: Delete from pa_alloc_exceptions

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 ;
9877: -- Delete Transactions from pa_alloc_runs
9878: Delete from pa_alloc_runs
9879: where run_id = p_run_id ;

Line 10024: -- Delete Transactions from pa_alloc_exceptions

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 ;
10027: -- Delete Transactions from pa_alloc_runs
10028: Delete from pa_alloc_runs

Line 10025: Delete from pa_alloc_exceptions

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 ;
10027: -- Delete Transactions from pa_alloc_runs
10028: Delete from pa_alloc_runs
10029: where run_id = l_run_id ;