eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RE_CANDIDATURE_PKG dependencies on IGS_GE_DATE

Line 178: NVL(old_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>

174: -- Validate minimum submission date
175: IF (p_inserting AND
176: new_references.min_submission_dt IS NOT NULL) OR
177: (p_updating AND
178: NVL(old_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
179: NVL(new_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN
180: IF IGS_RE_VAL_CA.resp_val_ca_minsbmsn (
181: new_references.person_id,
182: new_references.sca_course_cd,

Line 179: NVL(new_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN

175: IF (p_inserting AND
176: new_references.min_submission_dt IS NOT NULL) OR
177: (p_updating AND
178: NVL(old_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
179: NVL(new_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN
180: IF IGS_RE_VAL_CA.resp_val_ca_minsbmsn (
181: new_references.person_id,
182: new_references.sca_course_cd,
183: new_references.acai_admission_appl_number,

Line 201: NVL(old_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>

197: -- Validate maximum submission date
198: IF (p_inserting AND
199: new_references.max_submission_dt IS NOT NULL) OR
200: (p_updating AND
201: NVL(old_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
202: NVL(new_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN
203: IF IGS_RE_VAL_CA.resp_val_ca_maxsbmsn (
204: new_references.person_id,
205: new_references.sca_course_cd,

Line 202: NVL(new_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN

198: IF (p_inserting AND
199: new_references.max_submission_dt IS NOT NULL) OR
200: (p_updating AND
201: NVL(old_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
202: NVL(new_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN
203: IF IGS_RE_VAL_CA.resp_val_ca_maxsbmsn (
204: new_references.person_id,
205: new_references.sca_course_cd,
206: new_references.acai_admission_appl_number,