Search Results get_department_id

Overview

APPS.WIP_DEFAULT_RES is a private PL/SQL package body in the Oracle E-Business Suite Work in Process (WIP) module. Its business function is to supply defaulting logic for resource-related attributes during WIP material and resource transaction processing. The package body is identified by the header comment WIPDRESB.pls 120.4.12020000.3 (dated 2013/03/12), confirming it is a maintained production object shipped with the 12.1.1 and 12.2.2 releases.

The package declares a set of package globals typed against public WIP API records, including g_Res_rec (WIP_Transaction_PUB.Res_Rec_Type), g_RCV_txn (Rcv_Txn_Type), g_WIP_op_res (WIP_Op_Res_Type), g_PO_Dstr (PO_Dist_Type), g_Wip_Entities_rec (Wip_Entities_Rec_Type), and g_BOM_res (BOM_Resource_Type). These globals act as a cache: the private get_***_attr procedures populate them once, and subsequent attribute lookups default from the cached values rather than re-querying. The header comment explicitly notes this design exists because "populating each attribute individually will be a performance hit."

Key Procedures and Functions

The ETRM 12.2.2 metadata classifies this package under API classification OTHER and documents one procedure: ATTRIBUTES. Consistent with the source excerpt, this procedure participates in the attribute-defaulting framework that the package exposes. The excerpt additionally shows a private procedure, get_rti_attr, which populates all defaulting attributes from RCV_TRANSACTIONS_INTERFACE in a single pass.

The naming convention visible in the source — procedures named get_<attr_name> — indicates that the public entry point for the user's search term, get_department_id, is one such defaulting accessor. It returns the department identifier defaulted for a WIP resource transaction, drawing on BOM_DEPARTMENTS and the cached BOM resource record. The package therefore exposes a family of scalar defaulting routines (department, resource, and related identifiers) rather than a single monolithic API, and get_department_id should be understood as one member of that family. Parameter lists are not documented in the available metadata and are not reproduced here.

Tables Accessed

The documented table references through APPS synonyms reflect the package's defaulting responsibilities across WIP, Bills of Material, Costing, Purchasing, and Receiving:

• WIP_LINES, WIP_OPERATIONS, WIP_OPERATION_RESOURCES — source of WIP entity, operation sequence, and resource sequence context for defaulting.
• BOM_RESOURCES, BOM_DEPARTMENTS — resource and department definitions used by defaulting routines such as get_department_id.
• MTL_SYSTEM_ITEMS, MTL_PARAMETERS, MTL_TRANSACTION_REASONS — item attributes, organization parameters, and transaction reason codes.
• RCV_TRANSACTIONS_INTERFACE, RCV_PARAMETERS — inbound receiving interface rows read by get_rti_attr.
• PO_DISTRIBUTIONS_ALL, PO_LINES_ALL — purchasing distribution and line data used for PO-sourced resource transactions.
• WIP_EMPLOYEE_LABOR_RATES — labor rate derivation for resource defaults.
• CST_ACTIVITIES, FND_USER — costing activity context and user auditing columns.

Usage Notes

WIP_DEFAULT_RES is not intended for direct invocation by end users. It is consumed by the Receiving and WIP transaction processing flows — notably the WIP_Transaction_PUB and RCV interfaces — to derive attribute values when callers supply FND_API.G_MISS_* placeholders. Because it is referenced by one other documented package, customizations should prefer calling supported public APIs; direct calls to internal routines such as get_department_id risk dependency on undocumented signatures. The package is relevant for both 12.1.1 and 12.2.2 environments; the 120.4.12020000.3 version line indicates it has been carried forward into the 12.2 AD/online patching file system without functional redesign.