Search Results fetch_funding_id

Overview

PA_AGREEMENT_PVT is a private PL/SQL package in the Oracle Projects (PA) module of Oracle E-Business Suite, owned by the APPS schema and classified as a PVT (private) API. It encapsulates the core validation and identifier-resolution logic used throughout Oracle Projects for agreements and funding sources at the project level. Agreements represent contractual arrangements with customers or sponsors that authorize work and establish billing and revenue terms; funding sources identify the specific monetary authorizations attached to those agreements. The package provides a consolidated set of server-side routines that convert user-visible agreement and funding references into internal surrogate identifiers, validate the business rules governing agreement and funding creation, update, and deletion, and perform supporting lookups such as flexfield and funding-category validation.

Because the package is classified as PVT, it is not intended as a public integration surface. It is instead the shared internal engine consumed by Oracle Projects' own forms, concurrent programs, and higher-level public APIs, including the project and agreement maintenance flows. The source header indicates version lineage through release 12.1.1 patch levels (120.5.12010000.2), and the object remains documented under ETRM 12.2.2 with the same functional scope.

Key Procedures and Functions

• CONVERT_AG_REF_TO_ID — Resolves an agreement reference (the user-facing agreement number or name) to its internal agreement identifier, returning the identifier and a return status. Defaults support a "missing value" convention supplied by PA_INTERFACE_UTILS_PUB.
• CONVERT_FU_REF_TO_ID — Equivalent routine for funding sources: converts a funding reference into the internal funding identifier and returns a status.
• FETCH_AGREEMENT_ID — Function returning the agreement identifier for a supplied agreement reference, without the status out-parameter of the conversion routine; useful for simple lookups.
• FETCH_FUNDING_ID — Function returning the funding identifier for a supplied funding reference.
• CHECK_CREATE_AGREEMENT_OK — Validates whether a new agreement may be created, evaluating agreement reference, customer, agreement type and number, term, template and revenue-limit flags, ownership (person and organization), currency, invoice-limit flag, and federal-specific attributes such as start and end dates, advance-required indicator, and billing sequence.
• CHECK_UPDATE_AGREEMENT_OK — Validates modification of an existing agreement, accounting for agreement, funding, customer, and agreement-type context.
• CHECK_DELETE_AGREEMENT_OK — Determines whether an agreement is eligible for deletion given existing references.
• CHECK_FUNDING_CATEGORY — Validates the funding category assigned to a funding source.
• CHECK_ADD_FUNDING_OK — Validates the addition of a new funding source to an agreement or project.
• CHECK_UPDATE_FUNDING_OK — Validates changes to an existing funding source.
• CHECK_DELETE_FUNDING_OK — Determines whether a funding source may be removed.
• VALIDATE_FLEX_FIELDS — Validates descriptive flexfield values supplied for agreements or fundings.
• CHECK_YES_NO — Validates that a flag value conforms to the accepted yes/no domain.
• CHECK_ADD_UPDATE — Shared validation helper used across add and update paths.
• VALIDATE_FUNDING_AMT — Validates funding amount values against applicable rules.

Tables Accessed

The package operates against core Oracle Projects tables accessed through APPS synonyms:

• PA_AGREEMENTS_ALL — Stores agreement definitions; the primary source for agreement identifiers, types, numbers, terms, and customer associations.
• PA_PROJECTS_ALL — Provides project context required to associate fundings and validate project-level agreement usage.
• PA_PROJECT_FUNDINGS — Stores funding sources; central to the funding identifier lookups and funding add/update/delete validations.
• PA_PROJECT_TYPES_ALL — Supplies project type attributes that influence which agreement and funding rules apply.
• PA_TASKS — Supports task-level funding and agreement validation where funding is allocated at the task level.

Usage Notes

PA_AGREEMENT_PVT is invoked by two other Oracle Projects packages and is not intended for direct customer invocation. Typical call paths include the Oracle Projects agreement and funding maintenance forms, project setup and funding concurrent processes, and public APIs that internally delegate to this private layer for reference-to-ID conversion and business-rule validation. Custom code should prefer the sanctioned public APIs; if direct calls are unavoidable, callers must be aware that the API signature is subject to change without notice between releases, that the default parameter values assume PA_INTERFACE_UTILS_PUB conventions, and that the NOCOPY out-parameters require careful handling. Because the package is compiled AUTHID CURRENT_USER, grants and synonyms must be correct for the calling context. No commit or rollback is performed implicitly by these validation and lookup routines.