Results for “csc_check_ratings_pub”

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

Overview

CSC_CHECK_RATINGS_PUB is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema, classified as a PUB (public) interface. It is part of the Oracle Quality / telephony channel (CSC) module set and governs the maintenance of check rating definitions — the grade, color, code, and numeric range configuration that qualifies a "check" (for example, a customer satisfaction or quality monitoring check) on a rating scale. The package exposes a business logic layer over the underlying check ratings entity, allowing callers to create, modify, and remove rating grade rows without directly manipulating the base tables.

The package declares AUTHID CURRENT_USER and carries a header revision date of 2002, indicating that it is a long-standing, stable component of the EBS code line that has been preserved unchanged through the 12.1.1 and 12.2.2 releases. The search term rating_color_id corresponds directly to a column in the package's public record type, confirming that this API is the documented programmatic entry point for the RATING_COLOR_ID attribute.

Key Procedures and Functions

The ETRM documentation lists three public procedures, each following the standard Oracle EBS API conventions (API version number, initialization message list, and commit control parameters, with an OUT message list and return status):

• CREATE_CHECK_RATINGS — Inserts a new check rating definition. Callers supply the check identifier, rating grade, associated rating color, rating code, and the low/high range values that define the grade's scoring band. Validation and any derived or seeded attributes are applied by the API before the row is persisted.
• UPDATE_CHECK_RATINGS — Modifies an existing check rating row, permitting correction of the grade, color assignment, range boundaries, or descriptive codes while retaining the original record identity and audit columns.
• DELETE_CHECK_RATINGS — Removes a check rating definition, typically used when a rating scale is reorganized or a check is retired.

Each procedure operates against the record type CHK_RATING_Rec_Type, which the package publishes for caller use. This record exposes CHECK_RATING_ID, CHECK_ID, CHECK_RATING_GRADE, RATING_COLOR_ID, RATING_CODE, COLOR_CODE, RANGE_LOW_VALUE, RANGE_HIGH_VALUE, the standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN), and SEEDED_FLAG, which distinguishes Oracle-seeded data from customer-defined data. A companion index-by table type, CHK_RATING_Tbl_Type, supports bulk operations, and the package exports the conventional empty-record constant G_MISS_CHK_RATING_REC.

Tables Accessed

The ETRM metadata for this package records no explicit table references through APPS synonyms. Based on the record structure and the module's data model, the API logically operates against the check ratings base table (the CSC check rating entity) and references the rating color lookup that supplies RATING_COLOR_ID. The API performs all inserts, updates, and deletes on behalf of the caller; because it is a PUB package with no documented dependents, it is intended to be the single controlled path for maintaining this data.

Usage Notes

CSC_CHECK_RATINGS_PUB is a server-side integration and extension API. It is typically invoked from Oracle Forms or OAF pages within the Quality/telephony setup flows, from concurrent programs that mass-load rating configurations, and from custom PL/SQL that must provision rating grades programmatically. Callers should always pass a valid API version, honor the p_commit and p_init_msg_list parameters, and inspect the returned message list and status before committing. Because seeded rows are flagged via SEEDED_FLAG, custom code should avoid modifying Oracle-seeded rating definitions. The ETRM record shows zero packages referencing this API, so its use is confined to direct invocations rather than internal call chains.