DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_LOOKUPS

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

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

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

895: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
896: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
897: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
898: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
899: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
900: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
901: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
902: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
903: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

1939: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1940: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1944: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1945: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1946: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1947: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

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

1940: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1944: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1945: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1946: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1947: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1948: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

2079: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
2080: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
2081: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2082: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2083: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2084: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2085: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2086: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
2087: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

2080: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
2081: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2082: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2083: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2084: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2085: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2086: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
2087: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2088: ,p_api_version IN NUMBER := 1.0

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

3225: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
3226: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3227: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3228: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3229: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3230: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3231: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3232: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3233: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

4357: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
4358: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
4359: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
4360: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
4361: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
4364: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
4365: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

6421: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
6422: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
6423: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6424: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6425: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6426: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6427: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6428: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6429: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

6715: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
6716: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
6717: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6718: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6719: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6720: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6721: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6722: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6723: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

6938: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
6939: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
6940: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6941: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6942: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6943: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6944: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6945: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6946: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

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

7182: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
7183: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
7184: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
7185: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7186: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7187: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7188: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7189: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7190: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

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

7576: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
7577: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
7578: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
7579: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7580: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7581: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
7582: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7583: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7584: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR