APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_PS_VER

Line 52: FROM IGS_PS_VER

48: -------------------------------------------------------------------------------------------
49:
50: CURSOR c_get_career_type(c_program_cd VARCHAR2,c_program_ver NUMBER) IS
51: SELECT course_type
52: FROM IGS_PS_VER
53: WHERE course_cd = c_program_cd AND
54: version_number = c_program_ver;
55: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
56: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;

Line 55: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;

51: SELECT course_type
52: FROM IGS_PS_VER
53: WHERE course_cd = c_program_cd AND
54: version_number = c_program_ver;
55: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
56: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
57:
58: BEGIN
59:

Line 56: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;

52: FROM IGS_PS_VER
53: WHERE course_cd = c_program_cd AND
54: version_number = c_program_ver;
55: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
56: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
57:
58: BEGIN
59:
60: OPEN c_get_career_type(p_src_program_cd,p_src_progam_ver);

Line 1806: CURSOR c_src_eff_term(cp_src_course_cd IGS_PS_VER.COURSE_CD%TYPE) IS

1802: AND sub_ci_sequence_number = cp_term_seq;
1803:
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

Line 1830: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;

1826: v_spa_del_rec c_spa_clnup%ROWTYPE;
1827: v_rec_exists VARCHAR2(1);
1828: v_message_name VARCHAR2(30);
1829: v_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1830: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
1831: l_status_date IGS_PS_STDNT_TRN.status_date%TYPE;
1832: l_trans_status IGS_PS_STDNT_TRN.status_flag%TYPE;
1833: l_tran_across_careers BOOLEAN;
1834: l_trans_within_careers BOOLEAN;

Line 1838: v_src_career_type igs_ps_ver.course_type%TYPE;

1834: l_trans_within_careers BOOLEAN;
1835: l_stdnt_conf_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
1836: l_comm_date IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
1837: l_course_att_status IGS_EN_STDNT_PS_ATT.COURSE_ATTEMPT_STATUS%TYPE;
1838: v_src_career_type igs_ps_ver.course_type%TYPE;
1839: v_spat_rec c_spat_src%ROWTYPE;
1840: TYPE terms_tab IS TABLE OF term_rec INDEX BY BINARY_INTEGER;
1841: terms terms_tab;
1842: terms_ind NUMBER;

Line 2414: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;

2410: l_message_name VARCHAR2(30);
2411: l_show_warning VARCHAR2(1);
2412: l_rec_exists BOOLEAN;
2413: l_tran_across_careers BOOLEAN;
2414: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
2415: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
2416: l_msg VARCHAR2(4000);
2417: l_unit_sets_having_errors VARCHAR2(4000);
2418: l_uoo_ids_having_errors VARCHAR2(4000);