[Home] [Help]
153: ,endDateIn in date ) is
154: select distinct atr.attribute_id, atr.name
155: from ame_attributes atr
156: ,ame_conditions cond
157: ,ame_condition_usages condu
158: ,ame_rules rules
159: where cond.attribute_id = atr.attribute_id
160: and condu.condition_id = cond.condition_id
161: and condu.rule_id = rules.rule_id
283: ,endDateIn in date) is
284: select 'Y'
285: from ame_rules rul
286: ,ame_conditions con
287: ,ame_condition_usages cnu
288: ,wf_roles wf
289: where rul.rule_id = ruleIdIn
290: and con.condition_id = cnu.condition_id
291: and con.condition_type = ame_util.listModConditionType
489: ,applicationIdIn in integer) is
490: select distinct atr.attribute_id, atr.name
491: from ame_attributes atr
492: ,ame_conditions cond
493: ,ame_condition_usages condu
494: ,ame_rules rules
495: where cond.attribute_id = atr.attribute_id
496: and condu.condition_id = cond.condition_id
497: and condu.rule_id = rules.rule_id
642: cursor checkLMConditions(ruleIdIn in integer) is
643: select 'Y'
644: from ame_rules rul
645: ,ame_conditions con
646: ,ame_condition_usages cnu
647: ,wf_roles wf
648: where rul.rule_id = ruleIdIn
649: and con.condition_id = cnu.condition_id
650: and cnu.rule_id = rul.rule_id
857: ,endDateIn in date
858: ) is
859: select count(*)
860: from ame_conditions con
861: ,ame_condition_usages cnu
862: ,ame_rules rul
863: where rul.rule_id = ruleIdIn
864: and rul.end_date = endDateIn
865: and cnu.rule_id = rul.rule_id
908: --+
909: cursor getConditions(ruleIdIn in integer
910: ,endDateIn in date) is
911: select count(*)
912: from ame_condition_usages cnu
913: ,ame_rules rul
914: where rul.rule_id = ruleIdIn
915: and rul.end_date = endDateIn
916: and cnu.rule_id = rul.rule_id
994: --+
995: cursor getConditions(ruleIdIn in integer
996: ,endDateIn in date)is
997: select condition_id,created_by,creation_date
998: from ame_condition_usages
999: where rule_id = ruleIdIn
1000: and end_date = endDateIn;
1001: --+
1002: cursor getACtions(ruleIdIn in integer
1044: where rule_id = ruleIdIn
1045: and end_date = ruleEndDateIn;
1046: --+ conditions
1047: for condRec in getConditions(ruleIdIn,ruleEndDateIn) loop
1048: insert into ame_condition_usages
1049: (rule_id
1050: ,condition_id
1051: ,created_by
1052: ,creation_date
1392: select condition_id
1393: ,start_date
1394: ,end_date
1395: ,object_version_number
1396: from ame_condition_usages
1397: where rule_id = p_rule_id
1398: and ((l_effective_date between start_date
1399: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1400: or
1618: --+
1619: cursor rulCndCnt(p_rule_id in number) is
1620: select count(*)
1621: from ame_rules rul
1622: ,ame_condition_usages cnu
1623: where rul.rule_id = p_rule_id
1624: and cnu.rule_id = rul.rule_id
1625: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
1626: or
1807: ,p_rule_id in integer) return boolean is
1808: --+
1809: cursor getRuleConditions(p_rule_id in integer) is
1810: select cnu.condition_id
1811: from ame_condition_usages cnu
1812: ,ame_rules rul
1813: where rul.rule_id = cnu.rule_id
1814: and rul.rule_id = p_rule_id
1815: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
1933: --+
1934: cursor getLMConditions(p_rule_id in integer) is
1935: select count(*)
1936: from ame_rules rul
1937: ,ame_condition_usages cnu
1938: ,ame_conditions cnd
1939: where rul.rule_id = p_rule_id
1940: and cnu.rule_id = rul.rule_id
1941: and cnd.condition_id = cnu.condition_id
2249: --+
2250: cursor get_sub_ic_cond(p_rule_id in integer) is
2251: select distinct atr.item_class_id
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
2341: begin
2342: --+
2343: select count(*)
2344: into l_count
2345: from ame_condition_usages
2346: where rule_id = p_rule_id
2347: and condition_id = p_condition_id
2348: and ((sysdate between start_date and nvl(end_date - (1/86400),sysdate))
2349: or