Results for “ap_web_ame_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AP_WEB_AME_PKG is an Oracle E-Business Suite PL/SQL package whose name identifies it as the integration layer between Oracle Payables (AP) and Oracle Approvals Management Engine (AME), specifically for the Internet Expenses (OIE) approval workflow. Its object name combines the AP_WEB (Payables web/Internet Expenses) namespace with the AME designation, and its documented procedure inventory confirms that it operates on expense report data rather than on standard invoice records. The package supplies AME with the attributes, qualifiers, and approver resolution logic required to route expense reports through the correct approval hierarchy. It is a supporting technical component rather than an end-user-facing API, and is classified in the ETRM metadata as an OTHER API classification, meaning it is not published for general external consumption.

Key Procedures and Functions

The ETRM metadata documents ten callable units. Several are AME attribute functions that return values used by approval rules:

• GETVIOLATIONTOTAL — Returns the total value or count of expense policy violations associated with a report, supporting AME rules that escalate based on violation severity.
• GETVIOLATIONPERCENTAGE — Returns the proportion of a report that breaches expense policy, used for threshold-based routing.
• GETTOTALPERCOSTCENTER — Returns expense totals aggregated by cost center, enabling cost-center-specific approval rules.
• GETCOSTCENTEROWNER — Resolves the owner or responsible party for a given cost center.
• GETAWARDMANAGERID — Returns the manager associated with a grant award, drawn from Grants Management data.
• GETPROJECTMANAGERID — Returns the project manager identifier for project-related expense routing.
• GETAWARDNUMBER — Returns the award number tied to the expense distribution.
• ISMISSINGRECEIPTSSHORTPAY — Evaluates whether missing receipts should trigger a short payment condition.
• INITOIEAMENOTIFGT — Populates a global temporary table used for AME notification processing in Internet Expenses.
• INITOIEAMEAPPROVERAMTGT — Populates the approver amount global temporary table consumed by AME approver resolution.

Tables Accessed

The package reads and writes the following documented objects, primarily through APPS synonyms:

• Expense report tables: AP_EXPENSE_REPORT_LINES, AP_EXPENSE_REPORT_LINES_ALL, AP_EXPENSE_REPORT_HEADERS, AP_EXPENSE_REPORT_HEADERS_ALL, and AP_EXP_REPORT_DISTS_ALL — the source of report line amounts, header context, and accounting distributions.
• Policy data: AP_POL_VIOLATIONS_ALL — supplies violation records backing GETVIOLATIONTOTAL and GETVIOLATIONPERCENTAGE.
• AME engine tables: AME_ITEM_CLASSES, AME_TEMP_OLD_APPROVER_LISTS, and the OIE_AME_APPROVER_AMT_GT global temporary table — used to stage approver lists and attribute values during AME processing.
• Grants and HR tables: GMS_AWARDS, GMS_AWARDS_ALL, GMS_PERSONNEL, HR_ORGANIZATION_INFORMATION, and FND_SEGMENT_ATTRIBUTE_VALUES — resolve award, project, and cost-center ownership attributes.
• System parameters: AP_SYSTEM_PARAMETERS_ALL — provides organization-level configuration.

Usage Notes

AP_WEB_AME_PKG is invoked indirectly. It is called by the AME engine when evaluating expense report approval rules, and it is also referenced by AP_WEB_CUST_AME_PKG, the customer-facing customization package used to extend Internet Expenses approval behavior. The presence of the two OIE global temporary table initialization routines indicates the package is executed within the OIE submission and approval workflow, before AME approver resolution and notification generation. Consultants extending expense approval logic should generally route customizations through AP_WEB_CUST_AME_PKG rather than modifying AP_WEB_AME_PKG directly, because the latter is a seeded, VALID object whose logic is regenerated and supported by Oracle. Any direct dependency on its procedures risks breakage during patching or upgrade between 12.1.1 and 12.2.2.