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

Line 3612: IF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO

3608:
3609: -- check that mass workflow for updating assignment is not in progress.
3610: -- if mass workflow is in progress, cannot update the assignment
3611: -- perform this check only if this is online single update
3612: IF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
3613: and p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
3614: and p_asgn_update_mode <> 'MASS_ONLINE' THEN
3615:
3616: --dbms_output.put_line('single update - check number_mass_wf_in_progress');

Line 3613: and p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS

3609: -- check that mass workflow for updating assignment is not in progress.
3610: -- if mass workflow is in progress, cannot update the assignment
3611: -- perform this check only if this is online single update
3612: IF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
3613: and p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
3614: and p_asgn_update_mode <> 'MASS_ONLINE' THEN
3615:
3616: --dbms_output.put_line('single update - check number_mass_wf_in_progress');
3617:

Line 3633: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO

3629:
3630: -- check that the assignment or requirement is cancelled or filled
3631: -- only if this is during mass workflow
3632: -- do not allow user to update cancelled or filled asgn/req
3633: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
3634: OR p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
3635:
3636: OPEN get_project_system_status_code;
3637: FETCH get_project_system_status_code INTO l_project_system_status_code;

Line 3634: OR p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

3630: -- check that the assignment or requirement is cancelled or filled
3631: -- only if this is during mass workflow
3632: -- do not allow user to update cancelled or filled asgn/req
3633: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
3634: OR p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
3635:
3636: OPEN get_project_system_status_code;
3637: FETCH get_project_system_status_code INTO l_project_system_status_code;
3638: CLOSE get_project_system_status_code;

Line 3686: ELSIF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO

