DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_STATUSES

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

290: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
291: ,p_resource_name IN pa_resources.name%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

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

439: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
440: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
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

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

724: PROCEDURE Execute_Staff_Assign_From_Open
725: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
726: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
727: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
729: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
730: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
731: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
732: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

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

725: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
726: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
727: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
729: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
730: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
731: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
732: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
733: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR

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

726: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
727: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_assignment_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
729: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
730: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
731: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
732: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
733: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
734: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

823: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
825: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
826: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
827: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
828: ,p_api_version IN NUMBER := 1.0
829: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
830: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
831: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

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

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

1235: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1236: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1237: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1238: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1239: ,p_project_status_name IN pa_project_statuses.project_status_name%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

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

1441: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1442: ,p_project_name IN pa_projects_all.name%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

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

1526: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1527: ,p_project_name IN pa_projects_all.name%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

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

1737: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1738: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1739: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1740: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
1741: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1742: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
1743: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1744: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1745: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR