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_CONDITIONS

Line 106: conditionId ame_conditions.condition_id%type;

102: end doesStripeSetIdExist;
103: */
104: function getEqualityConditionId(attributeIdIn in integer,
105: stringValueIn in varchar2) return integer as
106: conditionId ame_conditions.condition_id%type;
107: begin
108: select ame_conditions.condition_id
109: into conditionId
110: from ame_conditions,

Line 108: select ame_conditions.condition_id

104: function getEqualityConditionId(attributeIdIn in integer,
105: stringValueIn in varchar2) return integer as
106: conditionId ame_conditions.condition_id%type;
107: begin
108: select ame_conditions.condition_id
109: into conditionId
110: from ame_conditions,
111: ame_string_values
112: where

Line 110: from ame_conditions,

106: conditionId ame_conditions.condition_id%type;
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

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 114: ame_conditions.condition_type = ame_util.ordinaryConditionType and

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
118: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 115: ame_conditions.attribute_id = attributeIdIn and

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
118: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
119: sysdate between ame_string_values.start_date and

Line 117: sysdate between ame_conditions.start_date and

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) ;
121: return(conditionId);

Line 118: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) 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) ;
121: return(conditionId);
122: exception

Line 1343: from ame_conditions

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
1345: attribute_id = attributeIdIn and
1346: */
1347: /* The condition only has one string value. */

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 1355: sysdate between ame_conditions.start_date and

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
1358: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1359: (sysdate < ame_rule_usages.start_date and

Line 1356: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)) 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
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,

Line 1388: from ame_conditions

1384: ru2.item_id = applicationIdIn and
1385: ru2.rule_id = ame_condition_usages.rule_id and
1386: ame_condition_usages.condition_id in
1387: (select condition_id
1388: from ame_conditions
1389: where
1390: attribute_id = attributeIdIn and
1391: */
1392: /* The condition only has one string value. */

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 1400: (ame_conditions.start_date <= sysdate and

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
1404: (ame_condition_usages.start_date <= sysdate and

Line 1401: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))) and

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
1404: (ame_condition_usages.start_date <= sysdate and
1405: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date))) and

Line 2544: ame_conditions.attribute_id,

2540: stripingAttribute3IdIn in integer,
2541: stripingAttribute4IdIn in integer,
2542: stripingAttribute5IdIn in integer) is
2543: select
2544: ame_conditions.attribute_id,
2545: ame_conditions.condition_id
2546: from
2547: ame_conditions,
2548: ame_condition_usages

Line 2545: ame_conditions.condition_id

2541: stripingAttribute4IdIn in integer,
2542: stripingAttribute5IdIn in integer) is
2543: select
2544: ame_conditions.attribute_id,
2545: ame_conditions.condition_id
2546: from
2547: ame_conditions,
2548: ame_condition_usages
2549: where

Line 2547: ame_conditions,

2543: select
2544: ame_conditions.attribute_id,
2545: ame_conditions.condition_id
2546: from
2547: ame_conditions,
2548: ame_condition_usages
2549: where
2550: ame_condition_usages.rule_id = ruleIdIn and
2551: ame_condition_usages.condition_id = ame_conditions.condition_id and

Line 2551: ame_condition_usages.condition_id = ame_conditions.condition_id and

2547: ame_conditions,
2548: ame_condition_usages
2549: where
2550: ame_condition_usages.rule_id = ruleIdIn and
2551: ame_condition_usages.condition_id = ame_conditions.condition_id and
2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
2555: ame_conditions.attribute_id = stripingAttribute3IdIn or

Line 2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and

2548: ame_condition_usages
2549: where
2550: ame_condition_usages.rule_id = ruleIdIn and
2551: ame_condition_usages.condition_id = ame_conditions.condition_id and
2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
2555: ame_conditions.attribute_id = stripingAttribute3IdIn or
2556: ame_conditions.attribute_id = stripingAttribute4IdIn or

Line 2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or

2549: where
2550: ame_condition_usages.rule_id = ruleIdIn and
2551: ame_condition_usages.condition_id = ame_conditions.condition_id and
2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
2555: ame_conditions.attribute_id = stripingAttribute3IdIn or
2556: ame_conditions.attribute_id = stripingAttribute4IdIn or
2557: ame_conditions.attribute_id = stripingAttribute5IdIn) and

Line 2554: ame_conditions.attribute_id = stripingAttribute2IdIn or

2550: ame_condition_usages.rule_id = ruleIdIn and
2551: ame_condition_usages.condition_id = ame_conditions.condition_id and
2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
2555: ame_conditions.attribute_id = stripingAttribute3IdIn or
2556: ame_conditions.attribute_id = stripingAttribute4IdIn or
2557: ame_conditions.attribute_id = stripingAttribute5IdIn) and
2558: (select count(*)

Line 2555: ame_conditions.attribute_id = stripingAttribute3IdIn or

2551: ame_condition_usages.condition_id = ame_conditions.condition_id and
2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
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

Line 2556: ame_conditions.attribute_id = stripingAttribute4IdIn or

2552: ame_conditions.condition_type = ame_util.ordinaryConditionType and
2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
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

Line 2557: ame_conditions.attribute_id = stripingAttribute5IdIn) and

2553: (ame_conditions.attribute_id = stripingAttribute1IdIn or
2554: ame_conditions.attribute_id = stripingAttribute2IdIn or
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

Line 2560: where sv2.condition_id = ame_conditions.condition_id and

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
2564: (ame_condition_usages.start_date <= sysdate and

Line 2562: (ame_conditions.start_date <= sysdate 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
2564: (ame_condition_usages.start_date <= sysdate and
2565: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date));
2566: cursor stripingConditionCursor(applicationIdIn in integer,

Line 2563: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

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
2564: (ame_condition_usages.start_date <= sysdate and
2565: (ame_condition_usages.end_date is null or sysdate < ame_condition_usages.end_date));
2566: cursor stripingConditionCursor(applicationIdIn in integer,
2567: stripingAttributeIdIn in integer) is

Line 2578: ame_conditions.condition_id,

2574: several rule usages can reference the same condition ID.
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,

Line 2581: ame_conditions,

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,
2584: ame_string_values
2585: where

Line 2586: ame_conditions.attribute_id = stripingAttributeIdIn and

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
2589: ame_condition_usages.condition_id = ame_conditions.condition_id and
2590: ame_condition_usages.rule_id = ame_rule_usages.rule_id and

Line 2587: ame_conditions.condition_type = ame_util.ordinaryConditionType and

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
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

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

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(*)
2593: from ame_string_values sv2

Line 2594: where sv2.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
2598: (ame_condition_usages.start_date <= sysdate and

Line 2596: (ame_conditions.start_date <= sysdate 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
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

Line 2597: (ame_conditions.end_date is null or sysdate < ame_conditions.end_date)) and

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
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

Line 4834: newConditionId ame_conditions.condition_id%type;

4830: indexToWrite integer;
4831: insertRow boolean;
4832: lastStripeSetId integer;
4833: lastStripingAttValues ame_util.stringList;
4834: newConditionId ame_conditions.condition_id%type;
4835: noAttributeMatchException exception;
4836: ruleIds ame_util.idList;
4837: stringValueList ame_util.longestStringList;
4838: stripeSetIds ame_util.idList;