Search Results interface_cwk_timecards




Overview
Explore in AI Chat

Overview

PA_PJC_CWK_UTILS is a utility package in the Oracle E-Business Suite Projects (PA) module that supports the integration of Oracle Purchasing commitment and rate-based supplier costs with Oracle Projects timecard processing. The package name reflects its role: "PJC" denotes Projects cost (subledger accounting) functionality, "CWK" refers to contractor work / timecards, and "UTILS" indicates it is a helper package rather than a transactional API. Its primary business purpose is to determine how costs originating from Purchasing documents — specifically rate-based purchase order lines and distributions — should be treated when contractor timecards are interfaced into Projects. The package dates to the 11i era (header revision 120.0, dated 2005) and remains in the 12.1.1 and 12.2.2 application schema, where it is classified as an OTHER API under the APPS schema. It is referenced by nineteen other packages, indicating broad internal reuse across contractor timecard and Purchasing-to-Projects integration flows.

Key Procedures and Functions

  • IS_RATE_BASED_LINE — A wrapper function around the Purchasing API PO_PA_INTEGRATION_GRP.is_rate_based_line. It accepts a purchase order line identifier and a PO distribution identifier, and returns a flag indicating whether the referenced PO line is rate-based. This answers the core question of whether a committed cost should be treated as a rate-based (labor-style) cost rather than a conventional supplier cost.
  • EXISTS_PRJ_CWK_RBTC — Returns 'Y' if there exist project-related rate-based purchase orders for any project within a given operating unit (P_Org_Id), otherwise 'N'. It is documented as being called from the Project Implementations form when the INTERFACE_CWK_TIMECARDS option is toggled between Y and N. This guards against turning off the interface setting while dependent rate-based contractor work still exists.
  • IS_CWK_TC_XFACE_ALLOWED — For a given project (P_Project_Id), this function identifies whether the contractor work timecard interface is allowed for the project's operating unit. When enabled, associated costs must be interfaced as labor costs; when disabled, they must be interfaced as supplier costs. This drives the cost classification logic in downstream processing.

Tables Accessed

The package reads from several Projects and Purchasing tables via APPS synonyms:

  • PA_IMPLEMENTATIONS_ALL — Provides the implementation-level option values, including the INTERFACE_CWK_TIMECARDS setting that governs interface behavior per operating unit.
  • PA_PROJECTS_ALL — Used to resolve project and operating unit context, particularly to correlate projects with the organizational parameter in EXISIS_PRJ_CWK_RBTC and the project-level lookup in IS_CWK_TC_XFACE_ALLOWED.
  • PO_DISTRIBUTIONS_ALL — Supplies purchase order distribution data used to determine whether a given commitment line is rate-based.
  • DUAL — Standard single-row selection for returning computed flag values.
  • PLITBLM — The PL/SQL table-type storage used by the package's global PL/SQL table variables (G_PoLineIdTab, G_IsRBLineTab, G_ExCwkRbTCOrgIdTab, G_CwkTCXfaceAllowedTab) for caching results across calls.

Usage Notes

PA_PJC_CWK_UTILS is an internal utility, not a public integration API, and is invoked primarily by other Oracle Projects packages and by the Project Implementations setup form. The most visible call path is the validation triggered when the INTERFACE_CWK_TIMECARDS implementation option is changed, where EXISTS_PRJ_CWK_RBTC prevents disabling the interface when rate-based contractor work commitments remain. Because it exposes caching PL/SQL tables, repeated calls within a session are optimized. Custom code should generally avoid direct invocation and instead use the underlying Purchasing API, but developers extending contractor timecard or Purchasing-to-Projects interfaces may reference these functions to classify rate-based lines consistently.