Search Results reverse_preclass




Overview
Explore in AI Chat

Overview

PA_INVOICE_DETAIL_PROCESS is an Oracle Projects PL/SQL package owned by the APPS schema. Its documented purpose is to support the processing, maintenance, and reversal of draft invoice detail records within the Oracle Projects billing cycle. Draft invoice details represent the individual expenditure and cost distribution lines that are accumulated on a draft invoice before it is finalized and transferred to Oracle Receivables. The package coordinates the relationship between draft invoice detail rows (stored in PA_DRAFT_INVOICE_DETAILS family of tables) and the cost distribution lines (PA_CC_DIST_LINES and PA_COST_DISTRIBUTION_LINES_ALL) that underpin them. Status is documented as VALID, and the object is classified as OTHER within the ETRM API classification scheme.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions. Their names indicate the following responsibilities:

  • PROCESS_INVOICE_DETAILS — The principal driver routine that processes draft invoice detail records, applying the core logic needed to build, adjust, or finalize the detail lines for an invoice.
  • INIT — Initialization routine, typically used to set up package-level state, globals, or working storage before the main processing logic executes.
  • REVERSE_ROW — Reverses an individual draft invoice detail row, undoing the billing effect of a specific detail record.
  • APPLY_INS_CHANGES — Applies insert-related changes, propagating new detail records or their associated adjustments into the relevant working structures.
  • REVERSE_CC_DIST — Reverses cost distribution (CC_DIST) entries associated with invoice details, ensuring that cost distribution lines remain consistent with the reversed detail.
  • REVERSE_PRECLASS — Reverses pre-classified amounts or classification records tied to the invoice detail, supporting corrections to previously categorized billing data.

Parameter lists for these routines are not disclosed in the metadata and are therefore not reproduced here.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

  • PA_DRAFT_INVOICE_DETAILS and its _ALL and _S variants — the primary draft invoice detail records being processed, reversed, or adjusted.
  • PA_CC_DIST_LINES and PA_COST_DISTRIBUTION_LINES_ALL — cost distribution lines that correspond to the invoice detail and must be reversed or realigned when details change.
  • PA_EXPENDITURE_ITEMS and PA_EXPENDITURE_ITEMS_ALL — the expenditure items from which the invoice details were generated, used to validate and reconcile the billing source.
  • PA_PROJECTS_ALL and PA_TASKS — project and task definitions, accessed for validation and context.
  • PLITBLM — a standard Oracle Projects PL/SQL table type used for in-memory collection handling.

Usage Notes

PA_INVOICE_DETAIL_PROCESS is an internal processing package rather than a public API. It is referenced by the PA_IC_INV_CNL package (inter-company invoice cancellation) and by itself, indicating it is invoked as part of larger billing, cancellation, and reversal flows rather than called directly by end users. In Oracle EBS 12.1.1 and 12.2.2, such packages are typically driven by Oracle Projects forms or concurrent programs that manage draft invoices, invoice reversals, and cost distribution corrections. Customizations should treat this package as internal: invoke it only through the standard Oracle Projects flows, and avoid direct calls because its logic depends on package state established by INIT and on the integrity of the draft invoice detail and cost distribution tables.