DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on FND_TERRITORIES_TL

Line 60: ,p_location_country_name IN fnd_territories_tl.territory_short_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
64: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 903: ,p_location_country_name IN fnd_territories_tl.territory_short_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
907: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 939: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;

935: l_new_role_list_id pa_role_lists.role_list_id%TYPE;
936: l_new_calendar_id pa_project_assignments.calendar_id %TYPE;
937: l_new_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
938: -- Bug: 4537865
939: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
940: l_location_country_code fnd_territories.territory_code%TYPE;
941: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
942: l_return_status VARCHAR2(1);
943: l_error_message_code fnd_new_messages.message_name%TYPE;

Line 3233: ,p_location_country_name IN fnd_territories_tl.territory_short_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
3237: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 4365: ,p_location_country_name IN fnd_territories_tl.territory_short_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
4369: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 4393: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;

4389: l_project_id pa_projects.project_id%TYPE;
4390: l_resource_source_id pa_resources.resource_id%TYPE;
4391: l_status_code pa_project_statuses.project_status_code%TYPE;
4392: l_project_role_id pa_project_role_types.project_role_id%TYPE;
4393: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
4394: l_location_country_code fnd_territories.territory_code%TYPE;
4395: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
4396: l_return_status VARCHAR2(1);
4397: l_tp_amount_type_desc VARCHAR2(80);

Line 6429: ,p_location_country_name IN fnd_territories_tl.territory_short_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
6433: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 6723: ,p_location_country_name IN fnd_territories_tl.territory_short_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
6727: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 6945: ,p_location_country_name IN fnd_territories_tl.territory_short_name%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
6949: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 7189: ,p_location_country_name IN fnd_territories_tl.territory_short_name%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
7193: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 7584: ,p_location_country_name IN fnd_territories_tl.territory_short_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
7588: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR