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_LOCATIONS

Line 58: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

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
60: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
62: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 59: ,p_location_region IN pa_locations.region%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
60: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
62: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
63: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 61: ,p_location_country_code IN pa_locations.country_code%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
60: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
62: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
63: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 603: l_location_country_code pa_locations.country_code%TYPE;

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;
604: l_resource_id pa_resources.resource_id%TYPE;
605: l_msg_count NUMBER;
606: l_msg_data VARCHAR2(4000);
607: l_work_type_id NUMBER;

Line 624: FROM pa_projects_all ppa,pa_locations pl

620:
621: -- Start of Performance Fix 4898314 SQL ID 14905800
622: CURSOR get_project_defaults IS
623: SELECT ppa.work_type_id,ppa.calendar_id ,pl.location_id ,pl.country_code
624: FROM pa_projects_all ppa,pa_locations pl
625: WHERE project_id = l_assignment_rec.project_id
626: AND PPA.LOCATION_ID = PL.LOCATION_ID(+) ;
627: -- End of Performance Fix 4898314 SQL ID 14905800
628:

Line 901: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

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
903: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
904: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
905: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 902: ,p_location_region IN pa_locations.region%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
903: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
904: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
905: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
906: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 904: ,p_location_country_code IN pa_locations.country_code%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
903: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
904: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
905: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
906: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
907: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
908: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM

Line 3231: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

3227: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3228: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3229: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3230: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3231: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3232: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3233: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3234: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3235: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 3232: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

3228: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3229: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3230: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3231: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3232: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3233: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3234: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3235: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3236: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 3234: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

3230: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3231: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3232: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3233: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3234: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3235: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3236: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
3237: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3238: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

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
4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
4364: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
4365: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4366: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
4367: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 4364: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

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
4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
4364: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
4365: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4366: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
4367: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
4368: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 4366: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
4364: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
4365: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4366: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
4367: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
4368: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
4369: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
4370: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 6427: ,p_location_city IN pa_locations.city%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
6429: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6430: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6431: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 6428: ,p_location_region IN pa_locations.region%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
6429: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6430: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6431: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6432: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 6430: ,p_location_country_code IN pa_locations.country_code%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
6429: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6430: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6431: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6432: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6433: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6434: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 6721: ,p_location_city IN pa_locations.city%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
6723: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6724: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6725: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 6722: ,p_location_region IN pa_locations.region%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
6723: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6724: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6725: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6726: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 6724: ,p_location_country_code IN pa_locations.country_code%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
6723: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6724: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6725: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6726: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6727: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6728: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 6943: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

6939: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
6940: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6941: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6942: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6943: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6944: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6945: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6946: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6947: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 6944: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

6940: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6941: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6942: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6943: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6944: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6945: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6946: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6947: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6948: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 6946: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

6942: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6943: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6944: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6945: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6946: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6947: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6948: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6949: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6950: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 7187: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

7183: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
7184: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
7185: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7186: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7187: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7188: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7189: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7190: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7191: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 7188: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

7184: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
7185: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7186: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7187: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7188: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7189: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7190: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7191: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7192: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 7190: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

7186: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7187: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7188: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7189: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7190: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7191: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7192: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
7193: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
7194: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 7582: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

7578: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
7579: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7580: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7581: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
7582: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7583: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7584: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7585: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7586: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 7583: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

7579: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7580: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7581: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
7582: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7583: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7584: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7585: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7586: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
7587: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 7585: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

7581: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
7582: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7583: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7584: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7585: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7586: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
7587: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
7588: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7589: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 7672: ,pa_locations loc

7668: SELECT 'Y'
7669: INTO l_exists
7670: FROM pa_project_assignments asgn
7671: ,pa_project_subteam_parties psp
7672: ,pa_locations loc
7673: WHERE asgn.project_id = p_project_id
7674: AND asgn.assignment_id = p_assignment_id
7675: AND asgn.assignment_name = p_assignment_name
7676: AND asgn.min_resource_job_level = p_min_resource_job_level