Search Results gmf_get_transfer_price_pub




Overview

APPS.INV_IC_ORDER_PUB is a public PL/SQL package within the Oracle E-Business Suite Inventory (INV) module. Its classification as a PUB (public) API indicates that it exposes supported, externally callable interfaces intended for use by other Oracle EBS application modules, and in some cases by customer-written extensions. The package functions within the intercompany (IC) order processing framework, which coordinates the movement of material and the generation of internal orders between distinct inventory organizations that belong to the same or related legal entities.

The package is owned by the APPS schema and holds a VALID status in the ETRM registry for release 12.2.2 (and by extension the 12.1.1 code line, which shares the intercompany architecture). Its most notable documented attribute is its role as a dependency for other packages: the ETRM metadata records that INV_IC_ORDER_PUB is referenced by two other packages — GMF_GET_TRANSFER_PRICE_PUB and MTL_QP_PRICE — establishing it as a foundational layer in the transfer-pricing and intercompany-order dependency chain.

Key Procedures and Functions

The ETRM documentation excerpt provided for this object lists zero documented procedures or functions. Consequently, no individual subprogram names, parameter signatures, or return types can be asserted from the source metadata, and none are invented here.

What the metadata does establish is the package's dependency position. It references only SYS.STANDARD, indicating that its compilation relies on no other APPS-level package for its own definition, while it is itself consumed by:

  • GMF_GET_TRANSFER_PRICE_PUB — the Process Manufacturing (GMF) pricing package that determines the transfer price applied to intercompany and intransit movements.
  • MTL_QP_PRICE — the inventory-side pricing package that resolves and applies pricing for material transactions.

It is also listed as referenced by GMF_GET_TRANSFER_PRICE_PUB and MTL_QP_PRICE a second time in the dependent-code listing, reflecting both package specification and body references. This dual dependency confirms that INV_IC_ORDER_PUB supplies shared intercompany order logic that the pricing packages invoke rather than reimplement.

Tables Accessed

The ETRM metadata does not enumerate the base tables read or written by INV_IC_ORDER_PUB. No tables are documented, and none are listed with APPS synonym mappings. Given that the package is not documented as referencing any APPS-level object, its table access is proxied indirectly through the packages that call it or is resolved at runtime through standard APPS synonyms not captured in this excerpt. Practically, intercompany order packages of this class operate over the intercompany order, transfer pricing, and inventory transaction tables maintained by the Inventory and Order Management modules, but the specific table inventory for this package is not confirmed by the supplied metadata.

Usage Notes

Because INV_IC_ORDER_PUB is an API-classified, public package in the APPS schema, it is intended to be invoked through supported interfaces rather than modified directly. Its documented consumers — GMF_GET_TRANSFER_PRICE_PUB and MTL_QP_PRICE — indicate that the typical invocation path runs through intercompany transfer pricing and inventory transaction pricing flows rather than through direct end-user forms.

Custom code that needs intercompany order behavior should call the package's public procedures rather than reproducing its logic, preserving upgrade safety across 12.1.1 and 12.2.2. The user search term "gmf_get_transfer_price_pub" aligns with this usage pattern: that Process Manufacturing pricing package is the documented caller, and INV_IC_ORDER_PUB should be understood as a supporting dependency of it. Any customization should be validated against the package specification in the target instance, since the ETRM excerpt records no signatures.