DBA Data[Home] [Help]

APPS.IGS_RU_GEN_002 dependencies on DUAL

Line 188: FROM DUAL;

184: IF p_LOV_number IS NULL
185: THEN
186: SELECT IGS_RU_LOV_SEQ_NUM_S.nextval
187: INTO p_LOV_number
188: FROM DUAL;
189: END IF;
190:
191: FOR C_RL_REC IN C_RL LOOP
192: IGS_RU_LOV_PKG.DELETE_ROW (X_ROWID => C_RL_REC.ROWID );

Line 249: FROM DUAL;

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
253: FROM igs_ru_rule

Line 312: FROM DUAL;

308: X_ROWID VARCHAR2(25);
309:
310: CURSOR C_IGS_RU_SET_SEQ_NUM_S IS
311: SELECT igs_ru_set_seq_num_s.NEXTVAL
312: FROM DUAL;
313:
314: CURSOR cur_max_plus_one IS
315: SELECT (sequence_number + 1) sequence_number
316: FROM igs_ru_set