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

Line 48: FROM igs_ca_inst

44: AND dai.ci_sequence_number = cp_cal_seq_number
45: ORDER BY 1 ASC; -- Order by the census_date to use the earliest value.
46: CURSOR cur_teach_period_start_date IS
47: SELECT start_dt
48: FROM igs_ca_inst
49: WHERE cal_type = p_teach_cal_type
50: AND sequence_number = p_teach_cal_seq_number;
51: --
52: -- Local Variables for the function get_effective_census_date:

Line 776: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

772: l_enr_ci_seq NUMBER(20);
773: l_enr_cat VARCHAR2(20);
774: l_enr_comm VARCHAR2(2000);
775: l_return_val BOOLEAN;
776: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
777: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;
780: l_alternate_code igs_ca_inst.alternate_code%TYPE;

Line 777: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

773: l_enr_cat VARCHAR2(20);
774: l_enr_comm VARCHAR2(2000);
775: l_return_val BOOLEAN;
776: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
777: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;
780: l_alternate_code igs_ca_inst.alternate_code%TYPE;
781: l_message VARCHAR2(100);

Line 778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;

774: l_enr_comm VARCHAR2(2000);
775: l_return_val BOOLEAN;
776: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
777: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;
780: l_alternate_code igs_ca_inst.alternate_code%TYPE;
781: l_message VARCHAR2(100);
782: l_person_type igs_pe_person_types.person_type_code%TYPE;

Line 779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;

775: l_return_val BOOLEAN;
776: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
777: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;
780: l_alternate_code igs_ca_inst.alternate_code%TYPE;
781: l_message VARCHAR2(100);
782: l_person_type igs_pe_person_types.person_type_code%TYPE;
783: l_notification_flag VARCHAR2(10);

Line 780: l_alternate_code igs_ca_inst.alternate_code%TYPE;

776: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
777: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;
780: l_alternate_code igs_ca_inst.alternate_code%TYPE;
781: l_message VARCHAR2(100);
782: l_person_type igs_pe_person_types.person_type_code%TYPE;
783: l_notification_flag VARCHAR2(10);
784: l_ret_status VARCHAR2(10);

Line 1211: l_current_load_cal_type igs_ca_inst.cal_type%TYPE;

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;
1215: l_other_detail VARCHAR2(255);

Line 1212: l_current_load_sequence_number igs_ca_inst.sequence_number%TYPE;

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;
1215: l_other_detail VARCHAR2(255);
1216: l_effective_dt DATE;

Line 1213: l_current_acad_cal_type igs_ca_inst.cal_type%TYPE;

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;
1215: l_other_detail VARCHAR2(255);
1216: l_effective_dt DATE;
1217: --

Line 1214: l_current_acad_sequence_number igs_ca_inst.sequence_number%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;
1215: l_other_detail VARCHAR2(255);
1216: l_effective_dt DATE;
1217: --
1218: -- Cursor to fetch student course attempt calendar type

Line 1236: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,

1232: WHERE secc.s_control_num = 1;
1233: --
1234: -- Cursor to fetch calendar instances
1235: --
1236: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
1237: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
1238: SELECT ci.cal_type,
1239: ci.sequence_number
1240: FROM igs_ca_inst ci,

Line 1237: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS

1233: --
1234: -- Cursor to fetch calendar instances
1235: --
1236: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
1237: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
1238: SELECT ci.cal_type,
1239: ci.sequence_number
1240: FROM igs_ca_inst ci,
1241: igs_ca_stat cs

Line 1240: FROM igs_ca_inst ci,

1236: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
1237: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
1238: SELECT ci.cal_type,
1239: ci.sequence_number
1240: FROM igs_ca_inst ci,
1241: igs_ca_stat cs
1242: WHERE ci.cal_type = cp_cal_type
1243: AND ci.start_dt <= cp_effective_dt
1244: AND ci.end_dt >= cp_effective_dt

Line 1251: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,

1247: ORDER BY ci.start_dt DESC;
1248: --
1249: -- Cursor to fetch calendar type instances
1250: --
1251: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
1252: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1253: SELECT ci.cal_type,
1254: ci.sequence_number,
1255: ci.start_dt,

Line 1252: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

