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_MASS_ASGMT_TRX dependencies on PA_WF_PROCESS_DETAILS

Line 267: INSERT INTO pa_wf_process_details(wf_type_code,

263:
264: --if there are any object ids then insert the wf process details.
265: IF l_object_id_tbl.COUNT > 0 THEN
266: FORALL i IN l_object_id_tbl.FIRST .. l_object_id_tbl.LAST
267: INSERT INTO pa_wf_process_details(wf_type_code,
268: item_type,
269: item_key,
270: object_id1,
271: process_status_code,

Line 832: FROM pa_wf_process_details

828: p_result := 'NONE';
829:
830: --bulk collect the pending resource or assignment ids for this mass transaction.
831: SELECT object_id1 BULK COLLECT INTO l_object_id_tbl
832: FROM pa_wf_process_details
833: WHERE item_type = p_item_type
834: AND item_key = p_item_key
835: AND process_status_code = 'P';
836:

Line 857: --pa_wf_process_details.process_status_code will be updated inside

853: --during a mass asgmt/update, the assignments created/updated will be
854: --committed if successful/rolled back if any errors - ONE AT A TIME.
855: --no commits are allowed in the workflow transaction, so call this
856: --API which will start an autonomous transaction.
857: --pa_wf_process_details.process_status_code will be updated inside
858: --the autonomous transaction
859: PA_MASS_ASGMT_TRX.mass_asgmt_autonomous_trx
860: (p_item_type => p_item_type,
861: p_item_key => p_item_key,

Line 878: FROM pa_wf_process_details

874: SELECT sum(decode(process_status_code, 'S', 1,0)),
875: sum(decode(process_status_code, 'A', 1, 'E', 1, 0))
876: INTO l_success_assignments,
877: l_failure_assignments
878: FROM pa_wf_process_details
879: WHERE item_type = p_item_type
880: AND item_key = p_item_key;
881:
882: --if the mass trx is submitted for approval and any assignments were

Line 2434: --set pa_wf_process_details.process_status_code.

2430: WHERE assignment_id = l_single_obj_id_tbl(1);
2431:
2432: END IF;
2433:
2434: --set pa_wf_process_details.process_status_code.
2435: --if the assignment was created/updated successfully then l_success_assignment_id_tbl(1)
2436: --will be not null - so set process_status_code to 'S'
2437: --otherwise the assignemnt was not created/updated successfully due to a validation
2438: --error so set process_status_code to 'E'.

Line 2439: UPDATE pa_wf_process_details

2435: --if the assignment was created/updated successfully then l_success_assignment_id_tbl(1)
2436: --will be not null - so set process_status_code to 'S'
2437: --otherwise the assignemnt was not created/updated successfully due to a validation
2438: --error so set process_status_code to 'E'.
2439: UPDATE pa_wf_process_details
2440: SET process_status_code = decode(l_success_assignment_id_tbl(1), NULL, 'E', 'S'),
2441: object_id2 = decode(l_mode, G_MASS_ASGMT, l_success_assignment_id_tbl(1), NULL)
2442: WHERE item_type = p_item_type
2443: AND item_key = p_item_key

Line 2462: UPDATE pa_wf_process_details

2458: --if l_mode is mass submit for approval then set everything to S.
2459: ELSIF l_object_id_tbl.COUNT > 0 THEN
2460:
2461: FORALL i IN l_object_id_tbl.FIRST .. l_object_id_tbl.LAST
2462: UPDATE pa_wf_process_details
2463: SET process_status_code = 'S'
2464: WHERE item_type = p_item_type
2465: AND item_key = p_item_key
2466: AND object_id1 = l_object_id_tbl(i);

Line 2576: FROM pa_wf_process_details wf,

2572: l_approver1_id_tbl,
2573: l_approver1_name_tbl,
2574: l_approver2_id_tbl,
2575: l_approver2_name_tbl
2576: FROM pa_wf_process_details wf,
2577: pa_project_assignments asgmt
2578: WHERE wf.item_type = p_item_type
2579: AND wf.item_key = p_item_key
2580: AND wf.process_status_code = 'S'

Line 2819: FROM pa_wf_process_details

2815: UPDATE pa_project_assignments
2816: SET mass_wf_in_progress_flag = 'N'
2817: WHERE assignment_id IN
2818: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2819: FROM pa_wf_process_details
2820: WHERE item_type = p_item_type
2821: AND item_key = p_item_key);
2822:
2823: EXCEPTION

Line 2838: --order to set pa_wf_process_details.process_status_code to 'A'.

2834: END;
2835:
2836: --if there is an unexpected error then the sysadmin can choose to abort or retry
2837: --the unprocessed items. If he chooses to abort then this API is called in
2838: --order to set pa_wf_process_details.process_status_code to 'A'.
2839:
2840: PROCEDURE Abort_Remaining_Trx
2841: (p_item_type IN VARCHAR2,
2842: p_item_key IN VARCHAR2,

Line 2891: UPDATE pa_wf_process_details

2887: itemkey => l_error_item_key,
2888: aname => 'PROJECT_ID');
2889:
2890: --set process_status_code to 'A' for the pending items.
2891: UPDATE pa_wf_process_details
2892: SET process_status_code = 'A' --'A' for aborted
2893: WHERE item_type = l_error_item_type
2894: AND item_key = l_error_item_key
2895: AND process_status_code = 'P'; --'P' for pending

Line 2902: FROM pa_wf_process_details

2898: UPDATE pa_project_assignments
2899: SET mass_wf_in_progress_flag = 'N'
2900: WHERE assignment_id IN
2901: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2902: FROM pa_wf_process_details
2903: WHERE item_type = l_error_item_type
2904: AND item_key = l_error_item_key
2905: AND process_status_code = 'A');
2906:

Line 2910: FROM pa_wf_process_details

2906:
2907: --get the object id (will be either resource id or assignment id)
2908: --for the aborted transactions.
2909: SELECT object_id1 BULK COLLECT INTO l_object_id1_tbl
2910: FROM pa_wf_process_details
2911: WHERE item_type = l_error_item_type
2912: AND item_key = l_error_item_key
2913: AND process_status_code = 'A';
2914: