Search Results pa_client_extn_project_wf




Overview
Explore in AI Chat

Overview

PA_CLIENT_EXTN_PROJECT_WF is an APPS-owned PL/SQL package in Oracle E-Business Suite Projects (PA). It serves as a client extension hook for the Oracle Workflow-driven project approval process. In EBS 12.1.1 and 12.2.2, project approvals are launched and orchestrated through the PA_PROJECT_WF workflow, and this package provides the extension points that allow an implementation to substitute or augment the standard approver resolution and workflow initiation logic without modifying Oracle-owned code. The package is classified as an "OTHER" API, meaning it is not part of the supported public API surface in the same manner as the PA_* public APIs, but is instead intended to be customized as a documented extension seam.

The package is a dependency of PA_PROJECT_WF, confirming that the core project workflow calls into this extension package during its execution. Its status is VALID, and it is backed by a package specification and package body as reflected in ETRM. The presence of two documented procedures indicates a narrow, purpose-built interface focused exclusively on the project approval workflow.

Key Procedures and Functions

ETRM documents two procedures or functions within this package:

  • SELECT_PROJECT_APPROVER — Provides the approver determination logic used by the workflow. Implementations override or extend this routine so that the correct approver (or approver list) is resolved based on the project's attributes, organization, or customer-defined rules rather than relying solely on Oracle's seeded routing.
  • START_PROJECT_WF — Responsible for initiating the project workflow. This routine is invoked to launch the workflow process for an eligible project, and is the entry point through which the approval cycle is started.

Parameter lists are not enumerated in the ETRM excerpt and are therefore intentionally omitted here; implementers should inspect the package specification in the target instance before customizing.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • PA_PROJECTS / PA_PROJECTS_ALL — The primary project definition tables; used to identify the project and its key attributes during approver selection and workflow start.
  • PA_PROJECT_STATUSES, PA_PROJECT_TYPES, PA_OBJ_STATUS_CHANGES — Support the determination of the project's current status and the status transitions relevant to the approval life cycle.
  • PA_WORKFLOW_ITEMKEY_S — The workflow item key sequence used to generate unique workflow identifiers for newly initiated project workflows.
  • PER_ALL_PEOPLE_F and FND_USER — Source the approver's person and user records, linking the resolved approver to a valid application user.
  • DUAL — Used for single-row expressions and sequence or function evaluation.

Usage Notes

This package is not typically invoked directly from a form; it is called by the PA_PROJECT_WF workflow process during project approval. Implementations customize it to enforce organization-specific approver routing, for example by deriving the approver from project type, project manager, or organizational hierarchy. Because it is designated as an extension package, the standard practice is for customers to copy its logic into their own custom package and update the workflow definition to call the custom package, rather than editing the APPS-owned object in place — a point of particular importance in 12.2.2, where Online Patching and the adoption of the new file system require that customizations be layered through supported mechanisms. Only one other package references this extension: PA_PROJECT_WF.