APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AV_STD_UNT_BASIS_PKG

Line 559: igs_av_std_unt_basis_pkg.delete_row(X_ROWID => rec_get_bas_dtl.rowid);

555: END LOOP;
556:
557: --Check if there exists any Unit Basis Details; If exists then delete it;
558: FOR rec_get_bas_dtl IN cur_get_bas_dtl(rec_del_adv_dtls.pk) LOOP
559: igs_av_std_unt_basis_pkg.delete_row(X_ROWID => rec_get_bas_dtl.rowid);
560: END LOOP;
561:
562: --Fetch the Advanced Standing Unit Record for deletion...
563: OPEN cur_get_adv_unit_dtls(rec_del_adv_dtls.pk);

Line 570: igs_av_std_unt_basis_pkg.delete_row(X_ROWID => rec_get_bas_dtl.rowid);

566: igs_av_stnd_unit_pkg.delete_row(X_ROWID => rec_get_adv_unit_dtls.rowid);
567: ELSIF RTRIM(rec_del_adv_dtls.lvl) = 'UNIT' AND SUBSTR(rec_del_adv_dtls.ece_type, 20, 10) <> 'PRECLUSION' THEN
568: --Check if there exists any Unit Basis Details; If exists then delete it;
569: FOR rec_get_bas_dtl IN cur_get_bas_dtl(rec_del_adv_dtls.pk) LOOP
570: igs_av_std_unt_basis_pkg.delete_row(X_ROWID => rec_get_bas_dtl.rowid);
571: END LOOP;
572:
573: --Fetch the Advanced Standing Unit Record for deletion...
574: OPEN cur_get_adv_unit_dtls(rec_del_adv_dtls.pk);