[Home] [Help]
196: cursor checkItemClass(ruleIdIn in integer
197: ,applicationIdIn in integer
198: ,endDatein in date) is
199: select name
200: from ame_item_classes itc
201: ,ame_rules rul
202: where rul.item_class_id = itc.item_class_id
203: and rul.rule_id = ruleIdIn
204: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
218: cursor getItemClass(ruleIdIn in integer
219: ,endDateIn in date) is
220: select 'Y'
221: from ame_rules rul
222: ,ame_item_classes itc
223: where rul.rule_id = ruleIdIn
224: and rul.item_class_id = itc.item_class_id
225: and itc.name <> ame_util.headerItemClassName
226: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
299: dummy varchar2(1);
300: errorExists boolean;
301: attributeIdList ame_util.idList;
302: attributeNamesList ame_util.stringList;
303: itemClassName ame_item_classes.name%type;
304: applicationName ame_calling_apps.application_name%type;
305: tempValue ame_config_vars.variable_value%type;
306: actionTypeIdList ame_util.idList;
307: actionTypeNameList ame_util.stringList;
544: --+
545: cursor checkItemClass(ruleIdIn in integer
546: ,applicationIdIn in integer) is
547: select name
548: from ame_item_classes itc
549: ,ame_rules rul
550: where rul.item_class_id = itc.item_class_id
551: and rul.rule_id = ruleIdIn
552: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
568: --+
569: cursor getItemClass(ruleIdIn in integer) is
570: select 'Y'
571: from ame_rules rul
572: ,ame_item_classes itc
573: where rul.rule_id = ruleIdIn
574: and rul.item_class_id = itc.item_class_id
575: and itc.name <> ame_util.headerItemClassName
576: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
664: dummy varchar2(1);
665: errorExists boolean;
666: attributeIdList ame_util.idList;
667: attributeNamesList ame_util.stringList;
668: itemClassName ame_item_classes.name%type;
669: applicationName ame_calling_apps.application_name%type;
670: tempValue ame_config_vars.variable_value%type;
671: actionTypeIdList ame_util.idList;
672: actionTypeNameList ame_util.stringList;
2252: from ame_rules rul
2253: ,ame_condition_usages cnu
2254: ,ame_attributes atr
2255: ,ame_conditions con
2256: ,ame_item_classes itc
2257: where rul.rule_id = p_rule_id
2258: and rul.rule_id = cnu.rule_id
2259: and cnu.condition_id = con.condition_id
2260: and con.attribute_id = atr.attribute_id
2289: end if;
2290: --+
2291: select item_class_id
2292: into l_header_item_class_id
2293: from ame_item_classes
2294: where name = ame_util.headerItemClassName
2295: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
2296: --+
2297: select atr.item_class_id