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_CA_INST

Line 1156: p_term_cal_type IGS_CA_INST.cal_type%TYPE,

1152: END del_ps_intm;
1153:
1154: PROCEDURE del_ps_trnsf(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1155: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1156: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1157: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)
1158: IS
1159:
1160: CURSOR c_del_ps_trnsf IS

Line 1157: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)

1153:
1154: PROCEDURE del_ps_trnsf(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1155: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1156: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1157: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)
1158: IS
1159:
1160: CURSOR c_del_ps_trnsf IS
1161: SELECT rowid

Line 1325: p_term_cal_type IGS_CA_INST.cal_type%TYPE,

1321:
1322: FUNCTION del_sua(
1323: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1324: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1325: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1326: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE
1327: )
1328: RETURN BOOLEAN
1329: IS

Line 1326: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE

1322: FUNCTION del_sua(
1323: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1324: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1325: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1326: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE
1327: )
1328: RETURN BOOLEAN
1329: IS
1330: BEGIN -- del_sua

Line 1403: p_term_cal_type IGS_CA_INST.cal_type%TYPE,

1399:
1400: PROCEDURE upd_sua(
1401: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1402: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1403: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1404: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)
1405: IS
1406: BEGIN -- upd_sua
1407: -- (1) Update IGS_EN_SU_ATTEMPT records

Line 1404: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)

1400: PROCEDURE upd_sua(
1401: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1402: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1403: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1404: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)
1405: IS
1406: BEGIN -- upd_sua
1407: -- (1) Update IGS_EN_SU_ATTEMPT records
1408: DECLARE

Line 1712: p_term_cal_type IGS_CA_INST.cal_type%TYPE,

1708: ------------------------------------------------------------------------------*/
1709:
1710: PROCEDURE cleanup_dest_program(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1711: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1712: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1713: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
1714: p_mode VARCHAR2)
1715:
1716: IS

Line 1713: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE,

1709:
1710: PROCEDURE cleanup_dest_program(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1711: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1712: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1713: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
1714: p_mode VARCHAR2)
1715:
1716: IS
1717: Type term_rec IS RECORD

Line 1724: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.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,
1726: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1727: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1728: SELECT rowid,sct.*

Line 1725: cp_term_sequence_number IGS_CA_INST.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,
1726: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1727: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1728: SELECT rowid,sct.*
1729: FROM IGS_PS_STDNT_TRN sct

Line 1766: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

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
1770: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2

Line 1767: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

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
1770: FROM IGS_EN_SPA_TERMS spat, IGS_CA_INST ci1, IGS_CA_INST ci2
1771: WHERE spat.person_id = cp_person_id

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 1783: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

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
1787: WHERE spat.person_id = cp_person_id

