Search Results set_ced_and_bb

Overview

CN_PAYMENT_WORKSHEET_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic for creating, maintaining, and refreshing payment worksheets within Oracle E-Business Suite's Channel Partner / Trade Management (CN) module. Payment worksheets represent the working documents used by payee managers to assemble commission and incentive payment lines into pay runs prior to disbursement. The package is classified as a Private (PVT) API, meaning it is not intended as a public integration interface; instead it provides the internal engine consumed by public APIs, controller packages, and concurrent programs such as CN_PAYMENT_WORKSHEET_PVT_W, CN_PAYRUN_PVT, CN_PMT_TRANS_PVT, CN_WKSHT_GET_PUB, and CN_WKSHT_CT_UP_PUB. It depends on the FND_API foundation layer for standard error handling and on the FND_CONCURRENT_PROGRAMS table for program resolution.

Key Procedures and Functions

The package exposes ten documented procedures and functions, reflecting a complete lifecycle for worksheet management:

• CREATE_WORKSHEET — Creates a single payment worksheet record, establishing the payee, payrun, and worksheet header context.
• CREATE_MULTIPLE_WORKSHEETS — Creates more than one worksheet in a single invocation, typically for batch payee processing.
• CREATE_MULT_WORKSHEET_CONC — Concurrent-program wrapper that drives bulk worksheet creation from the concurrent manager, invoking the multiple-worksheet logic.
• UPDATE_WORKSHEET — Modifies attributes of an existing worksheet while preserving associated payment transaction lines.
• DELETE_WORKSHEET — Removes a worksheet and its dependent data following the internal validation rules of the module.
• GET_CED_AND_BB / SET_CED_AND_BB — Paired accessors for retrieving and assigning the Commission Effective Date and Bonus Base (CED/BB) values used in commission calculation context.
• REFRESH_WORKSHEET_PARENT / REFRESH_WORKSHEET_CHILD — Recompute or re-derive parent (worksheet header) and child (worksheet line) data, used when underlying commission lines change.
• GENERIC_CONC_PROCESSOR — A shared concurrent-processor entry point that dispatches work submitted from concurrent programs, providing consistent argument parsing and completion handling.

Tables Accessed

The package reads and writes several core CN tables through APPS synonyms. Worksheet and payrun headers are managed in CN_PAYMENT_WORKSHEETS, CN_PAYMENT_WORKSHEETS_ALL, CN_PAYRUNS, and CN_PAYRUNS_ALL, which store the worksheet and pay run definitions. Commission source data is drawn from CN_COMMISSION_LINES, CN_COMMISSION_LINES_ALL, CN_PMT_PLANS, and CN_PERIOD_STATUSES / CN_PERIOD_STATUSES_ALL with CN_PERIOD_TYPES, supporting period-driven eligibility. Payment transaction detail is persisted in CN_PAYMENT_TRANSACTIONS, CN_PAYMENT_TRANSACTIONS_ALL, and the sequence CN_PAYMENT_TRANSACTIONS_S. Posting batches are referenced via CN_POSTING_BATCHES, and concurrent-program metadata is retrieved from FND_CONCURRENT_PROGRAMS.

Usage Notes

CN_PAYMENT_WORKSHEET_PVT is typically invoked indirectly. Forms and public APIs (CN_WKSHT_GET_PUB, CN_WKSHT_CT_UP_PUB) call it to build or alter worksheets, while CN_PAYRUN_PVT and CN_PMT_TRANS_PVT rely on it during payrun assembly and payment transaction generation. Bulk worksheet creation in EBS 12.1.1 and 12.2.2 is generally launched through the Create Payment Worksheets concurrent program, which calls CREATE_MULT_WORKSHEET_CONC and GENERIC_CONC_PROCESSOR. Because it is a private package, custom code should not call it directly; extensions should use the public CN interfaces or registered concurrent programs to ensure internal validations and FND_API error handling are preserved.