Search Results temp_status

Overview

APPS.PA_ADJUSTMENTS is the core Oracle Projects expenditure adjustment engine within Oracle E-Business Suite. Its principal business function is to create, modify, back out, and reprocess expenditure items and their associated cost distribution lines on projects and tasks. The package underpins the Adjust Expenditures window, allowing project accountants to reclassify, split, transfer, hold, reverse, and otherwise adjust raw, burdened, and capitalized costs. Because project cost adjustments must remain auditable and roll up consistently to Oracle General Ledger and Oracle Payables, PA_ADJUSTMENTS manages the full lifecycle of an adjustment — from validation of the original item through recalculation of cost and revenue, audit record creation, and net-zero or backout handling. The header identifies the source as PAXTADJB.pls (version 120.107.12020000.6, dated 2013/04/18), confirming its place in the R12 (12.1.1 and 12.2.2) code line. The package is classified as OTHER in the ETRM registry and is referenced by approximately fifteen other packages, which reflects its role as a shared adjustment utility rather than a standalone API.

Key Procedures and Functions

The documented interface exposes roughly forty-one procedures. The primary adjustment routines include ADJUST, RECLASS, SPLIT, and TRANSFER, which perform the respective cost movement operations on expenditure items. HOLD applies or releases an adjustment hold, while SETNETZERO enforces a net-zero adjustment condition for the affected item or group.

• Backout and reversal: BACKOUTITEM, BACKOUTMRCITEM, and REVERSERELATEDITEMS undo previously processed adjustments and cascade the reversal to related items.
• Cost recalculation: RECALCREV, RECALCCOSTREV, RECALCRAWCOST, RECALCINDCOST, and RECALCCAPCOST recompute revenue, total cost, raw cost, indirect (burdened) cost, and capitalized cost respectively after an adjustment.
• Validation and status: CHECKSTATUS, INVSTATUS, VERIFYORIGITEM, and GETINVID validate item status and source relationships, particularly against Oracle Payables invoice distributions.
• Supporting routines: INSAUDITREC writes audit trail records, COMMENTCHANGE records adjustment comments, and the internal RESOURCE_BUSY exception (Oracle error -0054) signals a locked or busy resource during processing.

Tables Accessed

The package reads and writes expenditure data primarily through PA_EXPENDITURE_ITEMS_ALL and PA_COST_DISTRIBUTION_LINES / PA_COST_DISTRIBUTION_LINES_ALL, which hold the item and its distribution detail. Payables integration relies on AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICES / AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_PAYMENTS_ALL, and AP_CHECKS_ALL to verify source invoice and payment information. AP_SYSTEM_PARAMETERS, AP_SELF_ASSESSED_TAX_DIST_ALL, and CE_BANK_ACCOUNTS support currency, tax, and bank account validation. Project and grants configuration is sourced from GMS_AWARDS_ALL, PA_BILL_RATES_ALL, PA_COMPENSATION_RULE_SETS, and related setup tables. Access is performed through APPS synonyms, which is standard for this code line.

Usage Notes

PA_ADJUSTMENTS is invoked from the Oracle Projects Adjust Expenditures and related cost-adjustment forms, from concurrent programs that reprocess or recalculate cost and revenue, and from custom extensions that require programmatic expenditure adjustment. Callers must supply the correct expenditure item context and currency; the package relies on package-level globals (such as ORG_ID, SET_OF_BOOKS_ID, GL_DATE, and CCID values) that are populated during processing. The RESOURCE_BUSY exception must be handled by callers to avoid failures on locked records. The G_AUTOMATIC_OFFSET_METHOD record type (R12 change) controls automatic offsetting behavior, and the P_DEBUG_MODE flag enables tracing via pa_cc_utils.g_debug_mode. The temp_status user search term most likely relates to the item status checks performed by CHECKSTATUS, INVSTATUS, and the internal processing status flags used to track whether an item is being adjusted, backed out, or held.