Search Results genp_clc_dt_diff




Overview
Explore in AI Chat

Overview

IGS_GE_GEN_001 is a general-purpose utility package in the Oracle EBS Higher Education / Student System (IGS) product family, owned by the APPS schema and classified as an "OTHER" API in the ETRM registry. Rather than implementing a single business transaction, it aggregates a broad collection of shared helper routines — date arithmetic, address and name resolution, audit column retrieval, note deletion, log purging, and dynamic SQL metadata inspection — that other IGS modules call to avoid duplicating common logic. The package header is declared AUTHID CURRENT_USER, meaning its dynamic SQL executes with the privileges of the calling session, and its header revision ($Header: IGSGE01S.pls 115.5) indicates it has been stable since the 11i era and carried forward into 12.1.1 and 12.2.2 without structural change.

Key Procedures and Functions

The 11 documented entry points fall into four functional clusters.

  • GENP_CHK_COL_UPPER — verifies that a given column on a given table is stored in upper case, typically used before comparisons that assume canonical casing.
  • GENP_CLC_DT_DIFF — returns the difference between two dates, returning a status message name alongside the numeric result.
  • GENP_CLC_WEEK_END_DT — calculates the week-ending date for a supplied date, defaulting to Friday as the week end.
  • GENP_DEL_LOG — a concurrent-program entry point that purges log entries older than a specified number of days, driven by log type; returns the standard errbuf/retcode pair.
  • GENP_DEL_NOTE — deletes a note identified by reference number, returning a boolean success indicator and an out message name. This is the routine associated with the search term genp_del_note.
  • GENP_GET_ADDR — assembles and formats a person or organisation address from location and party data, accepting parameters for address type, phone inclusion, name style, and case.
  • GENP_GET_APPL_OWNER — returns the application owner identifier for the current context.
  • GENP_GET_AUDIT — given a table name and ROWID, returns the "who" and "on" audit columns for that row.
  • GENP_GET_CMP_CUTOFF — returns the comparison cutoff date for a given academic calendar type and calendar instance sequence.
  • ADM_GET_NAME — resolves a person's formatted name from a person identifier.
  • ADM_GET_UNIT_TITLE — resolves the title associated with an admission application unit, keyed by person, application number, and nominated course.

Tables Accessed

Table access is narrowly scoped to the concern of each routine. Notes are handled through IGS_GE_NOTE, with logging through IGS_GE_S_LOG and IGS_GE_S_LOG_ENTRY; calendar cutoff logic reads IGS_GE_S_GEN_CAL_CON. Address retrieval draws from the Trading Community tables HZ_PARTIES and HZ_LOCATIONS together with the IGS address views IGS_AD_LOCVENUE_ADDR and IGS_PE_LOCVENUE_USE. Metadata inspection routines rely on the data dictionary views USER_COL_COMMENTS, USER_CONSTRAINTS, and USER_OBJECTS, with DBMS_SQL used to execute dynamically constructed statements. All access is via APPS synonyms.

Usage Notes

Because IGS_GE_GEN_001 exposes only scalar helpers rather than a business API, it is normally invoked indirectly. GENP_DEL_LOG is registered as a concurrent program and can be submitted from the Standard Request Submission form; the remaining routines are called from IGS forms, from other IGS packages (it is referenced by twelve packages), and occasionally from site-specific customisations. The WNDS purity declarations on several functions make them safe to call from SQL, but callers should note that GENP_DEL_NOTE performs a deletion and therefore must be invoked from PL/SQL, with the surrounding transaction committed or rolled back by the caller.