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 5596: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

5592: --If this is assignment creation mode set assignment info
5593: --else set Updated Info attributes
5594: -----------------------------------------------------------
5595:
5596: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
5597:
5598: l_selected_resources_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275' ||
5599: '&akRegionCode=PA_SELECTED_RESOURCES_LAYOUT&paCallingPage=WF_Notifications' ||
5600: '&paProjectId=' || l_assignments_rec.project_id || '&paNotifiedId=' ||

Line 5771: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

5767: , avalue => l_assignments_rec.work_type_name
5768: );
5769: -- End of Additions by RM
5770:
5771: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5772: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5773: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5774: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5775:

Line 5772: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

5768: );
5769: -- End of Additions by RM
5770:
5771: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5772: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5773: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5774: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5775:
5776: THEN

Line 5773: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

5769: -- End of Additions by RM
5770:
5771: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5772: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5773: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5774: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5775:
5776: THEN
5777:

Line 5774: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

5770:
5771: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5772: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
5773: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
5774: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5775:
5776: THEN
5777:
5778: wf_engine.SetItemAttrDocument

Line 6285: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

6281:
6282: -----------------------------------------------------------------------------
6283: --Setting Process Creation / Update / Aproval submission mode for assignments
6284: -----------------------------------------------------------------------------
6285: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
6286:
6287: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6288:
6289: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

Line 6289: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

6285: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
6286:
6287: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6288:
6289: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6290: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6291: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6292: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6293: THEN

Line 6290: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

6286:
6287: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6288:
6289: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6290: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6291: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6292: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6293: THEN
6294:

Line 6291: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

6287: l_wf_process := 'PA_MASS_APRVL_CRN_FP';
6288:
6289: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6290: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6291: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6292: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6293: THEN
6294:
6295: l_wf_process := 'PA_MASS_APRVL_UPD_FP';

Line 6292: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

6288:
6289: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
6290: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
6291: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
6292: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
6293: THEN
6294:
6295: l_wf_process := 'PA_MASS_APRVL_UPD_FP';
6296:

Line 6297: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN

6293: THEN
6294:
6295: l_wf_process := 'PA_MASS_APRVL_UPD_FP';
6296:
6297: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN
6298:
6299: l_wf_process := 'PA_MASS_APRVL_APS_FP';
6300:
6301: END IF;

Line 6840: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

6836: ,x_return_status => l_return_status);
6837:
6838: PA_MESSAGE_UTILS.save_messages
6839: (p_user_id => l_submitter_user_id,
6840: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6841: p_source_type2 => 'MASS_APPROVAL',
6842: p_source_identifier1 => 'PAWFAAP',
6843: p_source_identifier2 => p_group_id,
6844: p_context1 => p_project_id,

Line 6980: AND context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1

6976: CURSOR sub_not_required_csr IS
6977: SELECT 'Y'
6978: FROM PA_REPORTING_EXCEPTIONS
6979: WHERE user_id = l_submitter_user_id
6980: AND context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
6981: AND sub_context = 'MASS_APPROVAL'
6982: AND source_identifier1 = 'PAWFAAP'
6983: AND source_identifier2 = p_group_id;
6984:

Line 7357: WHERE context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1

7353:
7354: CURSOR count_error_asgns IS
7355: SELECT count( distinct ( attribute2))
7356: FROM PA_REPORTING_EXCEPTIONS
7357: WHERE context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
7358: AND sub_context = 'MASS_APPROVAL'
7359: AND source_identifier1 = 'PAWFAAP'
7360: AND source_identifier2 = p_group_id;
7361:

Line 7432: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

7428: log_message('The value of item_key is :' || l_itemkey );
7429: -----------------------------------------------------------------------------
7430: --Setting Process Creation / Update / Aproval submission mode
7431: -----------------------------------------------------------------------------
7432: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
7433:
7434: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7435:
7436: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

Line 7436: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

7432: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
7433:
7434: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7435:
7436: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7437: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7438: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7439: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7440: THEN

Line 7437: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

7433:
7434: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7435:
7436: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7437: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7438: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7439: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7440: THEN
7441:

Line 7438: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

7434: l_wf_process := 'PA_MASS_APRVL_SUB_CRN';
7435:
7436: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7437: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7438: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7439: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7440: THEN
7441:
7442: l_wf_process := 'PA_MASS_APRVL_SUB_UPD';

Line 7439: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

7435:
7436: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7437: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7438: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7439: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7440: THEN
7441:
7442: l_wf_process := 'PA_MASS_APRVL_SUB_UPD';
7443:

Line 7444: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN

7440: THEN
7441:
7442: l_wf_process := 'PA_MASS_APRVL_SUB_UPD';
7443:
7444: ELSIF p_mode = PA_MASS_ASGMT_TRX.G_MASS_SUBMIT_FOR_APPROVAL THEN
7445:
7446: l_wf_process := 'PA_MASS_APRVL_SUB_APS';
7447:
7448: END IF;

Line 7462: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN

7458: ------------------------------------------------------------
7459: --Set the item attributes required for submitter notification
7460: --based on the mode
7461: ------------------------------------------------------------
7462: IF p_mode = PA_MASS_ASGMT_TRX.G_MASS_ASGMT THEN
7463:
7464: BEGIN
7465: SELECT object_id1
7466: INTO l_assignment_id

Line 7633: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

7629: , itemkey => l_itemkey
7630: , aname => 'APPROVED_ASSIGNMENTS'
7631: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7632:
7633: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7634: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7635: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7636: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7637:

Line 7634: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR

7630: , aname => 'APPROVED_ASSIGNMENTS'
7631: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7632:
7633: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7634: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7635: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7636: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7637:
7638: THEN

Line 7635: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR

7631: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7632:
7633: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7634: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7635: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7636: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7637:
7638: THEN
7639: wf_engine.SetItemAttrDocument

Line 7636: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )

7632:
7633: ELSIF (p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
7634: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES OR
7635: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7636: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7637:
7638: THEN
7639: wf_engine.SetItemAttrDocument
7640: ( itemtype => l_wf_item_type

Line 8147: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

8143: ,p_group_id => l_group_id
8144: ,x_return_status => l_return_status);
8145:
8146: PA_MESSAGE_UTILS.save_messages(p_user_id => l_submitter_user_id,
8147: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
8148: p_source_type2 => 'MASS_APPROVAL',
8149: p_source_identifier1 => 'PAWFAAP',
8150: p_source_identifier2 => l_group_id,
8151: p_context1 => l_project_id,