Search Results calc_total_work_load_lecture




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_FAC_CREDT_WRKLOAD package is a component of the Oracle Student System (formerly Oracle iLearning/Student Records) within Oracle E-Business Suite, owned by the APPS schema and classified under the "OTHER" API category. Its purpose is to compute, validate, and expose faculty teaching workload and credit-point metrics associated with teaching responsibilities recorded against units of study offerings. The package bridges instructional responsibility data (who teaches which unit offering option) with the academic definitions of those units, allowing institutions to derive total credit points and instructional workload totals broken down by delivery mode (lecture, laboratory, and other). It also provides validation logic used to determine whether an instructor's assigned workload adheres to institutional rules. In EBS 12.1.1 and 12.2.2, the package is part of the IGS (Institution of Higher Education/Student System) family and is a server-side PL/SQL artifact rather than a self-service page or concurrent program in its own right; it is normally consumed by forms, other packages, and custom extensions.

Key Procedures and Functions

The package exposes eight documented program units, several of which carry the PRAGMA RESTRICT_REFERENCES directive, confirming their intended use inside SQL statements as well as PL/SQL.

  • PRGP_GET_LEAD_INSTRUCTOR — Given a unit offering option identifier, returns the lead instructor as a VARCHAR2 value. This is the function the user searched for; it is commonly embedded in queries and reports that must display the principal instructor for a teaching responsibility record. It is declared WNDS (writes no database state), making it safe for read-only SQL invocation.
  • CALC_TOTAL_CREDIT_POINT — Accepts an instructor identifier and returns the aggregate credit points attributed to that instructor. Marked WNDS and WNPS (writes no package state).
  • CALC_TOTAL_WORK_LOAD — Returns the combined instructional workload for an instructor across all delivery modes.
  • CALC_TOTAL_WORK_LOAD_LAB — Returns only the laboratory component of an instructor's workload. The header history notes this and the lecture function were added on 24-MAY-2001 by ayedubat.
  • CALC_TOTAL_WORK_LOAD_LECTURE — Returns only the lecture component of an instructor's workload.
  • CALCULATE_TEACH_WORK_LOAD — A procedure that, for a given unit offering option and percentage allocation, returns the lecture, laboratory, and other workload values as OUT parameters.
  • VALIDATE_WORKLOAD — Returns a BOOLEAN indicating whether workload totals for a unit offering option are valid, also emitting the lecture, laboratory, and total workload values via OUT parameters.
  • GET_VALIDATION_TYPE — Returns the validation type applicable to a given unit code and version number, indicating which rule set governs workload validation for that unit version.

Tables Accessed

The package reads from and writes to the following APPS-synonymed base tables:

  • IGS_PS_USEC_TCH_RESP — Teaching responsibility records, the primary source of instructor-to-unit-offering assignments and workload figures.
  • IGS_PS_USEC_CPS — Unit section/offering component data used to derive credit points and workload components.
  • IGS_PS_UNIT_OFR_OPT_ALL — Unit offering option definitions, linking offerings to options and instructors.
  • IGS_PS_UNIT_VER_ALL — Unit version definitions supplying credit-point and validation attributes.
  • IGS_PE_ALT_PERS_ID — Alternate person identifiers used to resolve instructor identity.
  • IGS_PE_PERSON_ID_TYP — Person identifier types, supporting resolution of the correct identifier for the lead instructor lookup.

Usage Notes

This package is referenced by four other packages, reflecting its role as a shared workload computation utility. Typical invocation patterns include Oracle Forms (e.g., the teaching responsibility and workload maintenance forms), which call CALCULATE_TEACH_WORK_LOAD and VALIDATE_WORKLOAD to populate and check workload fields, and custom PL/SQL or SQL that invokes PRGP_GET_LEAD_INSTRUCTOR to display the lead instructor name in enquiries and reports. Because several functions carry RESTRICT_REFERENCES pragmas, they may be called directly from SQL statements and views. The package is not documented as a concurrent program entry point, so bulk workload recalculation is generally performed by wrappers or by the forms that own the underlying data. Because the header shows the last substantive change in 2005 (version 120.0), the package predates the 12.1.1 and 12.2.2 releases and remains a stable, low-change component in both environments.