Search Results pa_deductions_dm_s

Overview

PA_DEDUCTIONS is the Oracle Projects package responsible for the deductions sub-ledger used in Oracle E-Business Suite. A deduction represents an amount withheld from a supplier, a subcontractor retainer, or a similar obligation that Oracle Projects must later recover by generating a debit memo in Oracle Payables. The package body implements the full lifecycle of that obligation: creation, maintenance, validation, and submission of deduction requests, followed by the mapping and import of the resulting debit memo into the Payables open interface tables.

The body is declared at line 1 as PACKAGE BODY PA_DEDUCTIONS AS and carries header revision $Header: PADEDTXB.pls 120.0.12020000.2. It is owned by APPS and classified as an OTHER API rather than a public interface. Because much of the processing is long-running and involves external integration, the body maintains internal state rather than exposing it to callers. Two PL/SQL collections are declared for this purpose: a record type g_dctn_hdr_amt (holding p_dctn_hdr_id and p_total_amount) and a table type g_dctn_hdrtbl_amt indexed by BINARY_INTEGER. A package-level variable g_api_name VARCHAR2(30) stores the name of the currently executing API, and P_DEBUG_MODE defaults from the profile option PA_DEBUG_MODE (defaulting to 'N') to control diagnostic logging.

Key Procedures and Functions

Thirteen documented program units make up the package:

• CREATE_DEDUCTION_HDR — creates a deduction header record representing the overall withholding.
• CREATE_DEDUCTION_TXN — creates the detail transaction lines belonging to a deduction header.
• UPDATE_DEDUCTION_HDR — modifies an existing deduction header.
• UPDATE_DEDUCTION_TXN — modifies an existing deduction transaction line.
• DELETE_DEDUCTION_HDR — removes a deduction header.
• DELETE_DEDUCTION_TXN — removes a deduction transaction line.
• VALIDATE_DEDUCTION_HDR — validates header data before it is processed.
• VALIDATE_DEDUCTION_TXN — validates the transaction details.
• SUBMIT_FOR_DEBITMEMO — submits validated deductions for debit memo generation.
• INVOICE_DM_MAP — maps a deduction request to the debit memo/invoice identifiers used downstream.
• IMPORT_DEBITMEMO — drives insertion of the debit memo into the Payables interface.
• VALIDATE_UNPROCESSED_DED — validates deduction requests that remain unprocessed.

Supporting private routines include log_message for debug output, Delete_Failed_Rec to back out interface rows when the payables import fails, Validate_DM to verify or generate a debit memo number via client extension, AddError_To_Stack to push coded messages onto the error stack, and Create_Invoice_Header to insert header rows into AP_INVOICES_INTERFACE.

Tables Accessed

Core Projects tables include PA_DEDUCTIONS_ALL and PA_DEDUCTION_TRANSACTIONS_ALL (header and line storage for deduction requests), PA_DEDUCTIONS_DM_S and PA_DEDUCTION_TXNS_S (sequences for key generation), and PA_PROJECTS_ALL and PA_EXPEND_TYP_SYS_LINKS for project and expenditure-type validation. Integration tables include AP_INVOICES_INTERFACE, AP_INVOICE_LINES_INTERFACE, and their _S sequence synonyms, populated during debit memo import, with AP_INTERFACE_REJECTIONS capturing rejected rows. Validation and reconciliation read AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, and AP_INVOICE_DISTRIBUTIONS_ALL. FND_LOOKUP_VALUES supplies coded values, and PA_DEBUG_MODE is read through FND_PROFILE.

Usage Notes

PA_DEDUCTIONS is invoked from the Oracle Projects deduction user interface, from concurrent programs that submit and import deduction debit memos, and from custom extensions requiring programmatic deduction processing. Callers should invoke CREATE_*, UPDATE_*, and DELETE_* in the standard sequence, run the validation routines, and then call SUBMIT_FOR_DEBITMEMO followed by IMPORT_DEBITMEMO. The package is referenced by three other packages, confirming its role as a shared service. Debug output is enabled by setting the PA_DEBUG_MODE profile option to 'Y'; the private logging and error-stack routines are not part of the public API.