Results for “ota_certifications”

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

Overview

APPS.OTA_CRT_BUS is the business-rule layer of the Oracle E-Business Suite certification management module (Oracle Training Administration / OTA). In the 12.1.1 and 12.2.2 code lines, the package belongs to the generated TAPI (Table API) family built on the Oracle HRMS API framework, and it is classified in the ETRM metadata as an OTHER API. Its role is to encapsulate the validation logic that must be satisfied before certification records are committed to the database, and to resolve the security context — business group, security group and legislation — under which a certification record may be accessed or modified.

The package body carries the standard TAPI signature elements: private global definitions holding the package name used in error messages, plus two globals (g_legislation_code and g_certification_id) reserved exclusively for the return_legislation_code routine. It is one of three packages referenced by other OTA components, and it depends on five OTA tables through APPS synonyms.

Key Procedures and Functions

• SET_SECURITY_GROUP_ID — Derives the security group and legislation code for a supplied certification by joining PER_BUSINESS_GROUPS_PERF to OTA_CERTIFICATIONS_B on BUSINESS_GROUP_ID. It performs mandatory-argument checking on the certification identifier, raises an error when the primary key cannot be resolved, and populates the two global variables used by the legislation lookup.
• RETURN_LEGISLATION_CODE — Returns the legislation code previously resolved by set_security_group_id for the current certification, allowing downstream validation and row-handler code to apply legislation-specific rules without repeating the security group query.
• INSERT_VALIDATE — Executes the pre-insert business rules for a certification record, confirming that required attributes and cross-table relationships are valid before the row is written to OTA_CERTIFICATIONS_B.
• UPDATE_VALIDATE — Applies the equivalent validation set for updates, ensuring that changes to an existing certification do not violate category inclusion, membership, or enrollment constraints.
• DELETE_VALIDATE — Determines whether a certification may be removed, checking dependent data such as enrollments and members before permitting the delete.
• CHK_SHOULD_WARN — Evaluates conditions that should produce a warning rather than a hard error, supporting forms behaviour in which the user is alerted but may continue.

Tables Accessed

• OTA_CERTIFICATIONS_B — The base certification table; the primary key source and the target of insert, update and delete validation.
• OTA_CATEGORY_USAGES — Establishes which certification categories are in use, supporting category-level validation.
• OTA_CERT_CAT_INCLUSIONS — Defines category-to-certification inclusion rules used during insert and update validation.
• OTA_CERTIFICATION_MEMBERS — Holds member assignments that constrain deletion and modification of a certification.
• OTA_CERT_ENROLLMENTS — Learner enrollment records that determine whether a certification is still in active use and therefore non-deletable.
• PER_BUSINESS_GROUPS_PERF — Read by set_security_group_id to resolve security group and legislation from the business group.

Usage Notes

OTA_CRT_BUS is not intended for direct invocation by end users. It is called by the certification maintenance forms and by the OTA certification TAPI/row-handler stack, and it is referenced by three other packages in the module. Custom code should not bypass this layer; where a certification must be created or changed programmatically, the supported route is the corresponding OTA certification API, which delegates to these validation routines. Direct calls are appropriate only for diagnostic work, since set_security_group_id requires a valid certification identifier and will raise an application error when the primary key is not found.