Line 1784: cp_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

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
1787: WHERE spat.person_id = cp_person_id
1788: AND spat.program_cd = cp_program_cd

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 1796: CURSOR c_term_acad_rel(cp_acad IGS_CA_INST.CAL_TYPE%TYPE, cp_term IGS_CA_INST.CAL_TYPE%TYPE,

1792: AND ci1.sequence_number = cp_sequence_number
1793: AND ci1.start_dt > ci2.start_dt
1794: ORDER BY ci2.start_dt DESC;
1795:
1796: CURSOR c_term_acad_rel(cp_acad IGS_CA_INST.CAL_TYPE%TYPE, cp_term IGS_CA_INST.CAL_TYPE%TYPE,
1797: cp_term_seq IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1798: SELECT 'x'
1799: FROM igs_ca_inst_rel
1800: WHERE sup_cal_type = cp_acad

Line 1797: cp_term_seq IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

1793: AND ci1.start_dt > ci2.start_dt
1794: ORDER BY ci2.start_dt DESC;
1795:
1796: CURSOR c_term_acad_rel(cp_acad IGS_CA_INST.CAL_TYPE%TYPE, cp_term IGS_CA_INST.CAL_TYPE%TYPE,
1797: cp_term_seq IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1798: SELECT 'x'
1799: FROM igs_ca_inst_rel
1800: WHERE sup_cal_type = cp_acad
1801: AND sub_cal_type = cp_term

Line 1799: FROM igs_ca_inst_rel

1795:
1796: CURSOR c_term_acad_rel(cp_acad IGS_CA_INST.CAL_TYPE%TYPE, cp_term IGS_CA_INST.CAL_TYPE%TYPE,
1797: cp_term_seq IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1798: SELECT 'x'
1799: FROM igs_ca_inst_rel
1800: WHERE sup_cal_type = cp_acad
1801: AND sub_cal_type = cp_term
1802: AND sub_ci_sequence_number = cp_term_seq;
1803:

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 2269: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,

2265: )
2266: IS
2267:
2268: -- Cursor to fetch the records to process
2269: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2270: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2271: SELECT sct.*
2272: FROM IGS_PS_STDNT_TRN sct
2273: WHERE effective_term_cal_type = cp_term_cal_type

Line 2270: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

2266: IS
2267:
2268: -- Cursor to fetch the records to process
2269: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2270: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2271: SELECT sct.*
2272: FROM IGS_PS_STDNT_TRN sct
2273: WHERE effective_term_cal_type = cp_term_cal_type
2274: AND effective_term_sequence_num = cp_term_sequence_number

Line 2293: CURSOR c_cln_up_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,

2289: FROM IGS_EN_CAL_CONF
2290: WHERE s_control_num = 1;
2291:
2292: -- cursor to get the clean up date alias value
2293: CURSOR c_cln_up_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2294: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2295: cp_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE ) IS
2296: SELECT alias_val
2297: FROM igs_ca_da_inst_v

Line 2294: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,

2290: WHERE s_control_num = 1;
2291:
2292: -- cursor to get the clean up date alias value
2293: CURSOR c_cln_up_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2294: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2295: cp_cleanup_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE ) IS
2296: SELECT alias_val
2297: FROM igs_ca_da_inst_v
2298: WHERE cal_type = cp_term_cal_type

Line 2303: CURSOR c_begin_pt_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,

2299: AND ci_sequence_number = cp_term_sequence_number
2300: AND dt_alias = cp_cleanup_dt_alias;
2301:
2302: -- cursor to get the begin program transfer details
2303: CURSOR c_begin_pt_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2304: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2305: cp_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
2306: SELECT alias_val
2307: FROM igs_ca_da_inst_v

Line 2304: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,

2300: AND dt_alias = cp_cleanup_dt_alias;
2301:
2302: -- cursor to get the begin program transfer details
2303: CURSOR c_begin_pt_dt_alias_val(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2304: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2305: cp_begin_pt_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
2306: SELECT alias_val
2307: FROM igs_ca_da_inst_v
2308: WHERE cal_type = cp_term_cal_type

Line 2319: CURSOR c_load_cal_end_dt(cp_term_cal IGS_CA_INST.cal_type%TYPE,

2315: FROM HZ_PARTIES
2316: WHERE party_id = cp_person_id;
2317:
2318: -- cursor to get the load calendar end date
2319: CURSOR c_load_cal_end_dt(cp_term_cal IGS_CA_INST.cal_type%TYPE,
2320: cp_term_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2321: SELECT end_dt
2322: FROM igs_ca_inst
2323: WHERE cal_type = cp_term_cal

Line 2320: cp_term_seq_num IGS_CA_INST.sequence_number%TYPE) IS

2316: WHERE party_id = cp_person_id;
2317:
2318: -- cursor to get the load calendar end date
2319: CURSOR c_load_cal_end_dt(cp_term_cal IGS_CA_INST.cal_type%TYPE,
2320: cp_term_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2321: SELECT end_dt
2322: FROM igs_ca_inst
2323: WHERE cal_type = cp_term_cal
2324: AND sequence_number = cp_term_seq_num;

Line 2322: FROM igs_ca_inst

2318: -- cursor to get the load calendar end date
2319: CURSOR c_load_cal_end_dt(cp_term_cal IGS_CA_INST.cal_type%TYPE,
2320: cp_term_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2321: SELECT end_dt
2322: FROM igs_ca_inst
2323: WHERE cal_type = cp_term_cal
2324: AND sequence_number = cp_term_seq_num;
2325:
2326:

Line 2331: cp_cur_term_cal IGS_CA_INST.cal_type%TYPE,

2327: -- Cursor to know if the destination program is primary in any of the prev terms
2328: -- whose start date is greater than transfer date
2329: CURSOR c_prim_in_prev_terms(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2330: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2331: cp_cur_term_cal IGS_CA_INST.cal_type%TYPE,
2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,
2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'

Line 2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,

2328: -- whose start date is greater than transfer date
2329: CURSOR c_prim_in_prev_terms(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2330: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2331: cp_cur_term_cal IGS_CA_INST.cal_type%TYPE,
2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,
2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,

Line 2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

2329: CURSOR c_prim_in_prev_terms(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2330: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2331: cp_cur_term_cal IGS_CA_INST.cal_type%TYPE,
2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,
2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,

Line 2336: FROM igs_ca_inst ci2,

2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,
2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,
2338: igs_ca_type ct,
2339: igs_ca_inst ci1,
2340: igs_ca_stat cs

Line 2337: igs_ca_inst_rel cir,

2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,
2338: igs_ca_type ct,
2339: igs_ca_inst ci1,
2340: igs_ca_stat cs
2341: WHERE

Line 2339: igs_ca_inst ci1,

2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,
2338: igs_ca_type ct,
2339: igs_ca_inst ci1,
2340: igs_ca_stat cs
2341: WHERE
2342: ci2.cal_type = cir.sub_cal_type AND
2343: ci2.sequence_number = cir.sub_ci_sequence_number AND

Line 2378: CURSOR c_sct(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,

2374: AND sua.uoo_id = sua2.uoo_id)
2375: AND unit_Attempt_status not in ('DROPPED','UNCONFIRM');
2376:
2377:
2378: CURSOR c_sct(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2379: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2380: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2381: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE
2382: ) IS

Line 2379: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,

2375: AND unit_Attempt_status not in ('DROPPED','UNCONFIRM');
2376:
2377:
2378: CURSOR c_sct(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2379: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
2380: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2381: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE
2382: ) IS
2383: SELECT 'X'

Line 2405: l_end_dt IGS_CA_INST.end_dt%TYPE;

2401: v_sca_src_rec c_sca%ROWTYPE;
2402: v_sca_dest_rec c_sca%ROWTYPE;
2403: l_term_cal_type IGS_CA_DA_INST.cal_type%TYPE;
2404: l_term_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
2405: l_end_dt IGS_CA_INST.end_dt%TYPE;
2406: v_del BOOLEAN;
2407: v_person_num HZ_PARTIES.party_number%TYPE;
2408: l_acad_cal_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
2409: l_acad_cal_type IGS_CA_DA_INST.cal_type%TYPE;