Search Results get_certification_type

Overview

The APPS.OTA_AME_ATTRIBUTES package body is a supporting PL/SQL unit within the Oracle E-Business Suite Training Administration (OTM/OTA) module. Its role is to supply attribute values to the Oracle Approvals Management Engine (AME) during workflow-driven approval processing of training-related transactions such as enrollments, certifications, offerings, and learning paths. AME requires attribute values to evaluate approval rules, and this package acts as the bridge that extracts those values from the Training schema and exposes them to the approval engine workflow. The header comment identifies the source as otamewkf.pkb, indicating the package was designed for the OTA-AME workflow integration.

The package is classified as OTHER in the ETRM metadata for 12.2.2 and is owned by APPS. It is not referenced by any other packaged API, meaning it is invoked indirectly by the workflow/AME infrastructure rather than called directly by dependent PL/SQL code.

Key Procedures and Functions

The package exposes seventeen documented functions, each retrieving a specific attribute for AME rule evaluation:

• GET_CLASS_STANDARD_PRICE — returns the standard price associated with a class.
• GET_LEARNING_PATH_NAME — returns the name of a learning path.
• GET_COURSE_PRIMARY_CATEGORY — returns the primary category of a course.
• GET_ENROLLMENT_STATUS — returns the current status of an enrollment.
• GET_OFR_DELIVERY_MODE — returns the delivery mode of an offering.
• GET_COURSE_NAME — returns the course name.
• GET_OFFERING_NAME — returns the offering name.
• GET_CLASS_NAME — returns the class name.
• GET_CLASS_LOCATION — returns the class location.
• GET_CERT_PERIOD_END_DATE and GET_CERT_PERIOD_START_DATE — return the start and end dates of a certification period.
• GET_CERTIFICATION_NAME — returns the certification name.
• GET_CERTIFICATION_TYPE — returns the certification type, the attribute the user searched for. It supports AME rules that branch on whether a certification is of a particular type.
• GET_INIT_CERT_COMP_DATE and GET_INIT_CERT_DUR — return the initial certification completion date and duration.
• GET_RENEWAL_DURATION — returns the renewal duration for a certification.
• GET_VALIDITY_DURATION — returns the validity duration.

The package also includes private helper functions such as get_item_type and get_item_key, which derive the workflow item type and item key from HR_API_TRANSACTIONS and HR_API_TRANSACTION_STEPS using the transaction identifier.

Tables Accessed

The package reads from a broad set of Training and HR tables, including: HR_API_TRANSACTIONS and HR_API_TRANSACTION_STEPS for workflow context; OTA_CERTIFICATIONS_B and OTA_CERTIFICATIONS_TL for certification definitions; OTA_CERT_ENROLLMENTS and OTA_CERT_PRD_ENROLLMENTS for certification enrollment and period data; OTA_EVENTS and OTA_EVENTS_TL for event details; OTA_ACTIVITY_VERSIONS_TL and OTA_CATEGORY_USAGES_TL for course and category information; OTA_ACT_CAT_INCLUSIONS for activity-category inclusion; OTA_BOOKING_STATUS_TYPES and OTA_BOOKING_STATUS_TYPES_TL for booking status; OTA_DELEGATE_BOOKINGS for delegate bookings; and HR_LOCATIONS_ALL for class location. These are accessed through APPS synonyms.

Usage Notes

OTA_AME_ATTRIBUTES is invoked by the AME integration layer when approval rules for training transactions require attribute evaluation. It is not intended for direct invocation from custom forms or concurrent programs; developers writing AME rule configurations for OTA transactions reference the functions exposed here. Because it is unreferenced by other packages, changes to its logic should be tested through the end-to-end AME approval flow rather than through direct API calls. The GET_CERTIFICATION_TYPE function in particular should be used in AME rules that need to conditionally approve or reject certification-related transactions based on the certification type value.