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_FUTURE_DT_TRANS dependencies on IGS_EN_SPA_TERMS

Line 1719: term_cal_type igs_en_spa_terms.term_cal_type%TYPE,

1715:
1716: IS
1717: Type term_rec IS RECORD
1718: (
1719: term_cal_type igs_en_spa_terms.term_cal_type%TYPE,
1720: term_seq_num igs_en_spa_terms.term_sequence_number%TYPE,
1721: key_program_flag igs_en_spa_terms.key_program_flag%TYPE
1722:
1723: );

Line 1720: term_seq_num igs_en_spa_terms.term_sequence_number%TYPE,

1716: IS
1717: Type term_rec IS RECORD
1718: (
1719: term_cal_type igs_en_spa_terms.term_cal_type%TYPE,
1720: term_seq_num igs_en_spa_terms.term_sequence_number%TYPE,
1721: key_program_flag igs_en_spa_terms.key_program_flag%TYPE
1722:
1723: );
1724: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,

Line 1721: key_program_flag igs_en_spa_terms.key_program_flag%TYPE

1717: Type term_rec IS RECORD
1718: (
1719: term_cal_type igs_en_spa_terms.term_cal_type%TYPE,
1720: term_seq_num igs_en_spa_terms.term_sequence_number%TYPE,
1721: key_program_flag igs_en_spa_terms.key_program_flag%TYPE
1722:
1723: );
1724: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
1725: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,

