Search Results hxc_proj_manager_approval_pkg




Overview
Explore in AI Chat

Overview

APPS.HXC_PROJ_MANAGER_APPROVAL_PKG is a server-side PL/SQL package within the Oracle E-Business Suite Time and Labor (HXC) and Projects (PA) integration layer. Its role is to support the project manager approval workflow by creating and maintaining the approval routing and time category structures that Time and Labor uses to direct submitted timecards to the correct project managers for review. The package operates as an auxiliary component of the broader HXC approval framework rather than as a standalone public API, and it is classified under the ETRM documentation as an OTHER API type.

In EBS 12.1.1 and 12.2.2, this package works alongside HXC_APPROVAL_WF_PKG, the workflow package that orchestrates timecard approval. HXC_PROJ_MANAGER_APPROVAL_PKG supplies the underlying categorization logic and recipient assignments that the workflow engine consumes. It is also self-referential, meaning portions of its own logic invoke other routines within the same package.

Key Procedures and Functions

The documented package exposes three procedures or functions:

  • CATEGORIZE_PROJECT_MANAGERS — Populates and maintains the categorization of project managers for approval purposes, grouping managers against the applicable time categories used in the approval hierarchy. This routine drives how approval recipients are identified for timecards charged to given projects.
  • CREATE_TIME_CAT — Creates a time category record, typically for use as a dynamic or system-generated approval category tied to project manager routing. It supports the automatic generation of categories that drive approval component matching.
  • REPLACE_PROJMAN_BY_SPL_ELA — Replaces the project manager approver with an alternate assignment derived from the supervisor/employee relationship (SPL/ELA), supporting substitution of the default approval recipient in scenarios where the assigned project manager is not the appropriate approver.

No parameter lists are documented in the available metadata; only purposes are provided above.

Tables Accessed

  • PA_PROJECTS_ALL — Read to identify project records and their associated managers for approval routing.
  • PER_ALL_PEOPLE_F — Read to resolve person records (project managers and alternates) with effective-dated people data.
  • FND_FLEX_VALUE_SETS — Read to resolve flexfield value set information used in category or approval validation.
  • HXC_APPROVAL_COMPS — Read/written to define approval components within styles.
  • HXC_APPROVAL_STYLES — Accessed to reference the approval style definitions driving the routing chain.
  • HXC_TIME_CATEGORIES — Written when new approval categories are created via CREATE_TIME_CAT.
  • HXC_TIME_CATEGORY_COMPS — Updated to link categories to their approval components.
  • HXC_TIME_RECIPIENTS — Read/written to associate approval recipients (project managers) with time categories.
  • PLITBLM — Used as a PL/SQL index-by table type for internal procedural logic.

Usage Notes

HXC_PROJ_MANAGER_APPROVAL_PKG is generally invoked indirectly. It is called by HXC_APPROVAL_WF_PKG during approval workflow processing and by its own internal routines, and it may be triggered from Time and Labor approval configuration or concurrent processes that build approval categories and recipient lists. It is not intended for direct ad hoc invocation by end users. Customizations should avoid modifying package internals and should instead reference documented procedures where permissible, taking a backup and validating against both 12.1.1 and 12.2.2 since internal logic can differ between releases.