APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_EN_CPD_EXT

Line 2784: l_en_cpd_ext_rec igs_en_cpd_ext%ROWTYPE;

2780: l_enc_message_name VARCHAR2(2000);
2781: l_app_short_name VARCHAR2(100);
2782: l_msg_index NUMBER;
2783: l_sys_per_type igs_pe_person_types.system_type%TYPE;
2784: l_en_cpd_ext_rec igs_en_cpd_ext%ROWTYPE;
2785: l_message_name VARCHAR2(100);
2786: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
2787: p_rule_failed BOOLEAN;
2788: l_step_def_query VARCHAR2(1000);

Line 2786: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;

2782: l_msg_index NUMBER;
2783: l_sys_per_type igs_pe_person_types.system_type%TYPE;
2784: l_en_cpd_ext_rec igs_en_cpd_ext%ROWTYPE;
2785: l_message_name VARCHAR2(100);
2786: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
2787: p_rule_failed BOOLEAN;
2788: l_step_def_query VARCHAR2(1000);
2789: l_unit_sec VARCHAR2(50);
2790: l_message_for VARCHAR2(100);

Line 2803: FROM igs_en_cpd_ext eru, igs_lookups_view lkv

2799:
2800: IF l_sys_per_type = 'STUDENT' THEN
2801:
2802: l_step_def_query := 'SELECT eru.*
2803: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
2804: WHERE eru.s_enrolment_step_type =lkv.lookup_code
2805: AND lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT''
2806: AND lkv.step_group_type = ''UNIT''
2807: AND eru.enrolment_cat = :1

Line 2818: FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv

2814:
2815: ELSE
2816:
2817: l_step_def_query := 'SELECT eru.*
2818: FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv
2819: WHERE eru.s_enrolment_step_type =lkv.lookup_code
2820: AND lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT''
2821: AND lkv.step_group_type = ''UNIT''
2822: AND eru.s_enrolment_step_type = uact.validation(+)