Search Results get_resource_assignment_id

Overview

PA_CI_SUPPLIER_PKG is an Oracle Applications (APPS) PL/SQL package body within the Oracle E-Business Suite Project Accounting (PA) module. Its purpose is to manage the persistence of supplier cost control item data associated with the Project Supplier Costing / Control Item (CI) framework. Control Items represent changes, commitments, or supplier-facing cost events raised against a project, task, and resource assignment. This package encapsulates the DML and concurrency operations required to insert, update, delete, and lock those supplier control item records in a controlled, API-like manner.

The package is classified as OTHER in the ETRM 12.2.2 metadata, meaning it is not a formally published public API but is consumed internally by the Project Accounting application. The source header identifies the file as PACISIIB.pls (version 120.24, dated 2010/06/24), placing it in the supplier cost integration logic introduced for Release 12.1.3 supplier costing requirements and carried forward into 12.1.1 and 12.2.2 environments. The package ships with a private helper, PRINT_MSG, used purely for debug/log output through PA_DEBUG.

Key Procedures and Functions

The documented 12.2.2 metadata lists five procedures/functions; the excerpt expands on INSERT_ROW.

• INSERT_ROW – Creates a new supplier control item transaction record. It returns the generated ROWID and CI_TRANSACTION_ID via NOCOPY OUT parameters, and accepts a broad set of attributes covering the control item type/ID, vendor and purchasing document identifiers (PO_HEADER_ID, PO_LINE_ID, ADJUSTED_TRANSACTION_ID), currency and change amount/type/description, standard WHO audit columns, and resource-assignment context (Task_Id, Resource_List_Mem_Id, From/To dates). Costing attributes include Estimated, Quoted, Negotiated, and Burdened cost plus Revenue. Release 12.1.3 supplier costing additions include expenditure type/organization, change reason code, quote negotiation reference, and need-by date. It returns X_RETURN_STATUS and X_ERROR_MSG_CODE for error handling.
• UPDATE_ROW – Modifies an existing supplier control item record identified by its key, applying the changed supplier cost attributes and WHO audit columns.
• DELETE_ROW – Removes a supplier control item record from the control items table, keyed by its identifier.
• LOCK_ROW – Issues a SELECT ... FOR UPDATE on the target row to serialize concurrent modification before update or delete.

Tables Accessed

The package reads and writes the core supplier cost objects PA_CI_SUPPLIER_DETAILS and its _S (secondary/audit) counterpart, while the primary control item header resides in PA_CONTROL_ITEMS. Resource assignment context is resolved through PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_ASSIGNMENTS_S, PA_RESOURCE_ASGN_CURR, and PA_RESOURCE_LIST_MEMBERS. Task and project structure references draw on PA_TASKS, PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, and PA_PROJ_ELEM_VER_STRUCTURE. Currency and rate information comes from PA_BILL_RATES_ALL, while budgeting/versioning uses PA_BUDGET_VERSIONS and forecast planning uses PA_PROJ_FP_OPTIONS. PLITBLM is a standard PL/SQL index-by table used internally for batch/ID lists.

Usage Notes

PA_CI_SUPPLIER_PKG is referenced by five other packages, indicating it is a foundational layer beneath higher-level supplier costing APIs rather than being called directly from a form or concurrent program. In practice it is invoked from Project Accounting supplier cost online pages, the Supplier Cost adjustment flows, and concurrent integration programs that stage control item changes. The user search term "get_resource_assignment_id" reflects the common dependency of these procedures on resolving a resource assignment for a given control item; that resolution relies on PA_RESOURCE_ASSIGNMENTS and PA_RESOURCE_LIST_MEMBERS, which are among the documented tables. Consistent with its OTHER classification, custom code should prefer the officially published Project Accounting control item APIs, treating PA_CI_SUPPLIER_PKG as an internal implementation whose signature may change between 12.1.1, 12.1.3, and 12.2.2.