Search Results per_special_info_types_s

Overview

APPS.PER_SIT_PKG is a PL/SQL package body in the Oracle E-Business Suite Human Resources (PER) module that manages Special Information Types (SITs) within an HR business group. Special Information Types are the configurable, descriptive flexfield-based categories — such as JOB, POSITION, SKILL, OTHER, OSHA, and ADA, as declared by the package's internal constants — that allow organizations to capture additional, non-standard information about people, jobs, and positions.

The package provides the server-side validation and data-manipulation logic that underpins the Special Information Types setup form. It enforces uniqueness of a Special Information Type definition within a business group, controls whether a flex structure may be modified or deleted once it has been consumed, and encapsulates the insert, update, and delete operations against the underlying PER_SPECIAL_INFO_TYPES tables. In the context of Oracle EBS 12.1.1 and 12.2.2, the package is classified as an "OTHER" API — that is, a supporting internal package rather than a formally published public API.

This package is not referenced by any other documented package, indicating that its callers are primarily Oracle Forms (notably the Special Information Types maintenance form) rather than other PL/SQL components.

Key Procedures and Functions

• CHECK_UNIQUE_SIT — Verifies that a Special Information Type is unique within the given business group and flex structure, raising a predefined error when a conflicting definition already exists.
• SIT_FLEX_USED — A function that determines whether the flex structure underlying a Special Information Type has already been used in Personal Analyses, returning a boolean result.
• SIT_DEL_VALIDATION — Performs the validation checks required before a Special Information Type may be deleted, protecting referential integrity of configured data.
• POPULATE_FIELDS — Populates the appropriate fields for a Special Information Type record, typically deriving or defaulting values during form processing.
• GET_SPECIAL_INFO_TYPE_ID — Retrieves the unique identifier for a Special Information Type, allowing callers to resolve a definition to its primary key.
• INS_SIT — Inserts a new Special Information Type definition into the base and translated tables.
• LCK — Locks the relevant record to serialize concurrent maintenance activity against a Special Information Type.
• UPD_SIT — Updates an existing Special Information Type definition.
• RESET_USAGES — Clears or resets usage records tracked for Special Information Types, typically when usage tracking must be re-established.
• DEL_SIT — Deletes a Special Information Type definition from the repository.
• SIT_IN_USE — Determines whether a Special Information Type is currently in use, guarding edits and deletions.

Tables Accessed

• PER_SPECIAL_INFO_TYPES and PER_SPECIAL_INFO_TYPES_S — The base and translated (TL) tables holding the Special Information Type definitions; the primary read/write targets for INS_SIT, UPD_SIT, DEL_SIT, and GET_SPECIAL_INFO_TYPE_ID.
• PER_SPECIAL_INFO_TYPE_USAGES — Records where a Special Information Type has been used; consulted by SIT_IN_USE and manipulated by RESET_USAGES.
• PER_PERSON_ANALYSES — Personal Analyses data; queried by SIT_FLEX_USED to determine whether a flex structure has been applied.
• PER_ANALYSIS_CRITERIA — Analysis criteria definitions, referenced when assessing usage of Special Information Type structures.
• PER_JOB_REQUIREMENTS — Job requirement records, referenced to determine whether a Special Information Type is required or in use by a job.
• PAY_LEGISLATION_RULES — Legislative rule definitions that can affect validity and processing of Special Information Types by legislation.
• DUAL — Used for singleton queries and PL/SQL evaluation.

All tables are accessed through APPS synonyms, consistent with standard EBS naming and the reliance on the APPS schema.

Usage Notes

PER_SIT_PKG is invoked primarily by the Oracle HRMS Special Information Types form, which calls the insert, update, delete, lock, and validation procedures as the user maintains SIT definitions. The uniqueness, deletion, and in-use checks are executed to prevent invalid configurations and to protect data already captured against a Special Information Type.

In the context of the user's search for "add_usage," the usage-tracking procedures — SIT_IN_USE, RESET_USAGES, and the PER_SPECIAL_INFO_TYPE_USAGES table — are the relevant code paths. These are triggered when a Special Information Type becomes associated with personal analysis data, job requirements, or other consuming entities, and when those associations are subsequently cleared.

As the package is documented as an "OTHER" API with no dependent packages, it is not intended for general custom extension. Custom code should interact with the supported HRMS public APIs rather than invoking PER_SIT_PKG directly, and any direct calls must account for the business group context and the flex structure identifier required by most of its procedures.