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_ASGMT_WFSTD dependencies on PA_MASS_ASGMT_TRX

Line 5580: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

5576: --If this is assignment creation mode set assignment info
5577: --else set Updated Info attributes
5578: -----------------------------------------------------------
5579:
5580: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
5581:
5582: l_selected_resources_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275' ||
5583: '&akRegionCode=PA_SELECTED_RESOURCES_LAYOUT&paCallingPage=WF_Notifications' ||
5584: '&paProjectId=' || l_assignments_rec.project_id || '&paNotifiedId=' ||

Line 5755: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

5751: , avalue => l_assignments_rec.work_type_name
5752: );
5753: -- End of Additions by RM
5754:
5755: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5756: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5757: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5758: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5759:

Line 5756: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

5752: );
5753: -- End of Additions by RM
5754:
5755: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5756: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5757: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5758: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5759:
5760: THEN

Line 5757: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

5753: -- End of Additions by RM
5754:
5755: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5756: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5757: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5758: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5759:
5760: THEN
5761:

Line 5758: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

5754:
5755: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5756: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5757: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5758: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5759:
5760: THEN
5761:
5762: wf_engine.SetItemAttrDocument

Line 6269: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

6265:
6266: -----------------------------------------------------------------------------
6267: --Setting Process Creation / Update / Aproval submission mode for assignments
6268: -----------------------------------------------------------------------------
6269: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
6270:
6271: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6272:
6273: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

Line 6273: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

6269: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
6270:
6271: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6272:
6273: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6274: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6275: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6276: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6277: THEN

Line 6274: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

6270:
6271: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6272:
6273: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6274: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6275: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6276: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6277: THEN
6278:

Line 6275: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

6271: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6272:
6273: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6274: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6275: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6276: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6277: THEN
6278:
6279: l_wf_process := 'PA_MASS_APRVL_UPD_FP';

Line 6276: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

6272:
6273: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6274: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6275: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6276: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6277: THEN
6278:
6279: l_wf_process := 'PA_MASS_APRVL_UPD_FP';
6280:

Line 6281: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN

6277: THEN
6278:
6279: l_wf_process := 'PA_MASS_APRVL_UPD_FP';
6280:
6281: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN
6282:
6283: l_wf_process := 'PA_MASS_APRVL_APS_FP';
6284:
6285: END IF;

Line 6824: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

6820: ,x_return_status => l_return_status);
6821:
6822: PA_MESSAGE_UTILS.save_messages
6823: (p_user_id => l_submitter_user_id,
6824: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6825: p_source_type2 => 'MASS_APPROVAL',
6826: p_source_identifier1 => 'PAWFAAP',
6827: p_source_identifier2 => p_group_id,
6828: p_context1 => p_project_id,

Line 6964: AND context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1

6960: CURSOR sub_not_required_csr IS
6961: SELECT 'Y'
6962: FROM PA_REPORTING_EXCEPTIONS
6963: WHERE user_id = l_submitter_user_id
6964: AND context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
6965: AND sub_context = 'MASS_APPROVAL'
6966: AND source_identifier1 = 'PAWFAAP'
6967: AND source_identifier2 = p_group_id;
6968:

Line 7341: WHERE context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1

7337:
7338: CURSOR count_error_asgns IS
7339: SELECT count( distinct ( attribute2))
7340: FROM PA_REPORTING_EXCEPTIONS
7341: WHERE context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
7342: AND sub_context = 'MASS_APPROVAL'
7343: AND source_identifier1 = 'PAWFAAP'
7344: AND source_identifier2 = p_group_id;
7345:

Line 7416: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

7412: log_message('The value of item_key is :' || l_itemkey );
7413: -----------------------------------------------------------------------------
7414: --Setting Process Creation / Update / Aproval submission mode
7415: -----------------------------------------------------------------------------
7416: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
7417:
7418: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7419:
7420: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

Line 7420: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

7416: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
7417:
7418: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7419:
7420: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7421: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7422: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7423: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7424: THEN

Line 7421: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

7417:
7418: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7419:
7420: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7421: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7422: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7423: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7424: THEN
7425:

Line 7422: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

7418: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7419:
7420: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7421: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7422: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7423: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7424: THEN
7425:
7426: l_wf_process := 'PA_MASS_APRVL_SUB_UPD';

Line 7423: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

7419:
7420: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7421: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7422: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7423: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7424: THEN
7425:
7426: l_wf_process := 'PA_MASS_APRVL_SUB_UPD';
7427:

Line 7428: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN

7424: THEN
7425:
7426: l_wf_process := 'PA_MASS_APRVL_SUB_UPD';
7427:
7428: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN
7429:
7430: l_wf_process := 'PA_MASS_APRVL_SUB_APS';
7431:
7432: END IF;

Line 7446: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

7442: ------------------------------------------------------------
7443: --Set the item attributes required for submitter notification
7444: --based on the mode
7445: ------------------------------------------------------------
7446: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
7447:
7448: BEGIN
7449: SELECT object_id1
7450: INTO l_assignment_id

Line 7617: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

7613: , itemkey => l_itemkey
7614: , aname => 'APPROVED_ASSIGNMENTS'
7615: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7616:
7617: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7618: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7619: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7620: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7621:

Line 7618: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

7614: , aname => 'APPROVED_ASSIGNMENTS'
7615: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7616:
7617: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7618: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7619: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7620: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7621:
7622: THEN

Line 7619: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

7615: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7616:
7617: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7618: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7619: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7620: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7621:
7622: THEN
7623: wf_engine.SetItemAttrDocument

Line 7620: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

7616:
7617: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7618: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7619: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7620: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7621:
7622: THEN
7623: wf_engine.SetItemAttrDocument
7624: ( itemtype => l_wf_item_type

Line 8131: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

8127: ,p_group_id => l_group_id
8128: ,x_return_status => l_return_status);
8129:
8130: PA_MESSAGE_UTILS.save_messages(p_user_id => l_submitter_user_id,
8131: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
8132: p_source_type2 => 'MASS_APPROVAL',
8133: p_source_identifier1 => 'PAWFAAP',
8134: p_source_identifier2 => l_group_id,
8135: p_context1 => l_project_id,