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

Line 634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

630: FOR UPDATE OF RQRMNTS_COMPLETE_IND ,
631: RQRMNTS_COMPLETE_DT , student_confirmed_ind NOWAIT;
632: c_susa_upd_rec c_susa_upd%ROWTYPE ;
633:
634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
637: igs_ca_inst ci,
638: igs_ca_type cal

Line 635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

631: RQRMNTS_COMPLETE_DT , student_confirmed_ind NOWAIT;
632: c_susa_upd_rec c_susa_upd%ROWTYPE ;
633:
634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
637: igs_ca_inst ci,
638: igs_ca_type cal
639: WHERE rel.sup_cal_type = p_acad_cal_type

Line 636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,

632: c_susa_upd_rec c_susa_upd%ROWTYPE ;
633:
634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
637: igs_ca_inst ci,
638: igs_ca_type cal
639: WHERE rel.sup_cal_type = p_acad_cal_type
640: AND rel.sup_ci_sequence_number = p_acad_seq_num

Line 637: igs_ca_inst ci,

633:
634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
637: igs_ca_inst ci,
638: igs_ca_type cal
639: WHERE rel.sup_cal_type = p_acad_cal_type
640: AND rel.sup_ci_sequence_number = p_acad_seq_num
641: AND rel.sub_cal_type = ci.cal_type

Line 654: l_load_cal_type igs_ca_inst.cal_type%TYPE;

650: FROM IGS_EN_STDNT_PS_ATT spa
651: WHERE spa.person_id = p_person_id AND
652: spa.course_cd = p_course_cd;
653:
654: l_load_cal_type igs_ca_inst.cal_type%TYPE;
655: l_load_seq_num igs_ca_inst.sequence_number%TYPE;
656: l_enr_method igs_en_method_type.enr_method_type%TYPE;
657: l_return_status VARCHAR2(20);
658: l_dummy_mesg VARCHAR2(100);

Line 655: l_load_seq_num igs_ca_inst.sequence_number%TYPE;

651: WHERE spa.person_id = p_person_id AND
652: spa.course_cd = p_course_cd;
653:
654: l_load_cal_type igs_ca_inst.cal_type%TYPE;
655: l_load_seq_num igs_ca_inst.sequence_number%TYPE;
656: l_enr_method igs_en_method_type.enr_method_type%TYPE;
657: l_return_status VARCHAR2(20);
658: l_dummy_mesg VARCHAR2(100);
659: FUNCTION prenrl_year (cp_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE)

Line 1104: CURSOR cur_catalog_details(p_commencement_date DATE,p_cal_type igs_ca_inst.cal_type%type) IS

1100:
1101: l_message_name VARCHAR2(2000) ;
1102: l_status NUMBER;
1103: -- cursor to fetch catalog details
1104: CURSOR cur_catalog_details(p_commencement_date DATE,p_cal_type igs_ca_inst.cal_type%type) IS
1105: SELECT ci.cal_type catalog_cal_type,
1106: ci.sequence_number catalog_seq_num
1107: FROM igs_ca_inst ci,
1108: igs_ca_type ct,

Line 1107: FROM igs_ca_inst ci,

1103: -- cursor to fetch catalog details
1104: CURSOR cur_catalog_details(p_commencement_date DATE,p_cal_type igs_ca_inst.cal_type%type) IS
1105: SELECT ci.cal_type catalog_cal_type,
1106: ci.sequence_number catalog_seq_num
1107: FROM igs_ca_inst ci,
1108: igs_ca_type ct,
1109: igs_ca_stat cs,
1110: igs_ca_inst_rel cir
1111: WHERE ci.cal_type = ct.cal_type

Line 1110: igs_ca_inst_rel cir

1106: ci.sequence_number catalog_seq_num
1107: FROM igs_ca_inst ci,
1108: igs_ca_type ct,
1109: igs_ca_stat cs,
1110: igs_ca_inst_rel cir
1111: WHERE ci.cal_type = ct.cal_type
1112: AND ct.s_cal_cat = 'LOAD'
1113: AND cs.cal_status = ci.cal_status
1114: AND cs.s_cal_status = 'ACTIVE'

