Search Results get_init_cert_comp_date

Overview

APPS.OTA_AME_ATTRIBUTES is a PL/SQL package in the Oracle E-Business Suite Learning Management (OTA) module. It acts as a supporting attribute provider for the Approvals Management Engine (AME) integration within Oracle Learning Management. Its principal business role is to resolve and return descriptive attribute values associated with a given HR API transaction so that approval routing rules defined in AME can evaluate those attributes. Because AME rule evaluation is driven by named attributes, Learning Management must expose transactional context — such as which course, offering, class, certification, or enrollment a transaction pertains to — in a form AME can consume. This package supplies that mapping.

The package is classified as OTHER in the ETRM documentation and references only standard APPS synonyms. It is a read-oriented utility package rather than a transaction-processing API; it does not perform DML against business entities, and the metadata indicates it is referenced by zero other packages, confirming it is an entry-point-style utility invoked directly by the AME attribute framework rather than a shared internal library.

Key Procedures and Functions

The package exposes 17 documented functions. The user search term get_course_name corresponds to the GET_COURSE_NAME function, which returns the name of the course associated with the transaction. All functions take a transaction identifier tied to HR_API_TRANSACTIONS.TRANSACTION_ID as the driver for attribute resolution.

• GET_COURSE_NAME — returns the course name for the transaction; the most commonly referenced attribute for course-level approval rules.
• GET_OFFERING_NAME — returns the offering name associated with the transaction.
• GET_CLASS_NAME — returns the class (event) name.
• GET_CLASS_LOCATION — returns the location of the class, resolved through HR location data.
• GET_CLASS_STANDARD_PRICE — returns the standard price for the event/class.
• GET_LEARNING_PATH_NAME — returns the learning path name.
• GET_COURSE_PRIMARY_CATEGORY — returns the primary category of the course.
• GET_ENROLLMENT_STATUS — returns the enrollment status for the transaction.
• GET_OFR_DELIVERY_MODE — returns the delivery mode of the offering.
• GET_CERTIFICATION_NAME and GET_CERTIFICATION_TYPE — return the certification name and type.
• GET_CERT_PERIOD_START_DATE and GET_CERT_PERIOD_END_DATE — return the certification period boundaries.
• GET_INIT_CERT_COMP_DATE — returns the initial certification completion date.
• GET_INIT_CERT_DUR, GET_RENEWAL_DURATION, and GET_VALIDITY_DURATION — return certification duration metrics.

Tables Accessed

Resolution draws on the HR API transaction model plus the principal Learning Management entity tables.

• HR_API_TRANSACTIONS and HR_API_TRANSACTION_STEPS — provide the transaction context and step detail used to identify the business object under approval.
• OTA_EVENTS and OTA_EVENTS_TL — source the class/event name and delivery information for GET_CLASS_NAME and GET_OFR_DELIVERY_MODE.
• OTA_ACTIVITY_VERSIONS_TL and OTA_CATEGORY_USAGES_TL — supply course and activity names and primary category values (GET_COURSE_NAME, GET_COURSE_PRIMARY_CATEGORY).
• OTA_ACT_CAT_INCLUSIONS — links activities to categories for category resolution.
• OTA_BOOKING_STATUS_TYPES and OTA_BOOKING_STATUS_TYPES_TL — provide enrollment status values (GET_ENROLLMENT_STATUS).
• OTA_CERTIFICATIONS_B and OTA_CERTIFICATIONS_TL — supply certification name and type.
• OTA_CERT_ENROLLMENTS and OTA_CERT_PRD_ENROLLMENTS — provide certification period, completion, renewal, and validity dates.
• OTA_DELEGATE_BOOKINGS — supports enrollment/booking attribute resolution.
• HR_LOCATIONS_ALL — provides class location details.

Usage Notes

OTA_AME_ATTRIBUTES is invoked through the AME attribute framework rather than by direct application calls. AME supplies the transaction identifier, and each registered function is called to return a scalar value used by approval rule conditions. Typical scenarios include approving enrollments, bookings, and certification-related transactions where routing depends on course, offering, class, category, price, delivery mode, or enrollment status.

Because all functions return simple scalars (VARCHAR2 or NUMBER), they are well suited to AME attribute registration. The package performs no writes and is not referenced by other packages, so custom code should treat it as read-only and avoid extending it with DML logic. Developers building custom approval rules may reference GET_COURSE_NAME and its sibling functions directly, but should not modify the package signature, since AME attribute definitions bind to these function names.