APPS.IGS_RU_GEN_002 dependencies on IGS_RU_RULE_SEQ_NUM_S

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 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