Search Results igs_re_val_mty

Overview

IGS_RE_VAL_MTY is a validation package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle iLearning / Oracle Learning Management product family. The "IGS" prefix identifies objects belonging to the Oracle Learning Management (formerly iLearning) module, while the "RE" component and the "_VAL_" infix indicate a validation routine associated with the Reminder/Notification engine. The trailing "MTY" abbreviates "milestone type." The package therefore provides server-side validation logic for the reminder configuration of milestone types used within learning and certification processing.

The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking session rather than as the definer. In Oracle EBS this is a common pattern for validation packages that must respect the caller's access to the underlying APPS synonyms. The metadata record dates the package header to release 11.5.3 era source control ($Header: IGSRE10S.pls 115.3 2002/11/29), and the package remains present and callable in both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents exactly one callable program unit:

• RESP_VAL_MTY_DAYS — A boolean-returning function that validates the reminder day intervals configured against an IGS_PR_MILESTONE type notification. Its stated purpose in the source header is "To validate IGS_PR_MILESTONE type notification days." It accepts reminder-day and re-reminder-day inputs, and returns an OUT parameter (declared NOCOPY) that carries a message name for use by the caller when validation fails. The function returns TRUE when the supplied day values are acceptable and FALSE otherwise; the message name output allows the calling form or routine to raise a translated, user-facing error.

No other procedures or functions are documented for this package. The parameter list above is reproduced from the package specification; additional internal validation logic is not exposed at the specification level and should not be assumed by integrators.

Tables Accessed

The documented ETRM metadata for IGS_RE_VAL_MTY lists no tables referenced through APPS synonyms. This is consistent with the design of a lightweight validation helper: the function receives its candidate values as parameters and applies rule checks in PL/SQL rather than querying the schema directly. Where the caller needs database context — for example, retrieving the milestone type definition from IGS_PR_MILESTONE or reading the reminder setup — that work is performed by the invoking program before this validation is called. Integrators should not rely on this package to read or write application tables.

Usage Notes

IGS_RE_VAL_MTY is an internal validation utility rather than a user-invoked API. It is typically called from the Oracle Learning Management setup forms and from other PL/SQL packages that configure milestone reminders. The ETRM metadata records that the package is referenced by one other package, confirming its role as a subordinate helper in the reminder/notification call chain rather than a top-level entry point.

Because the function is defined in the APPS schema and declared AUTHID CURRENT_USER, custom code may invoke it as APPS.IGS_RE_VAL_MTY.RESP_VAL_MTY_DAYS provided the executing schema has EXECUTE privilege on the package and access to the required APPS synonyms. Typical custom usage is pre-submission validation in a concurrent program or a custom form before writing reminder configuration rows. In EBS 12.2.2 the package continues to live in the APPS edition, and any custom caller must be aware of the editioning and privilege model when referencing it across schemas. The boolean return convention means callers must inspect the return value and, on FALSE, use the returned message name to surface an error through the standard message dictionary mechanism.