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_STDNT_PS_ATT

Line 127: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

123: END log_err_messages;
124:
125:
126: PROCEDURE del_gua(
127: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
128: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
129: IS
130: BEGIN -- del_gua
131: -- Delete IGS_GR_GRADUAND_PKG records

Line 128: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

124:
125:
126: PROCEDURE del_gua(
127: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
128: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
129: IS
130: BEGIN -- del_gua
131: -- Delete IGS_GR_GRADUAND_PKG records
132: DECLARE

Line 281: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

277: END del_gua;
278:
279:
280: PROCEDURE del_esaa(
281: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
282: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
283: IS
284: BEGIN -- del_esaa
285: -- Delete IGS_EN_SPA_AWD_AIM records

Line 282: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

278:
279:
280: PROCEDURE del_esaa(
281: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
282: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
283: IS
284: BEGIN -- del_esaa
285: -- Delete IGS_EN_SPA_AWD_AIM records
286: DECLARE

Line 337: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

333: END;
334: END del_esaa;
335:
336: PROCEDURE del_gsa(
337: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
338: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
339: IS
340: BEGIN -- del_gsa
341: -- (1) Delete IGS_GR_SPECIAL_AWARD records

Line 338: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

334: END del_esaa;
335:
336: PROCEDURE del_gsa(
337: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
338: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
339: IS
340: BEGIN -- del_gsa
341: -- (1) Delete IGS_GR_SPECIAL_AWARD records
342: DECLARE

Line 394: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

390: END;
391: END del_gsa;
392:
393: PROCEDURE del_hssc(
394: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
395: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
396: IS
397: BEGIN -- del_hssc
398: -- Delete IGS_HE_ST_SPA_CC records

Line 395: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

391: END del_gsa;
392:
393: PROCEDURE del_hssc(
394: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
395: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
396: IS
397: BEGIN -- del_hssc
398: -- Delete IGS_HE_ST_SPA_CC records
399: DECLARE

Line 446: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

442: END;
443: END del_hssc;
444:
445: PROCEDURE del_hssa(
446: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
447: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
448: IS
449: BEGIN -- del_hssa
450: -- Delete IGS_HE_ST_SPA records

Line 447: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

443: END del_hssc;
444:
445: PROCEDURE del_hssa(
446: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
447: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
448: IS
449: BEGIN -- del_hssa
450: -- Delete IGS_HE_ST_SPA records
451: DECLARE

Line 551: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

547: END del_hssa;
548:
549: ------------------------------------------------------------------------------------------------------------
550: PROCEDURE del_pr_rule_appl(
551: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
552: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
553: IS
554: BEGIN -- del_pr_rule_appl
555: -- Delete IGS_PR_RU_APPL records

Line 552: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

548:
549: ------------------------------------------------------------------------------------------------------------
550: PROCEDURE del_pr_rule_appl(
551: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
552: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
553: IS
554: BEGIN -- del_pr_rule_appl
555: -- Delete IGS_PR_RU_APPL records
556: DECLARE

Line 609: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

605: END del_pr_rule_appl;
606:
607:
608: PROCEDURE del_psaa(
609: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
611: IS
612: BEGIN -- del_psaa
613: -- Delete IGS_PS_STDNT_APV_ALT records

Line 610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

606:
607:
608: PROCEDURE del_psaa(
609: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
611: IS
612: BEGIN -- del_psaa
613: -- Delete IGS_PS_STDNT_APV_ALT records
614: DECLARE

Line 669: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

665: END del_psaa;
666:
667:
668: PROCEDURE del_susa(
669: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
670: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
671: IS
672: BEGIN -- del_susa
673: -- (2) Delete IGS_AS_SU_SETATMPT records

Line 670: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

666:
667:
668: PROCEDURE del_susa(
669: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
670: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
671: IS
672: BEGIN -- del_susa
673: -- (2) Delete IGS_AS_SU_SETATMPT records
674: DECLARE

Line 859: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

855: END;
856: END del_susa;
857:
858: PROCEDURE del_scho(
859: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
860: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
861: IS
862: BEGIN -- del_scho
863: -- (3) Delete IGS_EN_STDNTPSHECSOP records

Line 860: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

856: END del_susa;
857:
858: PROCEDURE del_scho(
859: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
860: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
861: IS
862: BEGIN -- del_scho
863: -- (3) Delete IGS_EN_STDNTPSHECSOP records
864: DECLARE

Line 917: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

913:
914: END del_scho;
915:
916: PROCEDURE del_scae(
917: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
918: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
919: IS
920:
921: BEGIN -- del_scae

Line 918: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

914: END del_scho;
915:
916: PROCEDURE del_scae(
917: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
918: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
919: IS
920:
921: BEGIN -- del_scae
922: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae

Line 1089: PROCEDURE del_fi_fee(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1085:
1086: END del_av;
1087:
1088: -- To delete IGS_FI_FEE_AS_RT table records
1089: PROCEDURE del_fi_fee(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1090: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1091: IS
1092:
1093: CURSOR c_del_fi_fee IS

Line 1090: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1086: END del_av;
1087:
1088: -- To delete IGS_FI_FEE_AS_RT table records
1089: PROCEDURE del_fi_fee(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1090: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1091: IS
1092:
1093: CURSOR c_del_fi_fee IS
1094: SELECT rowid

Line 1123: PROCEDURE del_ps_intm(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1119: END del_fi_fee;
1120:
1121:
1122: -- To delete intermission records
1123: PROCEDURE del_ps_intm(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1124: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1125: IS
1126:
1127: CURSOR c_del_ps_intm IS

Line 1124: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1120:
1121:
1122: -- To delete intermission records
1123: PROCEDURE del_ps_intm(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1124: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1125: IS
1126:
1127: CURSOR c_del_ps_intm IS
1128: SELECT rowid

Line 1154: PROCEDURE del_ps_trnsf(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1150: END IF;
1151:
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

Line 1155: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1151:
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:

Line 1195: PROCEDURE del_pr_cohinst_rank(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1191: END del_ps_trnsf;
1192:
1193:
1194:
1195: PROCEDURE del_pr_cohinst_rank(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1196: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1197: IS
1198:
1199: CURSOR c_del_pr_cohinst_rank IS

Line 1196: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1192:
1193:
1194:
1195: PROCEDURE del_pr_cohinst_rank(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1196: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1197: IS
1198:
1199: CURSOR c_del_pr_cohinst_rank IS
1200: SELECT rowid

Line 1226: PROCEDURE del_as_anon_id_ps(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1222:
1223: END del_pr_cohinst_rank;
1224:
1225:
1226: PROCEDURE del_as_anon_id_ps(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1227: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1228: IS
1229:
1230: CURSOR c_del_as_anon_id_ps IS

Line 1227: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1223: END del_pr_cohinst_rank;
1224:
1225:
1226: PROCEDURE del_as_anon_id_ps(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1227: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1228: IS
1229:
1230: CURSOR c_del_as_anon_id_ps IS
1231: SELECT rowid

Line 1258: PROCEDURE del_suar(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1254:
1255: END del_as_anon_id_ps;
1256:
1257: -- procedure to delete all the unit attempt reference codes
1258: PROCEDURE del_suar(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1261: IS
1262:

Line 1259: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1255: END del_as_anon_id_ps;
1256:
1257: -- procedure to delete all the unit attempt reference codes
1258: PROCEDURE del_suar(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1261: IS
1262:
1263: CURSOR cur_sua_ref_cds(cp_person_id NUMBER,

Line 1290: PROCEDURE del_as_anon_id_us(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1286:
1287: END del_suar;
1288:
1289:
1290: PROCEDURE del_as_anon_id_us(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1291: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1292: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1293: IS
1294:

Line 1291: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1287: END del_suar;
1288:
1289:
1290: PROCEDURE del_as_anon_id_us(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1291: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1292: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1293: IS
1294:
1295: CURSOR c_del_as_anon_id_us IS

Line 1323: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1319: END del_as_anon_id_us;
1320:
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: )

Line 1324: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1320:
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

Line 1401: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1397: END del_sua;
1398:
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

Line 1402: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1398:
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

Line 1541: PROCEDURE del_as_stmptout(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1537:
1538: END;
1539: END upd_sua;
1540:
1541: PROCEDURE del_as_stmptout(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1542: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1543: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1544: IS
1545:

Line 1542: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1538: END;
1539: END upd_sua;
1540:
1541: PROCEDURE del_as_stmptout(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1542: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1543: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1544: IS
1545:
1546: CURSOR c_del_as_stmptout(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 1546: CURSOR c_del_as_stmptout(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1542: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1543: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1544: IS
1545:
1546: CURSOR c_del_as_stmptout(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1547: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1548: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1549: IS
1550: SELECT rowid

Line 1547: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1543: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1544: IS
1545:
1546: CURSOR c_del_as_stmptout(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1547: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1548: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1549: IS
1550: SELECT rowid
1551: FROM igs_as_su_stmptout_all stmptout

Line 1575: PROCEDURE del_ps_stdnt_unt_trn(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1571: END IF;
1572:
1573: END del_as_stmptout;
1574:
1575: PROCEDURE del_ps_stdnt_unt_trn(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1576: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1577: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1578: IS
1579:

Line 1576: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1572:
1573: END del_as_stmptout;
1574:
1575: PROCEDURE del_ps_stdnt_unt_trn(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1576: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1577: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1578: IS
1579:
1580: CURSOR c_del_ps_stdnt_unt_trn(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 1580: CURSOR c_del_ps_stdnt_unt_trn(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1576: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1577: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1578: IS
1579:
1580: CURSOR c_del_ps_stdnt_unt_trn(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1581: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1582: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1583: IS
1584: SELECT rowid

Line 1581: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1577: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1578: IS
1579:
1580: CURSOR c_del_ps_stdnt_unt_trn(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1581: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1582: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1583: IS
1584: SELECT rowid
1585: FROM IGS_PS_STDNT_UNT_TRN unttrn

Line 1609: PROCEDURE del_as_sua_ses_atts(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1605: END IF;
1606:
1607: END del_ps_stdnt_unt_trn;
1608:
1609: PROCEDURE del_as_sua_ses_atts(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1611: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1612: IS
1613:

Line 1610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1606:
1607: END del_ps_stdnt_unt_trn;
1608:
1609: PROCEDURE del_as_sua_ses_atts(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1611: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1612: IS
1613:
1614: CURSOR c_del_as_sua_ses_atts(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 1614: CURSOR c_del_as_sua_ses_atts(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1611: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1612: IS
1613:
1614: CURSOR c_del_as_sua_ses_atts(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1615: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1616: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1617: IS
1618: SELECT rowid

Line 1615: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1611: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1612: IS
1613:
1614: CURSOR c_del_as_sua_ses_atts(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1615: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1616: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1617: IS
1618: SELECT rowid
1619: FROM igs_as_sua_ses_atts sua_ses_atts

Line 1653: PROCEDURE del_as_msht_su_atmpt(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1649: END IF;
1650:
1651: END del_as_sua_ses_atts;
1652:
1653: PROCEDURE del_as_msht_su_atmpt(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1654: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1655: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1656: IS
1657:

Line 1654: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1650:
1651: END del_as_sua_ses_atts;
1652:
1653: PROCEDURE del_as_msht_su_atmpt(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1654: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1655: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1656: IS
1657:
1658: CURSOR c_del_as_msht_su_atmpt(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 1658: CURSOR c_del_as_msht_su_atmpt(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1654: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1655: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1656: IS
1657:
1658: CURSOR c_del_as_msht_su_atmpt(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1659: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1660: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1661: IS
1662: SELECT rowid

Line 1659: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1655: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1656: IS
1657:
1658: CURSOR c_del_as_msht_su_atmpt(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1659: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1660: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1661: IS
1662: SELECT rowid
1663: FROM IGS_AS_MSHT_SU_ATMPT as_msht_su_atmpt

Line 1710: PROCEDURE cleanup_dest_program(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1706: || somasekar 13-apr-2005 bug# 4179106 modified to set the future date
1707: || transfer Cancelles status to 'C'
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)

Line 1711: p_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1707: || transfer Cancelles status to 'C'
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:

Line 1726: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%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
1730: WHERE sct.effective_term_cal_type = cp_term_cal_type

Line 1727: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

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
1730: WHERE sct.effective_term_cal_type = cp_term_cal_type
1731: AND sct.effective_term_sequence_num = cp_term_sequence_number

Line 1738: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1734: AND ( sct.status_flag = 'U' and p_mode IN ('CLEANUP')
1735: OR sct.status_flag = 'C' and p_mode IN ('DELETE'));
1736:
1737: -- cursor for fetching the source program details
1738: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1739: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1740: SELECT sca.rowid,sca.*
1741: FROM IGS_EN_STDNT_PS_ATT sca
1742: WHERE sca.person_id = cp_person_id

Line 1739: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

1735: OR sct.status_flag = 'C' and p_mode IN ('DELETE'));
1736:
1737: -- cursor for fetching the source program details
1738: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1739: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1740: SELECT sca.rowid,sca.*
1741: FROM IGS_EN_STDNT_PS_ATT sca
1742: WHERE sca.person_id = cp_person_id
1743: AND sca.course_cd = cp_course_cd;

Line 1741: FROM IGS_EN_STDNT_PS_ATT sca

1737: -- cursor for fetching the source program details
1738: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1739: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1740: SELECT sca.rowid,sca.*
1741: FROM IGS_EN_STDNT_PS_ATT sca
1742: WHERE sca.person_id = cp_person_id
1743: AND sca.course_cd = cp_course_cd;
1744:
1745: -- cursor for fetching the student unit attempt details having status other than dropped or uncofirmed

Line 1746: CURSOR c_sua (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1742: WHERE sca.person_id = cp_person_id
1743: AND sca.course_cd = cp_course_cd;
1744:
1745: -- cursor for fetching the student unit attempt details having status other than dropped or uncofirmed
1746: CURSOR c_sua (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1747: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1748: SELECT 'X'
1749: FROM IGS_EN_SU_ATTEMPT sua
1750: WHERE sua.person_id = cp_person_id

Line 1747: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

1743: AND sca.course_cd = cp_course_cd;
1744:
1745: -- cursor for fetching the student unit attempt details having status other than dropped or uncofirmed
1746: CURSOR c_sua (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1747: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1748: SELECT 'X'
1749: FROM IGS_EN_SU_ATTEMPT sua
1750: WHERE sua.person_id = cp_person_id
1751: AND sua.course_cd = cp_course_cd

Line 1755: CURSOR c_sua_drop (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1751: AND sua.course_cd = cp_course_cd
1752: AND sua.unit_attempt_status NOT IN ('DROPPED','UNCONFIRM');
1753:
1754: -- cursor for fetching the student unit attempt details having status as dropped
1755: CURSOR c_sua_drop (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1756: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1757: SELECT 'X'
1758: FROM IGS_EN_SU_ATTEMPT sua
1759: WHERE sua.person_id = cp_person_id

Line 1756: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

1752: AND sua.unit_attempt_status NOT IN ('DROPPED','UNCONFIRM');
1753:
1754: -- cursor for fetching the student unit attempt details having status as dropped
1755: CURSOR c_sua_drop (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1756: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1757: SELECT 'X'
1758: FROM IGS_EN_SU_ATTEMPT sua
1759: WHERE sua.person_id = cp_person_id
1760: AND sua.course_cd = cp_course_cd

Line 1829: v_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

1825: v_spa_clnup_rec c_spa_clnup%ROWTYPE;
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;

Line 1835: l_stdnt_conf_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%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;
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;

Line 1836: l_comm_date IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;

1832: l_trans_status IGS_PS_STDNT_TRN.status_flag%TYPE;
1833: l_tran_across_careers BOOLEAN;
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;

Line 1837: l_course_att_status IGS_EN_STDNT_PS_ATT.COURSE_ATTEMPT_STATUS%TYPE;

1833: l_tran_across_careers BOOLEAN;
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;

Line 2100: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

2096:
2097:
2098: -- update the destination program attempt with the values of l_stdnt_conf_ind,l_comm_date,l_course_att_status
2099: -- and set the future dated transfer flag to 'N'
2100: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
2101: X_ROWID => v_sca_dest_rec.ROWID,
2102: X_PERSON_ID => v_sca_dest_rec.PERSON_ID,
2103: X_COURSE_CD => v_sca_dest_rec.COURSE_CD,
2104: X_VERSION_NUMBER => v_sca_dest_rec.VERSION_NUMBER,

Line 2216: IGS_EN_STDNT_PS_ATT_PKG.DELETE_ROW(v_sca_dest_rec.rowid);

2212:
2213: --- If dropped unit attempts doesnot exists then delete program attempt.
2214: IF (c_sua_drop%NOTFOUND) THEN
2215:
2216: IGS_EN_STDNT_PS_ATT_PKG.DELETE_ROW(v_sca_dest_rec.rowid);
2217:
2218: END IF;
2219:
2220: CLOSE c_sua_drop;

Line 2279: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2275: AND ( sct.status_flag = 'U' and p_mode IN ('PROCESS','CLEANUP')
2276: OR sct.status_flag = 'C' and p_mode IN ('DELETE'));
2277:
2278: -- cursor to fetch student program details
2279: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2280: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2281: SELECT sca.rowid,sca.*
2282: FROM IGS_EN_STDNT_PS_ATT sca
2283: WHERE sca.person_id = cp_person_id

Line 2280: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

2276: OR sct.status_flag = 'C' and p_mode IN ('DELETE'));
2277:
2278: -- cursor to fetch student program details
2279: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2280: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2281: SELECT sca.rowid,sca.*
2282: FROM IGS_EN_STDNT_PS_ATT sca
2283: WHERE sca.person_id = cp_person_id
2284: AND sca.course_cd = cp_course_cd;

Line 2282: FROM IGS_EN_STDNT_PS_ATT sca

2278: -- cursor to fetch student program details
2279: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2280: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2281: SELECT sca.rowid,sca.*
2282: FROM IGS_EN_STDNT_PS_ATT sca
2283: WHERE sca.person_id = cp_person_id
2284: AND sca.course_cd = cp_course_cd;
2285:
2286: -- To fetch the date aliases set up in calendar configuration table

Line 2313: CURSOR c_person_num(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS

2309: AND ci_sequence_number = cp_term_sequence_number
2310: AND dt_alias = cp_begin_pt_dt_alias;
2311:
2312: -- cursor to get the person number
2313: CURSOR c_person_num(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
2314: SELECT party_number
2315: FROM HZ_PARTIES
2316: WHERE party_id = cp_person_id;
2317:

Line 2329: CURSOR c_prim_in_prev_terms(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2325:
2326:
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,

Line 2330: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2326:
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

Line 2362: CURSOR c_uoo (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2358: ORDER BY ci2.start_dt DESC;
2359:
2360:
2361: -- Cursor to get uoo details to be transferred
2362: CURSOR c_uoo (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2363: cp_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2364: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2365: SELECT uoo_id,core_indicator_code,unit_attempt_status
2366: FROM IGS_EN_SU_ATTEMPT sua

Line 2363: cp_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2359:
2360:
2361: -- Cursor to get uoo details to be transferred
2362: CURSOR c_uoo (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2363: cp_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2364: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2365: SELECT uoo_id,core_indicator_code,unit_attempt_status
2366: FROM IGS_EN_SU_ATTEMPT sua
2367: WHERE person_id = cp_person_id

Line 2364: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

2360:
2361: -- Cursor to get uoo details to be transferred
2362: CURSOR c_uoo (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2363: cp_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2364: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2365: SELECT uoo_id,core_indicator_code,unit_attempt_status
2366: FROM IGS_EN_SU_ATTEMPT sua
2367: WHERE person_id = cp_person_id
2368: AND course_cd = cp_src_course_cd

Line 2380: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

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'
2384: FROM IGS_PS_STDNT_TRN sct

Line 2381: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE

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'
2384: FROM IGS_PS_STDNT_TRN sct
2385: WHERE effective_term_cal_type = cp_term_cal_type

Line 2415: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

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);
2419: l_return_status VARCHAR2(1);

Line 2844: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2840: ||
2841: ------------------------------------------------------------------------------*/
2842:
2843: FUNCTION del_sua_for_reopen(
2844: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2845: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2846: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2847: )
2848: RETURN BOOLEAN

Line 2845: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2841: ------------------------------------------------------------------------------*/
2842:
2843: FUNCTION del_sua_for_reopen(
2844: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2845: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2846: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2847: )
2848: RETURN BOOLEAN
2849: AS

Line 2851: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2847: )
2848: RETURN BOOLEAN
2849: AS
2850: CURSOR c_sua_del (
2851: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2852: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2853: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2854: ) IS
2855: SELECT rowid

Line 2852: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2848: RETURN BOOLEAN
2849: AS
2850: CURSOR c_sua_del (
2851: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2852: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2853: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2854: ) IS
2855: SELECT rowid
2856: FROM IGS_EN_SU_ATTEMPT sua