APPS.IGS_RU_GEN_003 dependencies on IGS_PS_UNIT_RU

Line 177: v_ur_rec IGS_PS_UNIT_RU%ROWTYPE;

173: RETURN BOOLEAN IS
174: BEGIN
175: DECLARE
176: v_other_detail VARCHAR2(255);
177: v_ur_rec IGS_PS_UNIT_RU%ROWTYPE;
178: CURSOR c_unit_rule
179: (cp_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
180: cp_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE) IS
181: SELECT *

Line 179: (cp_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,

175: DECLARE
176: v_other_detail VARCHAR2(255);
177: v_ur_rec IGS_PS_UNIT_RU%ROWTYPE;
178: CURSOR c_unit_rule
179: (cp_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
180: cp_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE) IS
181: SELECT *
182: FROM IGS_PS_UNIT_RU ur
183: WHERE ur.unit_cd = cp_unit_cd AND

Line 180: cp_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE) IS

176: v_other_detail VARCHAR2(255);
177: v_ur_rec IGS_PS_UNIT_RU%ROWTYPE;
178: CURSOR c_unit_rule
179: (cp_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
180: cp_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE) IS
181: SELECT *
182: FROM IGS_PS_UNIT_RU ur
183: WHERE ur.unit_cd = cp_unit_cd AND
184: ur.s_rule_call_cd = cp_s_rule_call_cd;

Line 182: FROM IGS_PS_UNIT_RU ur

178: CURSOR c_unit_rule
179: (cp_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
180: cp_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE) IS
181: SELECT *
182: FROM IGS_PS_UNIT_RU ur
183: WHERE ur.unit_cd = cp_unit_cd AND
184: ur.s_rule_call_cd = cp_s_rule_call_cd;
185:
186: CURSOR Cur_Unit_Ru_Del(r_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,

Line 186: CURSOR Cur_Unit_Ru_Del(r_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,

182: FROM IGS_PS_UNIT_RU ur
183: WHERE ur.unit_cd = cp_unit_cd AND
184: ur.s_rule_call_cd = cp_s_rule_call_cd;
185:
186: CURSOR Cur_Unit_Ru_Del(r_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
187: r_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE
188: ) IS
189: SELECT rowid
190: FROM IGS_PS_UNIT_RU

Line 187: r_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE

183: WHERE ur.unit_cd = cp_unit_cd AND
184: ur.s_rule_call_cd = cp_s_rule_call_cd;
185:
186: CURSOR Cur_Unit_Ru_Del(r_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
187: r_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE
188: ) IS
189: SELECT rowid
190: FROM IGS_PS_UNIT_RU
191: WHERE unit_cd = r_unit_cd AND

Line 190: FROM IGS_PS_UNIT_RU

186: CURSOR Cur_Unit_Ru_Del(r_unit_cd IGS_PS_UNIT_RU.unit_cd%TYPE,
187: r_s_rule_call_cd IGS_PS_UNIT_RU.s_rule_call_cd%TYPE
188: ) IS
189: SELECT rowid
190: FROM IGS_PS_UNIT_RU
191: WHERE unit_cd = r_unit_cd AND
192: s_rule_call_cd = r_s_rule_call_cd;
193:
194: CURSOR Cur_Rule_Del(r_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE) IS

Line 194: CURSOR Cur_Rule_Del(r_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE) IS

190: FROM IGS_PS_UNIT_RU
191: WHERE unit_cd = r_unit_cd AND
192: s_rule_call_cd = r_s_rule_call_cd;
193:
194: CURSOR Cur_Rule_Del(r_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE) IS
195: SELECT rowid
196: FROM IGS_RU_RULE
197: WHERE sequence_number = r_sequence_number;
198:

Line 210: - This module deletes a IGS_PS_UNIT_RU and associated IGS_RU_RULE.

206: p_message_name := 'IGS_GE_INVALID_VALUE';
207: RETURN FALSE;
208: END IF;
209: /*
210: - This module deletes a IGS_PS_UNIT_RU and associated IGS_RU_RULE.
211: */
212: OPEN c_unit_rule(p_unit_cd,
213: p_s_rule_call_cd);
214:

Line 222: Delete IGS_PS_UNIT_RU

218: if so, the record can be deleted.
219: */
220: IF (c_unit_rule%FOUND) THEN
221: /*
222: Delete IGS_PS_UNIT_RU
223: */
224:
225: for unit_ru_rec in Cur_Unit_Ru_Del(v_ur_rec.unit_cd, v_ur_rec.s_rule_call_cd) loop
226: IGS_PS_UNIT_RU_PKG.DELETE_ROW(

Line 226: IGS_PS_UNIT_RU_PKG.DELETE_ROW(

222: Delete IGS_PS_UNIT_RU
223: */
224:
225: for unit_ru_rec in Cur_Unit_Ru_Del(v_ur_rec.unit_cd, v_ur_rec.s_rule_call_cd) loop
226: IGS_PS_UNIT_RU_PKG.DELETE_ROW(
227: X_ROWID => unit_ru_rec.rowid
228: );
229: end loop;
230: