Search Results cn_wksht_get_pub




Overview
Explore in AI Chat

Overview

CN_WKSHT_GET_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, belonging to the Channel Revenue Management (CN) product family. It serves as a query and retrieval layer for payment worksheet data used in channel rebate, accrual, and settlement processing. Specifically, the package exposes functionality for obtaining sales representative worksheet information, allowing callers to resolve the worksheet assignments associated with payment processing across sales channels. The package operates as a controlled public interface, meaning its procedures are intended to be invoked by other Oracle EBS components such as forms, concurrent programs, and dependent packages rather than being called directly by end users.

Key Procedures and Functions

Based on the documented metadata, the package exposes one public procedure or function:

  • GET_SRP_WKSHT — Retrieves sales representative (SRP) worksheet information. This is the sole documented entry point in the package. It is designed to return worksheet data associated with sales representatives, supporting the Channel Revenue Management workflow where payment worksheets are assigned to, or queried by, sales representatives for review, approval, or settlement. The procedure does not expose its parameter list in the documented metadata; consumers should refer to the package specification in the EBS instance for exact signatures.

The package body also contains internal, non-public logic and a wrapper package (CN_WKSHT_GET_PUB_W) that follows the standard Oracle EBS pattern of separating the public API from its implementation. The wrapper is referenced alongside the main package, indicating the typical layered design where the "W" package provides a thin public entry point that delegates to the core package body.

Tables Accessed

The package references the following tables through APPS synonyms, reflecting both the worksheet domain and supporting resource/HR data:

  • CN_PAYMENT_WORKSHEETS — The primary worksheet table holding payment worksheet header information. Central to the package's retrieval purpose.
  • CN_PAYRUNS — Payment run data, linking worksheets to their parent pay runs.
  • CN_PERIOD_STATUSES — Period status information used to validate whether worksheet data falls in open or closed accounting periods.
  • CN_WORKSHEET_QG_DTLS — Worksheet quantity and grouping detail records.
  • CN_SALESREPS — Sales representative master data (referenced in the dependency list).
  • FND_USER — Application user information, typically used to resolve the current user or to map users to sales representatives.
  • JTF_RS_RESOURCE_EXTNS, JTF_RS_REP_MANAGERS, JTF_RS_GROUP_USAGES — Resource manager and group usage tables from the JTF Resource Manager schema, providing organizational hierarchy and resource group context for sales representatives.
  • JTF_NOTES_B — Notes associated with worksheets or resources.
  • DUAL — Used for single-row utility queries.

Reads dominate; the package primarily queries data rather than performing DML, consistent with its "GET" naming convention.

Usage Notes

CN_WKSHT_GET_PUB is typically invoked from within the Channel Revenue Management forms and concurrent programs that manage payment worksheets and sales representative assignments. It may also be called by custom extensions or other Oracle EBS packages that need to resolve worksheet information for a given sales representative or user context. Because it is classified as a public (PUB) API, it is considered a supported integration point, though Oracle's standard guidance applies: custom code should call the documented public procedures rather than the underlying package body or wrapper. The package's dependency on JTF resource tables means it assumes the Oracle Resource Manager (JTF) modules are installed and configured. Its reference by only one other package suggests a relatively narrow, focused usage pattern within the CN module. As with any APPS-owned package, direct modification is unsupported; all behavior is governed by the current EBS patch level.