DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_EN_CAL_CONF

Line 1614: v_lapse_dt_alias IGS_EN_CAL_CONF.lapse_dt_alias%TYPE ;

1610: cst_future CONSTANT VARCHAR2(10) := 'FUTURE';
1611: cst_no_future CONSTANT VARCHAR2(10) := 'NO-FUTURE';
1612: e_record_locked EXCEPTION;
1613: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
1614: v_lapse_dt_alias IGS_EN_CAL_CONF.lapse_dt_alias%TYPE ;
1615: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;
1616: v_next_lapse_dt IGS_CA_DA_INST_V.alias_val%TYPE ;
1617: v_next_lapse_dt_found BOOLEAN := FALSE;
1618: v_enr_form_due_dt DATE ;

Line 1625: FROM IGS_EN_CAL_CONF secc

1621: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1622: v_last_teaching VARCHAR2(30);
1623: CURSOR c_secc IS
1624: SELECT secc.lapse_dt_alias
1625: FROM IGS_EN_CAL_CONF secc
1626: WHERE secc.s_control_num = 1;
1627: CURSOR c_ci IS
1628: SELECT ci.start_dt,
1629: ci.end_dt

Line 3690: -- IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias and

3686: -- attempt within the nominated academic calendar instance.
3687: -- Rules are checked recursively until no more rules are failed or passed
3688: -- (where invalid). The outcome is ENROLLED or INVALID IGS_PS_UNIT attempts.
3689: -- Switching of the status is subject to the
3690: -- IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias and
3691: -- IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias which are represented as
3692: -- IGS_CA_DA_INST records within the relevant teaching periods.
3693: -- All parameters are required, else checking and logging is not possible.
3694: IF( p_acad_cal_type IS NULL OR

Line 3691: -- IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias which are represented as

3687: -- Rules are checked recursively until no more rules are failed or passed
3688: -- (where invalid). The outcome is ENROLLED or INVALID IGS_PS_UNIT attempts.
3689: -- Switching of the status is subject to the
3690: -- IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias and
3691: -- IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias which are represented as
3692: -- IGS_CA_DA_INST records within the relevant teaching periods.
3693: -- All parameters are required, else checking and logging is not possible.
3694: IF( p_acad_cal_type IS NULL OR
3695: p_acad_sequence_number IS NULL OR