Search Results get_assign_status




Overview
Explore in AI Chat

Overview

APPS.HR_HELPDESK_UTIL_SS is a PL/SQL utility package within the Oracle E-Business Suite Human Resources module. Its name follows the Oracle naming convention for a stored specification belonging to the HR Help Desk utility layer, with the "_SS" suffix indicating it is defined as a package specification whose body contains the executable logic. The package consolidates a set of low-level lookup and validation routines that resolve identifiers, statuses, and descriptive attributes for persons, assignments, responsibilities, functions, and security groups. In EBS 12.1.1 and 12.2.2 the package is registered in the APPS schema and is classified under the ETRM metadata as an "OTHER" API type, meaning it is not a public, formally supported business API but an internal helper used by HR Help Desk and related self-service flows.

The header comment ($Header: hrhdutilss.pkh 120.2.12010000.5 2008/12/12 ...) confirms the specification has been stable since the 12.0 code line and carried forward unchanged into 12.1 and 12.2. Its functions are designed to be callable from PL/SQL, forms, and concurrent code where a lightweight resolution or validation step is required without duplicating query logic.

Key Procedures and Functions

The package specification documents nine callable functions. Each returns a VARCHAR2 result unless otherwise implied by its role.

  • GET_PERSON_ID — Resolves a person identifier from employee number, business group, and assignment ("CWK") number inputs held on PER_ALL_PEOPLE_F.
  • GET_ASSGN_ID — Returns the assignment identifier associated with a given person.
  • GET_PERSON_STATUS — Returns the current status of a person record, typically reflecting the active/inactive state used for help desk eligibility checks.
  • GET_ASSIGN_STATUS — Returns the status of a specific assignment.
  • GET_PERSON_TYPE_STATUS — Returns the person type combined with status information, used where both attributes are needed for display or routing.
  • VALIDATE_FUNCTION — Performs validation against the function definition layer, confirming that a requested function is legitimate within the current context.
  • GET_FUNCTION_TYPE — Returns the type classification for a named function.
  • GET_RESP_NAME — Resolves a responsibility identifier to its descriptive name.
  • GET_SECGRP_KEY — Returns the security group key corresponding to a supplied security group identifier.

Tables Accessed

The package reads from six documented base tables through APPS synonyms:

  • PER_ALL_PEOPLE_F — Source of person, employee number, business group, and assignment number data for the person-resolution functions.
  • PER_ALL_ASSIGNMENTS_F — Provides assignment identifiers and assignment status values.
  • FND_FORM_FUNCTIONS — Backs the function validation and function type lookups.
  • FND_MENU_ENTRIES — Supports menu and function validation context.
  • FND_RESPONSIBILITY — Supplies responsibility names for GET_RESP_NAME.
  • FND_SECURITY_GROUPS — Supplies security group keys for GET_SECGRP_KEY.

All access is read-only; the package performs no DML.

Usage Notes

Because the ETRM metadata records zero packages referencing HR_HELPDESK_UTIL_SS, it is not a dependency of other documented APIs. It is normally invoked directly by HR Help Desk forms, OAF pages, and custom PL/SQL that need to translate an employee identifier, assignment, responsibility, or security group into a usable value during ticket creation, routing, or validation. Oracle does not list it as a supported public interface, so customizations should treat the signatures as version-sensitive and avoid depending on behavior beyond the documented functions. In 12.1.1 and 12.2.2 the package is compiled into the APPS schema and requires the standard HR and Application Object Library grants available to that schema.