eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 243: p_rule_to_be_validated IN IGS_EN_SU_ATTEMPT_ALL.failed_unit_rule%TYPE )

239: --added for enrollment processes dld by smaddali bug#1832130
240: p_cal_type IN IGS_CA_INST.cal_type%TYPE,
241: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE ,
243: p_rule_to_be_validated IN IGS_EN_SU_ATTEMPT_ALL.failed_unit_rule%TYPE )
244: IS
245: BEGIN
246: DECLARE
247: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

Line 337: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

333:
334: --smaddali modified this cursor to select only one unit section attempt
335: --instead of all the unit sections of a given unit cd during enrollment processes dld
336: CURSOR cur_IGS_EN_SU_ATTEMPT(cp_unit_cd VARCHAR2,
337: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
338: SELECT sua.*
339: FROM IGS_EN_SU_ATTEMPT sua,
340: IGS_CA_INST ci
341: WHERE sua.person_id = p_person_id AND

Line 358: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE ;

354: SELECT s_cal_cat
355: FROM IGS_CA_TYPE
356: WHERE cal_type = p_cal_type ;
357: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;
358: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE ;
359: l_retval BOOLEAN ;
360: sua_rec cur_IGS_EN_SU_ATTEMPT%ROWTYPE ;
361:
362:

Line 828: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

824:
825: --smaddali modified this cursor to select only one unit section attempt
826: --instead of all the unit sections of a given unit cd during enrollment processes dld
827: CURSOR cur_IGS_EN_SU_ATTEMPT(cp_unit_cd varchar2,
828: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
829: SELECT sua.*
830: FROM IGS_EN_SU_ATTEMPT sua,
831: IGS_EN_STDNT_PS_ATT sca,
832: IGS_CA_INST ci

Line 868: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE;

864: AND load_ci_sequence_number = nvl( p_ci_sequence_number ,load_ci_sequence_number);
865:
866: rec_teach c_load_to_teach%ROWTYPE;
867: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;
868: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE;
869: sua_rec cur_IGS_EN_SU_ATTEMPT%ROWTYPE ;
870: l_loop_ended BOOLEAN := FALSE;
871:
872: BEGIN