APPS.AME_RULE_PKG dependencies on AME_CONDITION_USAGES

Line 435: from ame_condition_usages

431: conditionCount integer;
432: begin
433: select count(condition_id)
434: into conditionCount
435: from ame_condition_usages
436: where
437: rule_id = ruleIdIn and
438: /* allows for future start date */
439: ((sysdate between start_date and

Line 502: ame_condition_usages

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
506: ame_condition_usages.rule_id = ruleIdIn 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 506: ame_condition_usages.rule_id = ruleIdIn and

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
510: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 509: ((sysdate between ame_condition_usages.start_date 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,
513: ame_condition_usages.start_date + ame_util.oneSecond)));

Line 510: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
513: ame_condition_usages.start_date + ame_util.oneSecond)));
514: return(conditionId);

Line 511: (sysdate < ame_condition_usages.start_date 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,
513: ame_condition_usages.start_date + ame_util.oneSecond)));
514: return(conditionId);
515: exception

Line 512: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
513: ame_condition_usages.start_date + ame_util.oneSecond)));
514: return(conditionId);
515: exception
516: when others then

Line 513: ame_condition_usages.start_date + ame_util.oneSecond)));

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,
513: ame_condition_usages.start_date + ame_util.oneSecond)));
514: return(conditionId);
515: exception
516: when others then
517: rollback;

Line 1230: ame_condition_usages

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
1233: ame_conditions.attribute_id = ame_attributes.attribute_id and
1234: ame_condition_usages.rule_id = ruleIdIn 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 1234: ame_condition_usages.rule_id = ruleIdIn and

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
1238: (sysdate between ame_condition_usages.start_date and

Line 1238: (sysdate between ame_condition_usages.start_date 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));
1242: headerItemClassId integer;

Line 1239: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) 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));
1242: headerItemClassId integer;
1243: itemIds ame_util.idList;

Line 1467: ame_condition_usages

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
1471: ame_condition_usages.rule_id = ruleIdIn 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 1471: ame_condition_usages.rule_id = ruleIdIn and

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
1475: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 1474: ((sysdate between ame_condition_usages.start_date 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,
1478: ame_condition_usages.start_date + ame_util.oneSecond)));

Line 1475: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
1478: ame_condition_usages.start_date + ame_util.oneSecond)));
1479: if(conditionCount > 0) then

Line 1476: (sysdate < ame_condition_usages.start_date 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,
1478: ame_condition_usages.start_date + ame_util.oneSecond)));
1479: if(conditionCount > 0) then
1480: return(true);

Line 1477: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
1478: ame_condition_usages.start_date + ame_util.oneSecond)));
1479: if(conditionCount > 0) then
1480: return(true);
1481: else

Line 1478: ame_condition_usages.start_date + ame_util.oneSecond)));

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,
1478: ame_condition_usages.start_date + ame_util.oneSecond)));
1479: if(conditionCount > 0) then
1480: return(true);
1481: else
1482: return(false);

Line 1876: insert into ame_condition_usages(rule_id,

1872: descriptionIn,
1873: itemClassIdIn);
1874: if(conditionIdsIn.count > 0) then
1875: for tempIndex in 1 .. conditionIdsIn.count loop
1876: insert into ame_condition_usages(rule_id,
1877: condition_id,
1878: created_by,
1879: creation_date,
1880: last_updated_by,

Line 2285: update ame_condition_usages

2281: getConditionIds(ruleIdIn => ruleIdIn,
2282: conditionIdListOut => conditionIdList);
2283: if conditionIdList.count > 0 then
2284: for i in 1..conditionIdList.count loop
2285: update ame_condition_usages
2286: set
2287: last_updated_by = currentUserId,
2288: last_update_date = processingDate,
2289: last_update_login = currentUserId,

Line 2549: ame_condition_usages

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
2553: ame_conditions.condition_type = ame_util.ordinaryConditionType 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 2552: ame_condition_usages.rule_id = ruleIdIn and

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
2556: ((sysdate between ame_condition_usages.start_date and

Line 2556: ((sysdate between ame_condition_usages.start_date 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,
2560: ame_condition_usages.start_date + ame_util.oneSecond)));

Line 2557: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
2560: ame_condition_usages.start_date + ame_util.oneSecond)));
2561: if(conditionCount > 0) then

Line 2558: (sysdate < ame_condition_usages.start_date 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,
2560: ame_condition_usages.start_date + ame_util.oneSecond)));
2561: if(conditionCount > 0) then
2562: return(true);

Line 2559: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
2560: ame_condition_usages.start_date + ame_util.oneSecond)));
2561: if(conditionCount > 0) then
2562: return(true);
2563: end if;

Line 2560: ame_condition_usages.start_date + ame_util.oneSecond)));

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,
2560: ame_condition_usages.start_date + ame_util.oneSecond)));
2561: if(conditionCount > 0) then
2562: return(true);
2563: end if;
2564: return(false);

Line 2746: ame_condition_usages

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
2749: ame_conditions.attribute_id = ame_attributes.attribute_id and
2750: ame_condition_usages.rule_id = ruleIdIn 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 2750: ame_condition_usages.rule_id = ruleIdIn and

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
2754: (sysdate between ame_condition_usages.start_date and

Line 2754: (sysdate between ame_condition_usages.start_date 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));
2758: if(tempCount > 0) then

Line 2755: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) 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));
2758: if(tempCount > 0) then
2759: return(true);

Line 3049: update ame_condition_usages

3045: if(not ame_rule_pkg.hasListModCondition(conditionIdsIn => newConditionIdList)) then
3046: raise listModConditionException;
3047: end if;
3048: end if;
3049: update ame_condition_usages
3050: set
3051: last_updated_by = currentUserId,
3052: last_update_date = endDate,
3053: last_update_login = currentUserId,

