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_GEN_012 dependencies on IGS_GE_S_LOG

Line 1615: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;

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 ;
1619: v_lapsed BOOLEAN := FALSE;

Line 3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,

3149: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3154: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3155: BEGIN
3156: -- Re-check all INVALID IGS_PS_UNIT attempts and switch to ENROLLED if the rules
3157: -- are now passed. If an invalid IGS_PS_UNIT passes all rules the status is set

Line 3154: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS

3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3154: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3155: BEGIN
3156: -- Re-check all INVALID IGS_PS_UNIT attempts and switch to ENROLLED if the rules
3157: -- are now passed. If an invalid IGS_PS_UNIT passes all rules the status is set
3158: -- to ENROLLED and the select is repeated. This repeats until no more invalid

Line 3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,

3426: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3427: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3431: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3432: -------------------------------------------------------------------------------------------
3433: -- Check all ENROLLED IGS_PS_UNIT attempt IGS_PS_UNIT rules. If a IGS_RU_RULE is failed the
3434: -- status is set to INVALID and the select is repeated. This process

Line 3431: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS

3427: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3431: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3432: -------------------------------------------------------------------------------------------
3433: -- Check all ENROLLED IGS_PS_UNIT attempt IGS_PS_UNIT rules. If a IGS_RU_RULE is failed the
3434: -- status is set to INVALID and the select is repeated. This process
3435: -- repeats until no further units fail rules.