Search Results renew_cert_prd_enrollment




Overview
Explore in AI Chat

Overview

The APPS.OTA_CERT_PRD_ENROLLMENT_SWI package is a self-service wrapper (SWI) interface within the Oracle E-Business Suite Oracle Learning Management (OLM) module, which is part of the Oracle Training Administration (OTA) product family. Its primary business function is to expose certification period enrollment operations to self-service and web-facing application layers in a controlled, validated manner. Rather than invoking the underlying business logic directly, self-service callers route through this package, which in turn delegates to the core certification period enrollment API.

The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the package owner, consistent with Oracle's self-service security model. The source header indicates an internal development-use classification, and the ETRM metadata classifies the API type as OTHER. The documented procedures handle the full lifecycle of certification period enrollments — creation, modification, deletion, and renewal — with the renewal path (renew_cert_prd_enrollment) being the specific operation matching the user's search interest.

Key Procedures and Functions

The package documents four procedures:

  • CREATE_CERT_PRD_ENROLLMENT — The self-service wrapper for ota_cert_prd_enrollment_api.create_cert_prd_enrollment. It creates a new certification period enrollment record, accepting derived effective dates and period attributes. The documented signature includes parameters for the enrollment identifier, period status, completion date, certification period start and end dates, business group, and a standard DFF attribute block (attribute category plus attribute1 through attribute12). It supports validation-only mode via a p_validate flag.
  • UPDATE_CERT_PRD_ENROLLMENT — Modifies an existing certification period enrollment, allowing changes to period status, dates, and descriptive flexfield attributes while preserving the enrollment identity.
  • DELETE_CERT_PRD_ENROLLMENT — Removes a certification period enrollment record, typically invoked when an enrollment is cancelled or created in error.
  • RENEW_CERT_PRD_ENROLLMENT — Extends or re-establishes a certification period enrollment, supporting recertification workflows where a learner's certification validity must be continued past its original end date.

No parameter lists beyond the documented create signature are asserted here; each wrapper mirrors its corresponding API procedure's contract.

Tables Accessed

The package operates against two documented tables via APPS synonyms:

  • OTA_CERT_ENROLLMENTS — Stores the parent certification enrollment, representing a learner's enrollment in a certification. The period enrollment wrappers read this table to validate the parent enrollment context before creating or renewing period records.
  • OTA_CERT_PRD_ENROLLMENTS — Stores the individual certification periods (start date, end date, period status, completion date) associated with a certification enrollment. This is the primary table written by CREATE, UPDATE, DELETE, and RENEW operations.

Usage Notes

This wrapper is intended for internal self-service invocation rather than direct end-user or batch calls. In Oracle EBS 12.1.1 and 12.2.2, it is typically invoked by self-service OLM pages and by the certification management flows surfaced through the learner and administrator responsibility UIs. The renewal procedure is the entry point associated with recertification actions initiated from those pages.

Because no other packages reference it per the ETRM metadata, custom code should treat it as an integration surface only when replicating self-service behavior; otherwise, direct calls to the underlying ota_cert_prd_enrollment_api are preferable for back-end processing. Developers must honor the effective date and business group parameters, as these govern date-tracked validation and multi-organization data security.