DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_LOOKUPS_VIEW_PKG

Line 228: IF NOT igs_lookups_view_pkg.get_pk_for_validation('RESERVE_SEAT_PRIORITY', p_usec_rsv_rec.priority_value) THEN

224: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
225: p_usec_rsv_rec.status := 'E';
226: END IF;
227:
228: IF NOT igs_lookups_view_pkg.get_pk_for_validation('RESERVE_SEAT_PRIORITY', p_usec_rsv_rec.priority_value) THEN
229: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'PRIORITY_VALUE', 'LEGACY_TOKENS', FALSE);
230: p_usec_rsv_rec.status := 'E';
231: END IF;
232: END validate_db_cons_rsvpri;

Line 4751: IF NOT igs_lookups_view_pkg.get_pk_for_validation('UNIT_WAITLIST', p_usec_wlst_rec.priority_value) THEN

4747: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
4748: p_usec_wlst_rec.status := 'E';
4749: END IF;
4750:
4751: IF NOT igs_lookups_view_pkg.get_pk_for_validation('UNIT_WAITLIST', p_usec_wlst_rec.priority_value) THEN
4752: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'PRIORITY_VALUE', 'LEGACY_TOKENS', FALSE);
4753: p_usec_wlst_rec.status := 'E';
4754: END IF;
4755: END validate_db_cons_wlstpri;