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_PROJECT_STATUSES

Line 55: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

51: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
52: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
53: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
56: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
57: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 564: l_assignment_status_name PA_PROJECT_STATUSES.project_status_name%TYPE;

560: l_return_status VARCHAR2(1);
561: l_schedulable_flag VARCHAR2(1);
562: l_msg_index_out NUMBER;
563: l_menu_id NUMBER;
564: l_assignment_status_name PA_PROJECT_STATUSES.project_status_name%TYPE;
565: l_job_id NUMBER;
566: l_error_message_code fnd_new_messages.message_name%TYPE;
567: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
568: l_location_country_code pa_locations.country_code%TYPE;

Line 863: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

859: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
860: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
862: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
863: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
864: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
865: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
866: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
867: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 915: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;

911: l_msg_index_out NUMBER;
912: l_msg_count NUMBER;
913: l_msg_data VARCHAR2(2000);
914: l_valid_flag VARCHAR2(1);
915: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;

Line 916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;

912: l_msg_count NUMBER;
913: l_msg_data VARCHAR2(2000);
914: l_valid_flag VARCHAR2(1);
915: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;

Line 1224: -- defined in pa_project_statuses.

1220: --
1221: -- Validate Status code
1222: --
1223: -- need to convert from assignment status types to the status type
1224: -- defined in pa_project_statuses.
1225:
1226: --don't need to validate status if copying a team role
1227:
1228: IF p_asgn_creation_mode <> 'COPY' THEN

Line 1876: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

1872: PROCEDURE Execute_Staff_Assign_From_Open
1873: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
1874: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1875: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1876: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1877: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1878: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1879: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1880: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

Line 1877: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

1873: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
1874: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1875: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1876: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1877: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1878: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1879: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1880: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1881: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

Line 1878: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

1874: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1875: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1876: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1877: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1878: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1879: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1880: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1881: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1882: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

Line 1879: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

1875: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1876: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1877: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1878: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1879: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1880: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1881: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1882: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1883: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 2018: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

2014:
2015: PROCEDURE Staff_Assign_From_Open
2016: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
2017: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
2018: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2019: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2020: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2021: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2022: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

Line 2019: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

2015: PROCEDURE Staff_Assign_From_Open
2016: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
2017: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
2018: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2019: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2020: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2021: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2022: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2023: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

Line 2024: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

2020: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2021: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2022: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2023: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
2024: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2025: ,p_api_version IN NUMBER := 1.0
2026: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2027: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2028: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 3108: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

3104: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
3105: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
3106: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
3107: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
3108: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
3109: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
3110: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
3111: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
3112: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 3430: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

3426: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
3427: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3428: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3429: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3430: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
3431: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3432: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3433: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3434: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 3463: l_status_code pa_project_statuses.project_status_code%TYPE;

3459: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
3460: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3461: l_project_id pa_projects.project_id%TYPE;
3462: l_resource_source_id pa_resources.resource_id%TYPE;
3463: l_status_code pa_project_statuses.project_status_code%TYPE;
3464: l_project_role_id pa_project_role_types.project_role_id%TYPE;
3465: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
3466: l_location_country_code fnd_territories.territory_code%TYPE;
3467: l_calendar_id jtf_calendars_b.calendar_id%TYPE;

Line 3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;

3472: l_resource_type_id NUMBER;
3473: l_error_message_code fnd_new_messages.message_name%TYPE;
3474: l_msg_index_out NUMBER;
3475: l_valid_flag VARCHAR2(1);
3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
3478: l_object_type pa_project_subteams.object_type%TYPE;
3479: l_object_id pa_project_subteams.object_id%TYPE;
3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

Line 3481: l_project_status_name pa_project_statuses.project_status_name%TYPE;

3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
3478: l_object_type pa_project_subteams.object_type%TYPE;
3479: l_object_id pa_project_subteams.object_id%TYPE;
3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
3481: l_project_status_name pa_project_statuses.project_status_name%TYPE;
3482: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
3483: l_record_version_check VARCHAR2(1) := 'Y';
3484: l_pending_wf_check VARCHAR2(1) := 'Y';
3485: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;

Line 3487: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;

3483: l_record_version_check VARCHAR2(1) := 'Y';
3484: l_pending_wf_check VARCHAR2(1) := 'Y';
3485: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
3486: l_ret_code VARCHAR2(1);
3487: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;
3488:
3489: l_temp_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
3490: l_temp_fcst_job_group_id NUMBER;
3491: l_temp_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;

Line 3492: l_temp_status_code pa_project_statuses.project_status_code%TYPE;

3488:
3489: l_temp_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
3490: l_temp_fcst_job_group_id NUMBER;
3491: l_temp_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
3492: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
3493: l_temp_calendar_id NUMBER;
3494: l_temp_fcst_job_id NUMBER;
3495: l_temp_exp_organization_id NUMBER;
3496: l_temp_expenditure_org_id NUMBER;

Line 3539: pa_project_statuses ps

3535:
3536: CURSOR get_project_system_status_code IS
3537: SELECT ps.project_system_status_code
3538: FROM pa_project_assignments asgn,
3539: pa_project_statuses ps
3540: WHERE asgn.assignment_id = l_assignment_rec.assignment_id
3541: AND asgn.status_code = ps.project_status_code(+);
3542:
3543: /* Bug 2590938 Begin */

Line 3754: -- defined in pa_project_statuses.

3750: (l_project_status_name <> FND_API.G_MISS_CHAR AND l_project_status_name IS NOT NULL) THEN
3751: -- Validate Status code
3752: --
3753: -- need to convert from assignment status types to the status type
3754: -- defined in pa_project_statuses.
3755:
3756: IF l_assignment_rec.assignment_type = 'OPEN_ASSIGNMENT' THEN
3757:
3758: l_project_status_type := 'OPEN_ASGMT';

Line 5136: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;

5132: l_msg_count NUMBER;
5133: l_msg_index_out NUMBER;
5134: l_assignment_rec assignment_rec_type;
5135: l_resource_id pa_resources_denorm.resource_id%TYPE;
5136: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
5137: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
5138:
5139: BEGIN
5140:

Line 5448: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

5444: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5445: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5446: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5447: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5448: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5449: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5450: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
5451: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
5452: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 5742: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

5738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5739: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5740: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5741: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5742: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5743: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5744: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
5745: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
5746: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 6565: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

6561: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6562: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
6563: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
6564: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
6565: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6566: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
6567: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
6568: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
6569: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR