Search Results get_entity_defaults

Overview

OUTSIDE_PROC_SV is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified by ETRM as an "OTHER" API. It is a server-side utility package used by the Oracle Manufacturing and Projects execution flows to resolve default attribute values for work in process (WIP) entities, WIP lines, unit types, and project/task numbering. The package is not a public, declarative business API; instead it provides supporting lookup and defaulting logic invoked by higher-level forms, concurrent programs, and dependent packages that require entity and line-level defaults during discrete manufacturing transactions.

The source header indicates the original file (POXOPROB.pls, version 115.6) was last shipped in 2003, meaning the package logic is stable and unchanged across EBS 12.1.1 and 12.2.2. The APPS synonym and the "SV" suffix convention place it alongside other shared service packages used by Oracle's WIP, BOM, and Projects modules.

Key Procedures and Functions

ETRM documents 11 procedures/functions in the package body. The named entries include:

• GET_ENTITY_DEFAULTS — Retrieves the WIP entity name and entity type for a given WIP entity ID and destination organization, querying WIP_ENTITIES. Returns silently when no matching row exists and raises through PO_MESSAGE_S.SQL_ERROR for unexpected errors.
• TEST_GET_ENTITY_DEFAULTS — A diagnostic wrapper that calls GET_ENTITY_DEFAULTS with supplied entity and organization IDs to verify defaulting behavior during development or troubleshooting.
• TEST_GET_WIP_LINE_DEFAULTS — Companion test procedure for the WIP line defaulting logic.
• TEST_GET_UNIT_TYPE — Diagnostic wrapper for the unit type resolution routine; this is the object associated with the user search term "get_unit_type".
• GET_PROJECT_TASK_NUM — Resolves the project/task number used when linking WIP or BOM activity to Oracle Projects.

Additional procedures exist in the package body (for example GET_WIP_LINE_DEFAULTS and GET_UNIT_TYPE themselves), bringing the documented total to 11. The naming pattern established by GET_ENTITY_DEFAULTS — an IN ID/set of context parameters and IN OUT NOCOPY output variables — is repeated across the defaulting routines.

Tables Accessed

The package reads from the following APPS synonyms:

• WIP_ENTITIES — source of WIP entity name and entity type defaults.
• WIP_LINES — source of WIP line-level default attributes.
• WIP_OPERATION_RESOURCES — operation resource information used during line defaulting.
• BOM_RESOURCES — resource master data used in default resolution.
• PA_PROJECTS_ALL, PA_TASKS, PJM_SEIBAN_NUMBERS — Oracle Projects tables used by GET_PROJECT_TASK_NUM to derive project/task and Seiban numbering.

Usage Notes

OUTSIDE_PROC_SV is invoked indirectly. ETRM records it as referenced by one other package, indicating it is called by a companion service package rather than directly by forms or users. The TEST_* procedures are intended only for development and unit testing and should not be scheduled as concurrent programs. Because the package performs simple SELECT ... INTO lookups and returns silently on NO_DATA_FOUND, callers must supply valid WIP entity and organization IDs and be prepared for unpopulated output variables. No seeded concurrent program, form, or public API consumes this package directly; customizations that call it should replicate the standard defensive error handling, since unexpected errors are logged and re-raised via PO_MESSAGE_S.