Line 1764: CURSOR c_spat (cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,

1760: AND sua.course_cd = cp_course_cd
1761: AND sua.unit_attempt_status = 'DROPPED';
1762:
1763: -- cursor to get the future term records of the destination program
1764: CURSOR c_spat (cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
1765: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,
1766: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1767: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1768: SELECT spat.rowid, spat.key_program_flag, spat.term_cal_type,

Line 1765: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,

1761: AND sua.unit_attempt_status = 'DROPPED';
1762:
1763: -- cursor to get the future term records of the destination program
1764: CURSOR c_spat (cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
1765: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,
1766: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1767: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1768: SELECT spat.rowid, spat.key_program_flag, spat.term_cal_type,
1769: spat.term_sequence_number

Line 1770: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2

1766: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1767: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1768: SELECT spat.rowid, spat.key_program_flag, spat.term_cal_type,
1769: spat.term_sequence_number
1770: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2
1771: WHERE spat.person_id = cp_person_id
1772: AND spat.program_cd = cp_program_cd
1773: AND spat.term_cal_type = ci2.cal_type
1774: AND spat.term_sequence_number = ci2.sequence_number

Line 1781: CURSOR c_spat_src (cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,

1777: AND ci1.start_dt <= ci2.start_dt
1778: ORDER BY ci2.start_dt;
1779:
1780: -- cursor to get the any past term records of the source program
1781: CURSOR c_spat_src (cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
1782: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,
1783: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1784: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1785: SELECT spat.key_program_flag

Line 1782: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,

1778: ORDER BY ci2.start_dt;
1779:
1780: -- cursor to get the any past term records of the source program
1781: CURSOR c_spat_src (cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
1782: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,
1783: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1784: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1785: SELECT spat.key_program_flag
1786: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2

Line 1786: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2

1782: cp_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE,
1783: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1784: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1785: SELECT spat.key_program_flag
1786: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2
1787: WHERE spat.person_id = cp_person_id
1788: AND spat.program_cd = cp_program_cd
1789: AND spat.term_cal_type = ci2.cal_type
1790: AND spat.term_sequence_number = ci2.sequence_number

Line 1808: FROM igs_en_spa_terms spat, igs_ca_inst ca1, igs_ca_inst ca2

1804:
1805: -- Get the details of
1806: CURSOR c_src_eff_term(cp_src_course_cd IGS_PS_VER.COURSE_CD%TYPE) IS
1807: SELECT term_cal_type, term_sequence_number
1808: FROM igs_en_spa_terms spat, igs_ca_inst ca1, igs_ca_inst ca2
1809: WHERE ca1.cal_type = p_term_cal_type
1810: AND ca1.sequence_number = p_term_sequence_number
1811: AND spat.person_id = p_person_id
1812: AND spat.program_cd = cp_src_course_cd

Line 1819: l_acad_cal IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;

1815: AND ca2.start_dt >= ca1.start_dt
1816: ORDER BY ca2.start_dt ASC;
1817:
1818:
1819: l_acad_cal IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
1820: l_dummy VARCHAR2(1);
1821: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
1822: v_del BOOLEAN;
1823: v_sca_src_rec c_sca%ROWTYPE;

Line 1844: l_key_program_flag IGS_EN_SPA_TERMS.key_program_flag%TYPE;

1840: TYPE terms_tab IS TABLE OF term_rec INDEX BY BINARY_INTEGER;
1841: terms terms_tab;
1842: terms_ind NUMBER;
1843: v_ripple BOOLEAN;
1844: l_key_program_flag IGS_EN_SPA_TERMS.key_program_flag%TYPE;
1845: l_term_cal_type IGS_EN_SPA_TERMS.TERM_CAL_TYPE%TYPE;
1846: l_term_seq_num IGS_EN_SPA_TERMS.TERM_SEQUENCE_NUMBER%TYPE;
1847: BEGIN -----------------Begining of cleanup/delete
1848:

Line 1845: l_term_cal_type IGS_EN_SPA_TERMS.TERM_CAL_TYPE%TYPE;

1841: terms terms_tab;
1842: terms_ind NUMBER;
1843: v_ripple BOOLEAN;
1844: l_key_program_flag IGS_EN_SPA_TERMS.key_program_flag%TYPE;
1845: l_term_cal_type IGS_EN_SPA_TERMS.TERM_CAL_TYPE%TYPE;
1846: l_term_seq_num IGS_EN_SPA_TERMS.TERM_SEQUENCE_NUMBER%TYPE;
1847: BEGIN -----------------Begining of cleanup/delete
1848:
1849: SAVEPOINT sp_unable_to_clnup_del;

Line 1846: l_term_seq_num IGS_EN_SPA_TERMS.TERM_SEQUENCE_NUMBER%TYPE;

1842: terms_ind NUMBER;
1843: v_ripple BOOLEAN;
1844: l_key_program_flag IGS_EN_SPA_TERMS.key_program_flag%TYPE;
1845: l_term_cal_type IGS_EN_SPA_TERMS.TERM_CAL_TYPE%TYPE;
1846: l_term_seq_num IGS_EN_SPA_TERMS.TERM_SEQUENCE_NUMBER%TYPE;
1847: BEGIN -----------------Begining of cleanup/delete
1848:
1849: SAVEPOINT sp_unable_to_clnup_del;
1850:

Line 2021: IGS_EN_SPA_TERMS_PKG.DELETE_ROW(v_spat_recd.rowid);

2017: terms(terms_ind).term_seq_num :=v_spat_recd.term_sequence_number;
2018: terms(terms_ind).key_program_flag := v_spat_recd.key_program_flag;
2019: -- Delete the term records against the destination program
2020: IF NOT l_tran_across_careers THEN
2021: IGS_EN_SPA_TERMS_PKG.DELETE_ROW(v_spat_recd.rowid);
2022: END IF;
2023: terms_ind := terms_ind + 1;
2024: END LOOP;
2025: v_ripple := TRUE;

Line 2029: l_acad_cal := igs_en_spa_terms_api.get_spat_acad_cal_type(p_person_id,

2025: v_ripple := TRUE;
2026: FOR i IN terms.FIRST.. terms.LAST LOOP
2027: -- create term records against source program
2028:
2029: l_acad_cal := igs_en_spa_terms_api.get_spat_acad_cal_type(p_person_id,
2030: v_src_course_cd,
2031: terms(i).term_cal_type,
2032: terms(i).term_seq_num);
2033: OPEN c_term_acad_rel(l_acad_cal,terms(i).term_cal_type,terms(i).term_seq_num);

Line 2048: igs_en_spa_terms_api.CREATE_UPDATE_TERM_REC(

2044:
2045: OPEN c_src_eff_term(v_src_course_cd);
2046: FETCH c_src_eff_term INTO l_term_cal_type, l_term_seq_num;
2047: IF (c_src_eff_term%FOUND) THEN
2048: igs_en_spa_terms_api.CREATE_UPDATE_TERM_REC(
2049: P_PERSON_ID => p_person_id,
2050: P_PROGRAM_CD => v_src_course_cd,
2051: P_TERM_CAL_TYPE => l_term_cal_type,
2052: P_TERM_SEQUENCE_NUMBER => l_term_seq_num,

Line 2071: igs_en_spa_terms_api.CREATE_UPDATE_TERM_REC(

2067: IF (c_term_acad_rel%FOUND)THEN
2068:
2069:
2070: -- Terms api called as key changed if source is key and with ripple forward as TRUE only for the first time in loop
2071: igs_en_spa_terms_api.CREATE_UPDATE_TERM_REC(
2072: P_PERSON_ID => p_person_id,
2073: P_PROGRAM_CD => v_src_course_cd,
2074: P_TERM_CAL_TYPE => terms(i).term_cal_type,
2075: P_TERM_SEQUENCE_NUMBER => terms(i).term_seq_num,

Line 2353: AND EXISTS (SELECT 'x' from igs_en_spa_terms spat

2349: ci1.cal_type = cp_cur_term_cal AND
2350: ci1.sequence_number = cp_cur_term_seq_num AND
2351: ci2.start_dt < ci1.start_dt AND
2352: ci2.start_dt > cp_transfer_dt
2353: AND EXISTS (SELECT 'x' from igs_en_spa_terms spat
2354: WHERE spat.person_id = cp_person_id
2355: AND spat.program_cd = cp_dest_course_cd
2356: AND spat.term_cal_type = ci2.cal_type
2357: AND spat.term_sequence_number = ci2.sequence_number)