Line 41: select ame_rule_keys_s.nextval into ruleKeyId from dual;
37: else
38: seededKeyPrefix := null;
39: end if;
40: loop 41: select ame_rule_keys_s.nextval into ruleKeyId from dual; 42: newRuleKey := databaseId||':'||ruleKeyId;
43: if seededKeyPrefix is not null then
44: newRuleKey1 := seededKeyPrefix||'-' || newRuleKey;
45: else
Line 382: Cursor C_Sel1 is select ame_rules_s.nextval from sys.dual;
378: ,p_validation_start_date in date
379: ,p_validation_end_date in date
380: ) is
381: -- 382: Cursor C_Sel1 is select ame_rules_s.nextval from sys.dual; 383: --
384: Cursor C_Sel2 is
385: Select null
386: from ame_rules