APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AV_STND_UNIT_PKG

Line 566: igs_av_stnd_unit_pkg.delete_row(X_ROWID => rec_get_adv_unit_dtls.rowid);

562: --Fetch the Advanced Standing Unit Record for deletion...
563: OPEN cur_get_adv_unit_dtls(rec_del_adv_dtls.pk);
564: FETCH cur_get_adv_unit_dtls INTO rec_get_adv_unit_dtls;
565: CLOSE cur_get_adv_unit_dtls;
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);

Line 577: igs_av_stnd_unit_pkg.delete_row(X_ROWID => rec_get_adv_unit_dtls.rowid);

573: --Fetch the Advanced Standing Unit Record for deletion...
574: OPEN cur_get_adv_unit_dtls(rec_del_adv_dtls.pk);
575: FETCH cur_get_adv_unit_dtls INTO rec_get_adv_unit_dtls;
576: CLOSE cur_get_adv_unit_dtls;
577: igs_av_stnd_unit_pkg.delete_row(X_ROWID => rec_get_adv_unit_dtls.rowid);
578: ELSIF RTRIM(rec_del_adv_dtls.lvl) = 'UNIT LEVEL' THEN
579: --Check if there exists any Unit Level Basis Details; If exists then delete it;
580: FOR rec_get_bas_lvl IN cur_get_bas_lvl(rec_del_adv_dtls.pk) LOOP
581: igs_av_std_ulvlbasis_pkg.delete_row(X_ROWID => rec_get_bas_lvl.rowid);

Line 611: igs_av_stnd_unit_pkg.update_row(

607: IF rec_del_adv_dtls.lvl = 'UNIT' THEN
608: OPEN cur_get_adv_unit_dtls(rec_del_adv_dtls.pk);
609: FETCH cur_get_adv_unit_dtls INTO rec_get_adv_unit_dtls;
610: IF cur_get_adv_unit_dtls%FOUND THEN
611: igs_av_stnd_unit_pkg.update_row(
612: X_ROWID => rec_get_adv_unit_dtls.rowid ,
613: X_PERSON_ID => rec_get_adv_unit_dtls.person_id ,
614: X_AS_COURSE_CD => rec_get_adv_unit_dtls.as_course_cd ,
615: X_AS_VERSION_NUMBER => rec_get_adv_unit_dtls.as_version_number ,