Line 1121: catalog_cal_type igs_ca_inst.cal_type%TYPE;

1117: AND ci.sequence_number=cir.sub_ci_sequence_number
1118: AND cir.sup_cal_type=p_cal_type
1119: ORDER BY ci.end_dt desc;
1120:
1121: catalog_cal_type igs_ca_inst.cal_type%TYPE;
1122: catalog_seq_num igs_ca_inst.sequence_number%TYPE;
1123: BEGIN
1124: p_warn_level := NULL;
1125: p_message_name := null;

Line 1122: catalog_seq_num igs_ca_inst.sequence_number%TYPE;

1118: AND cir.sup_cal_type=p_cal_type
1119: ORDER BY ci.end_dt desc;
1120:
1121: catalog_cal_type igs_ca_inst.cal_type%TYPE;
1122: catalog_seq_num igs_ca_inst.sequence_number%TYPE;
1123: BEGIN
1124: p_warn_level := NULL;
1125: p_message_name := null;
1126: -- Determine research provisional indicator

Line 1947: v_enr_cal_type IGS_CA_INST.cal_type%TYPE;

1943:
1944: v_scae_upd_rec c_scae_upd%ROWTYPE;
1945:
1946: -- output variables
1947: v_enr_cal_type IGS_CA_INST.cal_type%TYPE;
1948: v_enr_sequence_number IGS_CA_INST.sequence_number%TYPE;
1949: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
1950: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
1951: BEGIN

Line 1948: v_enr_sequence_number IGS_CA_INST.sequence_number%TYPE;

1944: v_scae_upd_rec c_scae_upd%ROWTYPE;
1945:
1946: -- output variables
1947: v_enr_cal_type IGS_CA_INST.cal_type%TYPE;
1948: v_enr_sequence_number IGS_CA_INST.sequence_number%TYPE;
1949: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
1950: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
1951: BEGIN
1952: p_warn_level := NULL;

Line 2726: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

