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_VAL_ENCMB dependencies on IGS_EN_ENCMB_EFCTTYP_V

Line 117: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'SUS_SRVC';

113: TYPE t_pee_dt_record IS RECORD (
114: pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
115: expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE);
116: cst_suspend_service
117: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'SUS_SRVC';
118: cst_revoke_service
119: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'RVK_SRVC';
120: v_sus_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
121: v_rvk_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;

Line 119: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'RVK_SRVC';

115: expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE);
116: cst_suspend_service
117: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'SUS_SRVC';
118: cst_revoke_service
119: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'RVK_SRVC';
120: v_sus_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
121: v_rvk_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
122: v_validate_sus_srvc BOOLEAN := TRUE;
123: v_validate_rvk_srvc BOOLEAN := TRUE;

Line 120: v_sus_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;

116: cst_suspend_service
117: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'SUS_SRVC';
118: cst_revoke_service
119: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'RVK_SRVC';
120: v_sus_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
121: v_rvk_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
122: v_validate_sus_srvc BOOLEAN := TRUE;
123: v_validate_rvk_srvc BOOLEAN := TRUE;
124: v_pee_dates t_pee_dt_record;

Line 121: v_rvk_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;

117: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'SUS_SRVC';
118: cst_revoke_service
119: CONSTANT IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE := 'RVK_SRVC';
120: v_sus_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
121: v_rvk_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
122: v_validate_sus_srvc BOOLEAN := TRUE;
123: v_validate_rvk_srvc BOOLEAN := TRUE;
124: v_pee_dates t_pee_dt_record;
125: CURSOR c_chk_crs_for_srv_type

Line 126: ( cp_srv_type IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE ) IS

122: v_validate_sus_srvc BOOLEAN := TRUE;
123: v_validate_rvk_srvc BOOLEAN := TRUE;
124: v_pee_dates t_pee_dt_record;
125: CURSOR c_chk_crs_for_srv_type
126: ( cp_srv_type IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE ) IS
127: SELECT apply_to_course_ind
128: FROM IGS_EN_ENCMB_EFCTTYP_V
129: WHERE s_encmb_effect_type = cp_srv_type;
130: CURSOR c_get_pee_dates (

Line 128: FROM IGS_EN_ENCMB_EFCTTYP_V

124: v_pee_dates t_pee_dt_record;
125: CURSOR c_chk_crs_for_srv_type
126: ( cp_srv_type IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE ) IS
127: SELECT apply_to_course_ind
128: FROM IGS_EN_ENCMB_EFCTTYP_V
129: WHERE s_encmb_effect_type = cp_srv_type;
130: CURSOR c_get_pee_dates (
131: cp_srv_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ) IS
132: SELECT pee_start_dt, expiry_dt

Line 751: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

747: v_restricted_attendance_type
748: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
749: CURSOR c_course_ind IS
750: SELECT SEET.apply_to_course_ind
751: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
752: WHERE s_encmb_effect_type = 'RSTR_AT_TY';
753: CURSOR c_pee_details_1 IS
754: SELECT PEE.pee_start_dt,
755: PEE.expiry_dt,

Line 873: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

869: v_validate_rstr_ge_cp BOOLEAN := TRUE;
870: v_validate_rstr_le_cp BOOLEAN := TRUE;
871: CURSOR c_ge_course_ind IS
872: SELECT SEET.apply_to_course_ind
873: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
874: WHERE s_encmb_effect_type = cst_rstr_ge_cp;
875: CURSOR c_le_course_ind IS
876: SELECT SEET.apply_to_course_ind
877: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 877: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

873: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
874: WHERE s_encmb_effect_type = cst_rstr_ge_cp;
875: CURSOR c_le_course_ind IS
876: SELECT SEET.apply_to_course_ind
877: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
878: WHERE s_encmb_effect_type = cst_rstr_le_cp;
879: CURSOR c_pee_details_1 IS
880: SELECT PEE.pee_start_dt,
881: PEE.expiry_dt,

Line 1091: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1087: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1088: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1089: CURSOR c_course_ind IS
1090: SELECT SEET.apply_to_course_ind
1091: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1092: WHERE s_encmb_effect_type = cst_crsmtrl_blk;
1093: CURSOR c_pee_details_1 IS
1094: SELECT PEE.pee_start_dt,
1095: PEE.expiry_dt

Line 1201: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1197: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1198: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1199: CURSOR c_course_ind IS
1200: SELECT SEET.apply_to_course_ind
1201: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1202: WHERE s_encmb_effect_type = cst_grad_blk;
1203: CURSOR c_pee_details_1 IS
1204: SELECT PEE.pee_start_dt,
1205: PEE.expiry_dt

Line 1311: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1307: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1308: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1309: CURSOR c_course_ind IS
1310: SELECT SEET.apply_to_course_ind
1311: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1312: WHERE s_encmb_effect_type = cst_idcard_blk;
1313: CURSOR c_pee_details_1 IS
1314: SELECT PEE.pee_start_dt,
1315: PEE.expiry_dt

Line 1421: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1417: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1418: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1419: CURSOR c_course_ind IS
1420: SELECT SEET.apply_to_course_ind
1421: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1422: WHERE s_encmb_effect_type = cst_infbth_blk;
1423: CURSOR c_pee_details_1 IS
1424: SELECT PEE.pee_start_dt,
1425: PEE.expiry_dt

Line 1533: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1529: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1530: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1531: CURSOR c_course_ind IS
1532: SELECT SEET.apply_to_course_ind
1533: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1534: WHERE s_encmb_effect_type = cst_result_blk;
1535: CURSOR c_pee_details_1 IS
1536: SELECT PEE.pee_start_dt,
1537: PEE.expiry_dt

Line 1642: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1638: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1639: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1640: CURSOR c_course_ind IS
1641: SELECT SEET.apply_to_course_ind
1642: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1643: WHERE s_encmb_effect_type = cst_cor_blk;
1644: CURSOR c_pee_details_1 IS
1645: SELECT PEE.pee_start_dt,
1646: PEE.expiry_dt

Line 1752: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

1748: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
1749: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
1750: CURSOR c_course_ind IS
1751: SELECT SEET.apply_to_course_ind
1752: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1753: WHERE s_encmb_effect_type = cst_trans_blk;
1754: CURSOR c_pee_details_1 IS
1755: SELECT PEE.pee_start_dt,
1756: PEE.expiry_dt