Search Results mass_process_approval_result

Overview

PA_ASSIGNMENT_APPROVAL_PUB is the public application programming interface (API) within Oracle Projects that governs the approval lifecycle of project resource assignments. In Oracle E-Business Suite 12.1.1 and 12.2.2, project managers and resource managers create, modify, and staff assignments against project roles and work types; those changes must pass through a structured approval process before they become effective. PA_ASSIGNMENT_APPROVAL_PUB exposes that process to external callers, allowing assignment submissions, status transitions, reversions, cancellations, and mass approvals to be driven programmatically rather than exclusively through the Projects forms or workflow.

The package belongs to the APPS schema and holds a VALID status. It is classified as a PUB package, meaning it is an intended public interface whose signatures are supported for customer and partner extension, as opposed to the companion private package PA_ASSIGNMENT_APPROVAL_PVT, which contains the internal implementation and is not directly callable. The presence of both a public specification and a package body confirms that the procedures and functions are implemented and executable in the EBS instance.

Key Procedures and Functions

The documented package exposes nine procedures and functions, which collectively cover the complete assignment approval cycle:

• START_ASSIGNMENT_APPROVALS — initiates the approval process for one or more assignments, routing them to the appropriate approver.
• REVERT_TO_LAST_APPROVED — returns an assignment to its most recently approved state, discarding pending or rejected changes.
• POPULATE_CHANGED_ITEMS_TABLE — loads the set of modified assignment attributes into a PL/SQL table structure for downstream processing and comparison.
• CHANGE_ASSIGNMENT_STATUS — applies a new approval status to an assignment as it progresses through the workflow.
• GET_CURRENT_APPROVER — determines and returns the approver currently responsible for a pending assignment.
• CANCEL_ASSIGNMENT — cancels an assignment and removes it from the active approval chain.
• MASS_SUBMIT_FOR_ASGMT_APRVL — submits a batch of assignments for approval in a single invocation.
• MASS_ASSIGNMENT_APPROVAL — approves a group of assignments together.
• MASS_PROCESS_APPROVAL_RESULT — processes the outcome of a mass approval run, applying results across the affected assignments.

The mass-oriented procedures support the Resource Management and Projects concurrent programs that handle high volumes of assignments where individual processing would be impractical.

Tables Accessed

The package reads and writes the core Projects assignment and project tables. PA_PROJECT_ASSIGNMENTS is the primary transactional table holding assignment records and approval state, while PA_PROJECTS_ALL, PA_PROJECT_STATUSES, and PA_PROJECT_SUBTEAMS supply project context and status validation. PA_ROLE_LISTS and PA_PROJECT_ROLE_TYPES provide role definitions for approver determination. PA_LOCATIONS describes assignment work locations, and PA_ROLE_PROFILES_PUB interacts with role profile data.

Approver resolution draws on Oracle HR and People data: PER_PEOPLE_F, PER_JOBS, PER_JOB_GROUPS, PER_ORGANIZATION_STRUCTURES, PER_ORGANIZATION_UNITS, HR_ORGANIZATION_UNITS, and HR_ALL_ORGANIZATION_UNITS_TL. Notification and security tables include FND_NEW_MESSAGES, FND_USER, and FND_TERRITORIES_TL/VL. JTF_CALENDARS_TL supplies calendar information used in scheduling and approval timing. The package also declares and consumes several PL/SQL collection types — PA_DATE_TBL_TYPE, PA_NUM_TBL_TYPE, and the PA_VARCHAR2_* table types — to pass bulk assignment identifiers and attributes between its mass procedures.

Usage Notes

PA_ASSIGNMENT_APPROVAL_PUB is invoked in several contexts. Oracle Projects forms for assignment and resource management call it when users submit, approve, or reject assignments. Workflow-enabled processes, notably those referenced through PA_ASGMT_WFSTD, use it to advance assignments through approval states. Concurrent programs performing mass approval and mass submission rely on the MASS_* procedures. Several other packages call it directly, including PA_ASSIGNMENT_APPROVAL_PVT, PA_ASSIGNMENT_UTILS, PA_MASS_ASGMT_TRX, PA_RES_MANAGEMENT_AMG_PUB, PA_ROLE_PROFILES_PUB, PA_SCHEDULE_PUB, PA_SCHEDULE_PVT, and PA_STAFFED_ASSIGNMENT_PVT, confirming its role as a shared service layer across the Projects and Resource Management modules. Custom integrations extending the assignment approval process should call this PUB package rather than the underlying PVT implementation to remain upgrade-safe.