DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ROLE_TYPES

Line 57: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

53: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
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

Line 412: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

408:
409:
410: PROCEDURE Exec_Create_Assign_With_Def
411: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
412: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
413: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
414: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
415: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
416: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

Line 538: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

534:
535:
536: PROCEDURE Create_Assign_With_Def
537: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
538: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
539: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
540: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
541: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
542: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

Line 865: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
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

Line 3148: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

3144: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
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

Line 3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

3431: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
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

Line 3464: l_project_role_id pa_project_role_types.project_role_id%TYPE;

3460: l_assignment_id pa_project_assignments.assignment_id%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);

Line 5450: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

5446: ,p_project_number IN pa_projects_all.segment1%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

Line 5744: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

5740: ,p_project_number IN pa_projects_all.segment1%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

Line 6605: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

6601: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
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