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 599: l_assignment_status_name PA_PROJECT_STATUSES.project_status_name%TYPE;

595: l_return_status VARCHAR2(1);
596: l_schedulable_flag VARCHAR2(1);
597: l_msg_index_out NUMBER;
598: l_menu_id NUMBER;
599: l_assignment_status_name PA_PROJECT_STATUSES.project_status_name%TYPE;
600: l_job_id NUMBER;
601: l_error_message_code fnd_new_messages.message_name%TYPE;
602: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
603: l_location_country_code pa_locations.country_code%TYPE;

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

894: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
895: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
896: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
897: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
898: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
899: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
900: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
901: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
902: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

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

946: l_msg_index_out NUMBER;
947: l_msg_count NUMBER;
948: l_msg_data VARCHAR2(2000);
949: l_valid_flag VARCHAR2(1);
950: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
951: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
952: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
953: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
954: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;

Line 951: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;

947: l_msg_count NUMBER;
948: l_msg_data VARCHAR2(2000);
949: l_valid_flag VARCHAR2(1);
950: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
951: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
952: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
953: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
954: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
955: l_object_type pa_project_subteams.object_type%TYPE;

Line 1259: -- defined in pa_project_statuses.

1255: --
1256: -- Validate Status code
1257: --
1258: -- need to convert from assignment status types to the status type
1259: -- defined in pa_project_statuses.
1260:
1261: --don't need to validate status if copying a team role
1262:
1263: IF p_asgn_creation_mode <> 'COPY' THEN

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

1935: PROCEDURE Execute_Staff_Assign_From_Open
1936: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
1937: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1938: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1939: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1940: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

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

1936: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
1937: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1938: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1939: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1940: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1944: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

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

1937: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1938: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1939: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1940: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1944: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1945: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

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

1938: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1939: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1940: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1944: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1945: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1946: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

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

2077:
2078: PROCEDURE Staff_Assign_From_Open
2079: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
2080: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
2081: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2082: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2083: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2084: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2085: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

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

2078: PROCEDURE Staff_Assign_From_Open
2079: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
2080: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
2081: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2082: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2083: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2084: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2085: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2086: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

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

2083: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2084: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2085: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2086: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
2087: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2088: ,p_api_version IN NUMBER := 1.0
2089: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2090: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2091: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

3186: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
3187: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
3188: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
3189: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
3190: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
3191: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
3192: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
3193: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
3194: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

4353: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
4354: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
4355: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
4356: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
4357: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
4358: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
4359: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
4360: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
4361: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 4391: l_status_code pa_project_statuses.project_status_code%TYPE;

4387: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
4388: l_assignment_id pa_project_assignments.assignment_id%TYPE;
4389: l_project_id pa_projects.project_id%TYPE;
4390: l_resource_source_id pa_resources.resource_id%TYPE;
4391: l_status_code pa_project_statuses.project_status_code%TYPE;
4392: l_project_role_id pa_project_role_types.project_role_id%TYPE;
4393: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
4394: l_location_country_code fnd_territories.territory_code%TYPE;
4395: l_calendar_id jtf_calendars_b.calendar_id%TYPE;

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

4400: l_resource_type_id NUMBER;
4401: l_error_message_code fnd_new_messages.message_name%TYPE;
4402: l_msg_index_out NUMBER;
4403: l_valid_flag VARCHAR2(1);
4404: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
4405: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
4406: l_object_type pa_project_subteams.object_type%TYPE;
4407: l_object_id pa_project_subteams.object_id%TYPE;
4408: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

Line 4409: l_project_status_name pa_project_statuses.project_status_name%TYPE;

4405: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
4406: l_object_type pa_project_subteams.object_type%TYPE;
4407: l_object_id pa_project_subteams.object_id%TYPE;
4408: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
4409: l_project_status_name pa_project_statuses.project_status_name%TYPE;
4410: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
4411: l_record_version_check VARCHAR2(1) := 'Y';
4412: l_pending_wf_check VARCHAR2(1) := 'Y';
4413: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;

Line 4415: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;

4411: l_record_version_check VARCHAR2(1) := 'Y';
4412: l_pending_wf_check VARCHAR2(1) := 'Y';
4413: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
4414: l_ret_code VARCHAR2(1);
4415: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;
4416:
4417: l_temp_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
4418: l_temp_fcst_job_group_id NUMBER;
4419: l_temp_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;

Line 4420: l_temp_status_code pa_project_statuses.project_status_code%TYPE;

4416:
4417: l_temp_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
4418: l_temp_fcst_job_group_id NUMBER;
4419: l_temp_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
4420: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
4421: l_temp_calendar_id NUMBER;
4422: l_temp_fcst_job_id NUMBER;
4423: l_temp_exp_organization_id NUMBER;
4424: l_temp_expenditure_org_id NUMBER;

Line 4467: pa_project_statuses ps

4463:
4464: CURSOR get_project_system_status_code IS
4465: SELECT ps.project_system_status_code
4466: FROM pa_project_assignments asgn,
4467: pa_project_statuses ps
4468: WHERE asgn.assignment_id = l_assignment_rec.assignment_id
4469: AND asgn.status_code = ps.project_status_code(+);
4470:
4471: /* Bug 2590938 Begin */

Line 4700: -- defined in pa_project_statuses.

4696: (l_project_status_name <> FND_API.G_MISS_CHAR AND l_project_status_name IS NOT NULL) THEN
4697: -- Validate Status code
4698: --
4699: -- need to convert from assignment status types to the status type
4700: -- defined in pa_project_statuses.
4701:
4702: IF l_assignment_rec.assignment_type = 'OPEN_ASSIGNMENT' THEN
4703:
4704: l_project_status_type := 'OPEN_ASGMT';

Line 6112: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;

6108: l_msg_count NUMBER;
6109: l_msg_index_out NUMBER;
6110: l_assignment_rec assignment_rec_type;
6111: l_resource_id pa_resources_denorm.resource_id%TYPE;
6112: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
6113: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
6114:
6115: BEGIN
6116:

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

6420: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
6421: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
6422: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
6423: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6424: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6425: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6426: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6427: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6428: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

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

6714: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
6715: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
6716: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
6717: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6718: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6719: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6720: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6721: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6722: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

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

7537: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
7538: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7539: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
7540: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
7541: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
7542: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
7543: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
7544: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
7545: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR