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 568: l_location_country_code pa_locations.country_code%TYPE;

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;
569: l_resource_id pa_resources.resource_id%TYPE;
570: l_msg_count NUMBER;
571: l_msg_data VARCHAR2(4000);
572: l_work_type_id NUMBER;

Line 589: FROM pa_projects_all ppa,pa_locations pl

585:
586: -- Start of Performance Fix 4898314 SQL ID 14905800
587: CURSOR get_project_defaults IS
588: SELECT ppa.work_type_id,ppa.calendar_id ,pl.location_id ,pl.country_code
589: FROM pa_projects_all ppa,pa_locations pl
590: WHERE project_id = l_assignment_rec.project_id
591: AND PPA.LOCATION_ID = PL.LOCATION_ID(+) ;
592: -- End of Performance Fix 4898314 SQL ID 14905800
593:

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

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

Line 867: ,p_location_region IN pa_locations.region%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
868: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
869: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
870: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
871: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 869: ,p_location_country_code IN pa_locations.country_code%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
868: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
869: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
870: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
871: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
872: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
873: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM

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

3145: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3146: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3147: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3148: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3149: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3150: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3151: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3152: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3153: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

3146: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3147: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3148: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3149: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3150: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3151: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3152: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3153: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3154: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

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

3148: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3149: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3150: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3151: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3152: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3153: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3154: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
3155: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3156: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

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
3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3436: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3437: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3438: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3439: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3440: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

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
3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3436: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3437: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3438: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3439: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3440: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3441: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3436: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3437: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3438: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3439: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3440: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3441: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3442: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3443: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 5451: ,p_location_city IN pa_locations.city%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
5453: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5454: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5455: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 5452: ,p_location_region IN pa_locations.region%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
5453: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5454: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5455: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
5456: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 5454: ,p_location_country_code IN pa_locations.country_code%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
5453: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5454: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5455: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
5456: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5457: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5458: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 5745: ,p_location_city IN pa_locations.city%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
5747: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5748: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5749: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 5746: ,p_location_region IN pa_locations.region%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
5747: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5748: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5749: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
5750: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 5748: ,p_location_country_code IN pa_locations.country_code%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
5747: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5748: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5749: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
5750: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5751: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5752: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

5963: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
5964: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
5965: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5966: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5967: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
5968: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
5969: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5970: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5971: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

5964: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
5965: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5966: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5967: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
5968: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
5969: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5970: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5971: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5972: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

5966: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5967: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
5968: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
5969: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5970: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5971: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5972: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5973: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5974: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

6207: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
6208: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6209: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6210: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6211: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6212: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6213: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6214: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6215: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

6208: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6209: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6210: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6211: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6212: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6213: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6214: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6215: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6216: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

6210: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6211: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6212: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6213: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6214: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6215: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6216: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6217: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6218: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

6602: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
6603: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6604: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6605: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6606: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6607: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6608: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6609: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6610: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

6603: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6604: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6605: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6606: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6607: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6608: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6609: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6610: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6611: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

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

6605: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6606: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6607: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6608: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6609: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6610: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6611: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
6612: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6613: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 6696: ,pa_locations loc

6692: SELECT 'Y'
6693: INTO l_exists
6694: FROM pa_project_assignments asgn
6695: ,pa_project_subteam_parties psp
6696: ,pa_locations loc
6697: WHERE asgn.project_id = p_project_id
6698: AND asgn.assignment_id = p_assignment_id
6699: AND asgn.assignment_name = p_assignment_name
6700: AND asgn.min_resource_job_level = p_min_resource_job_level