Search Results get_rainvoice_num




Overview
Explore in AI Chat

Overview

PA_PWP_SUMM_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER API within the ETRM documentation set. Its documented purpose is to populate the PA_PWP_CUSTOMER_SUMM_ALL table, which underpins the Subcontractor (Supplier) Workbench in Oracle Projects. The package provides a lightweight mechanism for summarizing project-related customer billing data—specifically draft invoice information—so that the Subcontractor Workbench can present consolidated invoice details without directly querying the full Projects and Receivables transactional tables. The header comment indicates the source was last modified in January 2009 under version 120.0.12010000.2, and the package remains documented in both the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes three documented program units:

  • POPULATE_SUMMARY — A procedure that accepts a project identifier and populates the PA_PWP_CUSTOMER_SUMM_ALL table. This is the core load routine that refreshes the summary data consumed by the Subcontractor Workbench.
  • GET_RAINVOICE_NUM — A function that returns the Accounts Receivable invoice number associated with a project's draft invoice. This is the object surfaced by the search term "get_rainvoice_num." It accepts a project identifier and draft invoice number and returns a VARCHAR2.
  • GET_LAST_INVOICE_DATE — A function that returns the invoice date of a project's draft invoice, accepting the same project identifier and draft invoice number inputs and returning a DATE value.

Parameter lists are intentionally not reproduced here; the documented signatures take a project identifier and a draft invoice number for the two functions, and a project identifier for the procedure. No named exceptions or additional overloads are documented in the ETRM metadata.

Tables Accessed

The package references a broad set of APPS synonyms across the Projects, Receivables, General Ledger, and Trading Community models. Within Oracle Projects, it touches PA_PROJECTS, PA_PROJECTS_ALL, PA_AGREEMENTS_ALL, PA_DRAFT_INVOICES, PA_DRAFT_INVOICES_ALL, PA_DRAFT_INVOICE_ITEMS, PA_IMPLEMENTATIONS, and the summary target PA_PWP_CUSTOMER_SUMM (the base object behind PA_PWP_CUSTOMER_SUMM_ALL). Within Receivables, it reads AR_PAYMENT_SCHEDULES and AR_RECEIVABLE_APPLICATIONS_ALL to resolve invoice and application details. The GL_PERIOD_STATUSES table supplies period context, while FND_TERRITORIES_TL, HZ_CUST_ACCT_SITES, HZ_LOCATIONS, and HZ_PARTY_SITES provide customer and address attributes for the workbench display. The summary table is the principal write target; the remaining tables are read sources.

Usage Notes

ETRM records zero packages referencing PA_PWP_SUMM_PKG, indicating it is not a widely reused utility API and is most likely invoked from the Subcontractor Workbench forms or from a concurrent program that rebuilds the summary table on demand. Because the package is classified as OTHER rather than a public API, direct custom calls should be avoided where standard Oracle flows already trigger the summary population. Custom extensions should invoke POPULATE_SUMMARY only when a controlled refresh of PA_PWP_CUSTOMER_SUMM_ALL is required, and should call GET_RAINVOICE_NUM and GET_LAST_INVOICE_DATE as read-only lookups for reporting or validation logic, taking care to handle the exception raised when a matching draft invoice cannot be found. Always validate changes in a non-production environment, as the underlying tables are shared across Projects and Receivables.