DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_LOOKUPS

Line 294: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

290: ,p_resource_name IN pa_resources.name%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

Line 443: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

Line 731: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

727: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
729: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
730: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
731: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
732: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
733: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
734: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
735: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 732: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

728: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
729: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
730: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
731: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
732: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
733: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
734: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
735: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
736: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 822: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

818: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
819: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
820: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
821: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
822: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
823: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
825: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
826: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 823: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

819: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
820: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
821: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
822: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
823: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
825: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
826: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
827: ,p_api_version IN NUMBER := 1.0

Line 1007: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1003: ,p_resource_name IN pa_resources.name%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

Line 1145: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1141: ,p_project_status_name IN pa_project_statuses.project_status_name%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

Line 1347: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1343: ,p_project_name IN pa_projects_all.name%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

Line 1432: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1428: ,p_project_name IN pa_projects_all.name%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

Line 1502: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1498: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1499: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1500: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1501: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1502: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1503: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1504: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1505: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1506: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 1582: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1578: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1579: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1580: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1581: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1582: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1583: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1584: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1585: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1586: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

1677: ,p_resource_name IN pa_resources.name%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