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_AS_NOTIFY_PKG dependencies on IGS_AS_CAL_CONF

Line 377: v_mid_mgs_start_dt_alias igs_as_cal_conf.mid_mgs_start_dt_alias%TYPE;

373: AND gash2.grading_period_cd = 'FINAL');
374:
375:
376:
377: v_mid_mgs_start_dt_alias igs_as_cal_conf.mid_mgs_start_dt_alias%TYPE;
378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;
379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;
380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;
381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;

Line 378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;

374:
375:
376:
377: v_mid_mgs_start_dt_alias igs_as_cal_conf.mid_mgs_start_dt_alias%TYPE;
378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;
379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;
380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;
381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;
382: v_final_mgs_end_dt_alias igs_as_cal_conf.final_mgs_end_dt_alias%TYPE;

Line 379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;

375:
376:
377: v_mid_mgs_start_dt_alias igs_as_cal_conf.mid_mgs_start_dt_alias%TYPE;
378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;
379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;
380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;
381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;
382: v_final_mgs_end_dt_alias igs_as_cal_conf.final_mgs_end_dt_alias%TYPE;
383: v_midterm_start_dt DATE;

Line 380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;

376:
377: v_mid_mgs_start_dt_alias igs_as_cal_conf.mid_mgs_start_dt_alias%TYPE;
378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;
379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;
380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;
381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;
382: v_final_mgs_end_dt_alias igs_as_cal_conf.final_mgs_end_dt_alias%TYPE;
383: v_midterm_start_dt DATE;
384: v_midterm_end_dt DATE;

Line 381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;

377: v_mid_mgs_start_dt_alias igs_as_cal_conf.mid_mgs_start_dt_alias%TYPE;
378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;
379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;
380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;
381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;
382: v_final_mgs_end_dt_alias igs_as_cal_conf.final_mgs_end_dt_alias%TYPE;
383: v_midterm_start_dt DATE;
384: v_midterm_end_dt DATE;
385: v_earlyfinal_start_dt DATE;

Line 382: v_final_mgs_end_dt_alias igs_as_cal_conf.final_mgs_end_dt_alias%TYPE;

378: v_mid_mgs_end_dt_alias igs_as_cal_conf.mid_mgs_end_dt_alias%TYPE;
379: v_efinal_mgs_start_dt_alias igs_as_cal_conf.efinal_mgs_start_dt_alias%TYPE;
380: v_efinal_mgs_end_dt_alias igs_as_cal_conf.efinal_mgs_end_dt_alias%TYPE;
381: v_final_mgs_start_dt_alias igs_as_cal_conf.final_mgs_start_dt_alias%TYPE;
382: v_final_mgs_end_dt_alias igs_as_cal_conf.final_mgs_end_dt_alias%TYPE;
383: v_midterm_start_dt DATE;
384: v_midterm_end_dt DATE;
385: v_earlyfinal_start_dt DATE;
386: v_earlyfinal_end_dt DATE;

Line 448: FROM igs_as_cal_conf acc

444: v_efinal_mgs_start_dt_alias,
445: v_efinal_mgs_end_dt_alias,
446: v_final_mgs_start_dt_alias,
447: v_final_mgs_end_dt_alias
448: FROM igs_as_cal_conf acc
449: WHERE s_control_num = 1;
450:
451:
452: FOR v_ttl_rec IN c_ttl LOOP