Search Results pa_draftinvdetails

Overview

PA_PURGE_ICIP is an Oracle EBS Applications (APPS) schema PL/SQL package associated with the Projects (PA) module. Its name combines the purge functionality of the Projects suite with the inter-company invoice processing domain, indicating that it is responsible for the cleanup of interim or staged inter-company invoice data that accumulates in Projects invoice interface tables. In Oracle Projects, inter-company invoicing allows one operating unit to bill another for work performed across organizational boundaries, and the resulting draft invoice and expenditure records move through staging tables before final accounting. The PA_PURGE_ICIP package supports the removal of obsolete or processed draft invoice detail rows from these interim structures, preventing unbounded growth of interface tables that would otherwise degrade concurrent program performance and inflate database storage.

The package is classified under the API classification OTHER, meaning it is not an officially published, externally supported public API, but rather an internal utility invoked by other Projects purge logic. Per the documented metadata, PA_PURGE_ICIP is referenced by the PA_PURGE package and by itself, confirming its role as a subordinate component of the broader Projects purge framework rather than an entry point in its own right.

Key Procedures and Functions

Two documented program units exist within PA_PURGE_ICIP:

• PA_DRAFTINVDETAILS — Handles purging of draft invoice detail records tied to standard, non-multicurrency inter-company invoice processing. It targets rows in the draft invoice detail structures after they have been successfully processed or are otherwise no longer required.
• PA_MC_DRAFTINVOICEDETAILS — The multicurrency counterpart to the previous procedure. It addresses draft invoice details generated in multicurrency inter-company invoice scenarios, where additional currency-related staging data must be purged.

Both procedures are internal to the package and are invoked programmatically; the documented metadata does not expose parameter lists for public use.

Tables Accessed

PA_PURGE_ICIP references the following tables through APPS synonyms:

• PA_DRAFT_INVOICES_ALL — The master draft invoice header table from which related inter-company invoice records are identified.
• PA_DRAFT_INVOICE_DETAILS_ALL — The draft invoice line-level detail table that is the primary purge target.
• PA_DRAFT_INV_DETS_AR — An additional receiving-side draft invoice detail structure, accessed to ensure complete removal of inter-company invoice detail rows.
• PA_EXPENDITURE_ITEMS_ALL — The expenditure item table, referenced to correlate invoice details with their originating expenditures during purge selection.
• PA_TASKS — The project task table, used to resolve task relationships referenced by draft invoice details.

Usage Notes

PA_PURGE_ICIP is not intended for direct invocation by end users, forms, or custom extensions. It is invoked indirectly by the PA_PURGE package, which orchestrates the broader Projects data purge process, typically triggered from concurrent purge programs or the Projects administration menu. Administrators performing data cleanup or archiving of inter-company invoice history should execute the parent PA_PURGE concurrent request rather than calling PA_PURGE_ICIP directly. Because the package operates on interim and draft invoice data, it should be invoked only after downstream accounting and transfer processes have completed, and standard backup and purge validation procedures should precede execution.