DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_EN_GEN_004

Line 1823: v_enr_form_due_dt := Igs_En_Gen_004.enrp_get_scae_due(v_scae_ci_rec.person_id,

1819: FETCH c_scae_ci INTO v_scae_ci_rec;
1820: IF (c_scae_ci%FOUND) THEN
1821: -- Call routine to determine the enrolment form due date for
1822: -- the scae record
1823: v_enr_form_due_dt := Igs_En_Gen_004.enrp_get_scae_due(v_scae_ci_rec.person_id,
1824: v_scae_ci_rec.course_cd,
1825: v_scae_ci_rec.cal_type,
1826: v_scae_ci_rec.ci_sequence_number,
1827: 'Y',

Line 2487: Igs_En_Gen_004.ENRP_GET_SCAE_DUE(

2483: NOT EXISTS ( SELECT 'x'
2484: FROM IGS_AS_SC_ATMPT_ENR scae
2485: WHERE scae.person_id = sca.person_id AND
2486: scae.course_cd = sca.course_cd AND
2487: Igs_En_Gen_004.ENRP_GET_SCAE_DUE(
2488: scae.person_id,
2489: scae.course_cd,
2490: scae.cal_type,
2491: scae.ci_sequence_number,

Line 3176: Igs_En_Gen_004.enrp_get_rule_cutoff(

3172: sua.location_cd,
3173: sua.unit_class,
3174: sua.enrolled_dt,
3175: sua.uoo_id,
3176: Igs_En_Gen_004.enrp_get_rule_cutoff(
3177: sua.cal_type,
3178: sua.ci_sequence_number,
3179: cst_enrolled) enrolled_cutoff_date
3180: FROM IGS_EN_SU_ATTEMPT sua,

Line 3454: Igs_En_Gen_004.enrp_get_rule_cutoff(

3450: sua.version_number,
3451: sua.cal_type,
3452: sua.ci_sequence_number,
3453: sua.uoo_id,
3454: Igs_En_Gen_004.enrp_get_rule_cutoff(
3455: sua.cal_type,
3456: sua.ci_sequence_number,
3457: cst_invalid) invalid_cutoff_date
3458: FROM IGS_EN_SU_ATTEMPT sua