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_004 dependencies on IGS_CA_DA_INST

Line 294: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

290: -- Get one of the IGS_RU_RULE cutoff dates from the nominated teaching calendar.
291: -- The date type parameter indicates whether to get the enrolled or invalid
292: -- cut off dates.
293: DECLARE
294: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
295: CURSOR c_alias_val IS
296: SELECT daiv.alias_val
297: FROM IGS_EN_CAL_CONF secc,
298: IGS_CA_DA_INST_V daiv

Line 298: IGS_CA_DA_INST_V daiv

294: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
295: CURSOR c_alias_val IS
296: SELECT daiv.alias_val
297: FROM IGS_EN_CAL_CONF secc,
298: IGS_CA_DA_INST_V daiv
299: WHERE secc.s_control_num = 1 AND
300: daiv.dt_alias = DECODE(p_date_type,
301: 'ENROLLED',NVL(secc.enrolled_rule_cutoff_dt_alias, 'NULL'),
302: 'INVALID', NVL(secc.invalid_rule_cutoff_dt_alias,'NULL'),

Line 436: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

432: -- is used. Else, it is search for in the enrolment period matching the
433: -- IGS_EN_CAL_CONF. enr_form_due_dt_alias (the latest date is selected)
434: DECLARE
435: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
436: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
437: CURSOR c_scae IS
438: SELECT scae.enr_form_due_dt
439: FROM IGS_AS_SC_ATMPT_ENR scae
440: WHERE scae.person_id = p_person_id AND

Line 455: IGS_CA_DA_INST daiv

451: daiv.CAL_TYPE,
452: daiv.DT_ALIAS,
453: daiv.sequence_number) ) alias_val
454: FROM IGS_EN_CAL_CONF secc,
455: IGS_CA_DA_INST daiv
456: WHERE secc.s_control_num = 1 AND
457: daiv.cal_type = p_cal_type AND
458: daiv.ci_sequence_number = p_ci_sequence_number AND
459: daiv.dt_alias = secc.enr_form_due_dt_alias AND

Line 486: -- Query the latest IGS_CA_DA_INST_V from the enrolment calendar instance

482: RETURN v_enr_form_due_dt;
483: END IF;
484: CLOSE c_scae;
485: END IF;
486: -- Query the latest IGS_CA_DA_INST_V from the enrolment calendar instance
487: OPEN c_latest_alias_val;
488: FETCH c_latest_alias_val INTO v_alias_val;
489: IF (c_latest_alias_val%FOUND) THEN
490: CLOSE c_latest_alias_val;

Line 558: l_open_dt IGS_CA_DA_INST_V.alias_val%TYPE;

554: l_record_open_dt_alias IGS_EN_CAL_CONF.record_open_dt_alias%TYPE;
555: l_record_cutoff_dt_alias IGS_EN_CAL_CONF.record_cutoff_dt_alias%TYPE;
556: l_daiv_rec_found BOOLEAN;
557: l_rec_open_dt_pass BOOLEAN;
558: l_open_dt IGS_CA_DA_INST_V.alias_val%TYPE;
559: l_rec_cutt_off_dt IGS_CA_DA_INST_V.alias_val%TYPE;
560: l_effective_date DATE;
561:
562: --modified cursor for performance bug 3696424

Line 559: l_rec_cutt_off_dt IGS_CA_DA_INST_V.alias_val%TYPE;

555: l_record_cutoff_dt_alias IGS_EN_CAL_CONF.record_cutoff_dt_alias%TYPE;
556: l_daiv_rec_found BOOLEAN;
557: l_rec_open_dt_pass BOOLEAN;
558: l_open_dt IGS_CA_DA_INST_V.alias_val%TYPE;
559: l_rec_cutt_off_dt IGS_CA_DA_INST_V.alias_val%TYPE;
560: l_effective_date DATE;
561:
562: --modified cursor for performance bug 3696424
563: CURSOR c_recdt_alias_per_lvl( cp_person_type IGS_PE_USR_ARG.person_type%TYPE ) IS

Line 570: CURSOR c_alias_val_op_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

566: FROM IGS_PE_USR_ARG_ALL
567: WHERE person_type = cp_person_type;
568:
569: --Cursor is to get the all open date alias values for a calendar instance in ascending order.
570: CURSOR c_alias_val_op_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
571: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
572: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
573: SELECT alias_val FROM IGS_CA_DA_INST_V
574: WHERE cal_type = cp_cal_type

Line 571: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

567: WHERE person_type = cp_person_type;
568:
569: --Cursor is to get the all open date alias values for a calendar instance in ascending order.
570: CURSOR c_alias_val_op_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
571: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
572: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
573: SELECT alias_val FROM IGS_CA_DA_INST_V
574: WHERE cal_type = cp_cal_type
575: AND ci_sequence_number = cp_ci_sequence_number

Line 572: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

568:
569: --Cursor is to get the all open date alias values for a calendar instance in ascending order.
570: CURSOR c_alias_val_op_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
571: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
572: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
573: SELECT alias_val FROM IGS_CA_DA_INST_V
574: WHERE cal_type = cp_cal_type
575: AND ci_sequence_number = cp_ci_sequence_number
576: AND dt_alias = cp_dt_alias

Line 573: SELECT alias_val FROM IGS_CA_DA_INST_V

569: --Cursor is to get the all open date alias values for a calendar instance in ascending order.
570: CURSOR c_alias_val_op_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
571: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
572: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
573: SELECT alias_val FROM IGS_CA_DA_INST_V
574: WHERE cal_type = cp_cal_type
575: AND ci_sequence_number = cp_ci_sequence_number
576: AND dt_alias = cp_dt_alias
577: AND alias_val IS NOT NULL

Line 581: CURSOR c_alias_val_rec_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

577: AND alias_val IS NOT NULL
578: ORDER BY alias_val ASC;
579:
580: --Cursor is to get the all Record Cutt-off alias values for a calendar instance in descending order.
581: CURSOR c_alias_val_rec_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
582: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
583: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
584: SELECT alias_val FROM IGS_CA_DA_INST_V
585: WHERE cal_type = cp_cal_type

Line 582: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

578: ORDER BY alias_val ASC;
579:
580: --Cursor is to get the all Record Cutt-off alias values for a calendar instance in descending order.
581: CURSOR c_alias_val_rec_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
582: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
583: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
584: SELECT alias_val FROM IGS_CA_DA_INST_V
585: WHERE cal_type = cp_cal_type
586: AND ci_sequence_number = cp_ci_sequence_number

Line 583: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

579:
580: --Cursor is to get the all Record Cutt-off alias values for a calendar instance in descending order.
581: CURSOR c_alias_val_rec_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
582: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
583: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
584: SELECT alias_val FROM IGS_CA_DA_INST_V
585: WHERE cal_type = cp_cal_type
586: AND ci_sequence_number = cp_ci_sequence_number
587: AND dt_alias = cp_dt_alias

Line 584: SELECT alias_val FROM IGS_CA_DA_INST_V

580: --Cursor is to get the all Record Cutt-off alias values for a calendar instance in descending order.
581: CURSOR c_alias_val_rec_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
582: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
583: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
584: SELECT alias_val FROM IGS_CA_DA_INST_V
585: WHERE cal_type = cp_cal_type
586: AND ci_sequence_number = cp_ci_sequence_number
587: AND dt_alias = cp_dt_alias
588: AND alias_val IS NOT NULL