Search Results pos_header_info_s




Overview
Explore in AI Chat

Overview

POS_HEADER_INFO_S is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its classification in the ETRM repository is "OTHER," indicating that it is a supporting utility package rather than a public, documented Open Interface or extension API. The package operates in the procurement and supplier-facing area of the application stack; its name and its relationship to POS_ASN_HEADERS_V suggest a role in exposing or deriving header-level information associated with Advance Shipment Notices (ASNs) and related purchasing documents. It is listed with a status of VALID, meaning it is a compiled, functioning object in the database rather than a stub or disabled component.

The package is positioned within the dependency chain of the ASN views used by the application, providing header information retrieval logic that those views consume. Because it surfaces header data rather than performing transactional business events, it functions as a read-oriented informational utility within the purchasing and receiving flow.

Key Procedures and Functions

The documented metadata records one exposed program unit within the package:

  • GETPAYMENTTERMS — Retrieves the payment terms applicable to a purchasing document header. This function is used to obtain the terms of payment associated with a header record so that downstream processes and views can present or evaluate the payment conditions without duplicating that lookup logic.

The repository entry does not enumerate parameter lists or return types for this function, and no additional procedures or functions are documented. The package body is present (the metadata lists a [Package Body] section), but its internal implementation is not exposed in the ETRM extract.

Tables Accessed

The package accesses the following tables, documented through APPS synonyms:

  • PO_HEADERS_ALL — The base purchasing document header table. This is the primary source for header-level attributes, including the payment terms returned by GETPAYMENTTERMS. Access is consistent with a read operation used to resolve header context.
  • POS_ASN_SHOP_CART_DETAILS — A supplier-facing shop cart detail table associated with ASN processing. Access to this table indicates the package participates in the ASN header information flow, linking shop cart detail records to the header-level information it exposes.

Both tables are referenced only through the APPS schema synonyms, so the package respects the standard EBS access convention.

Usage Notes

POS_HEADER_INFO_S is referenced by the view POS_ASN_HEADERS_V, which is the most significant and concrete integration point documented in the metadata. Through that view, the package's header information logic becomes available to forms, concurrent programs, and any other consumer querying the ASN headers view.

Typical invocation patterns for a package of this class include:

  • Selection through the POS_ASN_HEADERS_V view when an ASN header record is displayed or processed.
  • Direct calls from custom PL/SQL or database objects that require payment terms resolution for a purchasing header.
  • Internal calls from within the package body itself, as indicated by its self-referencing dependency entry.

Because the package is not classified as a public API and only one program unit is documented, it should be treated as a dependency of the ASN views rather than as a supported extension point. Customizations that reference it directly should account for the possibility that internal behavior may change between patch levels of 12.1.1 and 12.2.2. When payment terms must be retrieved in custom code, verifying the current signature of GETPAYMENTTERMS against the deployed instance is advisable before reliance.