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_ADMIN_PKG dependencies on AME_RULE_USAGES

Line 246: ame_rule_usages,

242: begin
243: select count(*)
244: into ruleCount
245: from ame_rules,
246: ame_rule_usages,
247: ame_rule_stripe_sets
248: where
249: ame_rule_usages.item_id = applicationIdIn and
250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and

Line 249: ame_rule_usages.item_id = applicationIdIn and

245: from ame_rules,
246: ame_rule_usages,
247: ame_rule_stripe_sets
248: where
249: ame_rule_usages.item_id = applicationIdIn and
250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and
251: ame_rules.rule_id = ame_rule_usages.rule_id and
252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and
253: (ame_rule_stripe_sets.end_date is null or sysdate < ame_rule_stripe_sets.end_date) and

Line 251: ame_rules.rule_id = ame_rule_usages.rule_id and

247: ame_rule_stripe_sets
248: where
249: ame_rule_usages.item_id = applicationIdIn and
250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and
251: ame_rules.rule_id = ame_rule_usages.rule_id and
252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and
253: (ame_rule_stripe_sets.end_date is null or sysdate < ame_rule_stripe_sets.end_date) and
254: (ame_rules.end_date is null or sysdate < ame_rules.end_date);
255: return(ruleCount);

Line 252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and

248: where
249: ame_rule_usages.item_id = applicationIdIn and
250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and
251: ame_rules.rule_id = ame_rule_usages.rule_id and
252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and
253: (ame_rule_stripe_sets.end_date is null or sysdate < ame_rule_stripe_sets.end_date) and
254: (ame_rules.end_date is null or sysdate < ame_rules.end_date);
255: return(ruleCount);
256: exception

Line 776: ame_rule_usages,

772: begin
773: select count(*)
774: into ruleUsageCount
775: from
776: ame_rule_usages,
777: ame_rules
778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and

Line 779: ame_rule_usages.rule_id = ame_rules.rule_id and

775: from
776: ame_rule_usages,
777: ame_rules
778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and

Line 780: ame_rule_usages.item_id = applicationIdIn and

776: ame_rule_usages,
777: ame_rules
778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and
784: sysdate between ame_rules.start_date and

Line 782: sysdate between ame_rule_usages.start_date and

778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and
784: sysdate between ame_rules.start_date and
785: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate);
786: if(ruleUsageCount > 0) then

Line 783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and

779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and
784: sysdate between ame_rules.start_date and
785: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate);
786: if(ruleUsageCount > 0) then
787: return(true);

Line 1335: ame_rule_usages,

1331: ame_condition_usages.rule_id,
1332: ame_string_values.string_value
1333: from
1334: ame_condition_usages,
1335: ame_rule_usages,
1336: ame_string_values
1337: where
1338: ame_rule_usages.item_id = applicationIdIn and
1339: ame_rule_usages.rule_id = ame_condition_usages.rule_id and

Line 1338: ame_rule_usages.item_id = applicationIdIn and

