APPS.IGS_AV_GEN_001 dependencies on IGS_AV_STND_ALT_UNIT

Line 104: CURSOR c_alt_unt_all(cp_alt_unit_id IGS_AV_STND_ALT_UNIT.av_stnd_unit_id%TYPE) IS

100: SELECT rowid
101: FROM IGS_AV_STD_ULVLBASIS_ALL asbl
102: WHERE asbl.av_stnd_unit_lvl_id = cp_unit_lvl_id;
103:
104: CURSOR c_alt_unt_all(cp_alt_unit_id IGS_AV_STND_ALT_UNIT.av_stnd_unit_id%TYPE) IS
105: SELECT rowid
106: FROM IGS_AV_STND_ALT_UNIT asau
107: WHERE asau.av_stnd_unit_id = cp_alt_unit_id;
108:

Line 106: FROM IGS_AV_STND_ALT_UNIT asau

102: WHERE asbl.av_stnd_unit_lvl_id = cp_unit_lvl_id;
103:
104: CURSOR c_alt_unt_all(cp_alt_unit_id IGS_AV_STND_ALT_UNIT.av_stnd_unit_id%TYPE) IS
105: SELECT rowid
106: FROM IGS_AV_STND_ALT_UNIT asau
107: WHERE asau.av_stnd_unit_id = cp_alt_unit_id;
108:
109:
110: BEGIN

Line 148: igs_av_stnd_alt_unit_pkg.DELETE_ROW (

144: END IF;
145:
146: FOR v_alt_unt_all IN c_alt_unt_all(v_unit_all.av_stnd_unit_id)
147: LOOP
148: igs_av_stnd_alt_unit_pkg.DELETE_ROW (
149: X_ROWID => v_alt_unt_all.rowid );
150: END LOOP;
151:
152: