Results for “get_pay_group_roles”

16 results




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

Overview

CN_PAY_GROUP_DTLS_PVT is a private PL/SQL package in the Oracle EBS Channel Revenue Management (CRM) module, owned by the APPS schema and declaring AUTHID CURRENT_USER. It functions as a data-retrieval and structural support layer for the pay group detail inquiry infrastructure. Pay groups in Channel Revenue Management define the combination of a period set, period type, and calendar period against which supplier or channel sales activity is settled and remunerated. The package exposes three record type definitions — pay_group_dtls_rec_type, pay_group_sales_rec_type, and pay_group_roles_rec_type — each mirroring a distinct query surface: the pay group plus its accounting period attributes, the pay group joined to its sales representatives, and the pay group joined to its associated roles. Every record field is initialized to an FND_API / CN_API G_MISS sentinel value, which allows callers to distinguish unpopulated attributes from legitimately null ones. The "PVT" suffix classifies this as a private package: it is not part of the supported public API surface and should be treated as an internal implementation detail of the Channel Revenue Management pay group inquiry stack.

Key Procedures and Functions

  • GET_PAY_GROUP_DTLS — Retrieves the header-level detail of a pay group, populating the pay_group_dtls_rec_type structure with the pay group identifier and name, the period set name, the period type, and the specific period name, period year, quarter number, start date, and end date from the period statuses table.
  • GET_PAY_GROUP_SALES — Returns pay group information together with the sales representatives assigned to that pay group, populating pay_group_sales_rec_type with the sales representative name, employee number, and the effective start and end dates of the sales rep to pay group association.
  • GET_PAY_GROUP_ROLES — Returns pay group information together with the roles linked to the pay group, populating pay_group_roles_rec_type with the role identifier, role name, and the effective start and end dates of the role to pay group association.

The record types rather than explicit procedure parameter lists are the documented interface contract here; each procedure returns its corresponding record structure.

Tables Accessed

  • CN_PAY_GROUPS — The primary pay group definition, supplying the pay group identifier, name, and period type.
  • CN_PERIOD_SETS — Provides the period set name to which the pay group's calendar belongs.
  • CN_PERIOD_STATUSES — Supplies the period-level attributes: period name, period year, quarter number, and open/close dates.
  • CN_SRP_PAY_GROUPS — The intersection of sales representatives and pay groups, providing sales rep assignment dates.
  • CN_ROLE_PAY_GROUPS — The intersection of roles and pay groups, providing role assignment dates.

All tables are accessed through APPS synonyms, consistent with the package's AUTHID CURRENT_USER declaration and APPS ownership.

Usage Notes

As a private package, CN_PAY_GROUP_DTLS_PVT is invoked by other Channel Revenue Management modules rather than called directly from user-facing forms or concurrent programs. ETRM metadata records one dependent package, indicating that a sibling API or inquiry package consumes these getters to populate pay group LOVs, detail blocks, or validation logic. Because the record structures are seeded with G_MISS sentinels, callers must test each attribute before display to avoid rendering sentinel values. Customizations should not call this package directly; instead they should use the supported public Channel Revenue Management APIs, since the private interface may change without notice between patch levels or between EBS 12.1.1 and 12.2.2. The header comment indicates a coded version of 115.4, dated 2002, reflecting the historical lineage of this component.