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

Line 904: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;

900: l_new_role_list_id pa_role_lists.role_list_id%TYPE;
901: l_new_calendar_id pa_project_assignments.calendar_id %TYPE;
902: l_new_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
903: -- Bug: 4537865
904: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
905: l_location_country_code fnd_territories.territory_code%TYPE;
906: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
907: l_return_status VARCHAR2(1);
908: l_error_message_code fnd_new_messages.message_name%TYPE;

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

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

Line 3465: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;

3461: l_project_id pa_projects.project_id%TYPE;
3462: l_resource_source_id pa_resources.resource_id%TYPE;
3463: l_status_code pa_project_statuses.project_status_code%TYPE;
3464: l_project_role_id pa_project_role_types.project_role_id%TYPE;
3465: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
3466: l_location_country_code fnd_territories.territory_code%TYPE;
3467: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
3468: l_return_status VARCHAR2(1);
3469: l_tp_amount_type_desc VARCHAR2(80);

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

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

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

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

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