APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_X_GRPMEM

Line 4258: FROM igs_ps_usec_x_grpmem

4254: -- Check for Update
4255: FUNCTION check_insert_update_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) RETURN VARCHAR2 IS
4256: CURSOR c_usec_x_grpmem(cp_n_uoo_id NUMBER) IS
4257: SELECT 'X'
4258: FROM igs_ps_usec_x_grpmem
4259: WHERE uoo_id = cp_n_uoo_id;
4260:
4261: c_usec_x_grpmem_rec c_usec_x_grpmem%ROWTYPE;
4262: BEGIN

Line 4306: IF igs_ps_usec_x_grpmem_pkg.get_uk_for_validation (x_uoo_id =>l_n_uoo_id) THEN

4302: BEGIN
4303:
4304: IF (p_insert_update = 'I') THEN
4305: /* Unique Key Validation */
4306: IF igs_ps_usec_x_grpmem_pkg.get_uk_for_validation (x_uoo_id =>l_n_uoo_id) THEN
4307: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
4308: p_usec_x_grpmem.status := 'W';
4309: RETURN;
4310: END IF;

Line 4423: INSERT INTO igs_ps_usec_x_grpmem

4419:
4420: IF p_usec_x_grpmem.status = 'S' THEN
4421: IF l_insert_update = 'I' THEN
4422: /* Insert Record */
4423: INSERT INTO igs_ps_usec_x_grpmem
4424: ( usec_x_listed_group_mem_id,
4425: usec_x_listed_group_id,
4426: parent,
4427: created_by,

Line 4435: (igs_ps_usec_x_grpmem_s.NEXTVAL,

4431: last_update_login,
4432: uoo_id
4433: )
4434: VALUES
4435: (igs_ps_usec_x_grpmem_s.NEXTVAL,
4436: l_n_usec_x_listed_group_id,
4437: p_usec_x_grpmem.parent,
4438: g_n_user_id,
4439: SYSDATE,

Line 4454: UPDATE igs_ps_usec_x_grpmem

4450: p_usec_x_grpmem.unit_class||' '||'usec_x_listed_group_name:'||p_usec_x_grpmem.usec_x_listed_group_name);
4451: END IF;
4452:
4453: ELSE --update
4454: UPDATE igs_ps_usec_x_grpmem
4455: SET parent = p_usec_x_grpmem.parent,
4456: last_updated_by = g_n_user_id,
4457: last_update_date = SYSDATE,
4458: last_update_login = g_n_login_id