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_PRC_LOAD dependencies on IGS_CA_INST

Line 115: FROM IGS_CA_INST_REL acir,

111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,
114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,

Line 116: IGS_CA_INST aci,

112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,
114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,

Line 119: IGS_CA_INST_REL lcir,

115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
122: IGS_CA_STAT lcs
123: WHERE acir.sub_cal_type = p_teach_cal_type AND

Line 120: IGS_CA_INST lci,

116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
122: IGS_CA_STAT lcs
123: WHERE acir.sub_cal_type = p_teach_cal_type AND
124: acir.sub_ci_sequence_number = p_teach_sequence_number AND

Line 270: CURSOR c_sua_cir(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_num igs_ca_inst.sequence_number%TYPE) IS

266: FROM igs_ca_load_to_teach_v
267: WHERE load_cal_type = p_load_cal_type
268: AND load_ci_sequence_number = p_load_sequence_number;
269:
270: CURSOR c_sua_cir(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_num igs_ca_inst.sequence_number%TYPE) IS
271: SELECT sua.unit_cd,
272: sua.version_number,
273: sua.cal_type,
274: sua.ci_sequence_number,

Line 283: IGS_CA_INST_REL cir,

279: sua.discontinued_dt,
280: sua.uoo_id,
281: sua.no_assessment_ind
282: FROM IGS_EN_SU_ATTEMPT sua,
283: IGS_CA_INST_REL cir,
284: IGS_PS_UNIT_VER uv
285: WHERE sua.person_id = p_person_id AND
286: sua.course_cd = p_course_cd AND
287: sua.unit_attempt_status IN (cst_enrolled,

Line 1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,

1066: --due to signature change by EN308 Billing credit hours
1067: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1068: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1069: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,
1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,

Line 1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS

1067: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1068: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1069: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,
1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,
1075: IGS_CA_INST CI,

Line 1074: FROM IGS_CA_INST_REL CIR,

1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,
1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,
1075: IGS_CA_INST CI,
1076: IGS_CA_TYPE CT,
1077: IGS_CA_STAT CS
1078: WHERE CT.closed_ind = 'N' AND

Line 1075: IGS_CA_INST CI,

1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,
1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,
1075: IGS_CA_INST CI,
1076: IGS_CA_TYPE CT,
1077: IGS_CA_STAT CS
1078: WHERE CT.closed_ind = 'N' AND
1079: CT.s_cal_cat = cst_teaching AND

Line 1095: cp_cal_type IGS_CA_INST.cal_type%TYPE,

1091: -- 'N') = 'Y');
1092: CURSOR c_stu_unit_atmpt(
1093: cp_person_id IGS_PE_PERSON.person_id%TYPE,
1094: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
1095: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1096: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1097: SELECT SUA.unit_cd,
1098: SUA.version_number,
1099: SUA.cal_type,

Line 1096: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1092: CURSOR c_stu_unit_atmpt(
1093: cp_person_id IGS_PE_PERSON.person_id%TYPE,
1094: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
1095: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1096: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1097: SELECT SUA.unit_cd,
1098: SUA.version_number,
1099: SUA.cal_type,
1100: SUA.ci_sequence_number,

Line 1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

1206: v_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1207: v_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1208: v_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;
1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;

Line 1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

1207: v_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1208: v_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;
1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

Line 1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

1208: v_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;
1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;

Line 1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;
1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;

Line 1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;

1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;

Line 1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

1211: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;
1219: v_message_name VARCHAR2(30);

Line 1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;

1212: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;
1219: v_message_name VARCHAR2(30);
1220: v_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

Line 1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;

1213: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;
1219: v_message_name VARCHAR2(30);
1220: v_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1221:

Line 1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;

1214: v_first_cal_type IGS_CA_INST.cal_type%TYPE;
1215: v_first_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1216: v_first_ci_start_dt IGS_CA_INST.start_dt%TYPE;
1217: v_first_ci_end_dt IGS_CA_INST.end_dt%TYPE;
1218: v_dummy_alt_cd IGS_CA_INST.alternate_code%TYPE;
1219: v_message_name VARCHAR2(30);
1220: v_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1221:
1222: CURSOR c_dflt_load_apportion(

Line 1430: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,

1426: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1427: cst_waitlisted CONSTANT VARCHAR2(10) := 'WAITLISTED';
1428:
1429: CURSOR c_dla(
1430: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1431: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1432: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
1433: SELECT ci.start_dt,
1434: ci.end_dt

Line 1431: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,

1427: cst_waitlisted CONSTANT VARCHAR2(10) := 'WAITLISTED';
1428:
1429: CURSOR c_dla(
1430: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1431: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1432: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
1433: SELECT ci.start_dt,
1434: ci.end_dt
1435: FROM IGS_ST_DFT_LOAD_APPO dla,

Line 1432: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

1428:
1429: CURSOR c_dla(
1430: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1431: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1432: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
1433: SELECT ci.start_dt,
1434: ci.end_dt
1435: FROM IGS_ST_DFT_LOAD_APPO dla,
1436: IGS_CA_INST ci

Line 1436: IGS_CA_INST ci

1432: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
1433: SELECT ci.start_dt,
1434: ci.end_dt
1435: FROM IGS_ST_DFT_LOAD_APPO dla,
1436: IGS_CA_INST ci
1437: WHERE dla.cal_type = cp_load_cal_type AND
1438: dla.ci_sequence_number = cp_load_sequence_number AND
1439: dla.teach_cal_type = cp_cal_type AND
1440: ci.cal_type = dla.cal_type AND

Line 1444: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,

1440: ci.cal_type = dla.cal_type AND
1441: ci.sequence_number = dla.ci_sequence_number;
1442:
1443: CURSOR c_ausl(
1444: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1445: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1446: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1447: cp_administrative_unit_status
1448: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS

Line 1445: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,

1441: ci.sequence_number = dla.ci_sequence_number;
1442:
1443: CURSOR c_ausl(
1444: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1445: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1446: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1447: cp_administrative_unit_status
1448: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
1449: SELECT AUSL.load_incurred_ind

Line 1446: cp_cal_type IGS_CA_INST.cal_type%TYPE,

1442:
1443: CURSOR c_ausl(
1444: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1445: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1446: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1447: cp_administrative_unit_status
1448: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
1449: SELECT AUSL.load_incurred_ind
1450: FROM IGS_AD_ADM_UT_STT_LD AUSL

Line 1473: v_start_dt IGS_CA_INST.start_dt%TYPE;

1469: FROM IGS_EN_INST_WL_STPS;
1470:
1471: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1472: v_load_incurred_ind IGS_AD_ADM_UT_STT_LD.load_incurred_ind%TYPE;
1473: v_start_dt IGS_CA_INST.start_dt%TYPE;
1474: v_end_dt IGS_CA_INST.end_dt%TYPE;
1475: v_dummy_aus VARCHAR2(10);
1476: v_admin_unit_status_str VARCHAR2(2000);
1477: v_incl_wlst_cp VARCHAR2(1);

Line 1474: v_end_dt IGS_CA_INST.end_dt%TYPE;

1470:
1471: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1472: v_load_incurred_ind IGS_AD_ADM_UT_STT_LD.load_incurred_ind%TYPE;
1473: v_start_dt IGS_CA_INST.start_dt%TYPE;
1474: v_end_dt IGS_CA_INST.end_dt%TYPE;
1475: v_dummy_aus VARCHAR2(10);
1476: v_admin_unit_status_str VARCHAR2(2000);
1477: v_incl_wlst_cp VARCHAR2(1);
1478: BEGIN

Line 1495: -- Note: this query joints to the IGS_CA_INST tabel to get the start

1491: -- For other statuses - load cannot be incurred.
1492: -- Check whether the teaching calendar has a load apportionment link
1493: -- th the load calendar. If no IGS_ST_DFT_LOAD_APPO detail exists then
1494: -- load is definitely not incurred. Processing concludes.
1495: -- Note: this query joints to the IGS_CA_INST tabel to get the start
1496: -- and end dates - this is to possibly save doing it later
1497:
1498:
1499: -- Check whether the passed in Unit Attempt is a Audit Unit

Line 1616: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,

1612: DECLARE
1613: -- cursor to check if a load and teaching calendar instance are related to
1614: -- the same academic period calendar instance.
1615: CURSOR c_cal_reln(
1616: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'

Line 1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,

1613: -- cursor to check if a load and teaching calendar instance are related to
1614: -- the same academic period calendar instance.
1615: CURSOR c_cal_reln(
1616: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,

Line 1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,

1614: -- the same academic period calendar instance.
1615: CURSOR c_cal_reln(
1616: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,

Line 1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1615: CURSOR c_cal_reln(
1616: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,
1623: IGS_CA_INST_REL cir2

Line 1621: FROM IGS_CA_INST_REL cir1,

1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,
1623: IGS_CA_INST_REL cir2
1624: WHERE cir1.sub_cal_type = cp_load_cal_type AND
1625: cir1.sub_ci_sequence_number = cp_load_sequence_number AND

Line 1623: IGS_CA_INST_REL cir2

1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,
1623: IGS_CA_INST_REL cir2
1624: WHERE cir1.sub_cal_type = cp_load_cal_type AND
1625: cir1.sub_ci_sequence_number = cp_load_sequence_number AND
1626: ct.cal_type = cir1.sup_cal_type AND
1627: ct.s_cal_cat = 'ACADEMIC' AND

Line 1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1750:
1751: END enrp_clc_key_prog;
1752:
1753: PROCEDURE enrp_get_inst_latt(p_person_id IN hz_parties.party_id%TYPE,
1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1758: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE

Line 1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,

1751: END enrp_clc_key_prog;
1752:
1753: PROCEDURE enrp_get_inst_latt(p_person_id IN hz_parties.party_id%TYPE,
1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1758: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1759: )

Line 1789: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

1785: /* Who When What
1786: stutta 24-NOV-2003 Modified cursor c_active_cd to consider term records while
1787: finding out the primary program of a student. Term Records Build.
1788: */
1789: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1790: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;

Line 1790: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1786: stutta 24-NOV-2003 Modified cursor c_active_cd to consider term records while
1787: finding out the primary program of a student. Term Records Build.
1788: */
1789: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1790: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

Line 1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;

1787: finding out the primary program of a student. Term Records Build.
1788: */
1789: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1790: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

Line 1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;

1788: */
1789: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1790: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;

Line 1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;

1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1799: l_version_number igs_en_su_attempt.version_number%TYPE;
1800: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1801:

Line 1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1930:
1931:
1932:
1933: PROCEDURE enrp_get_inst_latt_fte(p_person_id IN hz_parties.party_id%TYPE,
1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1938: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE

Line 1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,

1931:
1932:
1933: PROCEDURE enrp_get_inst_latt_fte(p_person_id IN hz_parties.party_id%TYPE,
1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1938: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1939: )

Line 1960: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

1956: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1957: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
1958: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1959: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1960: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1961: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;

Line 1961: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1957: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
1958: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1959: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1960: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1961: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

Line 1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;

1958: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1959: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1960: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1961: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

Line 1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;

1959: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1960: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1961: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;

Line 1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;

1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1970: l_version_number igs_en_su_attempt.version_number%TYPE;
1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1972:

Line 2146: CURSOR c_get_teach_cal_dtls(cp_load_cal_type igs_ca_inst.cal_type%TYPE,

2142: */
2143:
2144: --added by ckasu as a part of bug#5059308
2145: --Fetches the Teach calendar details
2146: CURSOR c_get_teach_cal_dtls(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2147: cp_load_seq_num igs_ca_inst.sequence_number%TYPE,
2148: cp_tp_sd_cut_off_date DATE) IS
2149: SELECT teach_cal_type,
2150: teach_ci_sequence_number

Line 2147: cp_load_seq_num igs_ca_inst.sequence_number%TYPE,

2143:
2144: --added by ckasu as a part of bug#5059308
2145: --Fetches the Teach calendar details
2146: CURSOR c_get_teach_cal_dtls(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2147: cp_load_seq_num igs_ca_inst.sequence_number%TYPE,
2148: cp_tp_sd_cut_off_date DATE) IS
2149: SELECT teach_cal_type,
2150: teach_ci_sequence_number
2151: FROM IGS_CA_LOAD_TO_TEACH_V lt

Line 2158: CURSOR cur_stud_ua_acad(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

2154: AND lt.teach_start_dt <= cp_tp_sd_cut_off_date
2155: ORDER BY teach_cal_type ASC,teach_ci_sequence_number ASC;
2156:
2157: --modified by ckasu as a part of bug#5059308
2158: CURSOR cur_stud_ua_acad(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
2159: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2160:
2161: SELECT sua.person_id,
2162: sua.course_cd,

Line 2159: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS

2155: ORDER BY teach_cal_type ASC,teach_ci_sequence_number ASC;
2156:
2157: --modified by ckasu as a part of bug#5059308
2158: CURSOR cur_stud_ua_acad(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
2159: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2160:
2161: SELECT sua.person_id,
2162: sua.course_cd,
2163: sua.unit_cd,

Line 2274: l_load_cal_type igs_ca_inst.cal_type%TYPE;

2270: WHERE cal_type = p_cal_type;
2271:
2272: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2273:
2274: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2275: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2276:
2277: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2278: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;

Line 2275: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

2271:
2272: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2273:
2274: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2275: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2276:
2277: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2278: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2279:

Line 2277: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2273:
2274: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2275: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2276:
2277: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2278: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2279:
2280: l_acad_ci_start_dt DATE;
2281: l_acad_ci_end_dt DATE;

Line 2278: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;

2274: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2275: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2276:
2277: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2278: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2279:
2280: l_acad_ci_start_dt DATE;
2281: l_acad_ci_end_dt DATE;
2282: l_message_name VARCHAR2(1000);

Line 2366: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

2362:
2363:
2364: PROCEDURE get_latest_load_for_acad_cal
2365: (
2366: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2367: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2368: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2369: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
2370: )

Line 2367: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

2363:
2364: PROCEDURE get_latest_load_for_acad_cal
2365: (
2366: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2367: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2368: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2369: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
2370: )
2371: AS

Line 2368: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

2364: PROCEDURE get_latest_load_for_acad_cal
2365: (
2366: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2367: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2368: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2369: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
2370: )
2371: AS
2372: /**********************************************************************************************************************

Line 2369: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE

2365: (
2366: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2367: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2368: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2369: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
2370: )
2371: AS
2372: /**********************************************************************************************************************
2373: Created By : msrinivi

Line 2380: FROM igs_ca_inst_rel rel,

2376: Fetches the latest load under the given given academic calendar
2377: ***********************************************************************************************************************/
2378: CURSOR c_latest_load IS
2379: SELECT rel.SUB_CAL_TYPE , rel.SUB_CI_SEQUENCE_NUMBER , NVL(dai.absolute_val, cai.start_dt) load_effective_dt
2380: FROM igs_ca_inst_rel rel,
2381: igs_ca_da_inst dai,
2382: igs_en_cal_conf conf,
2383: igs_ca_inst cai
2384: WHERE

Line 2383: igs_ca_inst cai

2379: SELECT rel.SUB_CAL_TYPE , rel.SUB_CI_SEQUENCE_NUMBER , NVL(dai.absolute_val, cai.start_dt) load_effective_dt
2380: FROM igs_ca_inst_rel rel,
2381: igs_ca_da_inst dai,
2382: igs_en_cal_conf conf,
2383: igs_ca_inst cai
2384: WHERE
2385: rel.SUB_CAL_TYPE = dai.CAL_TYPE
2386: AND rel.SUB_CI_SEQUENCE_NUMBER = dai.CI_SEQUENCE_NUMBER
2387: AND cai.CAL_TYPE = rel.SUB_CAL_TYPE

Line 2395: l_load_cal_type igs_ca_inst.cal_type%TYPE;

2391: AND SUP_CAL_TYPE = p_acad_cal_type
2392: AND SUP_CI_SEQUENCE_NUMBER = p_acad_ci_sequence_number
2393: ORDER BY 3 DESC;
2394:
2395: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2396: l_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ;
2397: l_load_effective_dt DATE;
2398:
2399: BEGIN

Line 2396: l_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ;

2392: AND SUP_CI_SEQUENCE_NUMBER = p_acad_ci_sequence_number
2393: ORDER BY 3 DESC;
2394:
2395: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2396: l_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ;
2397: l_load_effective_dt DATE;
2398:
2399: BEGIN
2400:

Line 2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;

2456: FROM igs_ca_type
2457: WHERE cal_type = p_cal_type;
2458:
2459: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2461: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2462: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2463: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2464: l_acad_ci_start_dt DATE;

Line 2461: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

2457: WHERE cal_type = p_cal_type;
2458:
2459: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2461: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2462: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2463: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2464: l_acad_ci_start_dt DATE;
2465: l_acad_ci_end_dt DATE;

Line 2462: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2458:
2459: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2461: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2462: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2463: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2464: l_acad_ci_start_dt DATE;
2465: l_acad_ci_end_dt DATE;
2466: lRet_for_cal VARCHAR2(100);

Line 2463: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;

2459: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
2460: l_load_cal_type igs_ca_inst.cal_type%TYPE;
2461: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2462: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2463: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2464: l_acad_ci_start_dt DATE;
2465: l_acad_ci_end_dt DATE;
2466: lRet_for_cal VARCHAR2(100);
2467:

Line 2543: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

2539: -- Function to calculate the Institutional Level Attendance Type
2540:
2541: FUNCTION enrp_get_inst_attendance(
2542: p_person_id IN hz_parties.party_id%TYPE,
2543: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2544: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2545: ) RETURN VARCHAR2 AS
2546:
2547: l_attendance igs_en_atd_type_load.attendance_type%TYPE;

Line 2544: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE

2540:
2541: FUNCTION enrp_get_inst_attendance(
2542: p_person_id IN hz_parties.party_id%TYPE,
2543: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2544: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2545: ) RETURN VARCHAR2 AS
2546:
2547: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2548: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;

Line 2573: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

2569:
2570: -- Function to calculate the Institutional Level Attendance Type
2571: FUNCTION enrp_get_inst_cp(
2572: p_person_id IN hz_parties.party_id%TYPE,
2573: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2574: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2575: ) RETURN VARCHAR2 AS
2576:
2577: l_attendance igs_en_atd_type_load.attendance_type%TYPE;

Line 2574: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE

2570: -- Function to calculate the Institutional Level Attendance Type
2571: FUNCTION enrp_get_inst_cp(
2572: p_person_id IN hz_parties.party_id%TYPE,
2573: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2574: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2575: ) RETURN VARCHAR2 AS
2576:
2577: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2578: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;