1248: --
1249: -- Cursor to fetch calendar type instances
1250: --
1251: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
1252: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1253: SELECT ci.cal_type,
1254: ci.sequence_number,
1255: ci.start_dt,
1256: ci.end_dt

Line 1258: igs_ca_inst ci,

1254: ci.sequence_number,
1255: ci.start_dt,
1256: ci.end_dt
1257: FROM igs_ca_type ct,
1258: igs_ca_inst ci,
1259: igs_ca_stat cs,
1260: igs_ca_inst_rel cir
1261: WHERE ct.closed_ind = 'N'
1262: AND cs.s_cal_status = cst_active

Line 1260: igs_ca_inst_rel cir

1256: ci.end_dt
1257: FROM igs_ca_type ct,
1258: igs_ca_inst ci,
1259: igs_ca_stat cs,
1260: igs_ca_inst_rel cir
1261: WHERE ct.closed_ind = 'N'
1262: AND cs.s_cal_status = cst_active
1263: AND ci.cal_status = cs.cal_status
1264: AND ct.s_cal_cat = cst_load

Line 1270: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,

1266: AND cir.sub_cal_type = ci.cal_type
1267: AND cir.sub_ci_sequence_number =ci.sequence_number
1268: AND cir.sup_cal_type = cp_cal_type
1269: AND cir.sup_ci_sequence_number = cp_sequence_number
1270: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
1271: igs_ca_type ct
1272: WHERE cir.sup_cal_type = cp_cal_type
1273: AND cir.sup_ci_sequence_number = cp_sequence_number
1274: AND cir.sub_cal_type = ci.cal_type

