Search Results get_start_or_end_date

Overview

PA_FUNDS_CONTROL_PKG1 is an internal PL/SQL package owned by the APPS schema within Oracle E-Business Suite, classified as an OTHER API. It forms part of the budgetary controls and funds checking infrastructure of Oracle Projects, providing the low-level procedural logic that underpins encumbrance creation, budgetary control packet processing, and burden cost population. The package is not intended as a public entry point; rather, it supplies shared helper routines invoked by higher-level packages such as PA_FUNDS_CONTROL_PKG, PA_FUNDS_CONTROL_UTILS2, and the concurrent import program PA_CC_ENC_IMPORT_FCK. Its central role is to derive and persist the budgetary control packet (BC packet) records that represent funds-check results, encumbrances, and unreserved lines generated whenever project transactions—requisitions, purchase orders, invoices, and prepayments—are validated against a project or award budget.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. Their purposes are as follows:

• SETUP_START_END_DATE — Establishes the effective start and end dates used for the budgetary control processing run.
• CREATE_PROJ_ENCUMBRANCE_EVENTS — Generates encumbrance event records for project transactions.
• CREATE_AP_PO_BDN_LINES — Constructs burden distribution lines associated with Payables and Purchasing transactions.
• POPULATE_BURDEN_COST — Computes and populates burden cost values on the relevant control lines.
• CREATE_UNRSVD_LINES — Creates unreserved (unfunded) lines when insufficient funds exist.
• GET_START_OR_END_DATE — Returns the appropriate start or end date for a processing context.
• UPD_CWK_ATTRIBUTES — Updates Cost Workbench (CWK) attribute values.
• CHECK_EXP_OF_COST_BASE — Validates the expenditure type classification of a cost base.
• GET_CWK_MULTIPLIER — Retrieves the Cost Workbench multiplier applied to a cost base.
• TIEBACK_FAILED_ACCT_STATUS — Sets the accounting status when a tieback operation fails.
• INTERFACE_TBC_BTC_COMT_UPDATE — Interfaces total burdened cost, burdened cost, and commitment update values.
• GET_RATIO — Returns a ratio used in burden or cost calculations.
• POPULATE_PLSQL_TABS_CBC — Populates PL/SQL tables used for cost burden calculations.
• CREATE_CBC_PKT_LINES — Creates cost burden calculation packet lines.

Tables Accessed

Through APPS synonyms the package reads and writes PA_BC_PACKETS, the core budgetary control packet table, along with configuration sources PA_BUDGETARY_CONTROL_OPTIONS and PA_BUDGET_ENTRY_METHODS. It references Payables tables including AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, AP_PREPAY_APP_DISTS, AP_PREPAY_HISTORY_ALL, and AP_SELF_ASSESSED_TAX_DIST_ALL to build encumbrance and burden lines from invoice and prepayment activity. System configuration is read from AP_SYSTEM_PARAMS_ALL and FINANCIALS_SYSTEM_PARAMS_ALL. General Ledger interaction includes GL_BC_PACKETS_S, GL_ENCUMBRANCE_TYPES, and GL_PERIOD_STATUSES, supporting encumbrance types and period validation. IGC_CC_ACCT_LINES supplies cost collection account lines.

Usage Notes

PA_FUNDS_CONTROL_PKG1 is invoked indirectly. The dependency metadata shows it is referenced by PA_CC_ENC_IMPORT_FCK, PA_FUNDS_CONTROL_PKG, PA_FUNDS_CONTROL_UTILS2, and recursively by itself. It is therefore executed during concurrent funds-check and encumbrance import processing and during online transaction validation in Oracle Projects and Payables. Customizations should not call it directly; integrators should use the public funds control APIs in PA_FUNDS_CONTROL_PKG. The object is VALID in both 12.1.1 and 12.2.2, and its signature should be treated as internal and subject to change across patches.