Results for “top_bill_sequence_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OEXVWCAN is a PL/SQL package in the APPS schema that supports the Oracle Order Management (OM) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to perform the numbering, validation, and configuration-checking logic that governs sales order lines and their associated sub-entities. The package name (OEXVWCAN) is consistent with the Order Management "OEX" prefix used for order entry and configuration-related utilities, and the header comment indicates an original authoring date of 1999 with later porting changes.

Functionally, OEXVWCAN addresses the need to derive and assign the correct line numbers for shipment schedules, base (model) lines, and option lines within a configured or unconfigured sales order. It also answers a set of boolean-style questions about a line's context — whether a subtree exists, whether a line participates in a configuration, whether open picking slips are present, whether price adjustments exist, and which security object applies. These checks are essential to maintaining the integrity of order line hierarchies and to ensuring that downstream processes (picking, pricing, shipping) act on the correct lines.

Key Procedures and Functions

The package declares nine documented functions:

• SHIPMENT_SCHEDULE_NUMBER — returns the shipment schedule line number for a given parent, service parent, shipment schedule line, or line number context.
• BASE_LINE_NUMBER — returns the base line number, used to identify the model or base line within a configuration.
• OPTION_LINE_NUMBER — returns the option line number, used to identify option lines that belong to a configured item.
• SUBTREE_EXISTS — returns a VARCHAR2 indicator of whether a subtree exists for a given line and its real parent line.
• IN_CONFIGURATION — returns a VARCHAR2 indicator of whether a line, given its parent, item type code, and service parent, is part of a configuration.
• OPEN_PICKING_SLIPS — returns a VARCHAR2 indicator of whether open picking slips exist for a line and component code, relevant to shipment execution.
• PRICE_ADJUST_EXISTS — returns a VARCHAR2 indicator of whether price adjustments exist for a given header and line.
• TOP_BILL_SEQUENCE_ID — returns the top bill sequence identifier for a line and parent line, supporting bill-of-material sequence tracking.
• SECURITY_OBJECT — returns a VARCHAR2 value identifying the security object applicable to a line, based on parent line, shipment schedule line, service parent, and line type code.

The package is compiled with AUTHID CURRENT_USER, and several functions carry PRAGMA RESTRICT_REFERENCES declarations (WNDS, WNPS), indicating they are intended to be side-effect free and callable from SQL.

Tables Accessed

Per the ETRM metadata, OEXVWCAN references the following tables through APPS synonyms:

• SO_DISCOUNT_LINES — consulted to support discount and promotion logic, most likely in the context of the configuration or line-number validation checks.
• SO_PRICE_ADJUSTMENTS — consulted to determine whether price adjustments exist for a given header and line, supporting the PRICE_ADJUST_EXISTS function.

These references are read-oriented; the package's role is to validate and derive values rather than to maintain transactional data.

Usage Notes

OEXVWCAN is an internal Order Management utility. It is typically invoked from Order Management forms, from other OM packages, and from concurrent programs that process sales order lines, configurations, and shipments. The ETRM metadata indicates the package is referenced by two other packages, confirming its role as a shared dependency in the OM code base. Customizations should call its public functions rather than duplicate the numbering and validation logic, and because the package is compiled AUTHID CURRENT_USER with RESTRICT_REFERENCES pragmas, callers should be aware of the privileges of the invoking schema.