APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_PR_RU_APPL

Line 555: -- Delete IGS_PR_RU_APPL records

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
557: CURSOR c_pra IS
558: SELECT progression_rule_cat,sequence_number
559: FROM IGS_PR_RU_APPL pra

Line 559: FROM IGS_PR_RU_APPL pra

555: -- Delete IGS_PR_RU_APPL records
556: DECLARE
557: CURSOR c_pra IS
558: SELECT progression_rule_cat,sequence_number
559: FROM IGS_PR_RU_APPL pra
560: WHERE pra.sca_person_id = p_person_id
561: AND pra.sca_course_cd = p_course_cd;
562:
563: CURSOR c_pra_del (

Line 564: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,

560: WHERE pra.sca_person_id = p_person_id
561: AND pra.sca_course_cd = p_course_cd;
562:
563: CURSOR c_pra_del (
564: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
565: cp_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE) IS
566: SELECT rowid,pra.*
567: FROM IGS_PR_RU_APPL pra
568: WHERE pra.progression_rule_cat = cp_progression_rule_cat

Line 565: cp_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE) IS

561: AND pra.sca_course_cd = p_course_cd;
562:
563: CURSOR c_pra_del (
564: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
565: cp_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE) IS
566: SELECT rowid,pra.*
567: FROM IGS_PR_RU_APPL pra
568: WHERE pra.progression_rule_cat = cp_progression_rule_cat
569: AND pra.sequence_number = cp_sequence_number

Line 567: FROM IGS_PR_RU_APPL pra

563: CURSOR c_pra_del (
564: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
565: cp_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE) IS
566: SELECT rowid,pra.*
567: FROM IGS_PR_RU_APPL pra
568: WHERE pra.progression_rule_cat = cp_progression_rule_cat
569: AND pra.sequence_number = cp_sequence_number
570: FOR UPDATE OF pra.LAST_UPDATE_DATE NOWAIT ;
571:

Line 577: -- Delete IGS_PR_RU_APPL records

573:
574: BEGIN
575:
576: FOR v_pra_rec IN c_pra LOOP
577: -- Delete IGS_PR_RU_APPL records
578: FOR v_pra_upd_exists IN c_pra_del(v_pra_rec.progression_rule_cat,
579: v_pra_rec.sequence_number ) LOOP
580: -- DELETE THE RECORD
581: IGS_PR_RU_APPL_PKG.DELETE_ROW (X_ROWID => v_pra_upd_exists.rowid) ;

Line 581: IGS_PR_RU_APPL_PKG.DELETE_ROW (X_ROWID => v_pra_upd_exists.rowid) ;

577: -- Delete IGS_PR_RU_APPL records
578: FOR v_pra_upd_exists IN c_pra_del(v_pra_rec.progression_rule_cat,
579: v_pra_rec.sequence_number ) LOOP
580: -- DELETE THE RECORD
581: IGS_PR_RU_APPL_PKG.DELETE_ROW (X_ROWID => v_pra_upd_exists.rowid) ;
582:
583: END LOOP;
584:
585: END LOOP;