Results for “cn_prepost_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_PREPOST_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle E-Business Suite Channel Revenue Management (formerly Trade Management) module, which is delivered as part of the ETRM (Enterprise Trade and Revenue Management) product family. The package encapsulates the pre-posting logic used by Channel Revenue Management to convert commission and payment worksheet data into records that can subsequently be posted to Oracle Payables. It is declared with AUTHID CURRENT_USER, meaning that all unqualified object references resolve using the privileges of the invoking session rather than the package owner.

Because the package is classified as PVT (private), it forms part of the internal implementation layer of the application and is not intended as a public integration API. Its routines are consumed by the functional flows that stage, validate, and prepare commission lines and payment worksheets for downstream payment processing, and it maintains session-level state through global variables such as a batch identifier used to scope pre-posting work within a session.

Key Procedures and Functions

The package exposes five documented procedures:

• INITIALIZE_BATCH — Establishes a pre-posting batch for the current session and sets the package global variable that identifies the active batch. The batch may be system generated or driven by user-defined parameters. If a batch has already been initialized for the session, the procedure performs no action, making it idempotent. It also accepts a loading status and a posting batch record structure and returns status, message, and loading-status outputs.
• TERMINATE_BATCH — Ends the current pre-posting batch for the session and nullifies the batch identifier global variable, releasing the session's pre-posting context.
• CREATE_FROM_COMMLINE — Creates a pre-posting detail record for a commission line. The commission line may be treated as new or as reverted, reflecting corrections or reversals to previously processed commission data.
• CREATE_PREPOSTDETAILS — Populates pre-posting detail records, generating the individual lines that will ultimately be staged for posting.
• PREPOST_PAYWORKSHEETS — Drives the pre-posting of payment worksheets, preparing worksheet-based payment data for the posting process.

Tables Accessed

The package accesses the following tables, primarily through APPS synonyms:

• CN_COMMISSION_LINES / CN_COMMISSION_LINES_ALL — Source commission line data from which pre-posting details are created.
• CN_PAYMENT_WORKSHEETS — Payment worksheet data processed by the worksheet pre-posting routine.
• CN_PAYRUNS — Payment run information associated with commission and worksheet processing.
• CN_PERIOD_STATUSES — Period open/closed validation to ensure pre-posting occurs within valid accounting periods.
• CN_POSTING_BATCHES — The pre-posting batch header that scopes the session's work.
• CN_QUOTAS_ALL and CN_SRP_PAYEE_ASSIGNS_ALL — Quota and sales-representative payee assignment data used to determine payees and amounts.
• CN_WORKSHEET_BONUSES — Bonus information included in worksheet pre-posting.
• PLITBLM — A standard EBS PL/SQL table type used for array or bulk processing.

Usage Notes

CN_PREPOST_PVT is invoked internally by Channel Revenue Management flows rather than called directly by end users. It is typically reached from concurrent programs and forms that perform commission processing, payment worksheet preparation, or posting, and from other internal packages that drive the pre-posting sequence — the typical call order being Initialize_Batch, one or more creation routines, then Terminate_Batch. No other packages are documented as referencing it, so customization should be avoided; Oracle supports only the public APIs of the module, and the signature and behavior of these private routines may change without notice between releases such as 12.1.1 and 12.2.2.