Search Results ap_web_db_pa_int_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_WEB_DB_PA_INT_PKG is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that serves as the integration layer between the Oracle Payables Internet Expenses (OIE) module and Oracle Projects. Its name reflects this dual role: the AP_WEB prefix identifies it as part of the Payables web-based expense entry infrastructure, while the PA_INT suffix denotes its function as a Projects integration package. The package resolves and validates Projects-related context — project and task information — during expense report entry and workflow processing.

The package is deployed as a valid, compiled object in both EBS 12.1.1 and 12.2.2 and is classified under the ETRM as an OTHER API type, indicating it is intended primarily for internal consumption by Oracle's own expense and project components rather than as a published extension API.

Key Procedures and Functions

The ETRM metadata documents eight callable units within the package. The following procedures and functions are identified:

  • GETPROJECTINFO — Returns descriptive information for a given project, supporting the display and validation of project details on expense entry pages.
  • GETTASKINFO — Returns descriptive information for a given task, enabling task-level detail display and validation.
  • GETPROJECTNUMBER — Retrieves the project number associated with a project identifier, allowing expense lines to display the human-readable project number.
  • GETPROJECTID — Returns the internal project identifier corresponding to a supplied project reference; the inverse of GETPROJECTNUMBER.
  • GETTASKID — Resolves the internal task identifier for a given task reference.
  • GETTASKIDBYPROJID — Returns the task identifier filtered by project identifier, supporting combined project-and-task selection logic.

These functions are primarily lookup and resolution utilities. Each encapsulates the query logic required to translate between user-facing project/task identifiers and the internal foreign keys stored on expense distributions. No parameter lists are documented in the ETRM extract, and none are inferred here.

Tables Accessed

The package references the following objects, resolved through APPS synonyms:

  • PA_PROJECTS_EXPEND_V — A Projects expenditure view used to obtain project information in the context of expenditure entry and validation.
  • PA_TASKS_EXPEND_V — The corresponding task-level expenditure view, supplying task details associated with project expenditure transactions.
  • PA_PROJECTS_ALL — The base Projects table, documented as referenced via APPS synonyms, providing authoritative project records.

Collectively these objects allow the package to read project and task definitions without writing to Projects tables directly; the package functions as a read-oriented resolver that enforces valid project/task combinations before they are stored on Payables expense distributions.

Usage Notes

AP_WEB_DB_PA_INT_PKG is referenced by several other packages within the APPS schema, notably AP_WEB_AME_PKG, AP_WEB_EXPENSE_WF, and AP_WEB_PROJECT_PKG. These dependencies indicate that the package is invoked from the Internet Expenses approval workflow, the expense entry project package, and the AME (Approvals Management Engine) integration path. It is therefore called during expense report creation, line entry, and approval processing whenever project or task data must be validated or displayed.

Because the package is categorized as OTHER rather than as a public API, customers and integrators should treat direct invocation as unsupported. Customizations should instead rely on Oracle's documented extension points for Internet Expenses. Where custom code must reference project or task identifiers on expense data, the same underlying Projects views may be queried independently to avoid dependency on internal package signatures that may change between releases such as 12.1.1 and 12.2.2.