Search Results update_cert_prd_enrollment




Overview
Explore in AI Chat

Overview

OTA_CERT_PRD_ENROLLMENT_API is the public PL/SQL application programming interface for managing certification period enrollment records within Oracle EBS Human Resources (Oracle Advanced Benefits / Oracle Learning Management certification tracking). The package encapsulates the business rules required to create, modify, delete, and renew rows in the OTA_CERT_PRD_ENROLLMENTS entity, which stores the period-by-period enrollment detail of a learner's certification journey. Each certification enrollment in OTA_CERT_ENROLLMENTS may span multiple certification periods; this API governs those period segments, including their start and end dates, completion and expiration dates, and status codes. The package follows the standard Oracle EBS API pattern, providing date-effective, validation-aware, and object-version-number-controlled DML so that callers manipulate certification period enrollment data without issuing direct SQL against the underlying tables. It is classified as an API in the ETRM repository, owned by APPS, and is referenced by two other packages, indicating that it is a building block consumed by higher-level certification processing logic rather than an end-user entry point.

Key Procedures and Functions

  • CREATE_CERT_PRD_ENROLLMENT — Inserts a new certification period enrollment. It accepts the effective date, a validate-only flag, and the attributes of the new period record, including the certification enrollment, period status, business group, period start and end dates, completion and expiration dates, and the descriptive flexfield attribute columns. It returns the newly generated certification period enrollment identifier and object version number to the caller.
  • UPDATE_CERT_PRD_ENROLLMENT — Modifies an existing certification period enrollment. This is the procedure associated with the "update_cert_prd_enrollment" search term and is the standard route for changing period status, completion, start/end, or expiration dates and flexfield values. It observes date-effective and object version number checks so that concurrent modifications are detected.
  • DELETE_CERT_PRD_ENROLLMENT — Removes a certification period enrollment record, subject to the validation and referential rules enforced by the package.
  • RENEW_CERT_PRD_ENROLLMENT — Creates the next certification period segment for an existing certification enrollment, supporting the recurring renewal cycle that characterizes certification maintenance. It applies the same validation and versioning conventions as the create and update procedures.

Tables Accessed

  • OTA_CERT_PRD_ENROLLMENTS — The primary table managed by this package; holds the certification period enrollment rows that the procedures insert, update, delete, and renew.
  • OTA_CERT_ENROLLMENTS — The parent certification enrollment record. It is read to validate the context of the period enrollment and to maintain the required parent-child relationship.
  • OTA_CERTIFICATIONS_B — The certification definition. Referenced to validate that the certification being enrolled or renewed exists and to derive certification-level attributes.
  • WF_ITEMS — The Oracle Workflow item table, consulted and updated to support workflow-driven notifications and approvals associated with certification period enrollment events.

Usage Notes

As a server-side API owned by APPS, OTA_CERT_PRD_ENROLLMENT_API is invoked primarily by the certification and learning management forms and by other PL/SQL packages in the certification family; the two package references documented in ETRM confirm this internal consumption pattern. Because the procedures expose date-effective and validate-only parameters, callers should pass the effective date of the business transaction, not the system date, and should run in validate mode first when building interactive or batch interfaces. Callers must supply an object version number on update and delete operations to protect against lost updates. Custom integrations that previously used the older create_cert_prd_enrollment and update_cert_prd_enrollment signatures should note that the current version of the package body retains the create procedure with the OUT parameters p_cert_prd_enrollment_id and p_object_version_number; these values must be captured and passed back on subsequent UPDATE_CERT_PRD_ENROLLMENT calls. Direct DML against OTA_CERT_PRD_ENROLLMENTS should be avoided, since bypassing this API skips the validation, versioning, and workflow logic that the package provides.