Search Results get_occupational_category




Overview
Explore in AI Chat

Overview

APPS.PER_ZA_WSP_ARCHIVE_PKG is a South Africa–specific Oracle HRMS package that supports the archiving of Workplace Skills Plan (WSP) data. The Workplace Skills Plan is a statutory reporting obligation under South African skills development legislation, and this package exists to persist the workforce and training information required for those submissions. The package is defined with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling schema rather than the owner, which is consistent with standard Oracle E-Business Suite seed data conventions. The header file (perzawspa.pkh) was first created on 11-DEC-2006 by A. Mahanty and evolved through versions 115.0 to 115.2, the latter adding the get_parameter utility. The package is classified as OTHER in the ETRM metadata, indicating it is not a public, supported API but an internal code unit.

Key Procedures and Functions

The package exposes four procedures and two functions:

  • range_cursor — Returns a SQL string for a given action context, used to drive the archive extraction range.
  • action_creation — Creates archive action records over a person range, supporting chunked processing.
  • archive_init — Initialises the archive run for a given action.
  • archive_data — Performs the actual archival of data for a specified action and effective date.
  • get_occupational_category — Returns the occupational category for an assignment as of a report date, deriving it from assignment, job, grade, position, and business group identifiers (including p_report_date, p_assignment_id, p_job_id, p_grade_id, p_position_id, p_business_group_id). This function is what most callers reference when searching for occupational category logic in the WSP context.
  • get_parameter — Extracts a named parameter from a parameter list string.

Tables Accessed

The package reads from HR and OTA (Oracle Training Administration) tables via APPS synonyms. Core HR data comes from PER_ALL_ASSIGNMENTS_F, HR_ALL_ORGANIZATION_UNITS, and HR_ORGANIZATION_INFORMATION. Occupational category resolution is supported by FND_LOOKUP_VALUES. Training and certification data, central to WSP reporting, is drawn from OTA_EVENTS, OTA_ACTIVITY_VERSIONS, OTA_BOOKING_STATUS_TYPES, OTA_CERTIFICATIONS_B, OTA_CERTIFICATIONS_TL, OTA_CERTIFICATION_MEMBERS, OTA_CERT_ENROLLMENTS, OTA_DELEGATE_BOOKINGS, OTA_LEARNING_PATHS, OTA_LEARNING_PATHS_TL, and OTA_LEARNING_PATH_MEMBERS.

Usage Notes

This package is typically invoked by South Africa–localised concurrent programs and archive processes that generate WSP output. It is referenced by one other package. Because it is not a supported public API, direct calls from custom code should be treated cautiously; the reliable usage pattern is through the standard Oracle-delivered WSP concurrent process, which drives range_cursor, action_creation, archive_init, and archive_data in sequence. The get_occupational_category function can be queried where occupational classification logic must be replicated or verified, but callers should pass a valid effective date to obtain correct historical results.