DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ROLE_TYPES

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

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

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

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

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

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

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

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

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

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

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

1240: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1241: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1242: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1243: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1244: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1245: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1246: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1247: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1248: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

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

1443: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1444: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1445: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1446: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1447: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1448: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1449: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1450: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1451: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

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

1528: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1529: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1530: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1531: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1532: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1533: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1534: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1535: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1536: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

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

1777: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1778: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1780: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1781: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1782: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1783: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1784: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1785: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR