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 4539: IF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO

4535: -- if mass workflow is in progress, cannot update the assignment
4536: -- perform this check only if this is online single update
4537:
4538:
4539: IF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
4540: and p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
4541: and p_asgn_update_mode <> 'MASS_ONLINE' THEN
4542:
4543: --dbms_output.put_line('single update - check number_mass_wf_in_progress');

Line 4540: and p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS

4536: -- perform this check only if this is online single update
4537:
4538:
4539: IF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
4540: and p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
4541: and p_asgn_update_mode <> 'MASS_ONLINE' THEN
4542:
4543: --dbms_output.put_line('single update - check number_mass_wf_in_progress');
4544:

Line 4559: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO

4555: END IF;
4556: -- check that the assignment or requirement is cancelled or filled
4557: -- only if this is during mass workflow
4558: -- do not allow user to update cancelled or filled asgn/req
4559: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
4560: OR p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
4561: OPEN get_project_system_status_code;
4562: FETCH get_project_system_status_code INTO l_project_system_status_code;
4563: CLOSE get_project_system_status_code;

Line 4560: OR p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

4556: -- check that the assignment or requirement is cancelled or filled
4557: -- only if this is during mass workflow
4558: -- do not allow user to update cancelled or filled asgn/req
4559: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
4560: OR p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
4561: OPEN get_project_system_status_code;
4562: FETCH get_project_system_status_code INTO l_project_system_status_code;
4563: CLOSE get_project_system_status_code;
4564:

Line 4614: ELSIF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO

