APPS.IGS_FI_GET_SCAEH dependencies on IGS_GE_DATE

Line 169: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT',

165: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
166: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
167: gr_scaeh.r_scah.commencement_dt :=
168: NVL(p_scah_rec.commencement_dt,
169: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT',
170: p_scah_rec.person_id,
171: p_scah_rec.course_cd,
172: p_scah_rec.hist_end_dt)),
173: p_sca_rec.commencement_dt));

Line 223: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT',

219: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
220: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
221: gr_scaeh.r_scah.discontinued_dt :=
222: NVL(p_scah_rec.discontinued_dt,
223: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT',
224: p_scah_rec.person_id,
225: p_scah_rec.course_cd,
226: p_scah_rec.hist_end_dt)),
227: p_sca_rec.discontinued_dt));

Line 241: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT',

237: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
238: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
239: gr_scaeh.r_scah.lapsed_dt :=
240: NVL(p_scah_rec.lapsed_dt,
241: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT',
242: p_scah_rec.person_id,
243: p_scah_rec.course_cd,
244: p_scah_rec.hist_end_dt)),
245: p_sca_rec.lapsed_dt));

Line 322: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT',

318: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
319: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
320: gr_scaeh.r_scah.last_rule_check_dt :=
321: NVL(p_scah_rec.last_rule_check_dt,
322: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT',
323: p_scah_rec.person_id,
324: p_scah_rec.course_cd,
325: p_scah_rec.hist_end_dt)),
326: p_sca_rec.last_rule_check_dt));

Line 349: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT',

345: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
346: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
347: gr_scaeh.r_scah.course_rqrmnts_complete_dt :=
348: NVL(p_scah_rec.course_rqrmnts_complete_dt,
349: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT',
350: p_scah_rec.person_id,
351: p_scah_rec.course_cd,
352: p_scah_rec.hist_end_dt)),
353: p_sca_rec.course_rqrmnts_complete_dt));

Line 655: gv_effective_dt :=igs_ge_date.igsdate(igs_ge_date.igschar(p_effective_dt)|| '23:59:59');

651: END IF;
652: END IF;
653: gv_person_id := p_person_id;
654: gv_course_cd := p_course_cd;
655: gv_effective_dt :=igs_ge_date.igsdate(igs_ge_date.igschar(p_effective_dt)|| '23:59:59');
656: p_data_found := FALSE;
657: -- get the current student IGS_PS_COURSE attempt details
658: OPEN c_sca;
659: FETCH c_sca INTO r_sca;