APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_CPD_EXT

Line 1473: notification_flag igs_en_cpd_ext.notification_flag%TYPE

1469: WHERE person_type_code = p_person_type;
1470:
1471:
1472: TYPE l_program_steps_rec IS RECORD (
1473: notification_flag igs_en_cpd_ext.notification_flag%TYPE
1474: );
1475: TYPE cur_ref_program_steps IS REF CURSOR RETURN l_program_steps_rec;
1476: cur_program_steps cur_ref_program_steps;
1477:

Line 1480: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

1476: cur_program_steps cur_ref_program_steps;
1477:
1478: l_cur_program_steps cur_program_steps%ROWTYPE;
1479: l_cur_person_types cur_person_types%ROWTYPE;
1480: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1481: l_system_person_type igs_pe_person_types.system_type%TYPE;
1482: l_pig_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
1483: l_message fnd_new_messages.message_name%TYPE;
1484:

Line 1482: l_pig_deny_warn igs_en_cpd_ext.notification_flag%TYPE;

1478: l_cur_program_steps cur_program_steps%ROWTYPE;
1479: l_cur_person_types cur_person_types%ROWTYPE;
1480: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1481: l_system_person_type igs_pe_person_types.system_type%TYPE;
1482: l_pig_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
1483: l_message fnd_new_messages.message_name%TYPE;
1484:
1485: BEGIN
1486:

Line 1502: FROM igs_en_cpd_ext eru,

1498: END IF;
1499:
1500: IF l_system_person_type = 'STUDENT' THEN
1501: OPEN cur_program_steps FOR SELECT DECODE (l_pig_deny_warn, NULL, eru.notification_flag, l_pig_deny_warn) notification_flag
1502: FROM igs_en_cpd_ext eru,
1503: igs_lookups_view lkup
1504: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
1505: eru.enrolment_cat = p_enrollment_category AND
1506: (eru.s_student_comm_type = p_comm_type OR

Line 1521: FROM igs_en_cpd_ext_all eru,

1517: 'WARN', 'WARN',
1518: 'DENY', 'DENY',
1519: NULL, DECODE (l_pig_deny_warn, NULL, eru.notification_flag, l_pig_deny_warn)
1520: ) notification_flag
1521: FROM igs_en_cpd_ext_all eru,
1522: igs_pe_usr_aval_all uact,
1523: igs_lookups_view lkup
1524: WHERE eru.s_enrolment_step_type = lkup.lookup_code
1525: AND eru.enrolment_cat = p_enrollment_category

Line 3067: l_c_notify_flag igs_en_cpd_ext.notification_flag%TYPE;

3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;
3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;
3065: l_c_en_cat igs_en_enrolment_cat.enrolment_cat%TYPE;
3066: l_c_en_ctgs VARCHAR2(200);
3067: l_c_notify_flag igs_en_cpd_ext.notification_flag%TYPE;
3068: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3069: l_step_override BOOLEAN := FALSE;
3070: lv_timeslot_rec_found BOOLEAN := FALSE;
3071: