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_STRING_VALUES

Line 111: ame_string_values

107: begin
108: select ame_conditions.condition_id
109: into conditionId
110: from ame_conditions,
111: ame_string_values
112: where
113: ame_conditions.condition_id = ame_string_values.condition_id and
114: ame_conditions.condition_type = ame_util.ordinaryConditionType and
115: ame_conditions.attribute_id = attributeIdIn and

Line 113: ame_conditions.condition_id = ame_string_values.condition_id and

109: into conditionId
110: from ame_conditions,
111: ame_string_values
112: where
113: ame_conditions.condition_id = ame_string_values.condition_id and
114: ame_conditions.condition_type = ame_util.ordinaryConditionType and
115: ame_conditions.attribute_id = attributeIdIn and
116: ame_string_values.string_value = stringValueIn and
117: sysdate between ame_conditions.start_date and

Line 116: ame_string_values.string_value = stringValueIn and

112: where
113: ame_conditions.condition_id = ame_string_values.condition_id and
114: ame_conditions.condition_type = ame_util.ordinaryConditionType and
115: ame_conditions.attribute_id = attributeIdIn and
116: ame_string_values.string_value = stringValueIn and
117: sysdate between ame_conditions.start_date and
118: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
119: sysdate between ame_string_values.start_date and
120: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate) ;

Line 119: sysdate between ame_string_values.start_date and

115: ame_conditions.attribute_id = attributeIdIn and
116: ame_string_values.string_value = stringValueIn and
117: sysdate between ame_conditions.start_date and
118: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
119: sysdate between ame_string_values.start_date and
120: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate) ;
121: return(conditionId);
122: exception
123: when no_data_found then

Line 120: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate) ;

116: ame_string_values.string_value = stringValueIn and
117: sysdate between ame_conditions.start_date and
118: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
119: sysdate between ame_string_values.start_date and
120: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate) ;
121: return(conditionId);
122: exception
123: when no_data_found then
124: return(null);

Line 1332: ame_string_values.string_value

1328: cursor pairCursor(attributeIdIn in integer,
1329: applicationIdIn in integer) is
1330: select
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

Line 1336: ame_string_values

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
1340: ame_string_values.condition_id = ame_condition_usages.condition_id and

Line 1340: ame_string_values.condition_id = ame_condition_usages.condition_id and

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
1344: where

Line 1349: (select count(*) from ame_string_values

1345: attribute_id = attributeIdIn and
1346: */
1347: /* The condition only has one string value. */
1348: /*
1349: (select count(*) from ame_string_values
1350: where
1351: ame_string_values.condition_id = ame_conditions.condition_id and
1352: sysdate between ame_string_values.start_date and
1353: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate)

Line 1351: ame_string_values.condition_id = ame_conditions.condition_id and

1347: /* The condition only has one string value. */
1348: /*
1349: (select count(*) from ame_string_values
1350: where
1351: ame_string_values.condition_id = ame_conditions.condition_id and
1352: sysdate between ame_string_values.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

Line 1352: sysdate between ame_string_values.start_date and

1348: /*
1349: (select count(*) from ame_string_values
1350: where
1351: ame_string_values.condition_id = ame_conditions.condition_id and
1352: sysdate between ame_string_values.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

Line 1353: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate)

1349: (select count(*) from ame_string_values
1350: where
1351: ame_string_values.condition_id = ame_conditions.condition_id and
1352: sysdate between ame_string_values.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

Line 1367: sysdate between ame_string_values.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,
1366: ame_condition_usages.start_date + ame_util.oneSecond))) and
1367: sysdate between ame_string_values.start_date and
1368: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate)
1369: order by rule_id; */
1370: /* The order-by is crucial to 2(B) below. */
1371: /*

Line 1368: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate)

1364: (sysdate < ame_condition_usages.start_date and
1365: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1366: ame_condition_usages.start_date + ame_util.oneSecond))) and
1367: sysdate between ame_string_values.start_date and
1368: nvl(ame_string_values.end_date - ame_util.oneSecond, sysdate)
1369: order by rule_id; */
1370: /* The order-by is crucial to 2(B) below. */
1371: /*
1372: cursor noConditionRuleCursor(attributeIdIn in integer,

Line 1395: from ame_string_values

1391: */
1392: /* The condition only has one string value. */
1393: /*
1394: (select count(*)
1395: from ame_string_values
1396: where
1397: ame_string_values.condition_id = ame_conditions.condition_id and
1398: (ame_string_values.start_date <= sysdate and
1399: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date))) = 1 and

Line 1397: ame_string_values.condition_id = ame_conditions.condition_id and

1393: /*
1394: (select count(*)
1395: from ame_string_values
1396: where
1397: ame_string_values.condition_id = ame_conditions.condition_id and
1398: (ame_string_values.start_date <= sysdate and
1399: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date))) = 1 and
1400: (ame_conditions.start_date <= sysdate and
1401: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))) and

Line 1398: (ame_string_values.start_date <= sysdate and

1394: (select count(*)
1395: from ame_string_values
1396: where
1397: ame_string_values.condition_id = ame_conditions.condition_id and
1398: (ame_string_values.start_date <= sysdate and
1399: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date))) = 1 and
1400: (ame_conditions.start_date <= sysdate and
1401: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))) and
1402: (ru2.start_date <= sysdate and

Line 1399: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date))) = 1 and

1395: from ame_string_values
1396: where
1397: ame_string_values.condition_id = ame_conditions.condition_id and
1398: (ame_string_values.start_date <= sysdate and
1399: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date))) = 1 and
1400: (ame_conditions.start_date <= sysdate and
1401: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))) and
1402: (ru2.start_date <= sysdate and
1403: (ru2.end_date is null or sysdate < ru2.end_date)) and

Line 2559: from ame_string_values sv2

2555: ame_conditions.attribute_id = stripingAttribute3IdIn or
2556: ame_conditions.attribute_id = stripingAttribute4IdIn or
2557: ame_conditions.attribute_id = stripingAttribute5IdIn) and
2558: (select count(*)
2559: from ame_string_values sv2
2560: where sv2.condition_id = ame_conditions.condition_id and
2561: (sv2.start_date <= sysdate and (sv2.end_date is null or sysdate < sv2.end_date))) = 1 and
2562: (ame_conditions.start_date <= sysdate and
2563: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 2579: ame_string_values.string_value

2575: */
2576: /*
2577: select distinct
2578: ame_conditions.condition_id,
2579: ame_string_values.string_value
2580: from
2581: ame_conditions,
2582: ame_condition_usages,
2583: ame_rule_usages,

Line 2584: ame_string_values

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
2588: ame_string_values.condition_id = ame_conditions.condition_id and

Line 2588: ame_string_values.condition_id = ame_conditions.condition_id and

2584: ame_string_values
2585: where
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(*)

Line 2593: from ame_string_values sv2

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
2596: (ame_conditions.start_date <= sysdate and
2597: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

Line 2602: (ame_string_values.start_date <= sysdate 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;
2606: noStripingAttsException exception;

Line 2603: (ame_string_values.end_date is null or sysdate < ame_string_values.end_date));

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;
2606: noStripingAttsException exception;
2607: ruleIds ame_util.idList;