Results for “delete_candidates”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RES_MANAGEMENT_AMG_PUB is a public PL/SQL package in the APPS schema that serves as the central application programming interface for resource management within Oracle Projects. It exposes the business logic used to define staffing requirements, build and maintain assignments, manage candidate records, and administer competences and team-role structures across the resource management lifecycle. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as a PUB API, indicating that its procedures are the sanctioned entry points for external callers, including other Oracle Projects packages, Oracle Forms, and customer extensions. The package name follows the Oracle Projects naming convention, where the AMG suffix denotes Application Message Generation-style public APIs that wrap validation, concurrency control, and error handling around the underlying resource management private packages.

Key Procedures and Functions

The documented interface comprises sixteen procedures spanning four functional areas. The requirements group — CREATE_REQUIREMENTS, UPDATE_REQUIREMENTS, DELETE_REQUIREMENTS, STAFF_REQUIREMENTS, and COPY_TEAM_ROLES — governs the creation, maintenance, removal, staffing, and role-copying of resource requirements and team templates. The assignment group — CREATE_ASSIGNMENTS, UPDATE_ASSIGNMENTS, DELETE_ASSIGNMENTS, and SUBMIT_ASSIGNMENTS — manages the project assignment records that link people to project roles and handles the submission of those assignments for approval or workflow processing. The competence group — CREATE_REQUIREMENT_COMPETENCE, UPDATE_REQUIREMENT_COMPETENCE, and DELETE_REQUIREMENT_COMPETENCE — maintains the competence definitions attached to requirements, supporting skills matching during candidate searches. The candidate group — CREATE_CANDIDATES, UPDATE_CANDIDATES, DELETE_CANDIDATES, and CREATE_CANDIDATE_LOG — maintains candidate records and their associated audit log entries. All procedures return standard Oracle error-handling structures, consistent with FND_API conventions.

Tables Accessed

The package reads and writes a broad slice of the Oracle Projects and Oracle HRMS data model through APPS synonyms. Requirement, assignment, and candidate data are persisted in PA_CANDIDATES, PA_PROJECT_ASSIGNMENTS, PA_RESOURCE_ASSIGNMENTS, PA_PROJECT_SUBTEAM_PARTIES, PA_RESOURCE_LIST_MEMBERS, and PA_RESOURCES_DENORM, with team-template structures held in PA_TEAM_TEMPLATES. Project and reference data are sourced from PA_PROJECTS_ALL, PA_PROJECT_STATUSES, PA_LOCATIONS, and PA_IMPLEMENTATIONS_ALL, while person information is drawn from PER_ALL_PEOPLE_F. Security and audit context is supplied by FND_USER, FND_OBJECTS, and FND_GRANTS, which support function security and role-based access checks. The package also depends on PA_INTERFACE_UTILS_PUB and the PL/SQL table type PA_NUM_TBL_TYPE for bulk operations.

Usage Notes

PA_RES_MANAGEMENT_AMG_PUB is invoked primarily from the Oracle Projects resource management forms and from concurrent programs that process requirements, candidates, and assignments in batch. Four packages document dependencies on it — PA_ASSIGNMENTS_PUB, PA_CANDIDATE_UTILS, PA_HR_UPDATE_API, and PA_SEARCH_PVT — reflecting its role as a shared service layer for assignment, candidate, HR update, and search functionality. Custom integrations should call these procedures rather than inserting directly into the underlying tables, because the API applies validation, security, and denormalization logic. As with all PUB APIs, callers should initialize the FND_API global variables, check the returned exception status, and commit only after successful completion of the API call.