APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USO_CLAS_MEET

Line 3504: FROM igs_ps_uso_clas_meet

3500: -- Check for Update
3501: FUNCTION check_insert_update_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) RETURN VARCHAR2 IS
3502: CURSOR c_uso_clas_meet(cp_n_uoo_id NUMBER) IS
3503: SELECT 'X'
3504: FROM igs_ps_uso_clas_meet
3505: WHERE uoo_id = cp_n_uoo_id;
3506:
3507: c_uso_clas_meet_rec c_uso_clas_meet%ROWTYPE;
3508: BEGIN

Line 3551: IF igs_ps_uso_clas_meet_pkg.get_uk_for_validation (x_uoo_id =>l_n_uoo_id) THEN

3547: PROCEDURE validate_db_cons_cm ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3548: BEGIN
3549: IF (p_insert_update = 'I') THEN
3550: /* Unique Key Validation */
3551: IF igs_ps_uso_clas_meet_pkg.get_uk_for_validation (x_uoo_id =>l_n_uoo_id) THEN
3552: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
3553: p_uso_clas_meet_rec.status := 'W';
3554: RETURN;
3555: END IF;

Line 3664: INSERT INTO igs_ps_uso_clas_meet

3660:
3661: IF p_uso_clas_meet_rec.status = 'S' THEN
3662: IF l_insert_update = 'I' THEN
3663: /* Insert Record */
3664: INSERT INTO igs_ps_uso_clas_meet
3665: ( class_meet_id,
3666: class_meet_group_id,
3667: host,
3668: created_by,

Line 3676: (igs_ps_uso_clas_meet_s.NEXTVAL,

3672: last_update_login,
3673: uoo_id
3674: )
3675: VALUES
3676: (igs_ps_uso_clas_meet_s.NEXTVAL,
3677: l_n_class_meet_group_id,
3678: p_uso_clas_meet_rec.host,
3679: g_n_user_id,
3680: SYSDATE,

Line 3695: UPDATE igs_ps_uso_clas_meet

3691: p_uso_clas_meet_rec.unit_class||' '||'Class meet group name:'||p_uso_clas_meet_rec.class_meet_group_name);
3692: END IF;
3693:
3694: ELSE --update
3695: UPDATE igs_ps_uso_clas_meet
3696: SET host = p_uso_clas_meet_rec.host,
3697: last_updated_by = g_n_user_id,
3698: last_update_date = SYSDATE,
3699: last_update_login = g_n_login_id