DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_STATUSES

Line 293: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

Line 442: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

Line 727: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

723: PROCEDURE Execute_Staff_Assign_From_Open
724: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
725: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
726: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%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

Line 728: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

724: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
725: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
726: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%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

Line 729: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

725: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
726: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%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

Line 730: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

726: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%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

Line 820: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

816: --
817: PROCEDURE Staff_Assign_From_Open
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

Line 821: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

817: PROCEDURE Staff_Assign_From_Open
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

Line 826: ,p_assignment_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
828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
829: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
830: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 968: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

964: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
965: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
966: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
967: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
968: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
969: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
970: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
971: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
972: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 1141: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

1137: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1138: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1139: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1140: ,p_calendar_name IN jtf_calendars_tl.calendar_name%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

Line 1346: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

1342: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
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

Line 1431: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

1427: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
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

Line 1642: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

1638: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1639: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1640: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1641: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1642: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1643: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1644: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1645: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1646: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR