Search Results template_items_buttons




Overview
Explore in AI Chat

Overview

APPS.ICX_REQ_TEMPLATES is a PL/SQL package that underpins the Oracle EBS iProcurement requisition template and requisition express functionality. It is declared with AUTHID CURRENT_USER and is owned by the APPS schema. The package is responsible for rendering and managing the hierarchical template structure used to build shopping cart contents, exposing template nodes, template line items, and the item submission flow that ultimately creates requisition lines. In the context of Oracle EBS 12.1.1 and 12.2.2, this package is tightly coupled to the self-service procurement pages served through the Oracle Web Agent (OWA/PLSQL) toolkit, which is reflected in the presence of HTF, HTP, and OWA_UTIL among the referenced modules.

Functionally, the package bridges the iProcurement user interface and the underlying purchasing data model. It supports "requisition templates" — reusable, pre-defined groupings of items or services that a requester can select from when creating a non-catalog or catalog requisition. The submit_items procedure, which is the object the user searched for, is central to this workflow: it governs the act of adding template items into a shopping cart for subsequent checkout.

Key Procedures and Functions

The package exposes eight documented procedures:

  • GetTemplateTop — Retrieves the top-level entries of the requisition template hierarchy for a given organization, with an optional emergency indicator. It typically seeds the root nodes of the template tree displayed to the requester.
  • Templates — Renders or returns the template listing for the current page window, supporting pagination through start and end row parameters plus a filter clause.
  • GetTemplateChildren — Returns the child nodes of a specified template node, enabling expansion of the template tree in the user interface.
  • Template_Items — Retrieves the items associated with a template or template node for the requested row range.
  • Template_Items_Display — Produces the display representation of template items, formatting them for the OWA-rendered page.
  • Template_Items_Buttons — Generates the action buttons associated with the template item display, such as add, remove, or continue.
  • Submit_Items — Processes the selected template items and places them into the shopping cart identified by the cart ID. It accepts row-range parameters, a filter predicate, an express name, an optional emergency flag, pagination controls, and array parameters (Quantity and v_sequence_num) that carry per-item quantities and ordering. This procedure is the primary entry point for committing template selections into the cart.
  • Total_Page — Computes and renders page totals, including the counts of rows and quantities added versus updated, the order total, and the destination organization, so the shopping cart summary can be presented accurately.

Tables Accessed

The package reads and writes against the following documented objects via APPS synonyms:

  • ICX_SHOPPING_CARTS and ICX_SHOPPING_CART_LINES — the shopping cart header and line structures into which submitted template items are placed.
  • ICX_PARAMETERS — iProcurement configuration parameters that influence template behavior.
  • MTL_SYSTEM_ITEMS_KFV — the key-flexfield view of inventory items, used to describe the items appearing in templates.
  • PO_REQEXPRESS_HEADERS and PO_REQEXPRESS_LINES — the requisition express definition tables that define template groupings.
  • PO_REQUISITION_LINES_S — the requisition line base table where approved submissions ultimately materialize.
  • PO_HEADERS and PO_LINES — purchasing document tables consulted during the submission context.
  • DUAL — used for single-row scalar evaluations.
  • HTF, HTP, OWA_UTIL, PLITBLM — the OWA toolkit modules used to render HTML output and manage array/bulk data.

Usage Notes

ICX_REQ_TEMPLATES is invoked primarily from the iProcurement self-service pages rendered through the Oracle Web Agent. The template browsing and item selection screens call GetTemplateTop, Templates, GetTemplateChildren, Template_Items, Template_Items_Display, and Template_Items_Buttons to build the interactive tree. When the user confirms a selection, Submit_Items is called to move the chosen items, with their quantities and sequence numbers, into the active shopping cart, and Total_Page is then used to refresh the cart summary.

Because the package relies on OWA and HTF/HTP procedures, it is intended to run within the web/OWA session rather than as a standalone database API. The submit_items procedure's array parameters are available through ICX_OWA_PARMS, reinforcing its role as a web-layer driver rather than a public, generic requisition API.

It is referenced by one other package and should be treated as a supporting internal component. For customizations, developers should avoid direct calls where possible and instead extend behavior through the supported iProcurement personalization and extension mechanisms, since OWA-based packages of this vintage carry dependencies on session state, flexfields, and the ICX parameters configuration. Proper testing across both 12.1.1 and 12.2.2 is advised because the underlying OWA runtime and shopping cart schema have subtle differences between releases.