DBA Data[Home] [Help]

APPS.AME_RULE_PKG dependencies on AME_CONDITION_PKG

Line 35: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdListIn(i))

31: ordinaryConditionCount := 0;
32: deletedOrdinaryConditionCount := 0;
33: /* get a count of the existing ordinary conditions applied to the rule */
34: for i in 1..conditionIdListIn.count loop
35: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdListIn(i))
36: = ame_util.ordinaryConditionType) then
37: ordinaryConditionCount := (ordinaryConditionCount + 1);
38: end if;
39: end loop;

Line 44: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionId)

40: /* get a count of the deleted ordinary conditions */
41: for i in 1..deletedListIn.count loop
42: if(deletedListIn(i) like 'con%') then
43: conditionId := to_number(substrb(deletedListIn(i),4,(lengthb(deletedListIn(i)))));
44: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionId)
45: = ame_util.ordinaryConditionType) then
46: deletedOrdinaryConditionCount := (deletedOrdinaryConditionCount + 1);
47: end if;
48: end if;

Line 278: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdListIn(i))

274: tempIndex integer;
275: begin
276: tempIndex := 1;
277: for i in 1..conditionIdListIn.count loop
278: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdListIn(i))
279: = ame_util.exceptionConditionType) then
280: mandatoryConditionIdList(tempIndex) := conditionIdListIn(i);
281: tempIndex := (tempIndex + 1);
282: /* there can be multiple exception conditions so keep looping */

Line 1426: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) =

1422: end hasATUsageForRuleType2;
1423: function hasExceptionCondition(conditionIdsIn in ame_util.idList) return boolean as
1424: begin
1425: for i in 1..conditionIdsIn.count loop
1426: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) =
1427: ame_util.exceptionConditionType) then
1428: return(true);
1429: end if;
1430: end loop;

Line 1445: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) =

1441: end hasExceptionCondition;
1442: function hasListModCondition(conditionIdsIn in ame_util.idList) return boolean as
1443: begin
1444: for i in 1..conditionIdsIn.count loop
1445: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) =
1446: ame_util.listMOdConditionType) then
1447: return(true);
1448: end if;
1449: end loop;

Line 1602: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdsIn(i));

1598: conditionIdsIn in ame_util.idList) return boolean as
1599: attributeId integer;
1600: begin
1601: for i in 1..conditionIdsIn.count loop
1602: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdsIn(i));
1603: if(ame_attribute_pkg.getItemClassId(attributeIdIn => attributeId) =
1604: itemClassIdIn) then
1605: return(true);
1606: exit;

Line 4025: tempConditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdList(tempIndex));

4021: conditionListOut := ame_util.emptyStringList;
4022: conditionIdListOut := ame_util.emptyIdList;
4023: else
4024: for tempIndex in 1..upperLimit loop
4025: tempConditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdList(tempIndex));
4026: if(tempConditionType = ame_util.exceptionConditionType) then
4027: tempDescription := 'Exception: ' ||
4028: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4029: elsif(tempConditionType = ame_util.listModConditionType) then

Line 4028: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));

4024: for tempIndex in 1..upperLimit loop
4025: tempConditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdList(tempIndex));
4026: if(tempConditionType = ame_util.exceptionConditionType) then
4027: tempDescription := 'Exception: ' ||
4028: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4029: elsif(tempConditionType = ame_util.listModConditionType) then
4030: tempDescription := 'List Modification: ' ||
4031: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4032: else

Line 4031: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));

4027: tempDescription := 'Exception: ' ||
4028: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4029: elsif(tempConditionType = ame_util.listModConditionType) then
4030: tempDescription := 'List Modification: ' ||
4031: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4032: else
4033: tempDescription :=
4034: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4035: end if;

Line 4034: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));

4030: tempDescription := 'List Modification: ' ||
4031: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4032: else
4033: tempDescription :=
4034: ame_condition_pkg.getDescription(conditionIdIn => conditionIdList(tempIndex));
4035: end if;
4036: conditionListOut(tempIndex) := substrb(tempDescription, 1, 100);
4037: conditionIdListOut(tempIndex) := conditionIdList(tempIndex);
4038: end loop;

Line 4417: ame_condition_pkg.getDescription(conditionIdIn => tempCondition.condition_id);

4413: for tempCondition in conditionCursor(ruleIdIn => ruleIdIn,
4414: conditionTypeIn => conditionTypeIn) loop
4415: conditionIdsOut(tempIndex) := tempCondition.condition_id;
4416: conditionListOut(tempIndex) :=
4417: ame_condition_pkg.getDescription(conditionIdIn => tempCondition.condition_id);
4418: tempIndex := tempIndex + 1;
4419: end loop;
4420: exception
4421: when others then

Line 4459: ame_condition_pkg.removeConditionUsage(ruleIdIn => ruleIdIn,

4455: ame_rule_pkg.getConditionIds(ruleIdIn => ruleIdIn,
4456: conditionIdListOut => conditionIdList);
4457: conditionCount := conditionIdList.count;
4458: for tempIndex in 1..conditionCount loop
4459: ame_condition_pkg.removeConditionUsage(ruleIdIn => ruleIdIn,
4460: conditionIdIn => conditionIdList(tempIndex),
4461: finalizeIn => finalizeIn);
4462: end loop;
4463: currentUserId := ame_util.getCurrentUserId;

Line 4788: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.ordinaryConditionType and

4784: */
4785: /* tempIndex := 0; pre-increment */
4786: /*
4787: for i in 1 .. conditionIdsIn.count loop
4788: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.ordinaryConditionType and
4789: ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType) then
4790: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdsIn(i),
4791: stringValueListOut => stringValues);
4792: if(stringValues.count = 1) then */ /* equality condition, and so possible striping condition */

Line 4789: ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType) then

4785: /* tempIndex := 0; pre-increment */
4786: /*
4787: for i in 1 .. conditionIdsIn.count loop
4788: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.ordinaryConditionType and
4789: ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType) then
4790: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdsIn(i),
4791: stringValueListOut => stringValues);
4792: if(stringValues.count = 1) then */ /* equality condition, and so possible striping condition */
4793: /*

Line 4790: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdsIn(i),

4786: /*
4787: for i in 1 .. conditionIdsIn.count loop
4788: if(ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.ordinaryConditionType and
4789: ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType) then
4790: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdsIn(i),
4791: stringValueListOut => stringValues);
4792: if(stringValues.count = 1) then */ /* equality condition, and so possible striping condition */
4793: /*
4794: tempIndex := tempIndex + 1;

Line 4795: attributeIds(tempIndex) := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdsIn(i));

4791: stringValueListOut => stringValues);
4792: if(stringValues.count = 1) then */ /* equality condition, and so possible striping condition */
4793: /*
4794: tempIndex := tempIndex + 1;
4795: attributeIds(tempIndex) := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdsIn(i));
4796: equalityCondStringValues(tempIndex) := stringValues(1);
4797: end if;
4798: end if;
4799: end loop;