Search Results ap_web_project_pkg




Overview
Explore in AI Chat

Overview

The APPS.AP_WEB_PROJECT_PKG package body is a foundational component of the Oracle E-Business Suite Internet Expenses (OIE) module. Its primary responsibility is to manage the integration between expense reports and Oracle Projects, allowing expense lines to be charged to project and task combinations. The object resides in the APPS schema, is classified as VALID, and carries an API classification of OTHER. It is a central dependency for other Internet Expenses packages, most notably AP_WEB_DB_EXPTEMPLATE_PKG, AP_WEB_DB_PA_INT_PKG, and AP_WEB_UTILITIES_PKG, and it is referenced by six other packages. Critically, the package body confirms that APPS.AP_WEB_PROJECT_PKG is not referenced by any other database object, establishing it as a leaf-level dependency in the call graph.

Key Procedures and Functions

The ETRM documentation records six procedures and functions within this package body:

  • ISSESSIONPROJECTENABLED — Reports whether project-related functionality is enabled for the current session, gating downstream project entry logic.
  • DERIVEPAINFOFROMDATABASE — Derives project accounting information from persisted database sources, supporting expense line validation against existing project data.
  • DERIVEPAINFOFROMUSERINPUT — Populates project accounting information based on values entered by the user.
  • VALIDATEPATRANSACTION — Validates a project accounting transaction, ensuring that project and task combinations conform to the applicable business rules before the expense report proceeds.
  • GETEXPENDITURETYPEMAPPING — Returns the mapping between expenditure types and their associated configuration, which is required when allocating expense amounts.
  • ISGRANTSENABLED — Determines whether Grants functionality (Oracle Grants Management) is active, affecting project charging behavior for sponsored awards.

Tables Accessed

The package accesses two tables directly through APPS synonyms, with all other data retrieved via dependent packages and views:

  • AP_EXPENSE_REPORT_PARAMS — Stores Internet Expenses system parameters, used to evaluate session-level settings such as whether project charging is enabled.
  • FND_USER — The Oracle Applications user repository, consulted for the current user context and responsibility-level behavior.

Beyond direct table access, the package depends on views including PA_PROJECTS_EXPEND_V and PA_TASKS_EXPEND_V, which provide the expendable project and task definitions used during validation. It also relies on packages such as PA_CLIENT_EXTN_PTE, PA_PO_INTEGRATION, GMS_OIE_INT_PKG, and AP_WEB_DFLEX_PKG for project accounting, purchase order integration, grants integration, and descriptive flexfield handling respectively.

Usage Notes

AP_WEB_PROJECT_PKG is invoked indirectly during the normal Internet Expenses flow. When a user creates or edits an expense report that includes project-charged lines, the OIE user-interface packages call ISSESSIONPROJECTENABLED to determine whether project fields should be exposed. On entry or change of project and task values, DERIVEPAINFOFROMUSERINPUT and DERIVEPAINFOFROMDATABASE supply the accounting attributes, while VALIDATEPATRANSACTION enforces eligibility rules. GETEXPENDITURETYPEMAPPING supports expenditure type derivation, and ISGRANTSENABLED governs sponsored-project behavior.

Because the package body is a leaf dependency, no other database object calls it directly; it is executed through the Internet Expenses application stack, typically from Oracle Forms-based OIE pages or the associated self-service web pages. Customizations should avoid modifying the package directly and instead extend behavior through the supported client extension points such as PA_CLIENT_EXTN_PTE. The package is valid in both EBS 12.1.1 and 12.2.2 environments where Oracle Projects and Internet Expenses are installed.