Search Results per_qtt_shd




Overview
Explore in AI Chat

Overview

APPS.PER_QTT_SHD is a shared PL/SQL package body in the Oracle E-Business Suite Human Resources (PER) product family, delivering the server-side implementation for the qualification types DDL entity. In Oracle HRMS terminology, "QTT" denotes Qualification Type, the reference data element that classifies the qualifications, competencies, and licences that an enterprise tracks against its employees, applicants, and positions. The "_SHD" suffix follows the Oracle HRMS convention for a shared package, indicating that the package body is intended to be reused across multiple forms, concurrent processes, and internal APIs rather than being bound to a single UI module.

The package occupies the middle tier of the qualification type stack. At the base sits the table pair PER_QUALIFICATION_TYPES and PER_QUALIFICATION_TYPES_TL. Above it sits the DateTracked, Row Who, and Business Group secured API surface that validates qualification type rows before insert, update, or delete. PER_QTT_SHD supplies the supporting logic beneath that surface: key locking, API-context detection, translated-column maintenance, and language-aware argument conversion.

The ETRM record shows the object as VALID in the APPS schema and classifies it as OTHER rather than a published PL/SQL interface, which is consistent with its role as an internal shared module. It is not referenced by any database object in the dependency graph, but it is reported as referenced by four other packages, indicating a small set of internal consumers within the HRMS stack.

Key Procedures and Functions

Five entry points are documented for the package body:

  • CONSTRAINT_ERROR — Centralised handler for constraint violations encountered during qualification type DML. It inspects the violated constraint through ALL_CONSTRAINTS and raises or translates the failure into a message the calling layer can present to the user, keeping error text out of the individual business rules.
  • API_UPDATING — Predicate that reports whether the current transaction originates from the supported API path rather than from direct DML or a form. This lets the row-level validation logic apply stricter or looser rules depending on the caller, and it underpins the audit expectations of the HR_API layer.
  • LCK — Locking routine used to serialise access to a qualification type row before it is modified. This guards against concurrent updates and supports the DateTrack pattern where a logical change is implemented as an end-date plus a new effective-dated row.
  • ADD_LANGUAGE — Maintains translated rows in the PER_QUALIFICATION_TYPES_TL table for a newly installed or newly added language, using FND_LANGUAGES to determine which languages are installed and active.
  • CONVERT_ARGS — Argument conversion routine that normalises incoming values, including translated names and descriptions, before they are passed to the underlying table operations or to FND_MESSAGE for message token substitution.

Parameter lists are not reproduced here; callers should obtain signatures from the package specification rather than infer them from this summary.

Tables Accessed

  • PER_QUALIFICATION_TYPES — The base table holding qualification type definitions, including the key identifier, business group, DateTrack columns, and enabled flag. The package reads and writes this table during validation, locking, and conversion.
  • PER_QUALIFICATION_TYPES_TL — The translation table holding language-specific name and description values, managed by ADD_LANGUAGE and consulted by CONVERT_ARGS when resolving translatable attributes.
  • FND_LANGUAGES — The Applications foundation table listing installed and available languages, used to drive multilingual row generation and language-aware lookups.
  • ALL_CONSTRAINTS — Queried by CONSTRAINT_ERROR to map an Oracle error to its originating constraint, allowing a meaningful message to be surfaced instead of a raw ORA- error code.

Additional dependencies named in the metadata include the FND_MESSAGE package for message text and token substitution, HR_API and HR_UTILITY for the HRMS API and DateTrack helper utilities, and the STANDARD and SYS schema constructs used by generated PL/SQL.

Usage Notes

PER_QTT_SHD is an internal module and should not be treated as a supported integration point. It is invoked indirectly whenever qualification types are created, updated, or end-dated through the Oracle HRMS qualification type maintenance forms, through the supported HRMS API layer, or through the multilingual setup processes that populate installation languages. Custom code requiring qualification type maintenance should call the documented HRMS API or the qualification type business object rather than PER_QTT_SHD directly, because the shared package assumes the calling context established by HR_API, including Business Group security and DateTrack session settings. Because four packages depend on it, changes to its internal behaviour can propagate across the HRMS stack, so any customisation should be limited to wrapping or extending the supported API surface. In upgrade projects between 12.1.1 and 12.2.2 the package body should be treated as Oracle-owned and left intact.