Search Results za_wsp_courses

Overview

PER_ZA_WSP_LOOKUP is an Oracle EBS Human Resources (HRMS) PL/SQL package body owned by the APPS schema and classified as an "OTHER" API. It consolidates the lookup and configuration logic that supports the South African Workplace Skills Plan (WSP) and Annual Training Report (ATR) functionality within Oracle Learning Management. Its primary role is to populate, refresh, and copy the FND lookup values associated with occupational categories, learning paths, courses, certifications, competencies, and qualifications so that these code sets remain consistent for legislative reporting. The package abstracts the business rules governing which learning catalog entries qualify for WSP/ATR reporting by maintaining dedicated lookup types such as ZA_WSP_LEARNING_PATHS, ZA_WSP_COURSES, ZA_WSP_CERTIFICATIONS, and their ZA_ATR_* counterparts, along with the attribute category ZA_WSP_SKILLS_PRIORITIES and the occupational category lookup ZA_WSP_OCCUPATIONAL_CATEGORIES.

Key Procedures and Functions

The documented interface exposes seven procedures and functions. Their purposes follow.

• WSP_LOOKUP_VALUES — The principal retrieving routine; builds and returns the set of lookup values used to drive WSP/ATR selection.
• LOOKUP_VAL_INSERT_ROW — An internal worker that inserts a single lookup value row, used for controlled, row-by-row maintenance of the code sets.
• CREATE_LOOKUP_VALUES — Orchestrates creation of the lookup values required for a WSP/ATR cycle from the underlying learning catalog.
• REFRESH_LOOKUP_VALUES — Synchronizes existing lookup entries with current catalog data, reflecting additions or changes to courses, paths, and certifications.
• COPY_LOOKUP_VALUES — Duplicates lookup values, typically to seed a new planning or reporting period from a prior one.
• COPY_PLAN_2_TRINING — Carries WSP planning data across to the training reporting side (the ATR view).
• VS_WSP_C_YR — Resolves the current WSP year, working against the package globals g_plan_year_start_date, g_plan_year_end_date, g_trnd_year_start_date, and g_trnd_year_end_date. This is the object most directly relevant to a search for p_year, since year-parameter handling underlies its logic.

The private procedure set_wsp_cat_attr_cat back-fills a missing attribute category on occupational-category lookup rows, excluding codes owned by the ZA_EMP_EQ_OCCUPATIONAL_CAT lookup type.

Tables Accessed

The package reads and writes FND_LOOKUP_VALUES, which stores the WSP/ATR lookup code sets and their attribute categories. Organization data is drawn from HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, and HR_ORGANIZATION_INFORMATION to scope entries to the correct legal employer or business group. Learning catalog data comes from OTA_ACTIVITY_VERSIONS and OTA_ACTIVITY_VERSIONS_TL, OTA_LEARNING_PATHS and OTA_LEARNING_PATHS_TL, and OTA_CERTIFICATIONS_B and OTA_CERTIFICATIONS_TL. Enrollment and booking context is supplied by OTA_CERT_ENROLLMENTS, OTA_LP_ENROLLMENTS, OTA_DELEGATE_BOOKINGS, OTA_EVENTS, and OTA_BOOKING_STATUS_TYPES. Together these enable identification of which offerings are reportable.

Usage Notes

The package is not referenced by any other documented package, indicating it is intended for direct invocation by the South African WSP/ATR forms or by concurrent programs that build and refresh the associated lookup values. Because it manipulates FND_LOOKUP_VALUES, calls should be made in a controlled environment and followed by validation of the affected lookup types. Custom code invoking year-dependent logic should rely on VS_WSP_C_YR rather than reimplementing date boundaries, ensuring plan-year and trend-year windows remain consistent with the package globals.