Search Results create_deduction_hdr

Overview

APPS.PA_DEDUCTIONS_PUB is a public PL/SQL API package in Oracle Projects that manages the creation and maintenance of project-related deductions, debit memos, and their associated transaction lines. Deductions are used to recover amounts from suppliers, customers, or other parties in connection with project control items and purchase orders. The package encapsulates the business logic required to record a deduction header and its corresponding deduction transactions without requiring callers to write directly to the underlying tables.

The package body header, "$Header: PADCTNPB.pls 120.2.12010000.3 2010/04/15", indicates that the packaged logic belongs to the PA (Projects) product family and has remained stable across the 12.1.1 and 12.2.2 releases. Because the package is classified as a public API (PUB), it exposes a supported interface intended for use by other Oracle EBS modules and by customer extensions rather than being restricted to internal, private use. In the ETRM 12.2.2 metadata the package is documented with two procedures, CREATE_DEDUCTION_HDR and CREATE_DEDUCTION_TXN, both of which model Oracle's standard API behavior through API version numbering, commit control, initialization of the message list, and standard return status and message outputs.

Key Procedures and Functions

The package documents two callable procedures. Both follow the Oracle Application Object Library API conventions, accepting an API version number, a commit flag, an initialize-message-list flag, and returning message count, message data, and return status parameters.

• CREATE_DEDUCTION_HDR — Creates a deduction header record. Its parameters identify the project, vendor, vendor site, control item, and purchase order header, along with currency, conversion rate type, conversion rate date, conversion rate, deduction request number and date, debit memo number and date, description, status, and org context. The procedure returns the deduction request number, debit memo number, and status. Internally it declares working variables for the deduction request identifier, a table of deduction headers, and, as reflected in the source excerpt (bug 9052223), variables for conversion amount, denominator, and numerator used in currency conversion logic.
• CREATE_DEDUCTION_TXN — Creates the deduction transaction records that belong to a deduction header. The name of this procedure corresponds directly to the search term "create_deduction_txn" and represents the entry point for populating deduction transaction data.

Tables Accessed

Through APPS synonyms, the package references the following documented tables:

• PA_DEDUCTIONS_ALL and PA_DEDUCTIONS_S — the deduction entity tables, holding header and setup data. The _ALL table carries the operating unit, while the _S table is the sequence-generated key source.
• PA_DEDUCTION_TRANSACTIONS_ALL and PA_DEDUCTION_TXNS_S — the deduction transaction detail tables written by CREATE_DEDUCTION_TXN, with _S providing the transaction identifier sequence.
• PA_CONTROL_ITEMS — the project control item definition referenced when building the deduction line.
• PO_HEADERS_ALL — used to validate and associate the purchasing document when a deduction relates to a purchase order.
• DUAL — the standard Oracle single-row table, commonly used for sequence or scalar lookups within the package.

Usage Notes

The package is normally invoked by Oracle Projects forms, by concurrent programs, or by custom code implementing inbound integrations that create deductions and their transaction lines. Callers should treat it as a public API and rely on the returned message count, message data, and return status to detect errors, since exceptions are converted into the FND API message stack. Because commit behavior is controlled by the p_commit parameter and message initialization by p_init_msg_list, callers may participate in a larger transaction. The package is not documented as being referenced by any other package, so it is a top-level entry point in the deduction API layer.