Search Results p_draft_inv_num

Overview

PA_INVOICE_CURRENCY is a private support package in the Oracle E-Business Suite Projects (PA) module. Its central business function is to calculate, format, and maintain currency-related values on Oracle Projects draft invoices, including recalculation of invoice amounts using the correct project currency and multi-radix formatting. The package body carries the header identifier PAXICURB.pls 120.6.12010000.3, indicating a file maintained through the 11i/R12 family. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as OTHER and executes under the APPS schema, typically from within the Oracle Projects invoice generation and adjustment flow rather than being exposed as a public API.

Key Procedures and Functions

• FORMAT_PROJ_CURR_CODE — A private function returning a VARCHAR2 format mask for the invoice program's currency. It obtains the mask through FND_CURRENCY.GET_FORMAT_MASK using the package global G_CURRENCY_CODE. The mask length was increased to 22 characters (from 15) to accommodate multi-radix currency formatting, per the source comment referencing Bug#2337109.
• RECALCULATE — Recomputes the currency-denominated amounts on a draft invoice, driving the recalculation of invoice totals and distribution values in the invoice's currency.
• GET_INV_CURR_INFO — Retrieves currency information for an invoice, supplying the invoice-level currency attributes required by downstream calculations.
• GET_PROJFUNC_INV_CURR_INFO — Retrieves project functional currency information for an invoice, supporting the distinction between project functional currency and invoice (transaction) currency.
• GET_PROJ_CURR_INFO — Retrieves project currency information, providing the project-level currency context used when formatting and recalculating amounts.
• UPDATE_CRMEMO_INVAMT — Updates credit memo invoice amounts, applying the currency recalculation logic to credit memo transactions.
• RECALCULATE_DRIVER — Serves as the driver entry point for the recalculation process, orchestrating the currency recalculation sequence.

An internal procedure, INSERT_DISTRBUTION_WARNING, inserts a draft invoice distribution warning into PA_DISTRIBUTION_WARNINGS when a distribution condition is detected. It resolves the message text from PA_LOOKUPS using the supplied lookup type and error message code, defaulting to the raw code when no row is found, and honors the PA_DEBUG_MODE profile option.

Tables Accessed

• PA_DRAFT_INVOICES / PA_DRAFT_INVOICES_ALL — The draft invoice headers whose currency amounts are read and updated; P_DRAFT_INV_NUM identifies the target draft invoice number.
• PA_DRAFT_INVOICE_ITEMS — Draft invoice lines contributing to invoice amount totals.
• PA_DISTRIBUTION_WARNINGS — Insert target for distribution warnings raised during processing.
• PA_AGREEMENTS_ALL — Agreement records reviewed when determining currency and billing context.
• PA_PROJECTS_ALL — Project definitions supplying the project currency and identifying the project.
• PA_PROJECT_CUSTOMERS — Project customer assignments used in invoice currency derivation.
• PA_SUMMARY_PROJECT_FUNDINGS — Funding summary data used in recalculation logic.

Usage Notes

PA_INVOICE_CURRENCY is invoked internally by the Oracle Projects invoice generation and adjustment programs and is referenced by one other package in the ETRM inventory. Because the procedures are not documented as public APIs, customizations should not call them directly without regression risk. The P_DRAFT_INV_NUM parameter appears on the distribution warning procedure and on the invoice currency retrieval routines, meaning the package primarily operates against an identified draft invoice number supplied by the calling concurrent program or form.