Search Results get_default_template

Overview

APPS.ICX_REQ_TEMPLATES is a PL/SQL package body that implements the server-side rendering and navigation logic for the Oracle E-Business Suite iProcurement and Internet Procurement requisition template browser. Its primary purpose is to allow a user to browse a tree of purchasing requisition templates, expand template nodes on demand, display template line items, and submit the selected lines into a shopping cart or requisition. In the Oracle EBS 12.1.1 and 12.2.2 code lines this package sits in the self-service procurement (ICX) schema and is tightly coupled to the Oracle Web Toolkit (HTP/HTF/OWA_UTIL) since it generates HTML fragments dynamically rather than relying on Oracle Forms.

The package is classified in the ETRM repository as "OTHER," meaning it is not a public, supported API with a stable signature; it is an internal implementation package. This classification matters because the private function get_default_template, which is not declared in the package specification, is the object of the user's search. That function retrieves the user's default requisition template identifier, using icx_sec.getID(icx_sec.PV_USER_REQ_TEMPLATE), and applies emergency handling logic when the caller passes v_emergency = 'YES'.

Key Procedures and Functions

The ETRM metadata documents eight procedures/functions in this package. GETTEMPLATETOP renders the top-level template tree, establishing the initial HTML frame for the browser. TEMPLATES is the principal entry point that drives template display and selection. GETTEMPLATECHILDREN is invoked by the dummy-form POST built in the private createDummyPage procedure, expanding child nodes of a selected template. TEMPLATE_ITEMS presents the line items belonging to a template. TEMPLATE_ITEMS_DISPLAY handles the visual rendering of those items. TEMPLATE_ITEMS_BUTTONS generates the action buttons (such as add-to-cart or submit) on the item page. SUBMIT_ITEMS processes the user's selected items, transferring them into the shopping cart structures. TOTAL_PAGE rounds out the page rendering by producing totals and summary information. The private helper createDummyPage builds a hidden HTML form used to post node identifiers and indices back to GetTemplateChildren, and the private function get_default_template resolves the session user's default template.

Tables Accessed

The package reads and writes several core procurement and iProcurement tables through APPS synonyms. ICX_SHOPPING_CARTS and ICX_SHOPPING_CART_LINES store the active cart and its line entries when items are submitted. MTL_SYSTEM_ITEMS_KFV supplies item descriptions and key flexfield values for display. PO_HEADERS and PO_LINES provide purchasing document context. PO_REQEXPRESS_HEADERS, PO_REQEXPRESS_LINES, and PO_REQUISITION_LINES_S hold the requisition express template definitions and requisition lines used to seed a template. ICX_PARAMETERS supplies system and user-level iProcurement settings. DUAL, HTP, HTF, OWA_UTIL, and PLITBLM are the supporting pseudo-tables and Web Toolkit packages used for HTML output and utility calls.

Usage Notes

ICX_REQ_TEMPLATES is normally invoked indirectly by the iProcurement requisition template JSP/HTML pages rather than by direct calls from Oracle Forms or concurrent programs. Because the procedures act as servlet-like entry points, they are commonly reached through the Oracle HTTP Server or the EBS web application tier. The package is referenced by one other package in the ETRM metadata, so customizations should treat its procedures as internal and version-sensitive, particularly the private get_default_template function, which is not exposed in the specification and may change between 12.1.1 and 12.2.2 without notice.