Search Results get_ship_from_org_id

Overview

ASO_SHIPMENT_PVT is a private PL/SQL package in the Oracle E-Business Suite Order Management and Advanced Pricing (ASO) module, owned by the APPS schema and secured with AUTHID CURRENT_USER. It encapsulates the shipment-level business logic used by Oracle Quoting to manage the shipment records associated with a quote line and to resolve the party and site identifiers that drive shipping, invoicing, and customer-facing address information. The package header dates from Release 11i-era development (as indicated by the $Header identifier) and remains the underlying implementation referenced by higher-level public APIs such as ASO_QUOTE_PUB in both the 12.1.1 and 12.2.2 application releases.

The package is classified as a PVT (private) API, meaning it is not intended for direct invocation by external or customer-written code. Its procedures and functions are consumed internally by other ASO packages and by the quoting application layer to keep shipment data consistent with the parent quote header and quote line.

Key Procedures and Functions

The documented interface exposes fourteen procedures and functions, each targeting a discrete element of shipment and party resolution:

• DELETE_SHIPMENT — Removes a shipment record associated with a quote line. It observes the standard Oracle API conventions, accepting an API version number, an initialization flag for the message list, and a commit flag, while returning the standard x_return_status, x_msg_count, and x_msg_data output parameters. The shipment to be deleted is identified through the quote line record and shipment record structures defined in ASO_QUOTE_PUB.
• GET_SHIP_TO_SITE_ID — Returns the ship-to site identifier for a given quote header, quote line, and shipment combination.
• GET_SHIP_TO_PARTY_SITE_ID — Resolves the party site identifier corresponding to the ship-to location on the shipment.
• GET_INVOICE_TO_PARTY_SITE_ID — Derives the invoice-to party site for a quote header and line.
• GET_CUST_TO_PARTY_SITE_ID — Derives the customer-facing party site identifier for a quote header and line.
• GET_PARTY_NAME — Returns the formatted party name associated with a customer account or party site, typically assembled from the person or organization name held in HZ_PARTIES.
• GET_PARTY_FIRST_NAME, GET_PARTY_MID_NAME, GET_PARTY_LAST_NAME — Return the individual name components of a party, supporting the party-name resolution used in quoting and order documentation. The GET_PARTY_MID_NAME function specifically returns the middle name element where the party is a person and the name is stored in structured form.
• GET_SHIP_FROM_ORG_ID — Returns the ship-from inventory organization identifier for a shipment.
• GET_SHIP_METHOD_CODE — Returns the shipping method code (carrier and service level) applicable to a shipment.
• GET_DEMAND_CLASS_CODE — Returns the demand class code used for scheduling and availability determination on the shipment.
• GET_SHIP_TO_CUST_ACCOUNT_ID — Returns the customer account identifier associated with the ship-to location.

Tables Accessed

The package operates against both the quoting data model and the Oracle Trading Community Architecture (TCA) model, accessing these through APPS synonyms:

• ASO_SHIPMENTS — The primary shipment record for a quote line; read and updated by DELETE_SHIPMENT and the various GET_* functions.
• ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL — Parent quote structures used to resolve header- and line-level context for site and party lookups.
• ASO_QUOTE_LINE_DETAILS — Line detail attributes referenced during shipment resolution.
• ASO_FREIGHT_CHARGES — Freight data associated with the shipment.
• HZ_PARTIES, HZ_RELATIONSHIPS, HZ_CUST_ACCT_SITES, and HZ_CUST_SITE_USES — The TCA tables used to resolve party names, person name components, and ship-to, invoice-to, and customer site identifiers.

Usage Notes

Because ASO_SHIPMENT_PVT is a private API, it is not called directly from Oracle Forms or from customer extensions in supported configurations. It is invoked internally by public quoting APIs and by other ASO packages — the metadata records that seven packages reference it — to validate and maintain shipment records during quote entry, quote revision, and order conversion. The GET_PARTY_MID_NAME function and its sibling name functions are typically exercised when the quoting application formats the full party name for display on quotes, order documentation, or customer-facing confirmations, where the middle name of a person party must be reconstructed from the structured name columns in HZ_PARTIES. Standard API conventions apply: callers should inspect x_return_status and process the message stack returned through x_msg_count and x_msg_data, and should manage transaction boundaries explicitly using the p_commit parameter.