APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_HE_ST_SPA_CC

Line 398: -- Delete IGS_HE_ST_SPA_CC records

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
400:
401: CURSOR c_hssc IS
402: SELECT he_spa_cc_id

Line 403: FROM IGS_HE_ST_SPA_CC hssc

399: DECLARE
400:
401: CURSOR c_hssc IS
402: SELECT he_spa_cc_id
403: FROM IGS_HE_ST_SPA_CC hssc
404: WHERE hssc.person_id = p_person_id
405: AND hssc.course_cd = p_course_cd;
406:
407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS

Line 407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS

403: FROM IGS_HE_ST_SPA_CC hssc
404: WHERE hssc.person_id = p_person_id
405: AND hssc.course_cd = p_course_cd;
406:
407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS
408: SELECT rowid
409: FROM IGS_HE_ST_SPA_CC hssc
410: WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
411: FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;

Line 409: FROM IGS_HE_ST_SPA_CC hssc

405: AND hssc.course_cd = p_course_cd;
406:
407: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS
408: SELECT rowid
409: FROM IGS_HE_ST_SPA_CC hssc
410: WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
411: FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;
412:
413: v_hssc_del_exists c_hssc_del%ROWTYPE;

Line 417: -- Delete IGS_HE_ST_SPA_CC records

413: v_hssc_del_exists c_hssc_del%ROWTYPE;
414:
415: BEGIN
416: FOR v_hssc_rec IN c_hssc LOOP
417: -- Delete IGS_HE_ST_SPA_CC records
418: FOR v_hssc_del_exists IN c_hssc_del(v_hssc_rec.he_spa_cc_id) LOOP
419:
420: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(X_ROWID => v_hssc_del_exists.ROWID );
421:

Line 420: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(X_ROWID => v_hssc_del_exists.ROWID );

416: FOR v_hssc_rec IN c_hssc LOOP
417: -- Delete IGS_HE_ST_SPA_CC records
418: FOR v_hssc_del_exists IN c_hssc_del(v_hssc_rec.he_spa_cc_id) LOOP
419:
420: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(X_ROWID => v_hssc_del_exists.ROWID );
421:
422: END LOOP;
423:
424: END LOOP;