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_GR_PRC_GAC dependencies on IGS_GR_AWD_CRMN

Line 298: FROM IGS_GR_AWD_CRMN gac

294: v_gac_count NUMBER;
295: CURSOR c_gac (
296: cp_row_num NUMBER) IS
297: SELECT COUNT(*)
298: FROM IGS_GR_AWD_CRMN gac
299: WHERE gac.grd_cal_type = t_acusg_match(cp_row_num).grd_cal_type AND
300: gac.grd_ci_sequence_number =
301: t_acusg_match(cp_row_num).grd_ci_sequence_number AND
302: gac.ceremony_number = t_acusg_match(cp_row_num).ceremony_number AND

Line 351: IGS_GR_AWD_CRMN_PKG.INSERT_ROW(

347: FROM igs_pe_person_base_v
348: WHERE person_id = p_person_id;
349: l_person_number igs_pe_person_base_v.person_number%TYPE := NULL;
350: BEGIN
351: IGS_GR_AWD_CRMN_PKG.INSERT_ROW(
352: X_ROWID => lv_rowid,
353: X_GAC_ID => lv_id,
354: X_GRADUAND_SEAT_NUMBER => NULL,
355: X_NAME_PRONUNCIATION => p_name_pronunciation,

Line 580: FROM IGS_GR_AWD_CRMN gac

576: gac.ceremony_number,
577: gac.award_course_cd,
578: gac.award_crs_version_number,
579: gac.award_cd
580: FROM IGS_GR_AWD_CRMN gac
581: WHERE gac.grd_cal_type = p_grd_cal_type AND
582: gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
583: gac.ceremony_number = p_ceremony_number AND
584: NVL(gac.award_course_cd,'NULL')

Line 591: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,

587: = NVL(p_award_crs_version_number,0) AND
588: gac.award_cd = p_award_cd AND
589: gac.us_group_number = p_us_group_number;
590: CURSOR c_gac_del (
591: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
592: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
594: cp_grd_ci_sequence_number
595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

Line 592: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,

588: gac.award_cd = p_award_cd AND
589: gac.us_group_number = p_us_group_number;
590: CURSOR c_gac_del (
591: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
592: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
594: cp_grd_ci_sequence_number
595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

Line 593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

589: gac.us_group_number = p_us_group_number;
590: CURSOR c_gac_del (
591: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
592: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
594: cp_grd_ci_sequence_number
595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
597: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

Line 595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

591: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
592: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
594: cp_grd_ci_sequence_number
595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
597: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
598: SELECT rowid,gac.*
599: FROM IGS_GR_AWD_CRMN gac

Line 596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

592: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
594: cp_grd_ci_sequence_number
595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
597: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
598: SELECT rowid,gac.*
599: FROM IGS_GR_AWD_CRMN gac
600: WHERE gac.person_id = cp_person_id AND

Line 597: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

593: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
594: cp_grd_ci_sequence_number
595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
597: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
598: SELECT rowid,gac.*
599: FROM IGS_GR_AWD_CRMN gac
600: WHERE gac.person_id = cp_person_id AND
601: gac.create_dt = cp_create_dt AND

Line 599: FROM IGS_GR_AWD_CRMN gac

595: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
596: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
597: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
598: SELECT rowid,gac.*
599: FROM IGS_GR_AWD_CRMN gac
600: WHERE gac.person_id = cp_person_id AND
601: gac.create_dt = cp_create_dt AND
602: gac.grd_cal_type = cp_grd_cal_type AND
603: gac.grd_ci_sequence_number = cp_grd_ci_sequence_number AND

Line 608: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,

604: gac.award_cd = cp_award_cd
605: FOR UPDATE OF gac.person_id NOWAIT;
606: v_gac_del c_gac_del%ROWTYPE;
607: CURSOR c_gach(
608: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
609: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
611: cp_grd_ci_sequence_number
612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

Line 609: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,

605: FOR UPDATE OF gac.person_id NOWAIT;
606: v_gac_del c_gac_del%ROWTYPE;
607: CURSOR c_gach(
608: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
609: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
611: cp_grd_ci_sequence_number
612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

Line 610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

606: v_gac_del c_gac_del%ROWTYPE;
607: CURSOR c_gach(
608: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
609: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
611: cp_grd_ci_sequence_number
612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
614: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

Line 612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

608: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
609: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
611: cp_grd_ci_sequence_number
612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
614: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
615: SELECT rowid, gach.person_id
616: FROM IGS_GR_AWD_CRMN_HIST gach

Line 613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

609: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
611: cp_grd_ci_sequence_number
612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
614: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
615: SELECT rowid, gach.person_id
616: FROM IGS_GR_AWD_CRMN_HIST gach
617: WHERE gach.person_id = cp_gac_person_id AND

Line 614: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

610: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
611: cp_grd_ci_sequence_number
612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
614: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
615: SELECT rowid, gach.person_id
616: FROM IGS_GR_AWD_CRMN_HIST gach
617: WHERE gach.person_id = cp_gac_person_id AND
618: gach.create_dt = cp_gac_create_dt AND

Line 616: FROM IGS_GR_AWD_CRMN_HIST gach

612: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
613: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
614: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
615: SELECT rowid, gach.person_id
616: FROM IGS_GR_AWD_CRMN_HIST gach
617: WHERE gach.person_id = cp_gac_person_id AND
618: gach.create_dt = cp_gac_create_dt AND
619: gach.grd_cal_type = cp_grd_cal_type AND
620: gach.grd_ci_sequence_number = cp_grd_ci_sequence_number AND

Line 649: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(

645: v_gac_rec.award_cd);
646: FETCH c_gac_del INTO v_gac_del;
647: -- 3.Delete the existing graduand_award_ceremony record
648: IF (c_gac_del%FOUND) THEN
649: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(
650: X_ROWID => v_gac_del.rowid);
651: END IF;
652: CLOSE c_gac_del;
653: EXCEPTION

Line 673: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(

669: v_gac_rec.grd_cal_type,
670: v_gac_rec.grd_ci_sequence_number,
671: v_gac_rec.ceremony_number,
672: v_gac_rec.award_cd) LOOP
673: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(
674: X_ROWID => v_gach_rec.rowid);
675: END LOOP;
676: EXCEPTION
677: WHEN e_resource_busy_exception THEN

Line 793: FROM IGS_GR_AWD_CRMN gac

789: gac.ceremony_number,
790: gac.award_course_cd,
791: gac.award_crs_version_number,
792: gac.award_cd
793: FROM IGS_GR_AWD_CRMN gac
794: WHERE gac.grd_cal_type = p_grd_cal_type AND
795: gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
796: gac.ceremony_number = p_ceremony_number AND
797: gac.award_course_cd = p_award_course_cd AND

Line 802: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,

798: gac.award_crs_version_number = p_award_crs_version_number AND
799: gac.award_cd = p_award_cd AND
800: gac.us_group_number IS NULL;
801: CURSOR c_gac_del (
802: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
803: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
805: cp_grd_ci_sequence_number
806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

Line 803: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,

799: gac.award_cd = p_award_cd AND
800: gac.us_group_number IS NULL;
801: CURSOR c_gac_del (
802: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
803: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
805: cp_grd_ci_sequence_number
806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

Line 804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

800: gac.us_group_number IS NULL;
801: CURSOR c_gac_del (
802: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
803: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
805: cp_grd_ci_sequence_number
806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
808: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

Line 806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

802: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
803: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
805: cp_grd_ci_sequence_number
806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
808: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
809: SELECT rowid, gac.*
810: FROM IGS_GR_AWD_CRMN gac

Line 807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

803: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
805: cp_grd_ci_sequence_number
806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
808: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
809: SELECT rowid, gac.*
810: FROM IGS_GR_AWD_CRMN gac
811: WHERE gac.person_id = cp_person_id AND

Line 808: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

804: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
805: cp_grd_ci_sequence_number
806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
808: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
809: SELECT rowid, gac.*
810: FROM IGS_GR_AWD_CRMN gac
811: WHERE gac.person_id = cp_person_id AND
812: gac.create_dt = cp_create_dt AND

Line 810: FROM IGS_GR_AWD_CRMN gac

806: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
807: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
808: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
809: SELECT rowid, gac.*
810: FROM IGS_GR_AWD_CRMN gac
811: WHERE gac.person_id = cp_person_id AND
812: gac.create_dt = cp_create_dt AND
813: gac.grd_cal_type = cp_grd_cal_type AND
814: gac.grd_ci_sequence_number = cp_grd_ci_sequence_number AND

Line 819: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,

815: gac.award_cd = cp_award_cd
816: FOR UPDATE OF gac.person_id NOWAIT;
817: v_gac_del c_gac_del%ROWTYPE;
818: CURSOR c_gach(
819: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
820: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
822: cp_grd_ci_sequence_number
823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

Line 820: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,

816: FOR UPDATE OF gac.person_id NOWAIT;
817: v_gac_del c_gac_del%ROWTYPE;
818: CURSOR c_gach(
819: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
820: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
822: cp_grd_ci_sequence_number
823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

Line 821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

817: v_gac_del c_gac_del%ROWTYPE;
818: CURSOR c_gach(
819: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
820: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
822: cp_grd_ci_sequence_number
823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
825: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

Line 823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

819: cp_gac_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
820: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
822: cp_grd_ci_sequence_number
823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
825: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
826: SELECT rowid, gach.person_id
827: FROM IGS_GR_AWD_CRMN_HIST gach

Line 824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,

820: cp_gac_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
822: cp_grd_ci_sequence_number
823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
825: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
826: SELECT rowid, gach.person_id
827: FROM IGS_GR_AWD_CRMN_HIST gach
828: WHERE gach.person_id = cp_gac_person_id AND

Line 825: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

821: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
822: cp_grd_ci_sequence_number
823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
825: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
826: SELECT rowid, gach.person_id
827: FROM IGS_GR_AWD_CRMN_HIST gach
828: WHERE gach.person_id = cp_gac_person_id AND
829: gach.create_dt = cp_gac_create_dt AND

Line 827: FROM IGS_GR_AWD_CRMN_HIST gach

823: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
824: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE,
825: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
826: SELECT rowid, gach.person_id
827: FROM IGS_GR_AWD_CRMN_HIST gach
828: WHERE gach.person_id = cp_gac_person_id AND
829: gach.create_dt = cp_gac_create_dt AND
830: gach.grd_cal_type = cp_grd_cal_type AND
831: gach.grd_ci_sequence_number = cp_grd_ci_sequence_number AND

Line 882: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(

878: v_gac_rec.award_cd);
879: FETCH c_gac_del INTO v_gac_del;
880: -- 3.Delete the existing graduand_award_ceremony record
881: IF (c_gac_del%FOUND) THEN
882: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(
883: X_ROWID => v_gac_del.rowid);
884: END IF;
885: CLOSE c_gac_del;
886: EXCEPTION

Line 906: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(

902: v_gac_rec.grd_cal_type,
903: v_gac_rec.grd_ci_sequence_number,
904: v_gac_rec.ceremony_number,
905: v_gac_rec.award_cd) LOOP
906: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(
907: X_ROWID => v_gach_rec.rowid);
908: END LOOP;
909: EXCEPTION
910: WHEN e_resource_busy_exception THEN