DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_LOCATIONS

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

293: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
294: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
295: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
296: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
297: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
298: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
299: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
300: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

294: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
295: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
296: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
297: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
298: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
299: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
300: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

296: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
297: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
298: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
299: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
300: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
301: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
304: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

442: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
443: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
444: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
445: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
446: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
447: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
448: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
449: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
450: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

443: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
444: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
445: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
446: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
447: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
448: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
449: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
450: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
451: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

445: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
446: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
447: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
448: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
449: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
450: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
451: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
452: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
453: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM

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

1006: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1007: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1008: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1009: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1010: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1011: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1012: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1013: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1014: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1007: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1008: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1009: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1010: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1011: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1012: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1013: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1014: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1015: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

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

1009: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1010: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1011: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1012: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1013: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1014: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1015: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1016: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1017: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1241: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1242: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1243: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1244: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1245: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1246: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1247: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1248: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1249: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1242: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1243: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1244: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1245: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1246: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1247: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1248: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1249: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1250: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1244: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1245: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1246: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1247: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1248: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1249: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1250: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1251: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1252: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1444: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1445: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1446: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1447: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1448: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1449: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1450: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1451: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1452: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1445: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1446: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1447: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1448: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1449: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1450: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1451: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1452: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1453: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1447: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1448: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1449: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1450: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1451: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1452: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1453: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1454: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1455: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

1529: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1530: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1531: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1532: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1533: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1534: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1535: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1536: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1537: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1530: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1531: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1532: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1533: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1534: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1535: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1536: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1537: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1538: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1532: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1533: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1534: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1535: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1536: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1537: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1538: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1539: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1540: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

1598: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1599: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1600: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1601: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1602: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1603: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1604: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1605: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1606: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1599: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1600: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1601: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1602: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1603: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1604: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1605: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1606: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1607: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1601: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1602: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1603: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1604: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1605: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1606: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1607: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1608: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1609: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1678: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1679: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1682: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1685: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1686: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1679: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1682: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1685: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1686: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1687: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1682: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1685: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1686: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1687: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1688: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1689: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1778: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1780: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1781: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1782: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1783: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1784: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1785: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1786: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1780: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1781: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1782: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1783: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1784: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1785: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1786: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1787: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

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

1781: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1782: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1783: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1784: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1785: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1786: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1787: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1788: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1789: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR