Search Results ap_web_db_exptemplate_pkg




Overview
Explore in AI Chat

Overview

AP_WEB_DB_EXPTEMPLATE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that serves as the principal server-side repository for Oracle Internet Expenses (OIE) expense report templates and expense types. In EBS 12.1.1 and 12.2.2 it centralizes the retrieval and interpretation of template definitions and expense type configuration that drive the web-based expense entry experience. Every expense report created through the OIE self-service flow requires a template, and this package is the component that resolves which templates are web-enabled, what expense types each template exposes, which of those types require justification or receipts, and what prompt text and personalization parameters apply. It is therefore a foundational reference package rather than a transactional one: it supplies metadata to validation, workflow, project, discount, and integration packages across the Oracle Payables web stack. Its API classification in ETRM is documented as OTHER, and it is referenced by twelve other packages, confirming its role as a shared dependency rather than a niche utility.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions, organized around the following functional groups:

  • Template resolution and enumeration — GETWEBENABLEDTEMPLATESCURSOR and GETNUMWEBENABLEDEXPTEMPLATES return the set and count of templates enabled for web entry, while GETDEFAULTTEMPLATEID identifies the default template to apply when the user makes no explicit selection. GETEXPTEMPLATEID and GETTEMPLATENAME translate between identifiers and display names.
  • Expense type enumeration — GETALLEXPENSETYPESCURSOR, GETEXPTYPESOFTEMPLATECURSOR, GETEXPTYPESCURSOR, GETWEBEXPTYPESCURSOR, and GETJUSTIFREQDEXPTYPESCURSOR return expense types filtered by template, web enablement, or justification requirement. Together these support template-driven list-of-values and validation logic.
  • Attribute and parameter retrieval — GETEXPTYPEINFO, GETEXPTYPEPROMPT, GETPERSONALPARAMID, GET_ITEMDESC_LOOKUPCODE, and GETROUNDINGPARAMID resolve descriptive text, prompt labels, personalization identifiers, item description lookup codes, and rounding parameters associated with a template or expense type.
  • Behavioral flags — ISEXPTEMPLATEWEBENABLED, ISCUSTOMCALCULATEENABLED, and GETREQUIRERECEIPTAMT report whether a template permits web entry, whether custom calculation is active, and the monetary threshold above which a receipt is mandatory.

Tables Accessed

The package reads from three APPS tables through synonyms. AP_EXPENSE_REPORTS holds the template-level and expense report template definitions, including the web-enabled and rounding attributes the query functions return. AP_EXPENSE_REPORT_PARAMS stores the parameter rows that bind templates to expense types, prompts, personalization values, and receipt or justification rules. AP_SYSTEM_PARAMETERS supplies the Payables system-level options that qualify template behavior, such as default currency and functional settings used during template resolution.

Usage Notes

AP_WEB_DB_EXPTEMPLATE_PKG is invoked indirectly rather than by end users. Oracle Internet Expenses pages and the associated OA framework flows call it to populate template and expense type lists, while AP_WEB_DB_EXPLINE_PKG, AP_WEB_VALIDATE_UTIL, AP_WEB_OA_MAINFLOW_PKG, and AP_WEB_PARENT_PKG consume its cursor and flag functions during expense line entry and validation. Workflow components such as AP_WEB_EXPENSE_WF and integration packages including AP_WEB_DB_AP_INT_PKG rely on it when transferring approved expense reports into Payables. Because the API surface is stable and the package is a documented dependency of many standard objects, customizations should call the documented functions rather than query the underlying tables directly, and any modification risks broad impact across the Oracle Internet Expenses module.