1334: ame_condition_usages,
1335: ame_rule_usages,
1336: ame_string_values
1337: where
1338: ame_rule_usages.item_id = applicationIdIn and
1339: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
1340: ame_string_values.condition_id = ame_condition_usages.condition_id and
1341: ame_condition_usages.condition_id in
1342: (select condition_id

Line 1339: ame_rule_usages.rule_id = ame_condition_usages.rule_id and

1335: ame_rule_usages,
1336: ame_string_values
1337: where
1338: ame_rule_usages.item_id = applicationIdIn and
1339: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
1340: ame_string_values.condition_id = ame_condition_usages.condition_id and
1341: ame_condition_usages.condition_id in
1342: (select condition_id
1343: from ame_conditions

Line 1357: ((sysdate between ame_rule_usages.start_date and

1353: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate)
1354: ) = 1 and
1355: sysdate between ame_conditions.start_date and
1356: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1357: ((sysdate between ame_rule_usages.start_date and
1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1359: (sysdate < ame_rule_usages.start_date and
1360: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1361: ame_rule_usages.start_date + ame_util.oneSecond))) and

Line 1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

1354: ) = 1 and
1355: sysdate between ame_conditions.start_date and
1356: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1357: ((sysdate between ame_rule_usages.start_date and
1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1359: (sysdate < ame_rule_usages.start_date and
1360: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1361: ame_rule_usages.start_date + ame_util.oneSecond))) and
1362: ((sysdate between ame_condition_usages.start_date and

Line 1359: (sysdate < ame_rule_usages.start_date and

1355: sysdate between ame_conditions.start_date and
1356: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1357: ((sysdate between ame_rule_usages.start_date and
1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1359: (sysdate < ame_rule_usages.start_date and
1360: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1361: ame_rule_usages.start_date + ame_util.oneSecond))) and
1362: ((sysdate between ame_condition_usages.start_date and
1363: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 1360: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

1356: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) and
1357: ((sysdate between ame_rule_usages.start_date and
1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1359: (sysdate < ame_rule_usages.start_date and
1360: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1361: ame_rule_usages.start_date + ame_util.oneSecond))) and
1362: ((sysdate between ame_condition_usages.start_date and
1363: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1364: (sysdate < ame_condition_usages.start_date and

Line 1361: ame_rule_usages.start_date + ame_util.oneSecond))) and

1357: ((sysdate between ame_rule_usages.start_date and
1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1359: (sysdate < ame_rule_usages.start_date and
1360: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1361: ame_rule_usages.start_date + ame_util.oneSecond))) and
1362: ((sysdate between ame_condition_usages.start_date and
1363: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1364: (sysdate < ame_condition_usages.start_date and
1365: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

Line 1375: from ame_rule_usages

1371: /*
1372: cursor noConditionRuleCursor(attributeIdIn in integer,
1373: applicationIdIn in integer) is
1374: select rule_id
1375: from ame_rule_usages
1376: where
1377: item_id = applicationIdIn and
1378: rule_id not in
1379: (select ame_condition_usages.rule_id

Line 1382: ame_rule_usages ru2

1378: rule_id not in
1379: (select ame_condition_usages.rule_id
1380: from
1381: ame_condition_usages,
1382: ame_rule_usages ru2
1383: where
1384: ru2.item_id = applicationIdIn and
1385: ru2.rule_id = ame_condition_usages.rule_id and
1386: ame_condition_usages.condition_id in

Line 1406: (ame_rule_usages.start_date <= sysdate and

1402: (ru2.start_date <= sysdate and
1403: (ru2.end_date is null or sysdate < ru2.end_date)) and
1404: (ame_condition_usages.start_date <= sysdate and
1405: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date))) and
1406: (ame_rule_usages.start_date <= sysdate and
1407: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));
1408: cursor oldRuleStripeSetCursor(ruleIdIn in integer,
1409: applicationIdIn in integer,
1410: stripeSetDateIn in date) is

Line 1407: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));

1403: (ru2.end_date is null or sysdate < ru2.end_date)) and
1404: (ame_condition_usages.start_date <= sysdate and
1405: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date))) and
1406: (ame_rule_usages.start_date <= sysdate and
1407: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date));
1408: cursor oldRuleStripeSetCursor(ruleIdIn in integer,
1409: applicationIdIn in integer,
1410: stripeSetDateIn in date) is
1411: select

Line 2527: from ame_rule_usages

2523: */
2524: /* This cursor fetches the IDs of all rules used by the input transaction type. */
2525: /*
2526: select rule_id
2527: from ame_rule_usages
2528: where
2529: item_id = applicationIdIn and
2530: (start_date <= sysdate and (end_date is null or sysdate < end_date));
2531: */

Line 2583: ame_rule_usages,

2579: ame_string_values.string_value
2580: from
2581: ame_conditions,
2582: ame_condition_usages,
2583: ame_rule_usages,
2584: ame_string_values
2585: where
2586: ame_conditions.attribute_id = stripingAttributeIdIn and
2587: ame_conditions.condition_type = ame_util.ordinaryConditionType and

Line 2590: ame_condition_usages.rule_id = ame_rule_usages.rule_id and

2586: ame_conditions.attribute_id = stripingAttributeIdIn and
2587: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2588: ame_string_values.condition_id = ame_conditions.condition_id and
2589: ame_condition_usages.condition_id = ame_conditions.condition_id and
2590: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
2591: ame_rule_usages.item_id = applicationIdIn and
2592: (select count(*)
2593: from ame_string_values sv2
2594: where sv2.condition_id = ame_conditions.condition_id and

Line 2591: ame_rule_usages.item_id = applicationIdIn and

2587: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2588: ame_string_values.condition_id = ame_conditions.condition_id and
2589: ame_condition_usages.condition_id = ame_conditions.condition_id and
2590: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
2591: ame_rule_usages.item_id = applicationIdIn and
2592: (select count(*)
2593: from ame_string_values sv2
2594: where sv2.condition_id = ame_conditions.condition_id and
2595: (sv2.start_date <= sysdate and (sv2.end_date is null or sysdate < sv2.end_date))) = 1 and

Line 2600: (ame_rule_usages.start_date <= sysdate and

2596: (ame_conditions.start_date <= sysdate and
2597: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
2598: (ame_condition_usages.start_date <= sysdate and
2599: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date)) and
2600: (ame_rule_usages.start_date <= sysdate and
2601: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
2602: (ame_string_values.start_date <= sysdate and
2603: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date));
2604: errorCode integer;

Line 2601: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and

2597: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and
2598: (ame_condition_usages.start_date <= sysdate and
2599: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date)) and
2600: (ame_rule_usages.start_date <= sysdate and
2601: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
2602: (ame_string_values.start_date <= sysdate and
2603: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date));
2604: errorCode integer;
2605: errorMessage ame_util.longStringType;

Line 5334: from ame_rule_usages rule

5330: for update;
5331: cursor ruleUsageCursor(applicationIdIn in integer) is
5332: select rule.rule_id rule_id,
5333: start_date
5334: from ame_rule_usages rule
5335: where
5336: item_id = applicationIdIn and
5337: sysdate between start_date and
5338: nvl(end_date - ame_util.oneSecond, sysdate) ;