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_ENCMB dependencies on IGS_EN_ENCMB_EFCTTYP

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 131: cp_srv_type IGS_EN_ENCMB_EFCTTYP.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
133: FROM IGS_PE_PERSENC_EFFCT
134: WHERE person_id = p_person_id AND
135: s_encmb_effect_type = cp_srv_type;

Line 137: cp_srv_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ) IS

133: FROM IGS_PE_PERSENC_EFFCT
134: WHERE person_id = p_person_id AND
135: s_encmb_effect_type = cp_srv_type;
136: CURSOR c_get_pee_dates_for_crs (
137: cp_srv_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ) IS
138: SELECT pee_start_dt, expiry_dt
139: FROM IGS_PE_PERSENC_EFFCT
140: WHERE person_id = p_person_id AND
141: s_encmb_effect_type = cp_srv_type AND

Line 743: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

739: p_message_name OUT NOCOPY VARCHAR2)
740: RETURN BOOLEAN AS
741: BEGIN
742: DECLARE
743: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
744:
745: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;
746: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;
747: v_restricted_attendance_type

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 866: v_ge_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

862: BEGIN
863: DECLARE
864: cst_rstr_ge_cp CONSTANT VARCHAR2(10) := 'RSTR_GE_CP';
865: cst_rstr_le_cp CONSTANT VARCHAR2(10) := 'RSTR_LE_CP';
866: v_ge_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
867: v_le_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
868: v_message_name VARCHAR2(30);
869: v_validate_rstr_ge_cp BOOLEAN := TRUE;
870: v_validate_rstr_le_cp BOOLEAN := TRUE;

Line 867: v_le_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

863: DECLARE
864: cst_rstr_ge_cp CONSTANT VARCHAR2(10) := 'RSTR_GE_CP';
865: cst_rstr_le_cp CONSTANT VARCHAR2(10) := 'RSTR_LE_CP';
866: v_ge_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
867: v_le_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
868: v_message_name VARCHAR2(30);
869: v_validate_rstr_ge_cp BOOLEAN := TRUE;
870: v_validate_rstr_le_cp BOOLEAN := TRUE;
871: CURSOR c_ge_course_ind IS

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 1086: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1082: RETURN BOOLEAN AS
1083: BEGIN
1084: DECLARE
1085: cst_crsmtrl_blk CONSTANT VARCHAR2(10) := 'C_MTRL_BLK';
1086: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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 1196: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1192: RETURN BOOLEAN AS
1193: BEGIN
1194: DECLARE
1195: cst_grad_blk CONSTANT VARCHAR2(10) := 'GRAD_BLK';
1196: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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 1306: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1302: RETURN BOOLEAN AS
1303: BEGIN
1304: DECLARE
1305: cst_idcard_blk CONSTANT VARCHAR2(10) := 'IDCARD_BLK';
1306: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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 1416: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1412: RETURN BOOLEAN AS
1413: BEGIN
1414: DECLARE
1415: cst_infbth_blk CONSTANT VARCHAR2(10) := 'INFBTH_BLK';
1416: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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 1528: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1524: RETURN BOOLEAN AS
1525: BEGIN
1526: DECLARE
1527: cst_result_blk CONSTANT VARCHAR2(10) := 'RESULT_BLK';
1528: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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 1637: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1633: RETURN BOOLEAN AS
1634: BEGIN
1635: DECLARE
1636: cst_cor_blk CONSTANT VARCHAR2(10) := 'S_COR_BLK';
1637: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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 1747: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;

1743: RETURN BOOLEAN AS
1744: BEGIN
1745: DECLARE
1746: cst_trans_blk CONSTANT VARCHAR2(10) := 'TRANS_BLK';
1747: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP.apply_to_course_ind%TYPE;
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

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