APPS.IGS_RU_GEN_002 dependencies on IGS_RU_RULE

Line 247: CURSOR C_IGS_RU_RULE_SEQ_NUM_S IS

243: BEGIN DECLARE
244: v_rule_number NUMBER;
245: X_ROWID VARCHAR2(25);
246:
247: CURSOR C_IGS_RU_RULE_SEQ_NUM_S IS
248: SELECT igs_ru_rule_seq_num_s.NEXTVAL
249: FROM DUAL;
250:
251: CURSOR cur_max_plus_one IS

Line 248: SELECT igs_ru_rule_seq_num_s.NEXTVAL

244: v_rule_number NUMBER;
245: X_ROWID VARCHAR2(25);
246:
247: CURSOR C_IGS_RU_RULE_SEQ_NUM_S IS
248: SELECT igs_ru_rule_seq_num_s.NEXTVAL
249: FROM DUAL;
250:
251: CURSOR cur_max_plus_one IS
252: SELECT (sequence_number + 1) sequence_number

Line 253: FROM igs_ru_rule

249: FROM DUAL;
250:
251: CURSOR cur_max_plus_one IS
252: SELECT (sequence_number + 1) sequence_number
253: FROM igs_ru_rule
254: WHERE sequence_number =
255: (SELECT MAX (sequence_number)
256: FROM igs_ru_rule
257: WHERE sequence_number < 499999)

Line 256: FROM igs_ru_rule

252: SELECT (sequence_number + 1) sequence_number
253: FROM igs_ru_rule
254: WHERE sequence_number =
255: (SELECT MAX (sequence_number)
256: FROM igs_ru_rule
257: WHERE sequence_number < 499999)
258: FOR UPDATE OF sequence_number NOWAIT;
259:
260: BEGIN

Line 279: OPEN C_IGS_RU_RULE_SEQ_NUM_S;

275: OPEN cur_max_plus_one;
276: FETCH cur_max_plus_one INTO v_rule_number;
277: CLOSE cur_max_plus_one;
278: ELSE
279: OPEN C_IGS_RU_RULE_SEQ_NUM_S;
280: FETCH C_IGS_RU_RULE_SEQ_NUM_S INTO v_rule_number;
281: CLOSE C_IGS_RU_RULE_SEQ_NUM_S;
282: END IF;
283: ELSE

Line 280: FETCH C_IGS_RU_RULE_SEQ_NUM_S INTO v_rule_number;

276: FETCH cur_max_plus_one INTO v_rule_number;
277: CLOSE cur_max_plus_one;
278: ELSE
279: OPEN C_IGS_RU_RULE_SEQ_NUM_S;
280: FETCH C_IGS_RU_RULE_SEQ_NUM_S INTO v_rule_number;
281: CLOSE C_IGS_RU_RULE_SEQ_NUM_S;
282: END IF;
283: ELSE
284: /*

Line 281: CLOSE C_IGS_RU_RULE_SEQ_NUM_S;

277: CLOSE cur_max_plus_one;
278: ELSE
279: OPEN C_IGS_RU_RULE_SEQ_NUM_S;
280: FETCH C_IGS_RU_RULE_SEQ_NUM_S INTO v_rule_number;
281: CLOSE C_IGS_RU_RULE_SEQ_NUM_S;
282: END IF;
283: ELSE
284: /*
285: use deleted rule number

Line 291: IGS_RU_RULE_PKG.INSERT_ROW (

287: v_rule_number := gt_rule_numbers(gv_rn_index);
288: gv_rn_index := gv_rn_index - 1;
289: END IF;
290:
291: IGS_RU_RULE_PKG.INSERT_ROW (
292: X_ROWID => X_ROWID ,
293: X_SEQUENCE_NUMBER => V_RULE_NUMBER );
294:
295: RETURN v_rule_number;

Line 1258: p_rule_number IN IGS_RU_RULE.sequence_number%TYPE,

1254: save RULE and set numbers
1255:
1256: */
1257: PROCEDURE delete_rule_items(
1258: p_rule_number IN IGS_RU_RULE.sequence_number%TYPE,
1259: p_item IN IGS_RU_ITEM.item%TYPE)
1260: IS
1261: CURSOR c_rule_items IS
1262: SELECT rowid, ri.*

Line 1269: FROM IGS_RU_RULE rule

1265: AND item >= p_item ;
1266:
1267: CURSOR c_rule (p_rule_number IN IGS_RU_ITEM.RULE_NUMBER%TYPE) IS
1268: SELECT rowid, rule.*
1269: FROM IGS_RU_RULE rule
1270: WHERE sequence_number = p_rule_number;
1271:
1272:
1273: CURSOR c_rule_set_mbr(p_set_number IN IGS_RU_ITEM.SET_NUMBER%TYPE) IS

Line 1299: remove all items of this IGS_RU_RULE

1295: */
1296: gv_rn_index := gv_rn_index + 1;
1297: gt_rule_numbers(gv_rn_index) := c_rule_items_rec.rule_number;
1298: /*
1299: remove all items of this IGS_RU_RULE
1300: */
1301: delete_rule_items(c_rule_items_rec.rule_number,0);
1302: /*
1303: remove RULE

Line 1306: IGS_RU_RULE_PKG.DELETE_ROW (X_ROWID => C_RULE_REC.ROWID );

1302: /*
1303: remove RULE
1304: */
1305: FOR c_rule_rec IN c_rule (c_rule_items_rec.rule_number) LOOP
1306: IGS_RU_RULE_PKG.DELETE_ROW (X_ROWID => C_RULE_REC.ROWID );
1307: END LOOP;
1308:
1309: ELSIF c_rule_items_rec.set_number IS NOT NULL
1310: THEN