3682: --Update to Resource or Project Role is not allowed for Version 1.
3683: --So if any role/resource attributes is passed in (or NULL is passed in),
3684: --Then throw an error.
3685: --Do not throw error if this is with in Mass Update Workflow
3686: ELSIF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
3687: AND p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
3688: AND ((l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM OR l_assignment_rec.project_role_id IS NULL) OR
3689: (p_project_role_name <> FND_API.G_MISS_CHAR OR p_project_role_name IS NULL) OR
3690: (p_resource_id <> FND_API.G_MISS_NUM OR p_resource_id IS NULL) OR

Line 3687: AND p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS

3683: --So if any role/resource attributes is passed in (or NULL is passed in),
3684: --Then throw an error.
3685: --Do not throw error if this is with in Mass Update Workflow
3686: ELSIF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
3687: AND p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
3688: AND ((l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM OR l_assignment_rec.project_role_id IS NULL) OR
3689: (p_project_role_name <> FND_API.G_MISS_CHAR OR p_project_role_name IS NULL) OR
3690: (p_resource_id <> FND_API.G_MISS_NUM OR p_resource_id IS NULL) OR
3691: (p_resource_name <> FND_API.G_MISS_CHAR OR p_resource_name IS NULL) OR

Line 4760: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

4756: -- Perform security check for Admin Assignment
4757: -- if this is with in Mass Update Workflow
4758: IF l_assignment_rec.assignment_type='STAFFED_ADMIN_ASSIGNMENT' AND p_resource_id IS NOT NULL THEN
4759:
4760: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
4761: p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
4762:
4763: --dbms_output.put_line('check PA_ADM_ASN_CR_AND_DL for Mass Update ');
4764:

Line 4761: p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

4757: -- if this is with in Mass Update Workflow
4758: IF l_assignment_rec.assignment_type='STAFFED_ADMIN_ASSIGNMENT' AND p_resource_id IS NOT NULL THEN
4759:
4760: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
4761: p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
4762:
4763: --dbms_output.put_line('check PA_ADM_ASN_CR_AND_DL for Mass Update ');
4764:
4765: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,

Line 4782: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

4778: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4779: END IF;
4780: END IF;
4781:
4782: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
4783:
4784: --dbms_output.put_line('check PA_ADM_ASN_CR_AND_DL for Mass Update Forecast ');
4785:
4786: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,

Line 5628: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(

5624: FETCH csr_get_tp_amt_type into l_asg_tp_amount_type;
5625: CLOSE csr_get_tp_amt_type;
5626:
5627: --start the mass WF
5628: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
5629: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT
5630: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
5631: ,p_resource_id_tbl => p_resource_id_tbl
5632: ,p_assignment_name => p_assignment_name

Line 5629: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT

5625: CLOSE csr_get_tp_amt_type;
5626:
5627: --start the mass WF
5628: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
5629: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT
5630: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
5631: ,p_resource_id_tbl => p_resource_id_tbl
5632: ,p_assignment_name => p_assignment_name
5633: ,p_assignment_type => p_assignment_type

Line 5630: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE

5626:
5627: --start the mass WF
5628: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
5629: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT
5630: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
5631: ,p_resource_id_tbl => p_resource_id_tbl
5632: ,p_assignment_name => p_assignment_name
5633: ,p_assignment_type => p_assignment_type
5634: ,p_multiple_status_flag => p_multiple_status_flag

Line 5909: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,

5905: l_new_assignment_id_tbl(i) := l_new_assignment_id;
5906:
5907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5908: l_new_assignment_id_tbl(i) := NULL;
5909: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
5910: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
5911: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
5912: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
5913: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

Line 5910: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

5906:
5907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5908: l_new_assignment_id_tbl(i) := NULL;
5909: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
5910: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
5911: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
5912: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
5913: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
5914: p_context1 => p_project_id,

Line 5911: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,

5907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5908: l_new_assignment_id_tbl(i) := NULL;
5909: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
5910: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
5911: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
5912: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
5913: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
5914: p_context1 => p_project_id,
5915: p_context2 => NULL,

Line 5912: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,

5908: l_new_assignment_id_tbl(i) := NULL;
5909: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
5910: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
5911: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
5912: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
5913: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
5914: p_context1 => p_project_id,
5915: p_context2 => NULL,
5916: p_context3 => p_resource_id_tbl(i),

Line 5913: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

5909: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
5910: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
5911: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
5912: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
5913: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
5914: p_context1 => p_project_id,
5915: p_context2 => NULL,
5916: p_context3 => p_resource_id_tbl(i),
5917: p_commit => FND_API.G_TRUE,

Line 6104: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;

6100: --if p_validate_only=false and there are no errors then start the workflow process.
6101: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN
6102:
6103: IF p_asgn_update_mode = 'Forecast' THEN
6104: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;
6105: ELSE
6106: -- update BasicInfo or Candidate
6107: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;
6108: END IF;

Line 6107: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;

6103: IF p_asgn_update_mode = 'Forecast' THEN
6104: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;
6105: ELSE
6106: -- update BasicInfo or Candidate
6107: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;
6108: END IF;
6109:
6110: --start the mass WF
6111: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(

Line 6111: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(

6107: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;
6108: END IF;
6109:
6110: --start the mass WF
6111: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
6112: p_mode => l_wf_mode
6113: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
6114: ,p_assignment_id_tbl => p_assignment_id_tbl
6115: ,p_assignment_name => p_assignment_name

Line 6113: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE

6109:
6110: --start the mass WF
6111: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
6112: p_mode => l_wf_mode
6113: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
6114: ,p_assignment_id_tbl => p_assignment_id_tbl
6115: ,p_assignment_name => p_assignment_name
6116: ,p_assignment_type => p_assignment_type
6117: ,p_staffing_priority_code => p_staffing_priority_code

Line 6482: p_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

6478:
6479: --if successful and update mode is 'update forecast'
6480: --then call forecast API to generate forecast items
6481: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
6482: p_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
6483:
6484: --dbms_output.put_line('calling PA_FORECASTITEM_PVT.Create_Forecast_Item');
6485:
6486: PA_FORECASTITEM_PVT.Create_Forecast_Item(

Line 6503: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,

6499:
6500: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6501: l_assignment_id_tbl(i) := NULL;
6502:
6503: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6504: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6505: p_source_type2 => p_update_mode,
6506: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6507: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

Line 6504: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

6500: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6501: l_assignment_id_tbl(i) := NULL;
6502:
6503: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6504: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6505: p_source_type2 => p_update_mode,
6506: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6507: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6508: p_context1 => p_project_id,

Line 6506: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,

6502:
6503: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6504: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6505: p_source_type2 => p_update_mode,
6506: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6507: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6508: p_context1 => p_project_id,
6509: p_context2 => p_assignment_id_tbl(i),
6510: p_context3 => NULL,

Line 6507: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

6503: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6504: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6505: p_source_type2 => p_update_mode,
6506: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6507: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6508: p_context1 => p_project_id,
6509: p_context2 => p_assignment_id_tbl(i),
6510: p_context3 => NULL,
6511: p_commit => FND_API.G_TRUE,