eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_RULE_PKG dependencies on AME_CONDITIONS

Line 499: select ame_conditions.condition_id

495: end getItemClassId;
496: function getLMConditionId(ruleIdIn in integer) return integer as
497: conditionId integer;
498: begin
499: select ame_conditions.condition_id
500: into conditionId
501: from ame_conditions,
502: ame_condition_usages
503: where

Line 501: from ame_conditions,

497: conditionId integer;
498: begin
499: select ame_conditions.condition_id
500: into conditionId
501: from ame_conditions,
502: ame_condition_usages
503: where
504: ame_conditions.condition_id = ame_condition_usages.condition_id and
505: ame_conditions.condition_type = ame_util.listModConditionType and

Line 504: ame_conditions.condition_id = ame_condition_usages.condition_id and

500: into conditionId
501: from ame_conditions,
502: ame_condition_usages
503: where
504: ame_conditions.condition_id = ame_condition_usages.condition_id and
505: ame_conditions.condition_type = ame_util.listModConditionType and
506: ame_condition_usages.rule_id = ruleIdIn and
507: (ame_conditions.start_date <= sysdate and
508: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 505: ame_conditions.condition_type = ame_util.listModConditionType and

501: from ame_conditions,
502: ame_condition_usages
503: where
504: ame_conditions.condition_id = ame_condition_usages.condition_id and
505: ame_conditions.condition_type = ame_util.listModConditionType and
506: ame_condition_usages.rule_id = ruleIdIn and
507: (ame_conditions.start_date <= sysdate and
508: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
509: ((sysdate between ame_condition_usages.start_date and

Line 507: (ame_conditions.start_date <= sysdate and

503: where
504: ame_conditions.condition_id = ame_condition_usages.condition_id and
505: ame_conditions.condition_type = ame_util.listModConditionType and
506: ame_condition_usages.rule_id = ruleIdIn and
507: (ame_conditions.start_date <= sysdate and
508: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
509: ((sysdate between ame_condition_usages.start_date and
510: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
511: (sysdate < ame_condition_usages.start_date and

Line 508: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

504: ame_conditions.condition_id = ame_condition_usages.condition_id and
505: ame_conditions.condition_type = ame_util.listModConditionType and
506: ame_condition_usages.rule_id = ruleIdIn and
507: (ame_conditions.start_date <= sysdate and
508: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
509: ((sysdate between ame_condition_usages.start_date and
510: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
511: (sysdate < ame_condition_usages.start_date and
512: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 1228: from ame_conditions,

1224: function getSubItemClassId(ruleIdIn in integer) return integer as
1225: cursor getSubItemClassIdCur(ruleIdIn in integer,
1226: headerItemClassIdIn in integer) is
1227: select item_class_id
1228: from ame_conditions,
1229: ame_attributes,
1230: ame_condition_usages
1231: where
1232: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 1232: ame_conditions.condition_id = ame_condition_usages.condition_id and

1228: from ame_conditions,
1229: ame_attributes,
1230: ame_condition_usages
1231: where
1232: ame_conditions.condition_id = ame_condition_usages.condition_id and
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn and
1235: ame_attributes.item_class_id <> headerItemClassIdIn and
1236: (sysdate between ame_conditions.start_date and

Line 1233: ame_conditions.attribute_id = ame_attributes.attribute_id and

1229: ame_attributes,
1230: ame_condition_usages
1231: where
1232: ame_conditions.condition_id = ame_condition_usages.condition_id and
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn and
1235: ame_attributes.item_class_id <> headerItemClassIdIn and
1236: (sysdate between ame_conditions.start_date and
1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and

Line 1236: (sysdate between ame_conditions.start_date and

1232: ame_conditions.condition_id = ame_condition_usages.condition_id and
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn and
1235: ame_attributes.item_class_id <> headerItemClassIdIn and
1236: (sysdate between ame_conditions.start_date and
1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1238: (sysdate between ame_condition_usages.start_date and
1239: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
1240: (sysdate between ame_attributes.start_date and

Line 1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and

1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn and
1235: ame_attributes.item_class_id <> headerItemClassIdIn and
1236: (sysdate between ame_conditions.start_date and
1237: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1238: (sysdate between ame_condition_usages.start_date and
1239: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
1240: (sysdate between ame_attributes.start_date and
1241: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));

Line 1466: from ame_conditions,

1462: conditionCount integer;
1463: begin
1464: select count(*)
1465: into conditionCount
1466: from ame_conditions,
1467: ame_condition_usages
1468: where
1469: ame_conditions.condition_id = ame_condition_usages.condition_id and
1470: ame_conditions.condition_type = ame_util.listModConditionType and

Line 1469: ame_conditions.condition_id = ame_condition_usages.condition_id and

1465: into conditionCount
1466: from ame_conditions,
1467: ame_condition_usages
1468: where
1469: ame_conditions.condition_id = ame_condition_usages.condition_id and
1470: ame_conditions.condition_type = ame_util.listModConditionType and
1471: ame_condition_usages.rule_id = ruleIdIn and
1472: (ame_conditions.start_date <= sysdate and
1473: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 1470: ame_conditions.condition_type = ame_util.listModConditionType and

1466: from ame_conditions,
1467: ame_condition_usages
1468: where
1469: ame_conditions.condition_id = ame_condition_usages.condition_id and
1470: ame_conditions.condition_type = ame_util.listModConditionType and
1471: ame_condition_usages.rule_id = ruleIdIn and
1472: (ame_conditions.start_date <= sysdate and
1473: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
1474: ((sysdate between ame_condition_usages.start_date and

Line 1472: (ame_conditions.start_date <= sysdate and

1468: where
1469: ame_conditions.condition_id = ame_condition_usages.condition_id and
1470: ame_conditions.condition_type = ame_util.listModConditionType and
1471: ame_condition_usages.rule_id = ruleIdIn and
1472: (ame_conditions.start_date <= sysdate and
1473: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
1474: ((sysdate between ame_condition_usages.start_date and
1475: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1476: (sysdate < ame_condition_usages.start_date and

Line 1473: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

1469: ame_conditions.condition_id = ame_condition_usages.condition_id and
1470: ame_conditions.condition_type = ame_util.listModConditionType and
1471: ame_condition_usages.rule_id = ruleIdIn and
1472: (ame_conditions.start_date <= sysdate and
1473: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
1474: ((sysdate between ame_condition_usages.start_date and
1475: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1476: (sysdate < ame_condition_usages.start_date and
1477: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 2548: from ame_conditions,

2544: conditionCount integer;
2545: begin
2546: select count(*)
2547: into conditionCount
2548: from ame_conditions,
2549: ame_condition_usages
2550: where
2551: ame_conditions.condition_id = ame_condition_usages.condition_id and
2552: ame_condition_usages.rule_id = ruleIdIn and

Line 2551: ame_conditions.condition_id = ame_condition_usages.condition_id and

2547: into conditionCount
2548: from ame_conditions,
2549: ame_condition_usages
2550: where
2551: ame_conditions.condition_id = ame_condition_usages.condition_id and
2552: ame_condition_usages.rule_id = ruleIdIn and
2553: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2554: sysdate between ame_conditions.start_date and
2555: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 2553: ame_conditions.condition_type = ame_util.ordinaryConditionType and

2549: ame_condition_usages
2550: where
2551: ame_conditions.condition_id = ame_condition_usages.condition_id and
2552: ame_condition_usages.rule_id = ruleIdIn and
2553: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2554: sysdate between ame_conditions.start_date and
2555: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
2556: ((sysdate between ame_condition_usages.start_date and
2557: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 2554: sysdate between ame_conditions.start_date and

2550: where
2551: ame_conditions.condition_id = ame_condition_usages.condition_id and
2552: ame_condition_usages.rule_id = ruleIdIn and
2553: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2554: sysdate between ame_conditions.start_date and
2555: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
2556: ((sysdate between ame_condition_usages.start_date and
2557: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
2558: (sysdate < ame_condition_usages.start_date and

Line 2555: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

2551: ame_conditions.condition_id = ame_condition_usages.condition_id and
2552: ame_condition_usages.rule_id = ruleIdIn and
2553: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2554: sysdate between ame_conditions.start_date and
2555: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
2556: ((sysdate between ame_condition_usages.start_date and
2557: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
2558: (sysdate < ame_condition_usages.start_date and
2559: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 2744: from ame_conditions,

2740: ame_admin_pkg.getItemClassIdByName(itemClassNameIn =>
2741: ame_util.headerItemClassName);
2742: select count(*)
2743: into tempCount
2744: from ame_conditions,
2745: ame_attributes,
2746: ame_condition_usages
2747: where
2748: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 2748: ame_conditions.condition_id = ame_condition_usages.condition_id and

2744: from ame_conditions,
2745: ame_attributes,
2746: ame_condition_usages
2747: where
2748: ame_conditions.condition_id = ame_condition_usages.condition_id and
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn and
2751: ame_attributes.item_class_id <> headerItemClassId and
2752: (sysdate between ame_conditions.start_date and

Line 2749: ame_conditions.attribute_id = ame_attributes.attribute_id and

2745: ame_attributes,
2746: ame_condition_usages
2747: where
2748: ame_conditions.condition_id = ame_condition_usages.condition_id and
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn and
2751: ame_attributes.item_class_id <> headerItemClassId and
2752: (sysdate between ame_conditions.start_date and
2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and

Line 2752: (sysdate between ame_conditions.start_date and

2748: ame_conditions.condition_id = ame_condition_usages.condition_id and
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn and
2751: ame_attributes.item_class_id <> headerItemClassId and
2752: (sysdate between ame_conditions.start_date and
2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
2754: (sysdate between ame_condition_usages.start_date and
2755: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
2756: (sysdate between ame_attributes.start_date and

Line 2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and

2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn and
2751: ame_attributes.item_class_id <> headerItemClassId and
2752: (sysdate between ame_conditions.start_date and
2753: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
2754: (sysdate between ame_condition_usages.start_date and
2755: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) and
2756: (sysdate between ame_attributes.start_date and
2757: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate));

Line 3963: ame_conditions.condition_id condition_id,

3959: procedure getConditionIds(ruleIdIn in integer,
3960: conditionIdListOut out nocopy ame_util.idList) as
3961: cursor conditionCursor(ruleIdIn in integer) is
3962: select
3963: ame_conditions.condition_id condition_id,
3964: ame_conditions.condition_type condition_type
3965: from
3966: ame_conditions,
3967: ame_condition_usages

Line 3964: ame_conditions.condition_type condition_type

3960: conditionIdListOut out nocopy ame_util.idList) as
3961: cursor conditionCursor(ruleIdIn in integer) is
3962: select
3963: ame_conditions.condition_id condition_id,
3964: ame_conditions.condition_type condition_type
3965: from
3966: ame_conditions,
3967: ame_condition_usages
3968: where

Line 3966: ame_conditions,

3962: select
3963: ame_conditions.condition_id condition_id,
3964: ame_conditions.condition_type condition_type
3965: from
3966: ame_conditions,
3967: ame_condition_usages
3968: where
3969: ame_conditions.condition_id = ame_condition_usages.condition_id and
3970: ame_condition_usages.rule_id = ruleIdIn and

Line 3969: ame_conditions.condition_id = ame_condition_usages.condition_id and

3965: from
3966: ame_conditions,
3967: ame_condition_usages
3968: where
3969: ame_conditions.condition_id = ame_condition_usages.condition_id and
3970: ame_condition_usages.rule_id = ruleIdIn and
3971: (ame_conditions.start_date <= sysdate and
3972: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
3973: ((sysdate between ame_condition_usages.start_date and

Line 3971: (ame_conditions.start_date <= sysdate and

3967: ame_condition_usages
3968: where
3969: ame_conditions.condition_id = ame_condition_usages.condition_id and
3970: ame_condition_usages.rule_id = ruleIdIn and
3971: (ame_conditions.start_date <= sysdate and
3972: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
3973: ((sysdate between ame_condition_usages.start_date and
3974: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
3975: (sysdate < ame_condition_usages.start_date and

Line 3972: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

3968: where
3969: ame_conditions.condition_id = ame_condition_usages.condition_id and
3970: ame_condition_usages.rule_id = ruleIdIn and
3971: (ame_conditions.start_date <= sysdate and
3972: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
3973: ((sysdate between ame_condition_usages.start_date and
3974: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
3975: (sysdate < ame_condition_usages.start_date and
3976: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 4011: tempConditionType ame_conditions.condition_type%type;

4007: procedure getConditions(ruleIdIn in integer,
4008: conditionListOut out nocopy ame_util.stringList,
4009: conditionIdListOut out nocopy ame_util.idList) as
4010: conditionIdList ame_util.idList;
4011: tempConditionType ame_conditions.condition_type%type;
4012: tempDescription varchar2(200);
4013: upperLimit integer;
4014: ruleType ame_rules.rule_type%type;
4015: begin

Line 4092: select ame_conditions.attribute_id attribute_id

4088: end getDetailUrls;
4089: procedure getOrdinaryAttributeIds(ruleIdIn in integer,
4090: attributeIdListOut out nocopy ame_util.idList) as
4091: cursor attributeCursor(ruleIdIn in integer) is
4092: select ame_conditions.attribute_id attribute_id
4093: from
4094: ame_conditions,
4095: ame_condition_usages
4096: where

Line 4094: ame_conditions,

4090: attributeIdListOut out nocopy ame_util.idList) as
4091: cursor attributeCursor(ruleIdIn in integer) is
4092: select ame_conditions.attribute_id attribute_id
4093: from
4094: ame_conditions,
4095: ame_condition_usages
4096: where
4097: ame_conditions.condition_type = ame_util.ordinaryConditionType and
4098: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 4097: ame_conditions.condition_type = ame_util.ordinaryConditionType and

4093: from
4094: ame_conditions,
4095: ame_condition_usages
4096: where
4097: ame_conditions.condition_type = ame_util.ordinaryConditionType and
4098: ame_conditions.condition_id = ame_condition_usages.condition_id and
4099: ame_condition_usages.rule_id = ruleIdIn and
4100: (ame_conditions.start_date <= sysdate and
4101: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 4098: ame_conditions.condition_id = ame_condition_usages.condition_id and

4094: ame_conditions,
4095: ame_condition_usages
4096: where
4097: ame_conditions.condition_type = ame_util.ordinaryConditionType and
4098: ame_conditions.condition_id = ame_condition_usages.condition_id and
4099: ame_condition_usages.rule_id = ruleIdIn and
4100: (ame_conditions.start_date <= sysdate and
4101: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4102: ((sysdate between ame_condition_usages.start_date and

Line 4100: (ame_conditions.start_date <= sysdate and

4096: where
4097: ame_conditions.condition_type = ame_util.ordinaryConditionType and
4098: ame_conditions.condition_id = ame_condition_usages.condition_id and
4099: ame_condition_usages.rule_id = ruleIdIn and
4100: (ame_conditions.start_date <= sysdate and
4101: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4102: ((sysdate between ame_condition_usages.start_date and
4103: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4104: (sysdate < ame_condition_usages.start_date and

Line 4101: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

4097: ame_conditions.condition_type = ame_util.ordinaryConditionType and
4098: ame_conditions.condition_id = ame_condition_usages.condition_id and
4099: ame_condition_usages.rule_id = ruleIdIn and
4100: (ame_conditions.start_date <= sysdate and
4101: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4102: ((sysdate between ame_condition_usages.start_date and
4103: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4104: (sysdate < ame_condition_usages.start_date and
4105: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,ame_condition_usages.start_date + ame_util.oneSecond)))

Line 4130: select ame_conditions.attribute_id attribute_id

4126: end getOrdinaryAttributeIds;
4127: procedure getRequiredAttributes(ruleIdIn in integer,
4128: attributeIdsOut out nocopy ame_util.idList) as
4129: cursor attributeCursor(ruleIdIn in integer) is
4130: select ame_conditions.attribute_id attribute_id
4131: from
4132: ame_conditions,
4133: ame_condition_usages
4134: where

Line 4132: ame_conditions,

4128: attributeIdsOut out nocopy ame_util.idList) as
4129: cursor attributeCursor(ruleIdIn in integer) is
4130: select ame_conditions.attribute_id attribute_id
4131: from
4132: ame_conditions,
4133: ame_condition_usages
4134: where
4135: ame_conditions.condition_type in (ame_util.ordinaryConditionType, ame_util.exceptionConditionType) and
4136: ame_condition_usages.rule_id = ruleIdIn and

Line 4135: ame_conditions.condition_type in (ame_util.ordinaryConditionType, ame_util.exceptionConditionType) and

4131: from
4132: ame_conditions,
4133: ame_condition_usages
4134: where
4135: ame_conditions.condition_type in (ame_util.ordinaryConditionType, ame_util.exceptionConditionType) and
4136: ame_condition_usages.rule_id = ruleIdIn and
4137: ame_condition_usages.condition_id = ame_conditions.condition_id and
4138: (ame_conditions.start_date <= sysdate and
4139: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 4137: ame_condition_usages.condition_id = ame_conditions.condition_id and

4133: ame_condition_usages
4134: where
4135: ame_conditions.condition_type in (ame_util.ordinaryConditionType, ame_util.exceptionConditionType) and
4136: ame_condition_usages.rule_id = ruleIdIn and
4137: ame_condition_usages.condition_id = ame_conditions.condition_id and
4138: (ame_conditions.start_date <= sysdate and
4139: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4140: ((sysdate between ame_condition_usages.start_date and
4141: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 4138: (ame_conditions.start_date <= sysdate and

4134: where
4135: ame_conditions.condition_type in (ame_util.ordinaryConditionType, ame_util.exceptionConditionType) and
4136: ame_condition_usages.rule_id = ruleIdIn and
4137: ame_condition_usages.condition_id = ame_conditions.condition_id and
4138: (ame_conditions.start_date <= sysdate and
4139: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4140: ((sysdate between ame_condition_usages.start_date and
4141: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4142: (sysdate < ame_condition_usages.start_date and

Line 4139: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

4135: ame_conditions.condition_type in (ame_util.ordinaryConditionType, ame_util.exceptionConditionType) and
4136: ame_condition_usages.rule_id = ruleIdIn and
4137: ame_condition_usages.condition_id = ame_conditions.condition_id and
4138: (ame_conditions.start_date <= sysdate and
4139: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4140: ((sysdate between ame_condition_usages.start_date and
4141: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4142: (sysdate < ame_condition_usages.start_date and
4143: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 4350: ame_conditions.condition_id condition_id

4346: conditionIdsOut out nocopy ame_util.idList) as
4347: cursor conditionCursor(ruleIdIn in integer,
4348: conditionTypeIn in varchar2) is
4349: select
4350: ame_conditions.condition_id condition_id
4351: from
4352: ame_conditions,
4353: ame_condition_usages
4354: where

Line 4352: ame_conditions,

4348: conditionTypeIn in varchar2) is
4349: select
4350: ame_conditions.condition_id condition_id
4351: from
4352: ame_conditions,
4353: ame_condition_usages
4354: where
4355: ame_conditions.condition_type = conditionTypeIn and
4356: ame_condition_usages.rule_id = ruleIdIn and

Line 4355: ame_conditions.condition_type = conditionTypeIn and

4351: from
4352: ame_conditions,
4353: ame_condition_usages
4354: where
4355: ame_conditions.condition_type = conditionTypeIn and
4356: ame_condition_usages.rule_id = ruleIdIn and
4357: ame_condition_usages.condition_id = ame_conditions.condition_id and
4358: (ame_conditions.start_date <= sysdate and
4359: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 4357: ame_condition_usages.condition_id = ame_conditions.condition_id and

4353: ame_condition_usages
4354: where
4355: ame_conditions.condition_type = conditionTypeIn and
4356: ame_condition_usages.rule_id = ruleIdIn and
4357: ame_condition_usages.condition_id = ame_conditions.condition_id and
4358: (ame_conditions.start_date <= sysdate and
4359: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4360: ((sysdate between ame_condition_usages.start_date and
4361: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 4358: (ame_conditions.start_date <= sysdate and

4354: where
4355: ame_conditions.condition_type = conditionTypeIn and
4356: ame_condition_usages.rule_id = ruleIdIn and
4357: ame_condition_usages.condition_id = ame_conditions.condition_id and
4358: (ame_conditions.start_date <= sysdate and
4359: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4360: ((sysdate between ame_condition_usages.start_date and
4361: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4362: (sysdate < ame_condition_usages.start_date and

Line 4359: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

4355: ame_conditions.condition_type = conditionTypeIn and
4356: ame_condition_usages.rule_id = ruleIdIn and
4357: ame_condition_usages.condition_id = ame_conditions.condition_id and
4358: (ame_conditions.start_date <= sysdate and
4359: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4360: ((sysdate between ame_condition_usages.start_date and
4361: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4362: (sysdate < ame_condition_usages.start_date and
4363: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 4394: ame_conditions.condition_id condition_id

4390: conditionIdsOut out nocopy ame_util.idList) as
4391: cursor conditionCursor(ruleIdIn in integer,
4392: conditionTypeIn in varchar2) is
4393: select
4394: ame_conditions.condition_id condition_id
4395: from
4396: ame_conditions,
4397: ame_condition_usages
4398: where

Line 4396: ame_conditions,

4392: conditionTypeIn in varchar2) is
4393: select
4394: ame_conditions.condition_id condition_id
4395: from
4396: ame_conditions,
4397: ame_condition_usages
4398: where
4399: ame_conditions.condition_type = conditionTypeIn and
4400: ame_condition_usages.rule_id = ruleIdIn and

Line 4399: ame_conditions.condition_type = conditionTypeIn and

4395: from
4396: ame_conditions,
4397: ame_condition_usages
4398: where
4399: ame_conditions.condition_type = conditionTypeIn and
4400: ame_condition_usages.rule_id = ruleIdIn and
4401: ame_condition_usages.condition_id = ame_conditions.condition_id and
4402: (ame_conditions.start_date <= sysdate and
4403: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 4401: ame_condition_usages.condition_id = ame_conditions.condition_id and

4397: ame_condition_usages
4398: where
4399: ame_conditions.condition_type = conditionTypeIn and
4400: ame_condition_usages.rule_id = ruleIdIn and
4401: ame_condition_usages.condition_id = ame_conditions.condition_id and
4402: (ame_conditions.start_date <= sysdate and
4403: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4404: ((sysdate between ame_condition_usages.start_date and
4405: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 4402: (ame_conditions.start_date <= sysdate and

4398: where
4399: ame_conditions.condition_type = conditionTypeIn and
4400: ame_condition_usages.rule_id = ruleIdIn and
4401: ame_condition_usages.condition_id = ame_conditions.condition_id and
4402: (ame_conditions.start_date <= sysdate and
4403: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4404: ((sysdate between ame_condition_usages.start_date and
4405: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4406: (sysdate < ame_condition_usages.start_date and

Line 4403: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

4399: ame_conditions.condition_type = conditionTypeIn and
4400: ame_condition_usages.rule_id = ruleIdIn and
4401: ame_condition_usages.condition_id = ame_conditions.condition_id and
4402: (ame_conditions.start_date <= sysdate and
4403: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
4404: ((sysdate between ame_condition_usages.start_date and
4405: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
4406: (sysdate < ame_condition_usages.start_date and
4407: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,