APPS.IGS_GR_PRC_GAC dependencies on IGS_GR_AWD_CRMN_PKG

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