APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_LIM_WLST

Line 5121: FROM igs_ps_usec_lim_wlst

5117: ***********************************************************************************************/
5118: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
5119: CURSOR c_usec_lim(p_n_uoo_id NUMBER) IS
5120: SELECT 'X'
5121: FROM igs_ps_usec_lim_wlst
5122: WHERE uoo_id = p_n_uoo_id;
5123:
5124: c_usec_lim_rec c_usec_lim%ROWTYPE;
5125: BEGIN

Line 5156: FROM igs_ps_usec_lim_wlst

5152: rec_uop c_uop%ROWTYPE;
5153:
5154: CURSOR c_usec_lim(p_n_uoo_id NUMBER) IS
5155: SELECT *
5156: FROM igs_ps_usec_lim_wlst
5157: WHERE uoo_id = p_n_uoo_id;
5158:
5159: c_usec_lim_rec c_usec_lim%ROWTYPE;
5160: BEGIN

Line 5234: IF igs_ps_usec_lim_wlst_pkg.get_uk_for_validation(l_n_uoo_id) THEN

5230:
5231: PROCEDURE validate_db_cons(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
5232: BEGIN
5233: IF p_insert_update = 'I' THEN
5234: IF igs_ps_usec_lim_wlst_pkg.get_uk_for_validation(l_n_uoo_id) THEN
5235: p_usec_rec.status :='W';
5236: fnd_message.set_name('IGS','IGS_PS_USEC_ENR_LMTS');
5237: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
5238: END IF;

Line 5408: INSERT INTO igs_ps_usec_lim_wlst

5404:
5405: IF p_usec_rec.status = 'S' THEN
5406: IF l_insert_update = 'I' THEN
5407: /* Insert Record */
5408: INSERT INTO igs_ps_usec_lim_wlst
5409: (unit_section_limit_waitlist_id,
5410: uoo_id,
5411: enrollment_expected,
5412: enrollment_minimum ,

Line 5427: igs_ps_usec_lim_wlst_s.nextval,

5423: last_update_login
5424: )
5425: VALUES
5426: (
5427: igs_ps_usec_lim_wlst_s.nextval,
5428: l_n_uoo_id,
5429: p_usec_rec.enrollment_expected,
5430: p_usec_rec.enrollment_minimum,
5431: p_usec_rec.enrollment_maximum,

Line 5452: UPDATE igs_ps_usec_lim_wlst SET

5448: p_usec_rec.unit_class);
5449: END IF;
5450:
5451: ELSE ---update
5452: UPDATE igs_ps_usec_lim_wlst SET
5453: enrollment_expected=p_usec_rec.enrollment_expected,
5454: enrollment_minimum=p_usec_rec.enrollment_minimum ,
5455: enrollment_maximum=p_usec_rec.enrollment_maximum ,
5456: advance_maximum=p_usec_rec.advance_maximum,