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_GEN_015 dependencies on IGS_EN_CAL_CONF

Line 1210: l_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE;

1206: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
1207: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
1208: l_daiv_rec_found BOOLEAN;
1209: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1210: l_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE;
1211: l_current_load_cal_type igs_ca_inst.cal_type%TYPE;
1212: l_current_load_sequence_number igs_ca_inst.sequence_number%TYPE;
1213: l_current_acad_cal_type igs_ca_inst.cal_type%TYPE;
1214: l_current_acad_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 1231: FROM igs_en_cal_conf secc

1227: -- Cursor to fetch load effective date alias.
1228: --
1229: CURSOR c_s_enr_cal_conf IS
1230: SELECT secc.load_effect_dt_alias
1231: FROM igs_en_cal_conf secc
1232: WHERE secc.s_control_num = 1;
1233: --
1234: -- Cursor to fetch calendar instances
1235: --

Line 1284: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS

1280: -- Cursor to fetch the date alias
1281: --
1282: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
1283: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
1284: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
1285: SELECT daiv.alias_val
1286: FROM igs_ca_da_inst_v daiv
1287: WHERE daiv.cal_type = cp_cal_type
1288: AND daiv.ci_sequence_number = cp_ci_sequence_number

Line 2706: FROM igs_en_cal_conf secc

2702: --
2703: CURSOR
2704: c_s_enr_cal_conf IS
2705: SELECT secc.load_effect_dt_alias
2706: FROM igs_en_cal_conf secc
2707: WHERE secc.s_control_num = 1;
2708:
2709: L_LOAD_EFFECT_DT_ALIAS IGS_EN_CAL_CONF.LOAD_EFFECT_DT_ALIAS%TYPE;
2710:

Line 2709: L_LOAD_EFFECT_DT_ALIAS IGS_EN_CAL_CONF.LOAD_EFFECT_DT_ALIAS%TYPE;

2705: SELECT secc.load_effect_dt_alias
2706: FROM igs_en_cal_conf secc
2707: WHERE secc.s_control_num = 1;
2708:
2709: L_LOAD_EFFECT_DT_ALIAS IGS_EN_CAL_CONF.LOAD_EFFECT_DT_ALIAS%TYPE;
2710:
2711: --
2712: -- CURSOR TO FETCH CALENDAR TYPE INSTANCES
2713: --

Line 2738: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS

2734: -- CURSOR TO FETCH THE DATE ALIAS
2735: --
2736: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2737: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2738: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2739: SELECT daiv.alias_val
2740: FROM igs_ca_da_inst_v daiv
2741: WHERE daiv.cal_type = cp_cal_type
2742: AND daiv.ci_sequence_number = cp_ci_sequence_number

Line 2876: FROM igs_en_cal_conf secc

2872: --
2873: CURSOR
2874: c_s_enr_cal_conf IS
2875: SELECT secc.load_effect_dt_alias
2876: FROM igs_en_cal_conf secc
2877: WHERE secc.s_control_num = 1;
2878:
2879: L_LOAD_EFFECT_DT_ALIAS IGS_EN_CAL_CONF.LOAD_EFFECT_DT_ALIAS%TYPE;
2880:

Line 2879: L_LOAD_EFFECT_DT_ALIAS IGS_EN_CAL_CONF.LOAD_EFFECT_DT_ALIAS%TYPE;

2875: SELECT secc.load_effect_dt_alias
2876: FROM igs_en_cal_conf secc
2877: WHERE secc.s_control_num = 1;
2878:
2879: L_LOAD_EFFECT_DT_ALIAS IGS_EN_CAL_CONF.LOAD_EFFECT_DT_ALIAS%TYPE;
2880:
2881: CURSOR c_acad_cal_instances (cp_acad_cal_type igs_ca_inst.cal_type%TYPE) IS
2882: SELECT cal_type, sequence_number
2883: FROM IGS_CA_INST

Line 2918: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS

2914: -- CURSOR TO FETCH THE DATE ALIAS
2915: --
2916: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2917: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2918: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2919: SELECT daiv.alias_val
2920: FROM igs_ca_da_inst_v daiv
2921: WHERE daiv.cal_type = cp_cal_type
2922: AND daiv.ci_sequence_number = cp_ci_sequence_number

Line 3078: l_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE;

3074: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
3075: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
3076: l_daiv_rec_found BOOLEAN;
3077: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
3078: l_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE;
3079: l_current_load_cal_type igs_ca_inst.cal_type%TYPE;
3080: l_current_load_sequence_number igs_ca_inst.sequence_number%TYPE;
3081: l_current_acad_cal_type igs_ca_inst.cal_type%TYPE;
3082: l_current_acad_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 3099: FROM igs_en_cal_conf secc

3095: -- Cursor to fetch load effective date alias.
3096: --
3097: CURSOR c_s_enr_cal_conf IS
3098: SELECT secc.load_effect_dt_alias
3099: FROM igs_en_cal_conf secc
3100: WHERE secc.s_control_num = 1;
3101: --
3102: -- Cursor to fetch calendar instances
3103: --

Line 3152: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS

3148: -- Cursor to fetch the date alias
3149: --
3150: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
3151: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
3152: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
3153: SELECT daiv.alias_val
3154: FROM igs_ca_da_inst_v daiv
3155: WHERE daiv.cal_type = cp_cal_type
3156: AND daiv.ci_sequence_number = cp_ci_sequence_number