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 269: INSERT INTO pa_wf_process_details(wf_type_code,

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

Line 843: FROM pa_wf_process_details

839: p_result := 'NONE';
840:
841: --bulk collect the pending resource or assignment ids for this mass transaction.
842: SELECT object_id1 BULK COLLECT INTO l_object_id_tbl
843: FROM pa_wf_process_details
844: WHERE item_type = p_item_type
845: AND item_key = p_item_key
846: AND process_status_code = 'P';
847:

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

864: --during a mass asgmt/update, the assignments created/updated will be
865: --committed if successful/rolled back if any errors - ONE AT A TIME.
866: --no commits are allowed in the workflow transaction, so call this
867: --API which will start an autonomous transaction.
868: --pa_wf_process_details.process_status_code will be updated inside
869: --the autonomous transaction
870: PA_MASS_ASGMT_TRX.mass_asgmt_autonomous_trx
871: (p_item_type => p_item_type,
872: p_item_key => p_item_key,

Line 889: FROM pa_wf_process_details

885: SELECT sum(decode(process_status_code, 'S', 1,0)),
886: sum(decode(process_status_code, 'A', 1, 'E', 1, 0))
887: INTO l_success_assignments,
888: l_failure_assignments
889: FROM pa_wf_process_details
890: WHERE item_type = p_item_type
891: AND item_key = p_item_key;
892:
893: --if the mass trx is submitted for approval and any assignments were

Line 2491: --set pa_wf_process_details.process_status_code.

2487: WHERE assignment_id = l_single_obj_id_tbl(1);
2488:
2489: END IF;
2490:
2491: --set pa_wf_process_details.process_status_code.
2492: --if the assignment was created/updated successfully then l_success_assignment_id_tbl(1)
2493: --will be not null - so set process_status_code to 'S'
2494: --otherwise the assignemnt was not created/updated successfully due to a validation
2495: --error so set process_status_code to 'E'.

Line 2496: UPDATE pa_wf_process_details

2492: --if the assignment was created/updated successfully then l_success_assignment_id_tbl(1)
2493: --will be not null - so set process_status_code to 'S'
2494: --otherwise the assignemnt was not created/updated successfully due to a validation
2495: --error so set process_status_code to 'E'.
2496: UPDATE pa_wf_process_details
2497: SET process_status_code = decode(l_success_assignment_id_tbl(1), NULL, 'E', 'S'),
2498: object_id2 = decode(l_mode, G_MASS_ASGMT, l_success_assignment_id_tbl(1), NULL)
2499: WHERE item_type = p_item_type
2500: AND item_key = p_item_key

Line 2519: UPDATE pa_wf_process_details

2515: --if l_mode is mass submit for approval then set everything to S.
2516: ELSIF l_object_id_tbl.COUNT > 0 THEN
2517:
2518: FORALL i IN l_object_id_tbl.FIRST .. l_object_id_tbl.LAST
2519: UPDATE pa_wf_process_details
2520: SET process_status_code = 'S'
2521: WHERE item_type = p_item_type
2522: AND item_key = p_item_key
2523: AND object_id1 = l_object_id_tbl(i);

Line 2633: FROM pa_wf_process_details wf,

2629: l_approver1_id_tbl,
2630: l_approver1_name_tbl,
2631: l_approver2_id_tbl,
2632: l_approver2_name_tbl
2633: FROM pa_wf_process_details wf,
2634: pa_project_assignments asgmt
2635: WHERE wf.item_type = p_item_type
2636: AND wf.item_key = p_item_key
2637: AND wf.process_status_code = 'S'

Line 2878: FROM pa_wf_process_details

2874: UPDATE pa_project_assignments
2875: SET mass_wf_in_progress_flag = 'N'
2876: WHERE assignment_id IN
2877: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2878: FROM pa_wf_process_details
2879: WHERE item_type = p_item_type
2880: AND item_key = p_item_key);
2881:
2882: EXCEPTION

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

2893: END;
2894:
2895: --if there is an unexpected error then the sysadmin can choose to abort or retry
2896: --the unprocessed items. If he chooses to abort then this API is called in
2897: --order to set pa_wf_process_details.process_status_code to 'A'.
2898:
2899: PROCEDURE Abort_Remaining_Trx
2900: (p_item_type IN VARCHAR2,
2901: p_item_key IN VARCHAR2,

Line 2950: UPDATE pa_wf_process_details

2946: itemkey => l_error_item_key,
2947: aname => 'PROJECT_ID');
2948:
2949: --set process_status_code to 'A' for the pending items.
2950: UPDATE pa_wf_process_details
2951: SET process_status_code = 'A' --'A' for aborted
2952: WHERE item_type = l_error_item_type
2953: AND item_key = l_error_item_key
2954: AND process_status_code = 'P'; --'P' for pending

Line 2961: FROM pa_wf_process_details

2957: UPDATE pa_project_assignments
2958: SET mass_wf_in_progress_flag = 'N'
2959: WHERE assignment_id IN
2960: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2961: FROM pa_wf_process_details
2962: WHERE item_type = l_error_item_type
2963: AND item_key = l_error_item_key
2964: AND process_status_code = 'A');
2965:

Line 2969: FROM pa_wf_process_details

2965:
2966: --get the object id (will be either resource id or assignment id)
2967: --for the aborted transactions.
2968: SELECT object_id1 BULK COLLECT INTO l_object_id1_tbl
2969: FROM pa_wf_process_details
2970: WHERE item_type = l_error_item_type
2971: AND item_key = l_error_item_key
2972: AND process_status_code = 'A';
2973: