APPS.AME_RULE_PKG dependencies on AME_ADMIN_PKG

Line 1246: ame_admin_pkg.getItemClassIdByName(itemClassNameIn =>

1242: headerItemClassId integer;
1243: itemIds ame_util.idList;
1244: begin
1245: headerItemClassId :=
1246: ame_admin_pkg.getItemClassIdByName(itemClassNameIn =>
1247: ame_util.headerItemClassName);
1248: open getSubItemClassIdCur(ruleIdIn => ruleIdIn,
1249: headerItemClassIdIn => headerItemClassId);
1250: fetch getSubItemClassIdCur bulk collect

Line 1918: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then

1914: endDateToInsert);
1915: end loop;
1916: /*
1917: AME_STRIPING
1918: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then
1919: updateRuleStripeSets(applicationIdIn => applicationIdIn,
1920: ruleIdIn => ruleId,
1921: conditionIdsIn => conditionIdsIn);
1922: end if;

Line 2060: ame_admin_pkg.updateStripingAttUseCount(applicationIdIn => applicationIdIn);

2056: currentUserId,
2057: null,
2058: sysdate,
2059: null);
2060: ame_admin_pkg.updateStripingAttUseCount(applicationIdIn => applicationIdIn);
2061: commit;
2062: exception
2063: when others then
2064: rollback;

Line 2740: ame_admin_pkg.getItemClassIdByName(itemClassNameIn =>

2736: headerItemClassId integer;
2737: tempCount integer;
2738: begin
2739: headerItemClassId :=
2740: ame_admin_pkg.getItemClassIdByName(itemClassNameIn =>
2741: ame_util.headerItemClassName);
2742: select count(*)
2743: into tempCount
2744: from ame_conditions,

Line 3572: ame_admin_pkg.checkStripeSetUsage(stripeSetIdIn => stripeSetId,

3568: rule_id = ruleIdIn and
3569: stripe_set_id = stripeSetId and
3570: (start_date <= sysdate and
3571: (end_date is null or sysdate < end_date));
3572: ame_admin_pkg.checkStripeSetUsage(stripeSetIdIn => stripeSetId,
3573: finalizeIn => false);
3574: if(finalizeIn) then
3575: commit;
3576: end if;

Line 3934: ame_admin_pkg.getTransTypeItemClassIds(applicationIdIn => applicationIdIn,

3930: order by r.description;
3931: itemClassIds ame_util.idList;
3932: tempIndex integer;
3933: begin
3934: ame_admin_pkg.getTransTypeItemClassIds(applicationIdIn => applicationIdIn,
3935: itemClassIdsOut => itemClassIds);
3936: tempIndex := 1;
3937: for i in 1 .. itemClassIds.count loop
3938: for tempRule in ruleCursor(applicationIdToShareIn => applicationIdToShareIn,

Line 4669: if(ame_admin_pkg.isStripingOn(applicationIdIn => itemIdIn)) then

4665: finalizeIn => false,
4666: processingDateIn => processingDateIn);
4667: /*
4668: AME_STRIPING
4669: if(ame_admin_pkg.isStripingOn(applicationIdIn => itemIdIn)) then
4670: dropRuleStripeSet(ruleIdIn => ruleIdIn,
4671: applicationIdIn => itemIdIn);
4672: ame_admin_pkg.updateStripingAttUseCount(applicationIdIn => itemIdIn);
4673: end if;

Line 4672: ame_admin_pkg.updateStripingAttUseCount(applicationIdIn => itemIdIn);

4668: AME_STRIPING
4669: if(ame_admin_pkg.isStripingOn(applicationIdIn => itemIdIn)) then
4670: dropRuleStripeSet(ruleIdIn => ruleIdIn,
4671: applicationIdIn => itemIdIn);
4672: ame_admin_pkg.updateStripingAttUseCount(applicationIdIn => itemIdIn);
4673: end if;
4674: */
4675: else
4676: update ame_rules

Line 4801: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then

4797: end if;
4798: end if;
4799: end loop;
4800: for i in 1 .. applicationIds.count loop
4801: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then
4802: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,
4803: stripingAttributeIdsOut => stripingAttributeIds);
4804: stripingAttributeCount := stripingAttributeIds.count; */
4805: /* Initialize the striping-attribute values to the wildcard. */

Line 4802: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,

4798: end if;
4799: end loop;
4800: for i in 1 .. applicationIds.count loop
4801: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then
4802: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,
4803: stripingAttributeIdsOut => stripingAttributeIds);
4804: stripingAttributeCount := stripingAttributeIds.count; */
4805: /* Initialize the striping-attribute values to the wildcard. */
4806: /*

Line 4842: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,

4838: applicationIdIn => applicationIdIn);
4839: */
4840: /* Add the rule to its new stripe set, creating that stripe set if needed. */
4841: /*
4842: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
4843: attributeValuesIn => stripingAttributeValues);
4844: if(tempStripeSetId is null) then
4845: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
4846: attributeValuesIn => stripingAttributeValues);

Line 4845: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,

4841: /*
4842: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
4843: attributeValuesIn => stripingAttributeValues);
4844: if(tempStripeSetId is null) then
4845: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
4846: attributeValuesIn => stripingAttributeValues);
4847: end if;
4848: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,
4849: ruleIdIn => ruleIdIn,