DBA Data[Home] [Help]

APPS.IGS_EN_VAL_SUA dependencies on IGS_EN_GEN_008

Line 1482: -- Sarakshi , 27-07-2001, uoo_id is passed to IGS_EN_GEN_008.ENRP_GET_UDDC_AUS

1478:
1479: -- Validate that administrative unit status applies at discontinuation
1480: -- as determined by unit discontinuation date criteria
1481: --Modified as a part of Enrollment Process build bug no:1832130
1482: -- Sarakshi , 27-07-2001, uoo_id is passed to IGS_EN_GEN_008.ENRP_GET_UDDC_AUS
1483: IF p_legacy <> 'Y' THEN
1484: v_administrative_unit_status := IGS_EN_GEN_008.ENRP_GET_UDDC_AUS(
1485: p_discontinued_dt,
1486: p_cal_type,

Line 1484: v_administrative_unit_status := IGS_EN_GEN_008.ENRP_GET_UDDC_AUS(

1480: -- as determined by unit discontinuation date criteria
1481: --Modified as a part of Enrollment Process build bug no:1832130
1482: -- Sarakshi , 27-07-2001, uoo_id is passed to IGS_EN_GEN_008.ENRP_GET_UDDC_AUS
1483: IF p_legacy <> 'Y' THEN
1484: v_administrative_unit_status := IGS_EN_GEN_008.ENRP_GET_UDDC_AUS(
1485: p_discontinued_dt,
1486: p_cal_type,
1487: p_ci_sequence_number,
1488: v_admin_unit_status_str,

Line 2210: -- to the pk of igs_en_su_attempt and passed to IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD

2206: v_del_alwd_dt := p_effective_dt;
2207: END IF;
2208: --Modified as a part of Enrollment Process build bug no:1832130
2209: -- Sarakshi , 27-07-2001,one cursor is opened to fetch the uoo_id corresponding
2210: -- to the pk of igs_en_su_attempt and passed to IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD
2211: IF IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD(
2212: p_cal_type,
2213: p_ci_sequence_number,
2214: v_del_alwd_dt,

Line 2211: IF IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD(

2207: END IF;
2208: --Modified as a part of Enrollment Process build bug no:1832130
2209: -- Sarakshi , 27-07-2001,one cursor is opened to fetch the uoo_id corresponding
2210: -- to the pk of igs_en_su_attempt and passed to IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD
2211: IF IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD(
2212: p_cal_type,
2213: p_ci_sequence_number,
2214: v_del_alwd_dt,
2215: p_uoo_id) = 'N' THEN

Line 2226: -- to the pk of igs_en_su_attempt and passed to igs_en_gen_008.enrp_get_var_window

2222: --- record can only be deleted in the record enrolments time frame.
2223: IF p_unit_attempt_status = cst_enrolled THEN
2224: --Modified as a part of Enrollment Process build bug no:1832130
2225: -- Sarakshi , 27-07-2001,one cursor is opened to fetch the uoo_id corresponding
2226: -- to the pk of igs_en_su_attempt and passed to igs_en_gen_008.enrp_get_var_window
2227:
2228: -- Modified the Next IF logic as per the Bug# 2356997. Made the
2229: -- call to the igs_en_gen_008.enrp_get_var_window instead of IGS_EN_GEN_004.ENRP_GET_REC_WINDOW
2230: IF igs_en_gen_008.enrp_get_var_window(

Line 2229: -- call to the igs_en_gen_008.enrp_get_var_window instead of IGS_EN_GEN_004.ENRP_GET_REC_WINDOW

2225: -- Sarakshi , 27-07-2001,one cursor is opened to fetch the uoo_id corresponding
2226: -- to the pk of igs_en_su_attempt and passed to igs_en_gen_008.enrp_get_var_window
2227:
2228: -- Modified the Next IF logic as per the Bug# 2356997. Made the
2229: -- call to the igs_en_gen_008.enrp_get_var_window instead of IGS_EN_GEN_004.ENRP_GET_REC_WINDOW
2230: IF igs_en_gen_008.enrp_get_var_window(
2231: p_cal_type,
2232: p_ci_sequence_number,
2233: p_effective_dt,

Line 2230: IF igs_en_gen_008.enrp_get_var_window(

2226: -- to the pk of igs_en_su_attempt and passed to igs_en_gen_008.enrp_get_var_window
2227:
2228: -- Modified the Next IF logic as per the Bug# 2356997. Made the
2229: -- call to the igs_en_gen_008.enrp_get_var_window instead of IGS_EN_GEN_004.ENRP_GET_REC_WINDOW
2230: IF igs_en_gen_008.enrp_get_var_window(
2231: p_cal_type,
2232: p_ci_sequence_number,
2233: p_effective_dt,
2234: p_uoo_id) = FALSE THEN

Line 2726: l_person_type := IGS_EN_GEN_008.enrp_get_person_type(NULL);

2722:
2723:
2724: -- code added by ckasu as a part of Program transfer build bug#4000939
2725:
2726: l_person_type := IGS_EN_GEN_008.enrp_get_person_type(NULL);
2727:
2728: --get enrolment method type
2729:
2730: igs_en_gen_017.enrp_get_enr_method(p_enr_method_type => l_enr_method_type,

Line 3556: IF NOT IGS_EN_GEN_008.ENRP_GET_VAR_WINDOW(

3552:
3553:
3554: ELSE
3555: --call api to validate variation window
3556: IF NOT IGS_EN_GEN_008.ENRP_GET_VAR_WINDOW(
3557: sub_usecs_rec.cal_type,
3558: sub_usecs_rec.ci_sequence_number,
3559: nvl(p_enrollment_date,SYSDATE),
3560: sub_usecs_rec.uoo_id) THEN

Line 3658: END IF; --IGS_EN_GEN_008.ENRP_GET_VAR_WINDOW

3654: END IF;
3655: END IF; -- l_enroll
3656: END IF; --l_waitlst_ind NULL
3657:
3658: END IF; --IGS_EN_GEN_008.ENRP_GET_VAR_WINDOW
3659: END IF; --IF IGS_EN_GEN_004.ENRP_GET_REC_WINDOW
3660: END LOOP;
3661: EXCEPTION
3662: WHEN OTHERS THEN