Search Results cn_payrun_pvt




Overview
Explore in AI Chat

Overview

CN_PAYRUN_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic for Oracle EBS Incentive Compensation (CN) payruns. Within the Oracle Incentive Compensation module, a payrun represents the processing cycle in which calculated commissions are assembled, validated, and paid out to participants. This package serves as the internal engine that drives payrun creation, modification, deletion, and payment execution across the Incentive Compensation data model. Its "PVT" (private) classification indicates that it is not intended for direct invocation by external applications; rather, it resides beneath the public API layer and is consumed by sibling packages such as CN_PAYRUN_PVT_W (the wrapper), CN_PMT_TRANS_PVT, CN_PMTSUB_PUB, and CN_PAYMENT_WORKSHEET_PVT.

Key Procedures and Functions

The ETRM documentation identifies seven documented program units within CN_PAYRUN_PVT:

  • CREATE_PAYRUN — Establishes a new payrun record, initializing the payrun header against the appropriate operating unit and period context.
  • UPDATE_PAYRUN — Modifies attributes of an existing payrun, such as status, dates, or descriptive characteristics.
  • DELETE_PAYRUN — Removes a payrun and its associated records, subject to validation of the payrun state.
  • PAY_PAYRUN — Executes the payment processing for a payrun, transitioning calculated compensation amounts into payable form.
  • DELETE_PAYRUN_CONC — A concurrent-program-enabled wrapper for deletion, allowing payrun removal to be launched as a background concurrent request.
  • BUILD_BEE_API — Constructs the batch element entry (BEE) API structures that integrate Incentive Compensation payment results with Oracle Payroll for disbursement.
  • POPULATE_CCIDS — Populates cost center identifiers (CCIDs) used for accounting distribution of compensation expenses.

Tables Accessed

CN_PAYRUN_PVT reads and writes several core Incentive Compensation tables through APPS synonyms, including CN_PAYRUNS (the payrun header), CN_PAYMENT_TRANSACTIONS (individual payment lines), CN_PAYMENT_WORKSHEETS (intermediate worksheets), CN_PERIOD_STATUSES (period open/close controls that gate processing), CN_POSTING_DETAILS (accounting posting data), CN_OBJECTS, CN_PAY_GROUPS, CN_PAY_ELEMENT_INPUTS and CN_PAY_ELEMENT_INPUTS_ALL (payroll element inputs), CN_QUOTAS and CN_QUOTA_PAY_ELEMENTS (quota-to-payment mapping), and HR_OPERATING_UNITS (organization context). For payroll integration, it also touches the AP_INVOICES_INTERFACE, AP_INVOICE_LINES_INTERFACE, and their _S sequence tables, bridging compensation payments into Payables.

Usage Notes

This package is invoked indirectly. End users interact with payruns through the Incentive Compensation forms and the standard payment run concurrent programs; those front-end layers call the public wrapper CN_PAYRUN_PVT_W, which in turn delegates to CN_PAYRUN_PVT. The presence of DELETE_PAYRUN_CONC confirms that certain payrun operations are designed to run as concurrent requests. Because CN_PAYRUN_PVT is a private package, customizations and extensions should target the public wrapper or the API layer rather than this package directly. Any modification risks breaking the four packages that reference it. In 12.1.1 and 12.2.2 the package is documented as VALID in the ETRM repository, indicating it is actively used and supported within the shipped Incentive Compensation architecture.