2722: SELECT am.GOVT_ATTENDANCE_MODE
2723: FROM IGS_EN_ATD_MODE am
2724: WHERE am.attendance_mode = cp_attendance_mode;
2725: CURSOR c_cir (
2726: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
2727: SELECT ci.sequence_number
2728: FROM IGS_CA_INST_REL cir,
2729: IGS_CA_INST ci,
2730: IGS_CA_TYPE cat,

Line 2728: FROM IGS_CA_INST_REL cir,

2724: WHERE am.attendance_mode = cp_attendance_mode;
2725: CURSOR c_cir (
2726: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
2727: SELECT ci.sequence_number
2728: FROM IGS_CA_INST_REL cir,
2729: IGS_CA_INST ci,
2730: IGS_CA_TYPE cat,
2731: IGS_CA_STAT cs
2732: WHERE cir.sup_cal_type = p_acad_cal_type AND

Line 2729: IGS_CA_INST ci,

2725: CURSOR c_cir (
2726: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
2727: SELECT ci.sequence_number
2728: FROM IGS_CA_INST_REL cir,
2729: IGS_CA_INST ci,
2730: IGS_CA_TYPE cat,
2731: IGS_CA_STAT cs
2732: WHERE cir.sup_cal_type = p_acad_cal_type AND
2733: cir.sup_ci_sequence_number = p_acad_sequence_number AND

Line 4124: IGS_CA_INST ci

4120:
4121: CURSOR c_prev_enr_cat IS
4122: SELECT scae.enrolment_cat
4123: FROM IGS_AS_SC_ATMPT_ENR scae,
4124: IGS_CA_INST ci
4125: WHERE scae.person_id = p_person_id AND
4126: scae.course_cd = p_course_cd AND
4127: ci.cal_type = scae.cal_type AND
4128: ci.sequence_number = scae.ci_sequence_number

Line 4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

4319: IGS_EN_GEN_015.get_effective_census_date(Null,Null,sua.cal_type,sua.ci_sequence_number) < TRUNC(SYSDATE);
4320: c_census_dt_rec c_chk_census_dt%ROWTYPE ;
4321: v_dummy VARCHAR2(1);
4322:
4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
4326: igs_ca_inst ci,
4327: igs_ca_type cal

Line 4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

4320: c_census_dt_rec c_chk_census_dt%ROWTYPE ;
4321: v_dummy VARCHAR2(1);
4322:
4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
4326: igs_ca_inst ci,
4327: igs_ca_type cal
4328: WHERE rel.sup_cal_type = p_acad_cal_type

Line 4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,

4321: v_dummy VARCHAR2(1);
4322:
4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
4326: igs_ca_inst ci,
4327: igs_ca_type cal
4328: WHERE rel.sup_cal_type = p_acad_cal_type
4329: AND rel.sup_ci_sequence_number = p_acad_seq_num

Line 4326: igs_ca_inst ci,

4322:
4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
4326: igs_ca_inst ci,
4327: igs_ca_type cal
4328: WHERE rel.sup_cal_type = p_acad_cal_type
4329: AND rel.sup_ci_sequence_number = p_acad_seq_num
4330: AND rel.sub_cal_type = ci.cal_type

Line 4336: l_load_cal_type igs_ca_inst.cal_type%TYPE;

4332: AND rel.sub_cal_type = cal.cal_type
4333: AND cal.s_cal_cat = 'LOAD'
4334: AND cal.closed_ind = 'N'
4335: ORDER BY ci.start_dt;
4336: l_load_cal_type igs_ca_inst.cal_type%TYPE;
4337: l_load_seq_num igs_ca_inst.sequence_number%TYPE;
4338: l_enr_method igs_en_method_type.enr_method_type%TYPE;
4339: l_return_status VARCHAR2(20);
4340: l_dummy_mesg VARCHAR2(100);

Line 4337: l_load_seq_num igs_ca_inst.sequence_number%TYPE;

4333: AND cal.s_cal_cat = 'LOAD'
4334: AND cal.closed_ind = 'N'
4335: ORDER BY ci.start_dt;
4336: l_load_cal_type igs_ca_inst.cal_type%TYPE;
4337: l_load_seq_num igs_ca_inst.sequence_number%TYPE;
4338: l_enr_method igs_en_method_type.enr_method_type%TYPE;
4339: l_return_status VARCHAR2(20);
4340: l_dummy_mesg VARCHAR2(100);
4341:

Line 4373: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

4369: SELECT am.GOVT_ATTENDANCE_MODE
4370: FROM IGS_EN_ATD_MODE am
4371: WHERE am.attendance_mode = cp_attendance_mode;
4372: CURSOR c_cir (
4373: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
4374: SELECT ci.sequence_number
4375: FROM IGS_CA_INST_REL cir,
4376: IGS_CA_INST ci,
4377: IGS_CA_TYPE cat,

Line 4375: FROM IGS_CA_INST_REL cir,

4371: WHERE am.attendance_mode = cp_attendance_mode;
4372: CURSOR c_cir (
4373: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
4374: SELECT ci.sequence_number
4375: FROM IGS_CA_INST_REL cir,
4376: IGS_CA_INST ci,
4377: IGS_CA_TYPE cat,
4378: IGS_CA_STAT cs
4379: WHERE cir.sup_cal_type = p_acad_cal_type AND

Line 4376: IGS_CA_INST ci,

4372: CURSOR c_cir (
4373: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
4374: SELECT ci.sequence_number
4375: FROM IGS_CA_INST_REL cir,
4376: IGS_CA_INST ci,
4377: IGS_CA_TYPE cat,
4378: IGS_CA_STAT cs
4379: WHERE cir.sup_cal_type = p_acad_cal_type AND
4380: cir.sup_ci_sequence_number = p_acad_sequence_number AND

Line 6001: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,

5997:
5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5999: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6000: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
6001: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
6002: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)
6003:
6004: RETURN BOOLEAN AS
6005: -------------------------------------------------------------------------------------------

Line 6002: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)

5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5999: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6000: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
6001: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
6002: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)
6003:
6004: RETURN BOOLEAN AS
6005: -------------------------------------------------------------------------------------------
6006: --Change History:

Line 6017: CURSOR c_get_term_start_dt(cp_term_cal_type igs_ca_inst.cal_type%TYPE,

6013: FROM igs_en_stdnt_ps_att
6014: WHERE person_id = p_person_id AND
6015: course_cd = p_dest_course_cd ;
6016: -- Cursor to get the term calendar start date for a given term calendar instance.
6017: CURSOR c_get_term_start_dt(cp_term_cal_type igs_ca_inst.cal_type%TYPE,
6018: cp_term_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6019: IS
6020: SELECT start_dt
6021: FROM igs_ca_inst

Line 6018: cp_term_ci_seq_num igs_ca_inst.sequence_number%TYPE)

6014: WHERE person_id = p_person_id AND
6015: course_cd = p_dest_course_cd ;
6016: -- Cursor to get the term calendar start date for a given term calendar instance.
6017: CURSOR c_get_term_start_dt(cp_term_cal_type igs_ca_inst.cal_type%TYPE,
6018: cp_term_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6019: IS
6020: SELECT start_dt
6021: FROM igs_ca_inst
6022: WHERE cal_type = cp_term_cal_type

Line 6021: FROM igs_ca_inst

6017: CURSOR c_get_term_start_dt(cp_term_cal_type igs_ca_inst.cal_type%TYPE,
6018: cp_term_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6019: IS
6020: SELECT start_dt
6021: FROM igs_ca_inst
6022: WHERE cal_type = cp_term_cal_type
6023: AND sequence_number = cp_term_ci_seq_num;
6024:
6025: -- Cursor to get the Term Calendar of the Unit.

Line 6027: cp_load_cal_type igs_ca_inst.cal_type%TYPE,

6023: AND sequence_number = cp_term_ci_seq_num;
6024:
6025: -- Cursor to get the Term Calendar of the Unit.
6026: CURSOR c_get_term_cal(cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,
6027: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
6028: cp_load_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6029: IS
6030: SELECT 'X'
6031: FROM igs_ps_unit_ofr_opt uoo,

Line 6028: cp_load_ci_seq_num igs_ca_inst.sequence_number%TYPE)

6024:
6025: -- Cursor to get the Term Calendar of the Unit.
6026: CURSOR c_get_term_cal(cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,
6027: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
6028: cp_load_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6029: IS
6030: SELECT 'X'
6031: FROM igs_ps_unit_ofr_opt uoo,
6032: igs_ca_teach_to_load_v tl

Line 6041: CURSOR cur_get_term_next(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,

6037: AND uoo.uoo_id = cp_uoo_id;
6038:
6039: -- Cursor to get term calendars closest to the current term calendar and having
6040: -- a start date greater than the current term calendar.
6041: CURSOR cur_get_term_next(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
6042: cp_curr_term_start_dt igs_ca_inst.start_dt%TYPE)
6043: IS
6044: SELECT cir.sub_cal_type term_cal_type,
6045: cir.sub_ci_sequence_number term_sequence_number

Line 6042: cp_curr_term_start_dt igs_ca_inst.start_dt%TYPE)

6038:
6039: -- Cursor to get term calendars closest to the current term calendar and having
6040: -- a start date greater than the current term calendar.
6041: CURSOR cur_get_term_next(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
6042: cp_curr_term_start_dt igs_ca_inst.start_dt%TYPE)
6043: IS
6044: SELECT cir.sub_cal_type term_cal_type,
6045: cir.sub_ci_sequence_number term_sequence_number
6046: FROM igs_ca_inst_rel cir,

Line 6046: FROM igs_ca_inst_rel cir,

6042: cp_curr_term_start_dt igs_ca_inst.start_dt%TYPE)
6043: IS
6044: SELECT cir.sub_cal_type term_cal_type,
6045: cir.sub_ci_sequence_number term_sequence_number
6046: FROM igs_ca_inst_rel cir,
6047: igs_ca_inst ci,
6048: igs_ca_type ct,
6049: igs_ca_stat cs
6050: WHERE cir.sup_cal_type = cp_acad_cal_type

Line 6047: igs_ca_inst ci,

6043: IS
6044: SELECT cir.sub_cal_type term_cal_type,
6045: cir.sub_ci_sequence_number term_sequence_number
6046: FROM igs_ca_inst_rel cir,
6047: igs_ca_inst ci,
6048: igs_ca_type ct,
6049: igs_ca_stat cs
6050: WHERE cir.sup_cal_type = cp_acad_cal_type
6051: AND ct.cal_type = cir.sub_cal_type

Line 6062: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;

6058: ORDER BY ci.start_dt ASC;
6059:
6060: l_acad_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
6061: l_effect_or_future_term BOOLEAN;
6062: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
6063: l_dummy VARCHAR2(1);
6064:
6065: BEGIN
6066:

Line 8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,

8894:
8895: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
8896:
8897: CURSOR c_load(cp_date IGS_EN_SU_ATTEMPT.DISCONTINUED_DT%TYPE,
8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,
8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8900: cp_teach_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8901: SELECT load_cal_type, load_ci_sequence_number, load_start_dt
8902: FROM IGS_CA_TEACH_TO_LOAD_V

Line 8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

8895: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
8896:
8897: CURSOR c_load(cp_date IGS_EN_SU_ATTEMPT.DISCONTINUED_DT%TYPE,
8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,
8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8900: cp_teach_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8901: SELECT load_cal_type, load_ci_sequence_number, load_start_dt
8902: FROM IGS_CA_TEACH_TO_LOAD_V
8903: WHERE cp_date between load_start_dt and load_end_dt

Line 8900: cp_teach_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

8896:
8897: CURSOR c_load(cp_date IGS_EN_SU_ATTEMPT.DISCONTINUED_DT%TYPE,
8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,
8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8900: cp_teach_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8901: SELECT load_cal_type, load_ci_sequence_number, load_start_dt
8902: FROM IGS_CA_TEACH_TO_LOAD_V
8903: WHERE cp_date between load_start_dt and load_end_dt
8904: AND load_start_dt >= cp_load_start_dt

Line 8912: CURSOR c_eff_term_start_dt (cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

8908:
8909: v_load_rec c_load%ROWTYPE;
8910: v_load_found BOOLEAN;
8911:
8912: CURSOR c_eff_term_start_dt (cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8913: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8914: SELECT start_dt
8915: FROM IGS_CA_INST
8916: WHERE cal_type = cp_cal_type

Line 8913: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

8909: v_load_rec c_load%ROWTYPE;
8910: v_load_found BOOLEAN;
8911:
8912: CURSOR c_eff_term_start_dt (cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8913: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8914: SELECT start_dt
8915: FROM IGS_CA_INST
8916: WHERE cal_type = cp_cal_type
8917: AND sequence_number = cp_sequence_number;

Line 8915: FROM IGS_CA_INST

8911:
8912: CURSOR c_eff_term_start_dt (cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8913: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8914: SELECT start_dt
8915: FROM IGS_CA_INST
8916: WHERE cal_type = cp_cal_type
8917: AND sequence_number = cp_sequence_number;
8918:
8919: v_eff_term_start_dt IGS_CA_INST.START_DT%TYPE;

Line 8919: v_eff_term_start_dt IGS_CA_INST.START_DT%TYPE;

8915: FROM IGS_CA_INST
8916: WHERE cal_type = cp_cal_type
8917: AND sequence_number = cp_sequence_number;
8918:
8919: v_eff_term_start_dt IGS_CA_INST.START_DT%TYPE;
8920:
8921: BEGIN
8922:
8923: OPEN c_teach_to_load(p_person_id, p_source_course_cd, p_uoo_id);

Line 9014: IGS_CA_INST ci

9010: usec.CI_SEQUENCE_NUMBER,
9011: CI.START_DT,
9012: CI.END_DT
9013: FROM IGS_PS_UNIT_OFR_OPT usec,
9014: IGS_CA_INST ci
9015: WHERE usec.UOO_ID = cp_uoo_id
9016: and ci.cal_type = usec.cal_type
9017: and ci.sequence_number = usec.ci_sequence_number;
9018: