DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_LOCATIONS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1143: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1144: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1145: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1146: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1147: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1148: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1149: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1150: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1151: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1144: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1145: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1146: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1147: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1148: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1149: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1150: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1151: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1152: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1146: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1147: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1148: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1149: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1150: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1151: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1152: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1153: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1154: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1345: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1346: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1347: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1348: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1349: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1350: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1351: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1352: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1353: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1346: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1347: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1348: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1349: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1350: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1351: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1352: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1353: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1354: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1348: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1349: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1350: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1351: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1352: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1353: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1354: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1355: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1356: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

1430: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1431: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1432: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1433: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1434: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1435: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1436: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1437: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1438: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1431: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1432: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1433: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1434: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1435: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1436: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1437: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1438: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1439: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1433: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1434: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1435: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1436: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1437: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1438: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1439: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1440: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1441: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

1499: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1500: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1501: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1502: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1503: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1504: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1505: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1506: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1507: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1500: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1501: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1502: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1503: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1504: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1505: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1506: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1507: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1508: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1502: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1503: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1504: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1505: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1506: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1507: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1508: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1509: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1510: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1579: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1580: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1581: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1582: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1583: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1584: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1585: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1586: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1587: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

1580: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1581: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1582: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1583: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1584: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1585: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1586: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1587: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1588: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

1582: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1583: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1584: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1585: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1586: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1587: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1588: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1589: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1590: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1679: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
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_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1685: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1686: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1687: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 1684: ,p_location_region IN pa_locations.region%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_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1685: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1686: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1687: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1688: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM

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

1682: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1685: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1686: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1687: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1688: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1689: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1690: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR