Search Results pa_varchar2_100_tbl_type




Overview
Explore in AI Chat

Overview

PA_PROCESS_CI_LINES_PKG is an Oracle Projects package in the APPS schema that supports the processing of capital and indirect (CI) cost lines generated by Oracle Projects' burdening and cost distribution engine. It operates alongside the public API layer, notably PA_CI_DIR_COST_PUB and PA_CI_SUPPLIER_UTILS, which rely on this package to validate, stage, and post direct cost and supplier cost transaction lines to the relevant project cost tables. The package functions as an internal processing utility rather than a public API, and its procedures are typically invoked indirectly through the cost collection and distribution workflow.

The dependency listing confirms the package consumes a family of PL/SQL collection types defined at the schema level, including PA_VARCHAR2_100_TBL_TYPE, PA_VARCHAR2_1_TBL_TYPE, PA_VARCHAR2_15_TBL_TYPE, PA_VARCHAR2_30_TBL_TYPE, PA_VARCHAR2_80_TBL_TYPE, PA_VARCHAR2_150_TBL_TYPE, PA_VARCHAR2_240_TBL_TYPE, PA_DATE_TBL_TYPE, and PA_NUM_TBL_TYPE. PA_VARCHAR2_100_TBL_TYPE is one of several standard string-indexed collection types Oracle Projects uses to pass arrays of attribute values between processing layers.

Key Procedures and Functions

Four documented procedures constitute the functional surface of the package:

  • PROCESS_PLANNING_LINES — The primary driver procedure. It processes the supplied planning lines, coordinating validation, transformation, and persistence of CI transaction data against the project planning structures.
  • INSERT_PLANNING_TRANSACTION — Handles insertion of new planning transactions into the CI detail tables.
  • DELETE_PLANNING_TRANSACTION — Removes previously staged or persisted planning transactions, supporting corrections and re-processing.
  • UPDATE_PLANNING_TRANSACTION — Applies changes to existing planning transaction records.

The parameter signatures are not exposed in the ETRM extract; the VARCHAR2, DATE, and NUM table types in the dependency list indicate that these procedures accept array-based inputs, allowing bulk processing of cost line attributes rather than row-by-row calls.

Tables Accessed

The package reads and writes project planning, resource, and CI cost data. Documented table references (through APPS synonyms) include:

Usage Notes

PA_PROCESS_CI_LINES_PKG is not intended for direct invocation by end users. It is called by PA_CI_DIR_COST_PUB and PA_CI_SUPPLIER_UTILS during CI cost processing. Customizations that extend CI cost handling should invoke the documented public API layer when possible; direct calls to this package bind to internal processing logic that is not subject to Oracle's public API compatibility guarantees. All calls should run within a standard Oracle Projects security context, with proper initialization of the APPS environment and org context, and error handling anchored to the FND_MSG_PUB message stack.