Search Results outside_proc_sv




Overview
Explore in AI Chat

Overview

OUTSIDE_PROC_SV is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. In the ETRM 12.2.2 metadata it is classified as an API of type OTHER, indicating that it is a supporting utility rather than a formally published public interface such as an OPEN or PLSGLB API. The package resides in the APPS schema and is reported with a status of VALID. Its dependency map is deliberately shallow: within the database it references only SYS.STANDARD, and it is referenced directly by only one other package, PO_WF_BUILD_ACCOUNT_INIT, in addition to its own package body. This pattern is characteristic of a narrowly scoped helper package that encapsulates specialized parameter resolution and defaulting logic for outside processing in the manufacturing and procurement flows.

The name and the object inventory strongly suggest that the package resolves defaulting values for outside processing operations — that is, manufacturing operations performed by an external supplier rather than in-house. The presence of procedures whose names reference entity defaults, WIP line defaults, unit type, and project/task numbers confirms that the package assembles contextual defaults from Work in Process, Bills of Material, and Oracle Projects data.

Key Procedures and Functions

The documented public surface comprises eleven units, of which the following representative entries are named in the ETRM extract:

  • NAME — a standard identity or naming constant/function commonly present in Oracle packages; in this context it returns the package identifier used for diagnostic and logging purposes.
  • TEST_GET_ENTITY_DEFAULTS — a testing or diagnostic entry point that retrieves default attribute values for a WIP entity, allowing validation of the defaulting logic without invoking the production wrapper.
  • TEST_GET_WIP_LINE_DEFAULTS — returns the defaulted values applicable to a WIP line, including the operation and resource context.
  • TEST_GET_UNIT_TYPE — resolves the unit type associated with an outside processing operation, used to determine the basis on which resources are consumed.
  • GET_PROJECT_TASK_NUM — derives the project and task number combination associated with the manufacturing or purchasing transaction.

The metadata does not expose parameter lists, and none are asserted here. The recurring TEST_ prefix indicates that several of these units are intended for verification and troubleshooting rather than direct production invocation.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • WIP_ENTITIES and WIP_LINES — supply the discrete job header and line context from which entity and line defaults are derived.
  • WIP_OPERATION_RESOURCES and BOM_RESOURCES — define the operations and resources that carry the outside processing flag and the associated resource parameters.
  • PA_PROJECTS_ALL and PA_TASKS — provide project and task information for project-referenced manufacturing and procurement transactions.
  • PJM_SEIBAN_NUMBERS — supplies the project accounting numbering context used in project and task resolution.

Usage Notes

OUTSIDE_PROC_SV is an internal helper. Its only documented dependent, PO_WF_BUILD_ACCOUNT_INIT, belongs to the Purchasing workflow account-generation logic, which indicates that the package is invoked from within workflow and purchasing integration code rather than from an end-user form directly. Because it is classified as OTHER and carries TEST_ prefixed procedures, it should not be treated as a certified extension point; customizations should call the surrounding supported APIs instead. When troubleshooting outside processing defaulting, the TEST_ procedures may be invoked manually in a development or test environment to inspect the resolved entity, line, unit type, and project/task values, while the production path is exercised through the dependent Purchasing workflow package.