Search Results igs_sc




Overview
Explore in AI Chat

Overview

IGS_SC_GRANTS_TBL_PVT is a private PL/SQL package body owned by APPS within the Oracle E-Business Suite Student Systems (IGS) product family. The naming convention IGS_SC references the Student System Grants or Student Curriculum schema, and the _TBL_PVT suffix identifies this as a table-handling private package intended to encapsulate DML against a specific database table. The package dates to October 2002 and was created by Arkadi Tereshenkov. Its documented purpose in the header comment is to serve as a grant model for each object, and it also provides a utility function, Generate_and_raise, that assembles messages from the FND_MSG_PUB message stack and publishes them as a Workflow business event (oracle.apps.igs.sc.error). This event-driven error-reporting pattern is characteristic of the Oracle Application Framework (OAF) and BC4J toolset used throughout the IGS modules.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions, each corresponding to a standard table-maintenance operation:

  • INSERT_ROW — Inserts a new record into the underlying IGS table via the APPS synonym.
  • SELECT_ROW — Retrieves a single row of data, typically by primary key, returning the column values to the caller.
  • UPDATE_ROW — Applies modifications to an existing record identified by its key.
  • DELETE_ROW — Removes an existing record from the table.

In addition, the source header documents two functions that support the private API layer: Generate_and_raise, which iterates the FND_MSG_PUB error stack, concatenates message text, raises the workflow event oracle.apps.igs.sc.error with OBJECT_NAME and ERROR_TEXT parameters, and returns the accumulated message string; and get_grant, which accepts schema, object, and action arguments and returns a privilege decision as a VARCHAR2. Parameter lists for the four documented DML procedures are not reproduced here because the metadata does not expose them.

Tables Accessed

The only table referenced through an APPS synonym is PLITBLM, an internal Oracle EBS table commonly associated with flexfield or message-related storage. The four documented procedures operate against the grants table implied by the package name, with PLITBLM providing supporting lookup or message data. No direct schema-qualified access appears in the metadata; all access is via APPS synonyms, consistent with the standard EBS coding standard.

Usage Notes

The package is classified as PVT (private) and is referenced by zero other documented packages, meaning it is not a public API and callers within the IGS_SC region invoke it directly rather than through a wrapper. It is typically called from OAF-based grants pages, concurrent programs, or custom extensions that require controlled DML on the grants table. Because Generate_and_raise publishes an Oracle Workflow business event, consumers can subscribe to oracle.apps.igs.sc.error to capture and route error text independently of the calling form. The absence of documented package dependencies and the private classification indicate that direct external calls to this package should be avoided in favor of the corresponding public API in the same module.