APPS.IGS_FI_GET_SUAEH dependencies on IGS_GE_DATE

Line 177: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENROLLED_DT',

173: p_suah_rec.uoo_id),
174: p_sua_rec.unit_class ));
175: v_suah_rec.enrolled_dt :=
176: NVL(p_suah_rec.enrolled_dt,
177: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENROLLED_DT',
178: p_suah_rec.person_id,
179: p_suah_rec.course_cd,
180: p_suah_rec.hist_end_dt,
181: p_suah_rec.uoo_id)),

Line 201: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('DISCONTINUED_DT',

197: p_suah_rec.uoo_id),
198: p_sua_rec.administrative_unit_status));
199: v_suah_rec.discontinued_dt :=
200: NVL(p_suah_rec.discontinued_dt,
201: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('DISCONTINUED_DT',
202: p_suah_rec.person_id,
203: p_suah_rec.course_cd,
204: p_suah_rec.hist_end_dt,
205: p_suah_rec.uoo_id)),

Line 209: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_DT',

205: p_suah_rec.uoo_id)),
206: p_sua_rec.discontinued_dt));
207: v_suah_rec.rule_waived_dt :=
208: NVL(p_suah_rec.rule_waived_dt,
209: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_DT',
210: p_suah_rec.person_id,
211: p_suah_rec.course_cd,
212: p_suah_rec.hist_end_dt,
213: p_suah_rec.uoo_id)),

Line 289: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_OUTCOME_DUE_DT',

285: p_suah_rec.uoo_id)),
286: p_sua_rec.override_achievable_cp));
287: v_suah_rec.override_outcome_due_dt :=
288: NVL(p_suah_rec.override_outcome_due_dt,
289: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_OUTCOME_DUE_DT',
290: p_suah_rec.person_id,
291: p_suah_rec.course_cd,
292: p_suah_rec.hist_end_dt,
293: p_suah_rec.uoo_id)),

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

516: gv_table_index := 0;
517: gv_person_id := p_person_id;
518: gv_course_cd := p_course_cd;
519: gv_unit_cd := p_unit_cd;
520: gv_effective_dt := igs_ge_date.igsdate(igs_ge_date.igschar(p_effective_dt)|| '23:59:59');
521: -- get the current student IGS_PS_UNIT attempt detail
522: FOR v_sua_rec IN c_sua
523: LOOP
524: r_sua := v_sua_rec;

Line 823: igs_ge_date.igschardt(p_effective_dt);

819: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_GET_SUAEH.FINP_GET_SUAEH');
820: IGS_GE_MSG_STACK.ADD;
821: lv_param_values := to_char(p_person_id)||','||
822: p_course_cd||','||p_unit_cd||','||
823: igs_ge_date.igschardt(p_effective_dt);
824: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
825: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
826: IGS_GE_MSG_STACK.ADD;
827: App_Exception.Raise_Exception(Null, Null, fnd_message.get);