Search Results authorized_to_ship

Overview

APPS.OE_LINE_CL_DEP_ATTR is a dependent attribute clearing package within the Oracle Order Management module of Oracle E-Business Suite. Its name derives from its role: OE (Order Entry), Line, CL (clear), and Dep_Attr (dependent attributes). The package body implements a large family of small, uniformly structured procedures, each of which is responsible for clearing or resetting a specific dependent attribute on an order line when a parent attribute changes value. The header comment $Header: OEXNLINB.pls 115.19 2003/11/07 identifies the source file as OEXNLINB.pls, confirming it as a long-standing Order Management library component that has been maintained from the 11i generation through 12.1.1 and 12.2.2.

In Oracle Order Management, order line attributes are classified as independent or dependent. When a user changes an independent attribute (for example, the customer or the ship-to organization), changes to dependent attributes that flow from it must be propagated or cleared so that stale or contradictory values are not retained on the line. OE_LINE_CL_DEP_ATTR serves as the central clearing mechanism, delegating the actual work to OE_Line_Util_Ext.Clear_Dependent_Attr, a utility that receives the attribute identifier and the line record images before and after the change.

Key Procedures and Functions

The package exposes 62 documented procedures, each named after the dependent attribute it governs. The excerpt illustrates the standard pattern: a procedure accepts p_initial_line_rec and p_old_line_rec as input (both typed as OE_AK_ORDER_LINES_V%ROWTYPE) and p_x_line_rec as an IN OUT NOCOPY record, then calls OE_Line_Util_Ext.Clear_Dependent_Attr passing the relevant OE_Line_Util.G_* attribute constant.

• ACCOUNTING_RULE / ACCOUNTING_RULE_DURATION — clear the accounting rule and its duration when the governing line context changes.
• AGREEMENT — clears the agreement reference associated with the line.
• CUST_PO_NUMBER — resets the customer purchase order number on the line.
• DELIVER_TO_CONTACT / DELIVER_TO_ORG — clear the deliver-to contact and organization when a controlling attribute changes.
• DEMAND_CLASS — clears the demand class assignment.
• DEP_PLAN_REQUIRED — resets the dependent planning flag.
• EARLIEST_ACCEPTABLE_DATE / LATEST_ACCEPTABLE_DATE — clear the acceptable date window.
• FOB_POINT / FREIGHT_CARRIER / FREIGHT_TERMS — clear shipping and freight-related defaults.
• INTERMED_SHIP_TO_CONTACT / INTERMED_SHIP_TO_ORG — clear intermediate ship-to information.
• INVOICE_TO_CONTACT / INVOICE_TO_ORG — clear invoice-to contact and organization.
• INVOICING_RULE — clears the invoicing rule (distinct from the accounting rule).
• ITEM_IDENTIFIER_TYPE / ITEM_REVISION — clear item identification and revision values.
• ACTUAL_ARRIVAL_DATE / ACTUAL_SHIPMENT_DATE — clear actual arrival and shipment dates.

Note that the user search term authorized_to_ship is not among the 62 documented procedures in this package in the version catalogued. Authorized-to-ship is an order line flag typically controlled by separate Order Management validation and defaulting logic; where a clearing routine for it exists, it would be catalogued under its own name rather than within this list.

Tables Accessed

No standalone tables are documented as directly referenced via APPS synonyms in the ETRM metadata. All work is performed against the OE_AK_ORDER_LINES_V view, which supplies the row type used by every procedure signature. The procedures themselves do not perform DML directly; they manipulate the in-memory line record passed by the caller. Persistence occurs later when the calling Order Management framework saves the modified line record. The absence of documented table synonyms reflects this design: OE_LINE_CL_DEP_ATTR is a pure attribute-management layer.

Usage Notes

OE_LINE_CL_DEP_ATTR is invoked by the Order Management attribute dependency framework rather than by end users directly. When the Order Organizer, Sales Order form, or the Order Management APIs process a change to an independent attribute, the dependency engine calls the corresponding procedure in this package to clear affected dependent attributes before validation and defaulting run. The metadata records that the package is referenced by one other package, consistent with its role as a shared library. Customizations that introduce new dependent attributes should extend this package or an equivalent, following the established pattern of passing the initial, old, and modified line records to OE_Line_Util_Ext.Clear_Dependent_Attr. Because the package operates on record images rather than committed data, it is safe to invoke within both interactive form sessions and programmatic order import flows in 12.1.1 and 12.2.2.