APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_WLST_PRF

Line 4960: FROM igs_ps_usec_wlst_prf

4956: FUNCTION check_insert_update ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_n_wlst_usec_pri_id NUMBER) RETURN VARCHAR2 IS
4957:
4958: CURSOR c_usec_wlst_prf(cp_n_wlst_usec_pri_id NUMBER,cp_preference_code VARCHAR2) IS
4959: SELECT 'X'
4960: FROM igs_ps_usec_wlst_prf
4961: WHERE unit_sec_waitlist_priority_id = cp_n_wlst_usec_pri_id
4962: AND preference_code = cp_preference_code;
4963:
4964: c_usec_wlst_prf_rec c_usec_wlst_prf%ROWTYPE;

Line 4970: FROM igs_ps_usec_wlst_prf

4966: CURSOR c_usec_wlst_prf1(cp_n_wlst_usec_pri_id NUMBER,
4967: cp_preference_code VARCHAR2,
4968: cp_preference_version VARCHAR2) IS
4969: SELECT 'X'
4970: FROM igs_ps_usec_wlst_prf
4971: WHERE unit_sec_waitlist_priority_id = cp_n_wlst_usec_pri_id
4972: AND preference_code = cp_preference_code
4973: AND preference_version = cp_preference_version;
4974: c_usec_wlst_prf1_rec c_usec_wlst_prf1%ROWTYPE;

Line 5014: IF igs_ps_usec_wlst_prf_pkg.get_uk_for_validation(x_preference_code =>p_usec_wlst_rec.preference_code,

5010: BEGIN
5011:
5012: IF(p_insert_update = 'I') THEN
5013: /* Unique Key Validation */
5014: IF igs_ps_usec_wlst_prf_pkg.get_uk_for_validation(x_preference_code =>p_usec_wlst_rec.preference_code,
5015: x_preference_version=>p_usec_wlst_rec.preference_version,
5016: x_unit_sec_wlst_priority_id =>l_n_wlst_usec_pri_id) THEN
5017: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_WLST_PRF', 'LEGACY_TOKENS', FALSE);
5018: p_usec_wlst_rec.status := 'W';

Line 5141: INSERT INTO igs_ps_usec_wlst_prf

5137:
5138: IF p_usec_wlst_rec.status = 'S' THEN
5139: IF l_insert_update = 'I' THEN
5140: /* Insert Record */
5141: INSERT INTO igs_ps_usec_wlst_prf
5142: ( unit_sec_waitlist_pref_id,
5143: unit_sec_waitlist_priority_id,
5144: preference_order,
5145: preference_code,

Line 5155: igs_ps_usec_wlst_prf_s.nextval,

5151: last_update_login
5152: )
5153: VALUES
5154: (
5155: igs_ps_usec_wlst_prf_s.nextval,
5156: l_n_wlst_usec_pri_id,
5157: p_usec_wlst_rec.preference_order,
5158: p_usec_wlst_rec.preference_code,
5159: p_usec_wlst_rec.preference_version,

Line 5176: UPDATE igs_ps_usec_wlst_prf SET

5172: 'Preference Code:'||p_usec_wlst_rec.preference_code);
5173: END IF;
5174:
5175: ELSE ---update
5176: UPDATE igs_ps_usec_wlst_prf SET
5177: preference_order= p_usec_wlst_rec.preference_order,
5178: preference_version=p_usec_wlst_rec.preference_version,
5179: last_updated_by = g_n_user_id,
5180: last_update_date= SYSDATE ,