DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ROLE_TYPES

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

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

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

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

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

539: -- {End Of Comments}
540: --
541: PROCEDURE Exec_Create_Assign_With_Def
542: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
543: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
544: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
545: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
546: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
547: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

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

627: -- {End Of Comments}
628: --
629: PROCEDURE Create_Assign_With_Def
630: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
631: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
632: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
633: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
634: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
635: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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