APPS.IGS_EN_GEN_010 dependencies on IGS_EN_GEN_LEGACY

Line 2212: IF igs_en_gen_legacy.check_usa_overlap(

2208: IF c_susa%FOUND THEN
2209:
2210: IF v_susa_rec.student_confirmed_ind = 'N' AND
2211: v_confirmed_ind ='Y' THEN
2212: IF igs_en_gen_legacy.check_usa_overlap(
2213: v_susa_rec.person_id,
2214: v_susa_rec.course_cd,
2215: TRUNC(v_selection_dt),
2216: v_susa_rec.rqrmnts_complete_dt,

Line 3522: IF igs_en_gen_legacy.check_usa_overlap(

3518: FETCH c_susa_upd INTO c_susa_upd_rec ;
3519:
3520: v_rqrmnts_complete_dt := NVL(c_prog_outcome_rec.decision_dt,TRUNC(SYSDATE));
3521:
3522: IF igs_en_gen_legacy.check_usa_overlap(
3523: c_susa_upd_rec.person_id,
3524: c_susa_upd_rec.course_cd,
3525: c_susa_upd_rec.selection_dt,
3526: v_rqrmnts_complete_dt,

Line 3705: IF igs_en_gen_legacy.check_usa_overlap(

3701: IF c_exists_susa_rec.student_confirmed_ind <> l_confirmed_ind THEN
3702: OPEN c_susa_upd(l_first_us.unit_set_cd,l_first_us.us_version_number, c_exists_susa_rec.sequence_number) ;
3703: FETCH c_susa_upd INTO c_susa_upd_rec ;
3704:
3705: IF igs_en_gen_legacy.check_usa_overlap(
3706: c_susa_upd_rec.person_id,
3707: c_susa_upd_rec.course_cd,
3708: TRUNC(v_selection_dt),
3709: c_susa_upd_rec.RQRMNTS_COMPLETE_DT,

Line 5158: IF igs_en_gen_legacy.check_usa_overlap(

5154: ELSIF p_completion_date IS NULL AND p_selection_date IS NOT NULL THEN
5155: l_completion_date := p_selection_date - 1;
5156: END IF;
5157:
5158: IF igs_en_gen_legacy.check_usa_overlap(
5159: c_susa_upd_rec.person_id,
5160: c_susa_upd_rec.course_cd,
5161: c_susa_upd_rec.selection_dt,
5162: NVL(p_completion_date, TRUNC(l_completion_date)),

Line 8014: IF igs_en_gen_legacy.check_usa_overlap(

8010: IF c_susa_exists%NOTFOUND THEN
8011:
8012: SELECT IGS_AS_SU_SETATMPT_SEQ_NUM_S.NEXTVAL INTO vl_sequence_val FROM dual;
8013:
8014: IF igs_en_gen_legacy.check_usa_overlap(
8015: p_person_id,
8016: p_course_cd,
8017: TRUNC(v_selection_dt),
8018: NULL,

Line 8104: IF igs_en_gen_legacy.check_usa_overlap(

8100: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8101: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8102: THEN
8103:
8104: IF igs_en_gen_legacy.check_usa_overlap(
8105: vc_susa_upd_rec.person_id,
8106: vc_susa_upd_rec.course_cd,
8107: TRUNC(v_selection_dt),
8108: vc_susa_upd_rec.rqrmnts_complete_dt,

Line 8265: IF igs_en_gen_legacy.check_usa_overlap(

8261: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8262: <> NVL(v_susa_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8263: OR v_confirmed_ind <> v_susa_rec.student_confirmed_ind
8264: THEN
8265: IF igs_en_gen_legacy.check_usa_overlap(
8266: v_susa_rec.person_id,
8267: v_susa_rec.course_cd,
8268: TRUNC(v_selection_dt),
8269: v_susa_rec.rqrmnts_complete_dt,

Line 8350: IF igs_en_gen_legacy.check_usa_overlap(

8346: ELSE
8347: v_selection_dt := NULL;
8348: END IF;
8349:
8350: IF igs_en_gen_legacy.check_usa_overlap(
8351: p_person_id,
8352: p_course_cd,
8353: TRUNC(v_selection_dt),
8354: NULL,

Line 8519: IF igs_en_gen_legacy.check_usa_overlap(

8515: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8516: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8517: THEN
8518:
8519: IF igs_en_gen_legacy.check_usa_overlap(
8520: vc_susa_upd_rec.person_id,
8521: vc_susa_upd_rec.course_cd,
8522: TRUNC(v_selection_dt),
8523: v_rqrmnts_complete_dt,