Search Results insert_rows

Overview

PA_MC_INVOICE_DETAIL_PKG is a multi-currency (MRC) support package that belongs to the Oracle Projects (PA) module of Oracle E-Business Suite. Its purpose is to maintain the reporting-currency (MRC) image of draft invoice detail lines generated by Oracle Projects Billing. In a multi-currency accounting setup, every transaction must be represented in both the functional currency of the operating unit and the reporting currency defined by the MRC configuration. This package supplies the logic that populates, maintains, and removes the reporting-currency rows that accompany the primary draft invoice detail records in PA_DRAFT_INVOICE_DETAILS.

The package is classified as an "OTHER" API in ETRM, reflecting that it is an internal utility package rather than a public, commercially supported interface. The header string (PAMCIDTB.pls 120.3) and the use of NOCOPY OUT parameters indicate it is tuned for set-based PL/SQL processing within the invoice generation and MRC population flows.

Key Procedures and Functions

• INSERT_ROWS — The procedure most directly associated with the user search term "insert_rows." It creates the reporting-currency counterpart rows for draft invoice detail lines, deriving the amounts, exchange rate type, exchange rate date, and converted bill amount needed to satisfy MRC reporting requirements.
• UPDATE_ROWS — Maintains existing reporting-currency rows when the underlying primary-currency draft invoice detail is changed, such as when amounts, exchange rate information, or account currency assignments are adjusted during invoice processing.
• DELETE_ROWS — Removes the reporting-currency rows associated with draft invoice detail records, typically when the parent transaction is rejected, re-created, or otherwise reversed.

The package body also declares additional internal routines, including get_orig_exchg_rate, download, and compute_mrc, which support exchange-rate retrieval and array-based processing of invoice records. These are helper routines and are not part of the documented public interface. A package-level variable g1_debug_mode reads the PA_DEBUG_MODE profile option to control debug output. Array types from PA_PLSQL_DATATYPES (IdTabTyp, NumTabTyp, Char1TabTyp, Char30TabTyp, DateTabTyp) are used throughout to pass collections of project, currency, amount, and date values efficiently.

Tables Accessed

• PA_DRAFT_INVOICE_DETAILS — The primary draft invoice detail table. The package inserts, updates, and deletes reporting-currency rows in this table to keep the MRC image synchronized with the primary-currency image.
• PLITBLM — Referenced by the package for PL/SQL table (index-by table) manipulation, consistent with the array-driven design used to process invoice detail records in bulk.

Exchange rate information is obtained through the internal get_orig_exchg_rate routine, which accepts a line identifier and set of books identifier and returns the original exchange rate, exchange date, exchange rate type, and bill amount needed for currency conversion.

Usage Notes

PA_MC_INVOICE_DETAIL_PKG is an internal dependency rather than a standalone entry point. It is invoked from within the Oracle Projects billing and MRC population flows, most notably during draft invoice generation and whenever draft invoice details are created, modified, or removed. The ETRM metadata confirms the package is referenced by two other packages, indicating that higher-level billing processes call INSERT_ROWS, UPDATE_ROWS, and DELETE_ROWS as part of their normal transaction processing.

Because the procedures are not exposed as public APIs and carry no documented parameter list in the metadata, customizations should not call them directly. In Oracle EBS 12.1.1 and 12.2.2, multi-currency and reporting-currency behavior is controlled through system configuration; the package operates transparently behind the standard invoice workflow. The NOCOPY OUT parameters and bulk collection types suggest the routines are designed to process many invoice lines per call, and the PA_DEBUG_MODE profile can be enabled to aid diagnosis of MRC conversion issues. Sites troubleshooting reporting-currency balances on draft invoices should trace through these routines rather than attempting to modify the underlying rows manually.