Line 3967: ame_condition_usages

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
3971: (ame_conditions.start_date <= sysdate 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 3970: ame_condition_usages.rule_id = ruleIdIn and

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
3974: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 3973: ((sysdate between ame_condition_usages.start_date and

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,
3977: ame_condition_usages.start_date + ame_util.oneSecond)))

Line 3974: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
3977: ame_condition_usages.start_date + ame_util.oneSecond)))
3978: order by condition_type;

Line 3975: (sysdate < ame_condition_usages.start_date 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,
3977: ame_condition_usages.start_date + ame_util.oneSecond)))
3978: order by condition_type;
3979: tempIndex integer;

Line 3976: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
3977: ame_condition_usages.start_date + ame_util.oneSecond)))
3978: order by condition_type;
3979: tempIndex integer;
3980: begin

Line 3977: ame_condition_usages.start_date + ame_util.oneSecond)))

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,
3977: ame_condition_usages.start_date + ame_util.oneSecond)))
3978: order by condition_type;
3979: tempIndex integer;
3980: begin
3981: /*

Line 4095: ame_condition_usages

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
4099: ame_condition_usages.rule_id = ruleIdIn 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 4099: ame_condition_usages.rule_id = ruleIdIn and

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
4103: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 4102: ((sysdate between ame_condition_usages.start_date 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)))
4106: order by attribute_id;

Line 4103: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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)))
4106: order by attribute_id;
4107: tempIndex integer;

Line 4104: (sysdate < ame_condition_usages.start_date 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)))
4106: order by attribute_id;
4107: tempIndex integer;
4108: begin

Line 4105: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,ame_condition_usages.start_date + ame_util.oneSecond)))

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)))
4106: order by attribute_id;
4107: tempIndex integer;
4108: begin
4109: tempIndex := 1;

Line 4133: ame_condition_usages

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
4137: ame_condition_usages.condition_id = ame_conditions.condition_id and

Line 4136: ame_condition_usages.rule_id = ruleIdIn and

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
4140: ((sysdate between ame_condition_usages.start_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 4140: ((sysdate between ame_condition_usages.start_date 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,
4144: ame_condition_usages.start_date + ame_util.oneSecond)))

Line 4141: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
4144: ame_condition_usages.start_date + ame_util.oneSecond)))
4145: union

Line 4142: (sysdate < ame_condition_usages.start_date 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,
4144: ame_condition_usages.start_date + ame_util.oneSecond)))
4145: union
4146: select ame_mandatory_attributes.attribute_id attribute_id

Line 4143: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
4144: ame_condition_usages.start_date + ame_util.oneSecond)))
4145: union
4146: select ame_mandatory_attributes.attribute_id attribute_id
4147: from

Line 4144: ame_condition_usages.start_date + ame_util.oneSecond)))

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,
4144: ame_condition_usages.start_date + ame_util.oneSecond)))
4145: union
4146: select ame_mandatory_attributes.attribute_id attribute_id
4147: from
4148: ame_mandatory_attributes,

Line 4353: ame_condition_usages

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
4357: ame_condition_usages.condition_id = ame_conditions.condition_id and

Line 4356: ame_condition_usages.rule_id = ruleIdIn and

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
4360: ((sysdate between ame_condition_usages.start_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 4360: ((sysdate between ame_condition_usages.start_date 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,
4364: ame_condition_usages.start_date + ame_util.oneSecond)))

Line 4361: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
4364: ame_condition_usages.start_date + ame_util.oneSecond)))
4365: order by condition_type;

Line 4362: (sysdate < ame_condition_usages.start_date 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,
4364: ame_condition_usages.start_date + ame_util.oneSecond)))
4365: order by condition_type;
4366: tempIndex integer;

Line 4363: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
4364: ame_condition_usages.start_date + ame_util.oneSecond)))
4365: order by condition_type;
4366: tempIndex integer;
4367: begin

Line 4364: ame_condition_usages.start_date + ame_util.oneSecond)))

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,
4364: ame_condition_usages.start_date + ame_util.oneSecond)))
4365: order by condition_type;
4366: tempIndex integer;
4367: begin
4368: tempIndex := 1;

Line 4397: ame_condition_usages

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
4401: ame_condition_usages.condition_id = ame_conditions.condition_id and

Line 4400: ame_condition_usages.rule_id = ruleIdIn and

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
4404: ((sysdate between ame_condition_usages.start_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 4404: ((sysdate between ame_condition_usages.start_date 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,
4408: ame_condition_usages.start_date + ame_util.oneSecond)))

Line 4405: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

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,
4408: ame_condition_usages.start_date + ame_util.oneSecond)))
4409: order by condition_type;

Line 4406: (sysdate < ame_condition_usages.start_date 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,
4408: ame_condition_usages.start_date + ame_util.oneSecond)))
4409: order by condition_type;
4410: tempIndex integer;

Line 4407: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

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,
4408: ame_condition_usages.start_date + ame_util.oneSecond)))
4409: order by condition_type;
4410: tempIndex integer;
4411: begin

Line 4408: ame_condition_usages.start_date + ame_util.oneSecond)))

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,
4408: ame_condition_usages.start_date + ame_util.oneSecond)))
4409: order by condition_type;
4410: tempIndex integer;
4411: begin
4412: tempIndex := 1;

Line 4631: update ame_condition_usages

4627: actionIdListOut => actionIdList);
4628: actionCount := actionIdList.count;
4629: if conditionCount > 0 then
4630: for i in 1..conditionCount loop
4631: update ame_condition_usages
4632: set
4633: last_updated_by = currentUserId,
4634: last_update_date = processingDate,
4635: last_update_login = currentUserId,