Search Results govt_share_per
Overview
APPS.PO_EDA_DATATEMPLATE_PKG is a Purchasing (PO) Enterprise Data Architecture (EDA) utility package responsible for assembling the XML data templates and attribute payloads that Oracle E-Business Suite uses when generating procurement documents and Oracle Business Intelligence Publisher (BI Publisher) output. In the context of EBS 12.1.1 and 12.2.2, the package supplies the descriptive values for user-defined attributes (UDA) attached to headers, lines, and shipments, and it formats address, contact, and shipping detail used in printed and electronic purchasing documents. The body carries the private helper logic (DocFilter, ModFilter, dynamic SQL builders, and XML fragment assemblers) supporting the public interface of the specification.
Key Procedures and Functions
- DOCFILTER and MODFILTER — control-flow predicates keyed on a draft identifier; they determine whether the caller is processing a document context versus a modification (draft) context, returning BOOLEAN accordingly.
- SET_UDA_ATTRIBUTES_HEADER, SET_UDA_ATTRIBUTES_LINES, and SET_UDA_ATTRS_LINE_LOCATIONS — populate the extended attribute values for the three purchasing document levels (header, line, line location/shipment) into the data template result set.
- GET_SHIPADDRESSXML, GET_SHIPADDRESSXML_BASE, GET_MOD_ADDRESSXML, GET_ADDRESSXML — build the XML representations of ship-to and general address blocks, including a modification-context variant used during draft processing.
- GET_CONTACTSXML, GET_DRAFTS_CONTACTSXML, GET_DRAFTS_ADDRESSXML — assemble contact and address XML for approved documents and their draft counterparts.
- GET_PROCUREMENTINSTVEHICLE3, GET_PRICINGARRANGEMENTBASE, GET_AWARDFEE, GET_PERFORMANCEINCENTIVE — extract commercial terms: procurement instrument vehicle, pricing arrangement basis, award fee structures, and performance incentive clauses.
- GET_ADDENDAATTACHED, GET_LINEITEMTYPE, IS_CONTINGENCYCONTRACT, AFTERPFORM — surface addenda attachment presence, line item type classification, contingency contract flags, and post-form processing.
Tables Accessed
The package reads configuration and descriptive data through APPS synonyms that include PO_EDA_MAPPING (mapping of EDA data elements to source columns), FND_DESCR_FLEX_COLUMN_USAGES, FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, and FND_FLEX_VALIDATION_TABLES (flexfield value resolution for UDA display), EGO_FND_DF_COL_USGS_EXT and EGO_FND_DSC_FLX_CTX_EXT (extensible attribute column usage and context), GL_CODE_COMBINATIONS (accounting code combinations on lines and shipments), and AP_TERMS_LINES (payment terms text). Attachment and text content is drawn from FND_DOCUMENTS_SHORT_TEXT and FND_LOBS. Contract clause data is retrieved from OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS, OKC_BUS_DOC_TYPES_B, and OKC_BUS_VARIABLES_B (Oracle Contracts), which supports award fee, performance incentive, and contingency contract logic.
Usage Notes
PO_EDA_DATATEMPLATE_PKG is invoked indirectly by the purchasing document generation and BI Publisher reporting flows rather than being called directly by end users. It is executed when a purchase order, blanket agreement, or contract is printed, previewed, or communicated, and it participates in EDA data template population for draft (modification) rendering as indicated by the DOCFILTER and MODFILTER predicates. Because it relies on the Oracle Contracts (OKC) and extensible attribute (EGO) schemas together with flexfield value tables, the calling context must be a Purchasing-authorized session with APPS privileges. The metadata records no other packages referencing it, so any custom extension should invoke it with caution and preserve the documented argument conventions of the public specification rather than the private body helpers. The reference to "govt_share_per" relates to government share percentage attributes typically resolved through the flexfield and UDA value routines documented above.