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_PE_PERSENC_EFFCT

Line 35: FROM IGS_PE_PERSENC_EFFCT pee,

31: v_expiry_dt IGS_PE_PERS_UNT_EXCL.expiry_dt%TYPE;
32: CURSOR c_psd_ed IS
33: SELECT pue.pue_start_dt,
34: pue.expiry_dt
35: FROM IGS_PE_PERSENC_EFFCT pee,
36: IGS_PE_PERS_UNT_EXCL pue
37: WHERE pee.person_id = p_person_id AND
38: pee.s_encmb_effect_type = 'EXC_CRS_U' AND
39: pee.course_cd = p_course_cd AND

Line 114: pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

110:
111: BEGIN
112: DECLARE
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

Line 115: expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE);

111: BEGIN
112: DECLARE
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';

Line 133: FROM IGS_PE_PERSENC_EFFCT

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;
136: CURSOR c_get_pee_dates_for_crs (
137: cp_srv_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ) IS

Line 139: FROM IGS_PE_PERSENC_EFFCT

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
142: course_cd = p_course_cd;
143: BEGIN

Line 407: FROM IGS_PE_PERSENC_EFFCT pee,

403: v_expiry_dt IGS_PE_UNT_SET_EXCL.expiry_dt%TYPE;
404: CURSOR c_psd_ed IS
405: SELECT puse.puse_start_dt,
406: puse.expiry_dt
407: FROM IGS_PE_PERSENC_EFFCT pee,
408: IGS_PE_UNT_SET_EXCL puse
409: WHERE pee.person_id = p_person_id AND
410: pee.s_encmb_effect_type = 'EXC_CRS_US' AND
411: pee.course_cd = p_course_cd AND

Line 510: -- Cursor on IGS_PE_PERSENC_EFFCT (pee) and

506: v_expiry_dt IGS_PE_UNT_REQUIRMNT.expiry_dt%TYPE;
507: v_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
508: v_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
509: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
510: -- Cursor on IGS_PE_PERSENC_EFFCT (pee) and
511: -- IGS_PE_UNT_REQUIRMNT (pur) tables.
512: -- Cursor validates required IGS_PS_UNIT(s).
513: CURSOR c_pee_pur IS
514: SELECT pur.unit_cd,

Line 517: FROM IGS_PE_PERSENC_EFFCT pee,

513: CURSOR c_pee_pur IS
514: SELECT pur.unit_cd,
515: pur.pur_start_dt,
516: pur.expiry_dt
517: FROM IGS_PE_PERSENC_EFFCT pee,
518: IGS_PE_UNT_REQUIRMNT pur
519: WHERE pee.person_id = p_person_id AND
520: pee.s_encmb_effect_type = cst_effect_type AND
521: pee.course_cd = p_course_cd AND

Line 745: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
748: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
749: CURSOR c_course_ind IS

Line 746: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
748: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
749: CURSOR c_course_ind IS
750: SELECT SEET.apply_to_course_ind

Line 748: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%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
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';

Line 757: FROM IGS_PE_PERSENC_EFFCT PEE

753: CURSOR c_pee_details_1 IS
754: SELECT PEE.pee_start_dt,
755: PEE.expiry_dt,
756: PEE.restricted_attendance_type
757: FROM IGS_PE_PERSENC_EFFCT PEE
758: WHERE person_id = p_person_id AND
759: s_encmb_effect_type = 'RSTR_AT_TY';
760: CURSOR c_pee_details_2 IS
761: SELECT PEE.pee_start_dt,

Line 764: FROM IGS_PE_PERSENC_EFFCT PEE

760: CURSOR c_pee_details_2 IS
761: SELECT PEE.pee_start_dt,
762: PEE.expiry_dt,
763: PEE.restricted_attendance_type
764: FROM IGS_PE_PERSENC_EFFCT PEE
765: WHERE person_id = p_person_id AND
766: s_encmb_effect_type = 'RSTR_AT_TY' AND
767: course_cd = p_course_cd;
768: BEGIN

Line 883: FROM IGS_PE_PERSENC_EFFCT PEE

879: CURSOR c_pee_details_1 IS
880: SELECT PEE.pee_start_dt,
881: PEE.expiry_dt,
882: PEE.restricted_enrolment_cp
883: FROM IGS_PE_PERSENC_EFFCT PEE
884: WHERE person_id = p_person_id AND
885: s_encmb_effect_type = cst_rstr_ge_cp AND
886: restricted_enrolment_cp IS NOT NULL
887: ORDER BY PEE.restricted_enrolment_cp DESC;

Line 892: FROM IGS_PE_PERSENC_EFFCT PEE

888: CURSOR c_pee_details_2 IS
889: SELECT PEE.pee_start_dt,
890: PEE.expiry_dt,
891: PEE.restricted_enrolment_cp
892: FROM IGS_PE_PERSENC_EFFCT PEE
893: WHERE person_id = p_person_id AND
894: s_encmb_effect_type = cst_rstr_ge_cp AND
895: course_cd = p_course_cd AND
896: restricted_enrolment_cp IS NOT NULL

