APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_PS_UNIT_OFR_OPT

Line 1103: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo

1099: l_unchk_units_in_src VARCHAR2(2000);
1100:
1101: CURSOR c_get_all_src_units IS
1102: SELECT sua.unit_cd,sua.uoo_id, uoo.sup_uoo_id
1103: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo
1104: WHERE person_id = p_person_id AND
1105: course_cd = p_source_program_cd AND
1106: uoo.uoo_id = sua.uoo_id AND
1107: uoo.sup_uoo_id IS NOT NULL AND

Line 2055: FROM IGS_PS_UNIT_OFR_OPT

2051: -------------------------------------------------------------------------------------------
2052:
2053: CURSOR c_get_unit_dtls(cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
2054: SELECT cal_type,ci_sequence_number
2055: FROM IGS_PS_UNIT_OFR_OPT
2056: WHERE uoo_id = cp_uoo_id;
2057:
2058: CURSOR c_get_earliest_load_cal_dtls(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.TEACH_CAL_TYPE%TYPE,
2059: cp_teach_cal_seq_no IGS_CA_TEACH_TO_LOAD_V.TEACH_CI_SEQUENCE_NUMBER%TYPE) IS

Line 2082: l_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;

2078: l_pre_cindex NUMBER;
2079: l_nth_occurence NUMBER;
2080: l_uooid NUMBER;
2081: l_uooids_str VARCHAR2(1000);
2082: l_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;
2083: l_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;
2084: l_load_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
2085: l_load_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
2086:

Line 2083: l_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;

2079: l_nth_occurence NUMBER;
2080: l_uooid NUMBER;
2081: l_uooids_str VARCHAR2(1000);
2082: l_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;
2083: l_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;
2084: l_load_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
2085: l_load_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
2086:
2087: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;