[Home] [Help]
1122: --
1123: -- Cursor to generate new sequence number
1124: --
1125: CURSOR cur_seq_num IS
1126: SELECT igs_pe_persenc_effct_seq_num_s.NEXTVAL
1127: FROM dual;
1128: --
1129: -- Cursor to check if the Hold already existes for the Student
1130: --
1242: x_auth_resp_id => NULL,
1243: x_external_reference => NULL
1244: );
1245: --
1246: -- 2. Loop through all the Default hold effects for the hold type and Create a record in Table IGS_PE_PERSENC_EFFCT
1247: --
1248: FOR HldEfct_rec IN cur_hold_effect (lvcHoldType) LOOP
1249: --
1250: -- Get the sequnce number from the sequence
1252: OPEN cur_seq_num;
1253: FETCH cur_seq_num INTO lnpeeseqnum;
1254: CLOSE cur_seq_num;
1255: --
1256: igs_pe_persenc_effct_pkg.insert_row (
1257: x_rowid => lvHoldEfctRowID,
1258: x_person_id => std_rec.student_person_id,
1259: x_encumbrance_type => lvcHoldType,
1260: x_pen_start_dt => ldHldStrtDt,
2311: --
2312: CURSOR cur_hld_efct (cp_hold_type VARCHAR2, cp_start_date DATE) IS
2313: SELECT efc.ROWID row_id,
2314: efc.*
2315: FROM igs_pe_persenc_effct efc
2316: WHERE efc.person_id = p_person_id
2317: AND efc.encumbrance_type = cp_hold_type
2318: AND efc.pen_start_dt = cp_start_date; --to do see if there needs to be a check on expiry date also..
2319: --
2335: FOR effect_rec IN cur_hld_efct (
2336: hold_rec.encumbrance_type,
2337: hold_rec.start_dt
2338: ) LOOP
2339: igs_pe_persenc_effct_pkg.update_row (
2340: x_rowid => effect_rec.row_id,
2341: x_person_id => effect_rec.person_id,
2342: x_encumbrance_type => effect_rec.encumbrance_type,
2343: x_pen_start_dt => effect_rec.pen_start_dt,