Line 902: FROM IGS_PE_PERSENC_EFFCT PEE

898: CURSOR c_pee_details_3 IS
899: SELECT PEE.pee_start_dt,
900: PEE.expiry_dt,
901: PEE.restricted_enrolment_cp
902: FROM IGS_PE_PERSENC_EFFCT PEE
903: WHERE person_id = p_person_id AND
904: s_encmb_effect_type = cst_rstr_le_cp AND
905: restricted_enrolment_cp IS NOT NULL
906: ORDER BY PEE.restricted_enrolment_cp ASC;

Line 911: FROM IGS_PE_PERSENC_EFFCT PEE

907: CURSOR c_pee_details_4 IS
908: SELECT PEE.pee_start_dt,
909: PEE.expiry_dt,
910: PEE.restricted_enrolment_cp
911: FROM IGS_PE_PERSENC_EFFCT PEE
912: WHERE person_id = p_person_id AND
913: s_encmb_effect_type = cst_rstr_le_cp AND
914: course_cd = p_course_cd AND
915: restricted_enrolment_cp IS NOT NULL

Line 1087: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1091: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1088: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1091: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1092: WHERE s_encmb_effect_type = cst_crsmtrl_blk;

Line 1096: FROM IGS_PE_PERSENC_EFFCT PEE

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
1096: FROM IGS_PE_PERSENC_EFFCT PEE
1097: WHERE person_id = p_person_id AND
1098: s_encmb_effect_type = cst_crsmtrl_blk;
1099: CURSOR c_pee_details_2 IS
1100: SELECT PEE.pee_start_dt,

Line 1102: FROM IGS_PE_PERSENC_EFFCT PEE

1098: s_encmb_effect_type = cst_crsmtrl_blk;
1099: CURSOR c_pee_details_2 IS
1100: SELECT PEE.pee_start_dt,
1101: PEE.expiry_dt
1102: FROM IGS_PE_PERSENC_EFFCT PEE
1103: WHERE person_id = p_person_id AND
1104: s_encmb_effect_type = cst_crsmtrl_blk AND
1105: course_cd = p_course_cd;
1106: BEGIN

Line 1197: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1201: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1198: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1201: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1202: WHERE s_encmb_effect_type = cst_grad_blk;

Line 1206: FROM IGS_PE_PERSENC_EFFCT PEE

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
1206: FROM IGS_PE_PERSENC_EFFCT PEE
1207: WHERE person_id = p_person_id AND
1208: s_encmb_effect_type = cst_grad_blk;
1209: CURSOR c_pee_details_2 IS
1210: SELECT PEE.pee_start_dt,

Line 1212: FROM IGS_PE_PERSENC_EFFCT PEE

1208: s_encmb_effect_type = cst_grad_blk;
1209: CURSOR c_pee_details_2 IS
1210: SELECT PEE.pee_start_dt,
1211: PEE.expiry_dt
1212: FROM IGS_PE_PERSENC_EFFCT PEE
1213: WHERE person_id = p_person_id AND
1214: s_encmb_effect_type = cst_grad_blk AND
1215: course_cd = p_course_cd;
1216: BEGIN

Line 1307: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1311: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1308: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1311: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1312: WHERE s_encmb_effect_type = cst_idcard_blk;

Line 1316: FROM IGS_PE_PERSENC_EFFCT PEE

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
1316: FROM IGS_PE_PERSENC_EFFCT PEE
1317: WHERE person_id = p_person_id AND
1318: s_encmb_effect_type = cst_idcard_blk;
1319: CURSOR c_pee_details_2 IS
1320: SELECT PEE.pee_start_dt,

Line 1322: FROM IGS_PE_PERSENC_EFFCT PEE

1318: s_encmb_effect_type = cst_idcard_blk;
1319: CURSOR c_pee_details_2 IS
1320: SELECT PEE.pee_start_dt,
1321: PEE.expiry_dt
1322: FROM IGS_PE_PERSENC_EFFCT PEE
1323: WHERE person_id = p_person_id AND
1324: s_encmb_effect_type = cst_idcard_blk AND
1325: course_cd = p_course_cd;
1326: BEGIN

Line 1417: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1421: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1418: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1421: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1422: WHERE s_encmb_effect_type = cst_infbth_blk;

Line 1426: FROM IGS_PE_PERSENC_EFFCT PEE

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
1426: FROM IGS_PE_PERSENC_EFFCT PEE
1427: WHERE person_id = p_person_id AND
1428: s_encmb_effect_type = cst_infbth_blk;
1429: CURSOR c_pee_details_2 IS
1430: SELECT PEE.pee_start_dt,

Line 1432: FROM IGS_PE_PERSENC_EFFCT PEE

