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_ELGBL_PERSON dependencies on IGS_EN_CPD_EXT

Line 605: CURSOR c_non_stud_vald_steps (cp_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE) IS

601:
602: --
603: -- cursor to fetch validation steps for the person type not equal to STUDENT
604: --
605: CURSOR c_non_stud_vald_steps (cp_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE) IS
606: SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
607: eru.s_rule_call_cd,
608: eru.rul_sequence_number
609: FROM igs_en_cpd_ext eru,

Line 609: FROM igs_en_cpd_ext eru,

605: CURSOR c_non_stud_vald_steps (cp_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE) IS
606: SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
607: eru.s_rule_call_cd,
608: eru.rul_sequence_number
609: FROM igs_en_cpd_ext eru,
610: igs_pe_usr_aval_all uact,
611: igs_lookups_view lkup
612: WHERE eru.s_enrolment_step_type = lkup.lookup_code
613: AND lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'

Line 626: CURSOR c_stud_vald_steps (cp_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE) IS

622:
623: --
624: -- cursor to fetch validation steps for the person type equal to STUDENT
625: --
626: CURSOR c_stud_vald_steps (cp_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE) IS
627: SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
628: eru.s_rule_call_cd,
629: eru.rul_sequence_number
630: FROM igs_en_cpd_ext eru,

Line 630: FROM igs_en_cpd_ext eru,

626: CURSOR c_stud_vald_steps (cp_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE) IS
627: SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
628: eru.s_rule_call_cd,
629: eru.rul_sequence_number
630: FROM igs_en_cpd_ext eru,
631: igs_lookups_view lkup
632: WHERE eru.s_enrolment_step_type = lkup.lookup_code
633: AND lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
634: AND lkup.step_group_type = 'PERSON'

Line 645: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE; --added by nishikant

641:
642: l_vald_person_steps BOOLEAN;
643: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
644: l_person_type igs_pe_person_types.person_type_code%TYPE;
645: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE; --added by nishikant
646: l_message VARCHAR2(2000);
647: l_deny_person_steps BOOLEAN;
648: l_warn_person_steps BOOLEAN;
649: l_steps VARCHAR2(100);