Search Results create_no_qualification_type




Overview
Explore in AI Chat

Overview

The APPS.HR_NO_QUALIFICATION_TYPE_API package body is a public PL/SQL API within the Oracle E-Business Suite Human Resources (HR) module. It provides a programmatic interface for creating and maintaining "No Qualification Type" records in the Oracle HRMS qualification framework. In Oracle HRMS, the qualification type model distinguishes between qualification types that are established and tracked against a person, and those that represent the absence or non-possession of a formal qualification. This package encapsulates the business logic required to register such "no qualification" type definitions at the enterprise level, ensuring they conform to HR data validation and who-column (audit) conventions that govern all HRMS entities. The object is owned by the APPS schema and is classified as an API, which indicates it is intended for supported programmatic invocation rather than internal use.

Key Procedures and Functions

The ETRM documentation lists two documented procedures for this package body:

  • CREATE_NO_QUALIFICATION_TYPE — Inserts a new no-qualification type definition. This procedure applies HRMS validation rules, assigns the primary key from the HR sequence mechanism, and populates the mandatory WHO columns (creation date, created by, and related audit attributes). It is the entry point for introducing a new no-qualification type into the qualification catalog.
  • UPDATE_NO_QUALIFICATION_TYPE — Modifies an existing no-qualification type definition. It updates the mutable descriptive attributes of the record while preserving referential integrity and maintaining the WHO audit columns to record who last changed the row and when.

Both procedures follow the standard Oracle HRMS API design pattern of accepting a series of IN parameters, returning a status and error table, and providing a validation-only mode so callers can screen data before committing. Because the metadata does not enumerate the parameter lists, the exact signatures should be obtained from the live package specification rather than inferred.

Tables Accessed

The ETRM metadata does not expose the underlying tables accessed through APPS synonyms, and no table dependencies are documented for this object. Based on the HRMS qualification data model, the package operates on the qualification type base and translation tables (HR_QUALIFICATION_TYPES and its multilanguage counterpart) and relies on the HR sequence for key generation. Auxiliary dependencies shown in ETRM include HR_API, HR_QUALIFICATION_TYPE_API, and HR_UTILITY, which supply common validation, error-handling, and utility services used across HR APIs. The absence of documented table rows reflects limited metadata rather than an absence of data access.

Usage Notes

This package is typically invoked in one of three ways. First, from Oracle Forms or OA Framework pages within the HRMS Qualification Type setup when an administrator defines or edits no-qualification type entries. Second, from concurrent programs or data-load routines that seed qualification types during implementation. Third, from custom PL/SQL integration code that programmatically maintains the qualification catalog. Because the ETRM documentation states that this package is not referenced by any other database object, it is designed to be called directly by the application or custom code rather than as a dependency of another API. Callers must always inspect the returned status and error table and commit only on success; the package does not perform an autonomous commit. Standard HRMS API conventions apply, including initialization of the business group and the use of the FND message dictionary for error reporting.