1428: s_encmb_effect_type = cst_infbth_blk;
1429: CURSOR c_pee_details_2 IS
1430: SELECT PEE.pee_start_dt,
1431: PEE.expiry_dt
1432: FROM IGS_PE_PERSENC_EFFCT PEE
1433: WHERE person_id = p_person_id AND
1434: s_encmb_effect_type = cst_infbth_blk AND
1435: course_cd = p_course_cd;
1436: BEGIN

Line 1529: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1533: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1530: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1533: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1534: WHERE s_encmb_effect_type = cst_result_blk;

Line 1538: FROM IGS_PE_PERSENC_EFFCT PEE

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
1538: FROM IGS_PE_PERSENC_EFFCT PEE
1539: WHERE person_id = p_person_id AND
1540: s_encmb_effect_type = cst_result_blk;
1541: CURSOR c_pee_details_2 IS
1542: SELECT PEE.pee_start_dt,

Line 1544: FROM IGS_PE_PERSENC_EFFCT PEE

1540: s_encmb_effect_type = cst_result_blk;
1541: CURSOR c_pee_details_2 IS
1542: SELECT PEE.pee_start_dt,
1543: PEE.expiry_dt
1544: FROM IGS_PE_PERSENC_EFFCT PEE
1545: WHERE person_id = p_person_id AND
1546: s_encmb_effect_type = cst_result_blk AND
1547: course_cd = p_course_cd;
1548: BEGIN

Line 1638: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1642: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1639: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1642: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1643: WHERE s_encmb_effect_type = cst_cor_blk;

Line 1647: FROM IGS_PE_PERSENC_EFFCT PEE

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
1647: FROM IGS_PE_PERSENC_EFFCT PEE
1648: WHERE person_id = p_person_id AND
1649: s_encmb_effect_type = cst_cor_blk;
1650: CURSOR c_pee_details_2 IS
1651: SELECT PEE.pee_start_dt,

Line 1653: FROM IGS_PE_PERSENC_EFFCT PEE

1649: s_encmb_effect_type = cst_cor_blk;
1650: CURSOR c_pee_details_2 IS
1651: SELECT PEE.pee_start_dt,
1652: PEE.expiry_dt
1653: FROM IGS_PE_PERSENC_EFFCT PEE
1654: WHERE person_id = p_person_id AND
1655: s_encmb_effect_type = cst_cor_blk AND
1656: course_cd = p_course_cd;
1657: BEGIN

Line 1748: v_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE;

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
1752: FROM IGS_EN_ENCMB_EFCTTYP_V SEET

Line 1749: v_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE;

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
1752: FROM IGS_EN_ENCMB_EFCTTYP_V SEET
1753: WHERE s_encmb_effect_type = cst_trans_blk;

Line 1757: FROM IGS_PE_PERSENC_EFFCT PEE

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
1757: FROM IGS_PE_PERSENC_EFFCT PEE
1758: WHERE person_id = p_person_id AND
1759: s_encmb_effect_type = cst_trans_blk;
1760: CURSOR c_pee_details_2 IS
1761: SELECT PEE.pee_start_dt,

Line 1763: FROM IGS_PE_PERSENC_EFFCT PEE

1759: s_encmb_effect_type = cst_trans_blk;
1760: CURSOR c_pee_details_2 IS
1761: SELECT PEE.pee_start_dt,
1762: PEE.expiry_dt
1763: FROM IGS_PE_PERSENC_EFFCT PEE
1764: WHERE person_id = p_person_id AND
1765: s_encmb_effect_type = cst_trans_blk AND
1766: course_cd = p_course_cd;
1767: BEGIN

Line 1880: v_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE;

1876: v_period_cp NUMBER;
1877: v_period_load NUMBER;
1878: v_credit_points NUMBER;
1879: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1880: v_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE;
1881: v_restricted_attendance_type
1882: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
1883: v_rstrct_le_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1884: v_rstrct_ge_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;

Line 1882: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;

1878: v_credit_points NUMBER;
1879: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1880: v_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE;
1881: v_restricted_attendance_type
1882: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
1883: v_rstrct_le_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1884: v_rstrct_ge_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1885: v_return_type VARCHAR2(1);
1886: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;

Line 1883: v_rstrct_le_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;

1879: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1880: v_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE;
1881: v_restricted_attendance_type
1882: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
1883: v_rstrct_le_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1884: v_rstrct_ge_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1885: v_return_type VARCHAR2(1);
1886: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1887: v_load_effect_dt DATE;

Line 1884: v_rstrct_ge_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;

1880: v_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE;
1881: v_restricted_attendance_type
1882: IGS_PE_PERSENC_EFFCT.restricted_attendance_type%TYPE;
1883: v_rstrct_le_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1884: v_rstrct_ge_cp_value IGS_PE_PERSENC_EFFCT.restricted_enrolment_cp%TYPE;
1885: v_return_type VARCHAR2(1);
1886: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1887: v_load_effect_dt DATE;
1888: v_message_name VARCHAR2(200);