Line 1501: CURSOR cur_load_dtl_of_uoo_id (p_cal_type IGS_CA_TYPE.cal_type%TYPE , p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS

1497: FROM IGS_PS_UNIT_OFR_OPT
1498: WHERE uoo_id = p_uoo_id;
1499:
1500: -- Cursor to get the Load Calendar of the given Teach Calendar.
1501: CURSOR cur_load_dtl_of_uoo_id (p_cal_type IGS_CA_TYPE.cal_type%TYPE , p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
1502: SELECT load_cal_type,
1503: load_ci_sequence_number
1504: FROM igs_ca_teach_to_load_v
1505: WHERE teach_cal_type = p_cal_type

Line 1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;

1628: -- Local Variables
1629:
1630: l_achieved_cp NUMBER;
1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;

Line 1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

1629:
1630: l_achieved_cp NUMBER;
1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;

1630: l_achieved_cp NUMBER;
1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;

Line 1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;

1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;

Line 1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;

1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;

Line 1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;

Line 1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;

1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

Line 1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;

1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1644: l_init_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1645: l_init_load_ci_end_dt igs_ca_inst.end_dt%TYPE;

Line 1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1644: l_init_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1645: l_init_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1646: l_message_name VARCHAR2(30) := NULL;

Line 1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;

1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1644: l_init_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1645: l_init_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1646: l_message_name VARCHAR2(30) := NULL;
1647: l_cst_enrolled VARCHAR2(10) ;

Line 1644: l_init_load_ci_start_dt igs_ca_inst.start_dt%TYPE;

1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1644: l_init_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1645: l_init_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1646: l_message_name VARCHAR2(30) := NULL;
1647: l_cst_enrolled VARCHAR2(10) ;
1648:

Line 1645: l_init_load_ci_end_dt igs_ca_inst.end_dt%TYPE;

1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1644: l_init_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1645: l_init_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1646: l_message_name VARCHAR2(30) := NULL;
1647: l_cst_enrolled VARCHAR2(10) ;
1648:
1649:

Line 1651: CURSOR cur_ca_inst ( p_load_cal_type igs_ca_inst.cal_type%TYPE,

1647: l_cst_enrolled VARCHAR2(10) ;
1648:
1649:
1650: -- Cursor to find the Start Date and End Date of a Calendar Instance
1651: CURSOR cur_ca_inst ( p_load_cal_type igs_ca_inst.cal_type%TYPE,
1652: p_load_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS
1653: SELECT alternate_code, start_dt, end_dt
1654: FROM IGS_CA_INST
1655: WHERE cal_type = p_load_cal_type

Line 1652: p_load_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS

1648:
1649:
1650: -- Cursor to find the Start Date and End Date of a Calendar Instance
1651: CURSOR cur_ca_inst ( p_load_cal_type igs_ca_inst.cal_type%TYPE,
1652: p_load_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS
1653: SELECT alternate_code, start_dt, end_dt
1654: FROM IGS_CA_INST
1655: WHERE cal_type = p_load_cal_type
1656: AND sequence_number = p_load_ci_seq_num ;

Line 1654: FROM IGS_CA_INST

1650: -- Cursor to find the Start Date and End Date of a Calendar Instance
1651: CURSOR cur_ca_inst ( p_load_cal_type igs_ca_inst.cal_type%TYPE,
1652: p_load_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS
1653: SELECT alternate_code, start_dt, end_dt
1654: FROM IGS_CA_INST
1655: WHERE cal_type = p_load_cal_type
1656: AND sequence_number = p_load_ci_seq_num ;
1657: cur_ca_inst_rec cur_ca_inst%ROWTYPE;
1658:

Line 1681: l_cal_type igs_ca_inst.cal_type%TYPE;

1677: SELECT sca.cal_type
1678: FROM igs_en_stdnt_ps_att sca
1679: WHERE sca.person_id = cp_person_id
1680: AND sca.course_cd = cp_course_cd;
1681: l_cal_type igs_ca_inst.cal_type%TYPE;
1682:
1683: BEGIN
1684: --Assigning due to gscc warnings
1685: l_cst_enrolled := 'ENROLLED';

Line 2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;

Line 2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

Line 2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2045: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2045: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2046: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
2047: l_message VARCHAR2(2000);

Line 2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2045: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2046: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
2047: l_message VARCHAR2(2000);
2048: l_return_status VARCHAR2(10);

Line 2045: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2045: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2046: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
2047: l_message VARCHAR2(2000);
2048: l_return_status VARCHAR2(10);
2049: l_dummy VARCHAR2(200);

Line 2570: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2566: l_person_type igs_pe_person_types.person_type_code%TYPE;
2567: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2568: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2569: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2570: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2571: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2572: l_step_override_limit NUMBER;
2573: l_message VARCHAR2(100);
2574: l_ret_status VARCHAR2(10);

Line 2571: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2567: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2568: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2569: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2570: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2571: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2572: l_step_override_limit NUMBER;
2573: l_message VARCHAR2(100);
2574: l_ret_status VARCHAR2(10);
2575: l_en_cal_type igs_ca_inst.cal_type%TYPE;

Line 2575: l_en_cal_type igs_ca_inst.cal_type%TYPE;

2571: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2572: l_step_override_limit NUMBER;
2573: l_message VARCHAR2(100);
2574: l_ret_status VARCHAR2(10);
2575: l_en_cal_type igs_ca_inst.cal_type%TYPE;
2576: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2577: l_dummy VARCHAR2(200);
2578:
2579: BEGIN

Line 2576: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;

2572: l_step_override_limit NUMBER;
2573: l_message VARCHAR2(100);
2574: l_ret_status VARCHAR2(10);
2575: l_en_cal_type igs_ca_inst.cal_type%TYPE;
2576: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;
2577: l_dummy VARCHAR2(200);
2578:
2579: BEGIN
2580:

Line 2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;

2688: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
2689: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2690: l_daiv_rec_found BOOLEAN;
2691: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2696: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

Line 2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;

2689: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2690: l_daiv_rec_found BOOLEAN;
2691: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2696: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2697: l_other_detail VARCHAR2(255);

Line 2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;

2690: l_daiv_rec_found BOOLEAN;
2691: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2696: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2697: l_other_detail VARCHAR2(255);
2698: l_effective_dt DATE;

Line 2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2691: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2696: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2697: l_other_detail VARCHAR2(255);
2698: l_effective_dt DATE;
2699:

Line 2696: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2696: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2697: l_other_detail VARCHAR2(255);
2698: l_effective_dt DATE;
2699:
2700: --

Line 2714: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE) is

2710:
2711: --
2712: -- CURSOR TO FETCH CALENDAR TYPE INSTANCES
2713: --
2714: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE) is
2715: SELECT ci.cal_type,
2716: ci.sequence_number,
2717: ci.alternate_code,
2718: ci.start_dt,

Line 2721: igs_ca_inst ci,

2717: ci.alternate_code,
2718: ci.start_dt,
2719: ci.end_dt
2720: FROM igs_ca_type ct,
2721: igs_ca_inst ci,
2722: igs_ca_stat cs,
2723: igs_ca_inst_rel cir
2724: WHERE cs.s_cal_status = cst_active
2725: AND ci.cal_status = cs.cal_status

Line 2723: igs_ca_inst_rel cir

2719: ci.end_dt
2720: FROM igs_ca_type ct,
2721: igs_ca_inst ci,
2722: igs_ca_stat cs,
2723: igs_ca_inst_rel cir
2724: WHERE cs.s_cal_status = cst_active
2725: AND ci.cal_status = cs.cal_status
2726: AND ct.s_cal_cat = cst_load
2727: AND ci.cal_type = ct.cal_type

Line 2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;

2858: -- LOCAL VARIABLES
2859: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
2860: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2861: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2866: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

Line 2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;

2859: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
2860: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2861: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2866: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2867: l_other_detail VARCHAR2(255);

Line 2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;

2860: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2861: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2866: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2867: l_other_detail VARCHAR2(255);
2868: l_effective_dt DATE;

Line 2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2861: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2866: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2867: l_other_detail VARCHAR2(255);
2868: l_effective_dt DATE;
2869:

Line 2866: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2866: l_current_load_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2867: l_other_detail VARCHAR2(255);
2868: l_effective_dt DATE;
2869:
2870: --

Line 2881: CURSOR c_acad_cal_instances (cp_acad_cal_type igs_ca_inst.cal_type%TYPE) IS

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
2884: WHERE CAL_TYPE = cp_acad_cal_type
2885: ORDER BY start_dt DESC;

Line 2883: FROM IGS_CA_INST

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
2884: WHERE CAL_TYPE = cp_acad_cal_type
2885: ORDER BY start_dt DESC;
2886:
2887: lb_found_load_rec Boolean;

Line 2892: CURSOR c_cal_type_instance (cp_acad_cal_type igs_ca_inst.cal_type%TYPE,

2888:
2889: --
2890: -- CURSOR TO FETCH CALENDAR TYPE INSTANCES
2891: --
2892: CURSOR c_cal_type_instance (cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
2893: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
2894: SELECT ci.cal_type,
2895: ci.sequence_number,
2896: ci.alternate_code,

Line 2893: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

2889: --
2890: -- CURSOR TO FETCH CALENDAR TYPE INSTANCES
2891: --
2892: CURSOR c_cal_type_instance (cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
2893: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
2894: SELECT ci.cal_type,
2895: ci.sequence_number,
2896: ci.alternate_code,
2897: ci.start_dt,

Line 2900: igs_ca_inst ci,

2896: ci.alternate_code,
2897: ci.start_dt,
2898: ci.end_dt
2899: FROM igs_ca_type ct,
2900: igs_ca_inst ci,
2901: igs_ca_stat cs,
2902: igs_ca_inst_rel cir
2903: WHERE cs.s_cal_status = cst_active
2904: AND ci.cal_status = cs.cal_status

Line 2902: igs_ca_inst_rel cir

2898: ci.end_dt
2899: FROM igs_ca_type ct,
2900: igs_ca_inst ci,
2901: igs_ca_stat cs,
2902: igs_ca_inst_rel cir
2903: WHERE cs.s_cal_status = cst_active
2904: AND ci.cal_status = cs.cal_status
2905: AND ct.s_cal_cat = cst_load
2906: AND ci.cal_type = ct.cal_type

Line 2927: CURSOR c_first_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE) IS

2923: AND daiv.dt_alias = cp_load_effect_dt_alias;
2924:
2925: -- Cursor to fetch load calendar with earliest start date
2926: -- and whose start_date and end_date encompass the SYSDATE
2927: CURSOR c_first_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE) IS
2928: SELECT ci.cal_type,
2929: ci.sequence_number,
2930: ci.alternate_code,
2931: ci.start_dt,

Line 2934: igs_ca_inst ci,

2930: ci.alternate_code,
2931: ci.start_dt,
2932: ci.end_dt
2933: FROM igs_ca_type ct,
2934: igs_ca_inst ci,
2935: igs_ca_stat cs,
2936: igs_ca_inst_rel cir
2937: WHERE cs.s_cal_status = cst_active
2938: AND ci.cal_status = cs.cal_status

Line 2936: igs_ca_inst_rel cir

2932: ci.end_dt
2933: FROM igs_ca_type ct,
2934: igs_ca_inst ci,
2935: igs_ca_stat cs,
2936: igs_ca_inst_rel cir
2937: WHERE cs.s_cal_status = cst_active
2938: AND ci.cal_status = cs.cal_status
2939: AND ct.s_cal_cat = cst_load
2940: AND ci.cal_type = ct.cal_type

Line 3079: l_current_load_cal_type igs_ca_inst.cal_type%TYPE;

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;
3083: l_other_detail VARCHAR2(255);

Line 3080: l_current_load_sequence_number igs_ca_inst.sequence_number%TYPE;

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;
3083: l_other_detail VARCHAR2(255);
3084: l_effective_dt DATE;

Line 3081: l_current_acad_cal_type igs_ca_inst.cal_type%TYPE;

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;
3083: l_other_detail VARCHAR2(255);
3084: l_effective_dt DATE;
3085: --

Line 3082: l_current_acad_sequence_number igs_ca_inst.sequence_number%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;
3083: l_other_detail VARCHAR2(255);
3084: l_effective_dt DATE;
3085: --
3086: -- Cursor to fetch student course attempt calendar type

Line 3104: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,

3100: WHERE secc.s_control_num = 1;
3101: --
3102: -- Cursor to fetch calendar instances
3103: --
3104: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
3105: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
3106: SELECT ci.cal_type,
3107: ci.sequence_number
3108: FROM igs_ca_inst ci,

Line 3105: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS

3101: --
3102: -- Cursor to fetch calendar instances
3103: --
3104: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
3105: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
3106: SELECT ci.cal_type,
3107: ci.sequence_number
3108: FROM igs_ca_inst ci,
3109: igs_ca_stat cs

Line 3108: FROM igs_ca_inst ci,

3104: CURSOR c_cal_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
3105: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
3106: SELECT ci.cal_type,
3107: ci.sequence_number
3108: FROM igs_ca_inst ci,
3109: igs_ca_stat cs
3110: WHERE ci.cal_type = cp_cal_type
3111: AND ci.start_dt <= cp_effective_dt
3112: AND ci.end_dt >= cp_effective_dt

Line 3119: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,

3115: ORDER BY ci.start_dt DESC;
3116: --
3117: -- Cursor to fetch calendar type instances
3118: --
3119: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
3120: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3121: SELECT ci.cal_type,
3122: ci.sequence_number,
3123: ci.start_dt,

Line 3120: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

3116: --
3117: -- Cursor to fetch calendar type instances
3118: --
3119: CURSOR c_cal_type_instance (cp_cal_type igs_ca_inst.cal_type%TYPE,
3120: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3121: SELECT ci.cal_type,
3122: ci.sequence_number,
3123: ci.start_dt,
3124: ci.end_dt

Line 3126: igs_ca_inst ci,

3122: ci.sequence_number,
3123: ci.start_dt,
3124: ci.end_dt
3125: FROM igs_ca_type ct,
3126: igs_ca_inst ci,
3127: igs_ca_stat cs,
3128: igs_ca_inst_rel cir
3129: WHERE ct.closed_ind = 'N'
3130: AND cs.s_cal_status = cst_active

Line 3128: igs_ca_inst_rel cir

3124: ci.end_dt
3125: FROM igs_ca_type ct,
3126: igs_ca_inst ci,
3127: igs_ca_stat cs,
3128: igs_ca_inst_rel cir
3129: WHERE ct.closed_ind = 'N'
3130: AND cs.s_cal_status = cst_active
3131: AND ci.cal_status = cs.cal_status
3132: AND ct.s_cal_cat = cst_load

Line 3138: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,

3134: AND cir.sub_cal_type = ci.cal_type
3135: AND cir.sub_ci_sequence_number =ci.sequence_number
3136: AND cir.sup_cal_type = cp_cal_type
3137: AND cir.sup_ci_sequence_number = cp_sequence_number
3138: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
3139: igs_ca_type ct
3140: WHERE cir.sup_cal_type = cp_cal_type
3141: AND cir.sup_ci_sequence_number = cp_sequence_number
3142: AND cir.sub_cal_type = ci.cal_type