Search Results wip_default_res




Overview
Explore in AI Chat

Overview

WIP_DEFAULT_RES is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Work in Process (WIP) transaction processing framework. Its documented purpose is to supply defaulting logic for resource transaction records used during WIP move, completion, and resource charge transactions. The package exposes a single public procedure named Attributes, which accepts a resource record structure and returns a defaulted resource record. The record types are defined in the companion package WIP_Transaction_PUB (Res_Rec_Type), indicating that WIP_DEFAULT_RES operates as a subordinate utility invoked by the broader WIP transaction public API layer.

The package is declared AUTHID CURRENT_USER, meaning it executes under the privileges of the calling schema rather than the definer. It is classified under API classification OTHER in the ETRM repository for release 12.2.2.

Key Procedures and Functions

The ETRM metadata documents one procedure: Attributes. It takes an input resource record (p_Res_rec of type WIP_Transaction_PUB.Res_Rec_Type), an optional iteration counter (p_iteration), and an IN OUT NOCOPY output record (x_Res_rec) that carries the defaulted attribute values back to the caller. The procedure's role is to populate or correct resource-level attributes—such as resource, department, activity, and rate defaults—prior to the resource transaction being written to the WIP tables. No functions are documented.

The presence of the p_iteration parameter suggests the procedure can be called repeatedly in a loop to satisfy the defaulting needed for multiple resource records in a single transaction payload.

Tables Accessed

The package reads from a defined set of setup and transaction tables via APPS synonyms. BOM_DEPARTMENTS and BOM_RESOURCES provide department and resource definitions used to validate and default resource entries. CST_ACTIVITIES and WIP_EMPLOYEE_LABOR_RATES supply costing activity and labor rate information. WIP_OPERATIONS, WIP_OPERATION_RESOURCES, and WIP_LINES supply the routing and operation context. MTL_SYSTEM_ITEMS and MTL_PARAMETERS provide item and inventory-organization setup, while MTL_TRANSACTION_REASONS supplies reason code information. FND_USER resolves user identity. RCV_PARAMETERS, RCV_TRANSACTIONS_INTERFACE, PO_LINES_ALL, and PO_DISTRIBUTIONS_ALL relate to receiving and purchasing defaults that influence resource costing in outside-processing scenarios.

Usage Notes

WIP_DEFAULT_RES is not exposed directly to end users. It is typically invoked from WIP transaction forms, the WIP resource transaction concurrent processes, or custom code that calls the WIP_Transaction_PUB API and requires resource-level defaulting before submission. The ETRM metadata indicates it is referenced by one other package, confirming its role as a subordinate utility rather than a top-level entry point. Developers extending WIP resource transactions should call WIP_Transaction_PUB for the primary transaction and rely on WIP_DEFAULT_RES for consistent defaulting behavior. Because the package is AUTHID CURRENT_USER, custom callers must ensure the invoking schema has appropriate privileges on the underlying tables.