4610: --Update to Resource or Project Role is not allowed for Version 1.
4611: --So if any role/resource attributes is passed in (or NULL is passed in),
4612: --Then throw an error.
4613: --Do not throw error if this is with in Mass Update Workflow
4614: ELSIF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
4615: AND p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
4616: AND ((l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM OR l_assignment_rec.project_role_id IS NULL) OR
4617: (p_project_role_name <> FND_API.G_MISS_CHAR OR p_project_role_name IS NULL) OR
4618: (p_resource_id <> FND_API.G_MISS_NUM OR p_resource_id IS NULL) OR

Line 4615: AND p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS

4611: --So if any role/resource attributes is passed in (or NULL is passed in),
4612: --Then throw an error.
4613: --Do not throw error if this is with in Mass Update Workflow
4614: ELSIF p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO
4615: AND p_asgn_update_mode <> PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS
4616: AND ((l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM OR l_assignment_rec.project_role_id IS NULL) OR
4617: (p_project_role_name <> FND_API.G_MISS_CHAR OR p_project_role_name IS NULL) OR
4618: (p_resource_id <> FND_API.G_MISS_NUM OR p_resource_id IS NULL) OR
4619: (p_resource_name <> FND_API.G_MISS_CHAR OR p_resource_name IS NULL) OR

Line 5733: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR

5729: -- Perform security check for Admin Assignment
5730: -- if this is with in Mass Update Workflow
5731: IF l_assignment_rec.assignment_type='STAFFED_ADMIN_ASSIGNMENT' AND p_resource_id IS NOT NULL THEN
5732:
5733: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5734: p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
5735:
5736: --dbms_output.put_line('check PA_ADM_ASN_CR_AND_DL for Mass Update ');
5737:

Line 5734: p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

5730: -- if this is with in Mass Update Workflow
5731: IF l_assignment_rec.assignment_type='STAFFED_ADMIN_ASSIGNMENT' AND p_resource_id IS NOT NULL THEN
5732:
5733: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO OR
5734: p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
5735:
5736: --dbms_output.put_line('check PA_ADM_ASN_CR_AND_DL for Mass Update ');
5737:
5738: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,

Line 5754: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

5750: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
5751: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5752: END IF;
5753: END IF;
5754: IF p_asgn_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
5755:
5756: --dbms_output.put_line('check PA_ADM_ASN_CR_AND_DL for Mass Update Forecast ');
5757:
5758: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,

Line 6604: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(

6600: FETCH csr_get_tp_amt_type into l_asg_tp_amount_type;
6601: CLOSE csr_get_tp_amt_type;
6602:
6603: --start the mass WF
6604: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
6605: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT
6606: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
6607: ,p_resource_id_tbl => p_resource_id_tbl
6608: ,p_assignment_name => p_assignment_name

Line 6605: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT

6601: CLOSE csr_get_tp_amt_type;
6602:
6603: --start the mass WF
6604: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
6605: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT
6606: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
6607: ,p_resource_id_tbl => p_resource_id_tbl
6608: ,p_assignment_name => p_assignment_name
6609: ,p_assignment_type => p_assignment_type

Line 6606: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE

6602:
6603: --start the mass WF
6604: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
6605: p_mode => PA_MASS_ASGMT_TRX.G_MASS_ASGMT
6606: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
6607: ,p_resource_id_tbl => p_resource_id_tbl
6608: ,p_assignment_name => p_assignment_name
6609: ,p_assignment_type => p_assignment_type
6610: ,p_multiple_status_flag => p_multiple_status_flag

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

6881: l_new_assignment_id_tbl(i) := l_new_assignment_id;
6882:
6883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6884: l_new_assignment_id_tbl(i) := NULL;
6885: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6886: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6887: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
6888: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6889: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

Line 6886: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

6882:
6883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6884: l_new_assignment_id_tbl(i) := NULL;
6885: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6886: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6887: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
6888: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6889: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6890: p_context1 => p_project_id,

Line 6887: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,

6883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6884: l_new_assignment_id_tbl(i) := NULL;
6885: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6886: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6887: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
6888: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6889: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6890: p_context1 => p_project_id,
6891: p_context2 => NULL,

Line 6888: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,

6884: l_new_assignment_id_tbl(i) := NULL;
6885: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6886: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6887: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
6888: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6889: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6890: p_context1 => p_project_id,
6891: p_context2 => NULL,
6892: p_context3 => p_resource_id_tbl(i),

Line 6889: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

6885: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
6886: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
6887: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_ASGMT,
6888: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
6889: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
6890: p_context1 => p_project_id,
6891: p_context2 => NULL,
6892: p_context3 => p_resource_id_tbl(i),
6893: p_commit => FND_API.G_TRUE,

Line 7080: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;

7076: --if p_validate_only=false and there are no errors then start the workflow process.
7077: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg =0 THEN
7078:
7079: IF p_asgn_update_mode = 'Forecast' THEN
7080: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;
7081: ELSE
7082: -- update BasicInfo or Candidate
7083: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;
7084: END IF;

Line 7083: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;

7079: IF p_asgn_update_mode = 'Forecast' THEN
7080: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS;
7081: ELSE
7082: -- update BasicInfo or Candidate
7083: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;
7084: END IF;
7085:
7086: --start the mass WF
7087: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(

Line 7087: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(

7083: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_ASGMT_BASIC_INFO;
7084: END IF;
7085:
7086: --start the mass WF
7087: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
7088: p_mode => l_wf_mode
7089: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
7090: ,p_assignment_id_tbl => p_assignment_id_tbl
7091: ,p_assignment_name => p_assignment_name

Line 7089: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE

7085:
7086: --start the mass WF
7087: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
7088: p_mode => l_wf_mode
7089: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
7090: ,p_assignment_id_tbl => p_assignment_id_tbl
7091: ,p_assignment_name => p_assignment_name
7092: ,p_assignment_type => p_assignment_type
7093: ,p_staffing_priority_code => p_staffing_priority_code

Line 7458: p_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN

7454:
7455: --if successful and update mode is 'update forecast'
7456: --then call forecast API to generate forecast items
7457: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
7458: p_update_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS THEN
7459:
7460: --dbms_output.put_line('calling PA_FORECASTITEM_PVT.Create_Forecast_Item');
7461:
7462: PA_FORECASTITEM_PVT.Create_Forecast_Item(

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

7475:
7476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7477: l_assignment_id_tbl(i) := NULL;
7478:
7479: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
7480: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
7481: p_source_type2 => p_update_mode,
7482: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
7483: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

Line 7480: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

7476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7477: l_assignment_id_tbl(i) := NULL;
7478:
7479: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
7480: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
7481: p_source_type2 => p_update_mode,
7482: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
7483: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
7484: p_context1 => p_project_id,

Line 7482: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,

7478:
7479: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
7480: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
7481: p_source_type2 => p_update_mode,
7482: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
7483: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
7484: p_context1 => p_project_id,
7485: p_context2 => p_assignment_id_tbl(i),
7486: p_context3 => NULL,

Line 7483: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,

7479: PA_MESSAGE_UTILS.save_messages(p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
7480: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
7481: p_source_type2 => p_update_mode,
7482: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
7483: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
7484: p_context1 => p_project_id,
7485: p_context2 => p_assignment_id_tbl(i),
7486: p_context3 => NULL,
7487: p_commit => FND_API.G_TRUE,