Search Results get_limitsh

Overview

APPS.ICX_DATATEMPLATE_PKG is a PL/SQL package declared with AUTHID CURRENT_USER, residing in the Oracle E-Business Suite Applications (APPS) schema. It belongs to the iProcurement / Internet Consulting (ICX) product family and supports the Oracle iProcurement requisitioning and purchasing data-template framework. The package assembles structured XML and CLOB payloads, resolves descriptive flexfield attributes, and generates the page templates and data definitions consumed by the DD448 data template rendering engine used in iProcurement checkout and requisition entry flows.

Functionally, the package bridges the Oracle iProcurement user interface with the underlying purchasing data model. It queries descriptive flexfield (DFF) column usages and UDA (User Defined Attribute) templates, joins these to requisition header and line tables, and returns serialized XML fragments for addresses, contacts, authorizing officers, funds data, and miscellaneous purchasing attributes. The version header (120.3.12020000.3, dated 2013/04/18) confirms support across both the 12.1.1 and 12.2.2 code lines. The documented API classification is OTHER, indicating it is not a formally published public API but is nonetheless referenced within the application code base — including by one other package — making it relevant to customization and troubleshooting activities.

The user search term get_contactsxml corresponds directly to the documented GET_CONTACTSXML function, one of fifteen documented program units in this package.

Key Procedures and Functions

• AFTERPFORM — A form-level post-query/initialization function returning Boolean; performs setup logic when the associated Oracle Forms block is entered.
• GET_UDA_ATTR_DESC_SQL — Returns a VARCHAR2 SQL fragment used to resolve the description of a UDA attribute for a given document type, PK1 value, data type, application column name, end-user column name, attribute group, and attribute ID.
• GET_UDA_HEADER_XML — Returns an XMLType containing the UDA header attributes for the current requisition context.
• GET_ADDRESSXML — Returns a CLOB containing the address XML fragment.
• GET_CONTACTSXML — Returns a CLOB containing the contacts XML fragment; this is the object of interest when searching for get_contactsxml.
• GET_AUTH_OFFICER_XML — Returns a CLOB of the authorizing officer XML.
• GET_APPROPRIATION — Derives the appropriation value for a supplied charge account.
• GET_LIMITSH — Derives the limit (SH) value associated with a supplied charge account.
• GET_ADDRESS_FROM_LOCATION — Returns a formatted address VARCHAR2 for a given location ID.
• GET_FUNDSDATAXML — Returns a CLOB of the funds data XML fragment.
• GET_MIPR_ACC_ATTRIBUTES — Returns CLOB-based Miscellaneous Internal Purchase Requisition (MIPR) account attributes.
• GET_TEMPLATES_FOR_DD448 — Populates face-page, content-page, and data-definition template variables for the DD448 form.
• GET_TEMPLATES_FOR_DD448_2 — Variant of the above providing alternate template and data-definition output for DD448.
• GET_ADDRESS_FROM_UDA_ATTR — Returns an address VARCHAR2 derived from UDA attributes for a requisition header ID, address type, and column name.
• GET_MIPR_ACCEPTANCE_STATUS — Returns the MIPR acceptance status for a given requisition header ID.

Tables Accessed

• PO_REQ_HEADERS_EXT_B and PO_REQUISITION_LINES_ALL — Source requisition header extension and line data used when assembling XML and resolving UDA/descriptive attribute context.
• PO_UDA_AG_TEMPLATES and PO_UDA_AG_TEMPLATE_USAGES — UDA attribute-group templates and their usage mappings that drive UDA header and descriptive SQL generation.
• EGO_FND_DF_COL_USGS_EXT and EGO_FND_DSC_FLX_CTX_EXT — Extended descriptive flexfield column usage and context metadata used for attribute description resolution.
• FND_DESCR_FLEX_COLUMN_USAGES — Core descriptive flexfield column usage definitions.
• DUAL — Utility single-row select.
• DBMS_LOB and XMLTYPE — Referenced as program units/types rather than application tables; used respectively for CLOB manipulation and XML construction.

Usage Notes

ICX_DATATEMPLATE_PKG is invoked primarily from the Oracle iProcurement requisition and checkout forms, where the data template framework calls its template and XML generation routines to render the requisition page and to populate address, contact, authorizing officer, funds, and MIPR-related sections. The AFTERPFORM hook confirms integration with an Oracle Forms block, and the DD448 template procedures are called during page-template setup.

Because the package is classified as OTHER and is not a published public API, Oracle does not guarantee interface stability; customizations should avoid direct dependence on signatures. Nevertheless, custom code and extensions — particularly those extending iProcurement descriptive flexfields or UDA-driven requisition attributes — may call members such as GET_CONTACTSXML, GET_ADDRESSXML, or GET_UDA_HEADER_XML to obtain the same XML fragments the standard UI consumes. Debugging efforts may also trace invocations of these functions. The package is referenced by one other package in the environment, reinforcing its role as a supporting internal utility rather than a standalone entry point. Testing any modification should be performed in a non-production instance due to the absence of published API compatibility guarantees.