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.

[Home] [Help]

APPS.IGS_EN_VAL_SUA dependencies on IGS_AS_UNIT_CLASS

Line 3070: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;

3066: RETURN boolean AS
3067: BEGIN
3068: DECLARE
3069: v_coo_rec_found BOOLEAN;
3070: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
3071: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3072: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3073: v_other_detail VARCHAR(255);
3074: CURSOR c_coo(

Line 3110: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;

3106: RETURN boolean AS
3107: BEGIN
3108: DECLARE
3109: v_coo_rec_found BOOLEAN;
3110: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
3111: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3112: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3113: v_other_detail VARCHAR(255);
3114: CURSOR c_coo(

Line 3123: FROM IGS_AS_UNIT_CLASS

3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3120: CURSOR c_unit_class(
3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
3122: SELECT unit_mode
3123: FROM IGS_AS_UNIT_CLASS
3124: WHERE IGS_AS_UNIT_CLASS.unit_class = cp_unit_class AND IGS_AS_UNIT_CLASS.closed_ind = 'N';
3125: CURSOR c_unit_mode(
3126: cp_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE) IS
3127: SELECT s_unit_mode

Line 3124: WHERE IGS_AS_UNIT_CLASS.unit_class = cp_unit_class AND IGS_AS_UNIT_CLASS.closed_ind = 'N';

3120: CURSOR c_unit_class(
3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
3122: SELECT unit_mode
3123: FROM IGS_AS_UNIT_CLASS
3124: WHERE IGS_AS_UNIT_CLASS.unit_class = cp_unit_class AND IGS_AS_UNIT_CLASS.closed_ind = 'N';
3125: CURSOR c_unit_mode(
3126: cp_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE) IS
3127: SELECT s_unit_mode
3128: FROM IGS_AS_UNIT_MODE

Line 3126: cp_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE) IS

3122: SELECT unit_mode
3123: FROM IGS_AS_UNIT_CLASS
3124: WHERE IGS_AS_UNIT_CLASS.unit_class = cp_unit_class AND IGS_AS_UNIT_CLASS.closed_ind = 'N';
3125: CURSOR c_unit_mode(
3126: cp_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE) IS
3127: SELECT s_unit_mode
3128: FROM IGS_AS_UNIT_MODE
3129: WHERE IGS_AS_UNIT_MODE.unit_mode = cp_unit_mode;
3130: CURSOR c_attend_mode(