Search Results pa_salesreps




Overview
Explore in AI Chat

Overview

PA_SALESREPS is an Oracle Applications (APPS) PL/SQL package body that supports sales credit processing within the Oracle Projects and Oracle Receivables integration flow. Its central business function is to process project-related sales credits and to derive or validate the salesperson and sales credit type information that is attached to project invoices and interface records. In Oracle EBS releases 12.1.1 and 12.2.2, sales credits associate a salesperson with a revenue or invoice line so that credit and compensation reporting in Receivables and Oracle Sales can be attributed correctly.

The package operates entirely within the APPS schema and is classified as OTHER in the ETRM documentation metadata, meaning it is not an externally published public API but an internal supporting package used by the Oracle Projects subsystem. It is not referenced by any other database object, and the documented procedures are limited to two entry points.

Key Procedures and Functions

  • PROCESS_PROJECT — The primary driver routine. Based on ETRM metadata it processes a project for sales credit purposes, working across project, customer, and invoice interface data. It determines the salespersons and credit receivers associated with the project and applies the appropriate sales credit types so that interface rows can be built or validated prior to transfer into Receivables.
  • VALIDATE_SALES_CREDIT_TYPE — A validation routine that checks a sales credit type against the setup sources referenced by the package, notably the sales credit type definitions and project lookup values. It ensures that only enabled and correctly configured sales credit types are accepted before downstream processing continues.

No parameter lists are documented in the ETRM metadata; only the procedure names and their purposes are recorded.

Tables Accessed

The ETRM dependency listing and synonym reference metadata identify the following documented tables accessed by PA_SALESREPS:

Usage Notes

Because PA_SALESREPS is not referenced by any other database object, it is invoked through Oracle Projects application logic rather than being called from dependent packaged APIs. Typical invocation paths include the Project Billing and Project Costing flows that create or adjust sales credits, and the Receivables interface import process for project invoices. It is also common for custom extensions and concurrent programs that manipulate project sales credits to call the documented procedures directly. Implementers should treat the package as an internal, unsupported interface, review the ETRM dependency tree before modifying related data, and validate all sales credit types against SO_SALES_CREDIT_TYPES and the relevant lookups prior to submission.