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_ENGINE dependencies on AME_RULES

Line 3203: ame_rules.rule_id rule_id,

3199: productionRulePriorityModeIn in varchar2,
3200: productionRuleThresholdIn in integer,
3201: headerItemClassIdIn in integer) is
3202: select
3203: ame_rules.rule_id rule_id,
3204: nvl(ame_rules.item_class_id,
3205: headerItemClassIdIn) item_class_id,
3206: ame_rules.rule_type rule_type,
3207: ame_rule_usages.priority priority,

Line 3204: nvl(ame_rules.item_class_id,

3200: productionRuleThresholdIn in integer,
3201: headerItemClassIdIn in integer) is
3202: select
3203: ame_rules.rule_id rule_id,
3204: nvl(ame_rules.item_class_id,
3205: headerItemClassIdIn) item_class_id,
3206: ame_rules.rule_type rule_type,
3207: ame_rule_usages.priority priority,
3208: ame_rule_usages.approver_category approver_category

Line 3206: ame_rules.rule_type rule_type,

3202: select
3203: ame_rules.rule_id rule_id,
3204: nvl(ame_rules.item_class_id,
3205: headerItemClassIdIn) item_class_id,
3206: ame_rules.rule_type rule_type,
3207: ame_rule_usages.priority priority,
3208: ame_rule_usages.approver_category approver_category
3209: from
3210: ame_rules,

Line 3210: ame_rules,

3206: ame_rules.rule_type rule_type,
3207: ame_rule_usages.priority priority,
3208: ame_rule_usages.approver_category approver_category
3209: from
3210: ame_rules,
3211: ame_rule_usages,
3212: ame_item_class_usages
3213: where
3214: ame_rules.rule_id = ame_rule_usages.rule_id and

Line 3214: ame_rules.rule_id = ame_rule_usages.rule_id and

3210: ame_rules,
3211: ame_rule_usages,
3212: ame_item_class_usages
3213: where
3214: ame_rules.rule_id = ame_rule_usages.rule_id and
3215: ame_rule_usages.item_id = engAmeApplicationId and
3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3217: ame_item_class_usages.application_id = engAmeApplicationId and
3218: (processPrioritiesIn = ame_util.booleanFalse or

Line 3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and

3212: ame_item_class_usages
3213: where
3214: ame_rules.rule_id = ame_rule_usages.rule_id and
3215: ame_rule_usages.item_id = engAmeApplicationId and
3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3217: ame_item_class_usages.application_id = engAmeApplicationId and
3218: (processPrioritiesIn = ame_util.booleanFalse or
3219: (ame_rules.rule_type = ame_util.combinationRuleType and
3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3219: (ame_rules.rule_type = ame_util.combinationRuleType and

3215: ame_rule_usages.item_id = engAmeApplicationId and
3216: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3217: ame_item_class_usages.application_id = engAmeApplicationId and
3218: (processPrioritiesIn = ame_util.booleanFalse or
3219: (ame_rules.rule_type = ame_util.combinationRuleType and
3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3222: (ame_rules.rule_type = ame_util.authorityRuleType and
3223: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3222: (ame_rules.rule_type = ame_util.authorityRuleType and

3218: (processPrioritiesIn = ame_util.booleanFalse or
3219: (ame_rules.rule_type = ame_util.combinationRuleType and
3220: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3222: (ame_rules.rule_type = ame_util.authorityRuleType and
3223: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3225: (ame_rules.rule_type = ame_util.exceptionRuleType and
3226: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3225: (ame_rules.rule_type = ame_util.exceptionRuleType and

3221: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3222: (ame_rules.rule_type = ame_util.authorityRuleType and
3223: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3225: (ame_rules.rule_type = ame_util.exceptionRuleType and
3226: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3228: (ame_rules.rule_type = ame_util.listModRuleType and
3229: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3228: (ame_rules.rule_type = ame_util.listModRuleType and

3224: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3225: (ame_rules.rule_type = ame_util.exceptionRuleType and
3226: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3228: (ame_rules.rule_type = ame_util.listModRuleType and
3229: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3231: (ame_rules.rule_type = ame_util.substitutionRuleType and
3232: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3231: (ame_rules.rule_type = ame_util.substitutionRuleType and

3227: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3228: (ame_rules.rule_type = ame_util.listModRuleType and
3229: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3231: (ame_rules.rule_type = ame_util.substitutionRuleType and
3232: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3233: substRuleThresholdIn >= ame_rule_usages.priority)) or
3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3235: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and

3230: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3231: (ame_rules.rule_type = ame_util.substitutionRuleType and
3232: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3233: substRuleThresholdIn >= ame_rule_usages.priority)) or
3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3235: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3236: preRuleThresholdIn >= ame_rule_usages.priority)) or
3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3238: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and

3233: substRuleThresholdIn >= ame_rule_usages.priority)) or
3234: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3235: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3236: preRuleThresholdIn >= ame_rule_usages.priority)) or
3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3238: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3239: postRuleThresholdIn >= ame_rule_usages.priority)) or
3240: (ame_rules.rule_type = ame_util.productionRuleType and
3241: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3240: (ame_rules.rule_type = ame_util.productionRuleType and

3236: preRuleThresholdIn >= ame_rule_usages.priority)) or
3237: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3238: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3239: postRuleThresholdIn >= ame_rule_usages.priority)) or
3240: (ame_rules.rule_type = ame_util.productionRuleType and
3241: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3242: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3243: (processProductionRulesIn = ame_util.booleanTrue or
3244: ame_rules.rule_type <> ame_util.productionRuleType) and

Line 3244: ame_rules.rule_type <> ame_util.productionRuleType) and

3240: (ame_rules.rule_type = ame_util.productionRuleType and
3241: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3242: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3243: (processProductionRulesIn = ame_util.booleanTrue or
3244: ame_rules.rule_type <> ame_util.productionRuleType) and
3245: not exists (select *
3246: from
3247: ame_conditions,
3248: ame_condition_usages

Line 3252: ame_condition_usages.rule_id = ame_rules.rule_id and

3248: ame_condition_usages
3249: where
3250: ame_conditions.condition_type <> ame_util.listModConditionType and
3251: ame_conditions.condition_id = ame_condition_usages.condition_id and
3252: ame_condition_usages.rule_id = ame_rules.rule_id and
3253: engEffectiveRuleDate between
3254: ame_conditions.start_date and
3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3256: engEffectiveRuleDate between

Line 3262: ame_rules.start_date and

3258: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3259: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3260: rownum < 2) and
3261: engEffectiveRuleDate between
3262: ame_rules.start_date and
3263: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3264: engEffectiveRuleDate between
3265: ame_rule_usages.start_date and
3266: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3263: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3259: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3260: rownum < 2) and
3261: engEffectiveRuleDate between
3262: ame_rules.start_date and
3263: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3264: engEffectiveRuleDate between
3265: ame_rule_usages.start_date and
3266: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3267: engEffectiveRuleDate between

Line 3273: ame_rules.rule_type,

3269: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3270: order by
3271: ame_item_class_usages.item_class_order_number,
3272: item_class_id,
3273: ame_rules.rule_type,
3274: ame_rules.rule_id;
3275: conditionlessItemClassIds ame_util.idList;
3276: conditionlessRuleApprCats ame_util.charList;
3277: conditionlessRuleIds ame_util.idList;

Line 3274: ame_rules.rule_id;

3270: order by
3271: ame_item_class_usages.item_class_order_number,
3272: item_class_id,
3273: ame_rules.rule_type,
3274: ame_rules.rule_id;
3275: conditionlessItemClassIds ame_util.idList;
3276: conditionlessRuleApprCats ame_util.charList;
3277: conditionlessRuleIds ame_util.idList;
3278: conditionlessRulePriorities ame_util.idList;

Line 3541: ame_rules.rule_type rule_type,

3537: ame_conditions.parameter_three parameter_three,
3538: ame_conditions.include_lower_limit,
3539: ame_conditions.include_upper_limit,
3540: ame_condition_usages.rule_id rule_id,
3541: ame_rules.rule_type rule_type,
3542: nvl(ame_rules.item_class_id,
3543: headerItemClassIdIn) rule_item_class,
3544: ame_rule_usages.priority priority,
3545: ame_rule_usages.approver_category

Line 3542: nvl(ame_rules.item_class_id,

3538: ame_conditions.include_lower_limit,
3539: ame_conditions.include_upper_limit,
3540: ame_condition_usages.rule_id rule_id,
3541: ame_rules.rule_type rule_type,
3542: nvl(ame_rules.item_class_id,
3543: headerItemClassIdIn) rule_item_class,
3544: ame_rule_usages.priority priority,
3545: ame_rule_usages.approver_category
3546: from

Line 3550: ame_rules,

3546: from
3547: ame_attributes,
3548: ame_conditions,
3549: ame_condition_usages,
3550: ame_rules,
3551: ame_rule_usages
3552: where
3553: ame_attributes.attribute_id = ame_conditions.attribute_id and
3554: ame_conditions.condition_type <> ame_util.listModConditionType and

Line 3556: ame_condition_usages.rule_id = ame_rules.rule_id and

3552: where
3553: ame_attributes.attribute_id = ame_conditions.attribute_id and
3554: ame_conditions.condition_type <> ame_util.listModConditionType and
3555: ame_conditions.condition_id = ame_condition_usages.condition_id and
3556: ame_condition_usages.rule_id = ame_rules.rule_id and
3557: ame_rules.rule_id = ame_rule_usages.rule_id and
3558: ame_rule_usages.item_id = engAmeApplicationId and
3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and

Line 3557: ame_rules.rule_id = ame_rule_usages.rule_id and

3553: ame_attributes.attribute_id = ame_conditions.attribute_id and
3554: ame_conditions.condition_type <> ame_util.listModConditionType and
3555: ame_conditions.condition_id = ame_condition_usages.condition_id and
3556: ame_condition_usages.rule_id = ame_rules.rule_id and
3557: ame_rules.rule_id = ame_rule_usages.rule_id and
3558: ame_rule_usages.item_id = engAmeApplicationId and
3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and
3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3560: (ame_rules.rule_type = ame_util.combinationRuleType and

3556: ame_condition_usages.rule_id = ame_rules.rule_id and
3557: ame_rules.rule_id = ame_rule_usages.rule_id and
3558: ame_rule_usages.item_id = engAmeApplicationId and
3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and
3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3563: (ame_rules.rule_type = ame_util.authorityRuleType and
3564: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3563: (ame_rules.rule_type = ame_util.authorityRuleType and

3559: (processPrioritiesIn = ame_util.booleanFalse or
3560: (ame_rules.rule_type = ame_util.combinationRuleType and
3561: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3563: (ame_rules.rule_type = ame_util.authorityRuleType and
3564: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3566: (ame_rules.rule_type = ame_util.exceptionRuleType and
3567: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3566: (ame_rules.rule_type = ame_util.exceptionRuleType and

3562: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3563: (ame_rules.rule_type = ame_util.authorityRuleType and
3564: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3566: (ame_rules.rule_type = ame_util.exceptionRuleType and
3567: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3569: (ame_rules.rule_type = ame_util.listModRuleType and
3570: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3569: (ame_rules.rule_type = ame_util.listModRuleType and

3565: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3566: (ame_rules.rule_type = ame_util.exceptionRuleType and
3567: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3569: (ame_rules.rule_type = ame_util.listModRuleType and
3570: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3572: (ame_rules.rule_type = ame_util.substitutionRuleType and
3573: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3572: (ame_rules.rule_type = ame_util.substitutionRuleType and

3568: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3569: (ame_rules.rule_type = ame_util.listModRuleType and
3570: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3572: (ame_rules.rule_type = ame_util.substitutionRuleType and
3573: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3574: substRuleThresholdIn >= ame_rule_usages.priority)) or
3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3576: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and

3571: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3572: (ame_rules.rule_type = ame_util.substitutionRuleType and
3573: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3574: substRuleThresholdIn >= ame_rule_usages.priority)) or
3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3576: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3577: preRuleThresholdIn >= ame_rule_usages.priority)) or
3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3579: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and

3574: substRuleThresholdIn >= ame_rule_usages.priority)) or
3575: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3576: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3577: preRuleThresholdIn >= ame_rule_usages.priority)) or
3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3579: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3580: postRuleThresholdIn >= ame_rule_usages.priority)) or
3581: (ame_rules.rule_type = ame_util.productionRuleType and
3582: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or

Line 3581: (ame_rules.rule_type = ame_util.productionRuleType and

3577: preRuleThresholdIn >= ame_rule_usages.priority)) or
3578: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3579: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3580: postRuleThresholdIn >= ame_rule_usages.priority)) or
3581: (ame_rules.rule_type = ame_util.productionRuleType and
3582: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3583: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3584: (processProductionRulesIn = ame_util.booleanTrue or
3585: ame_rules.rule_type <> ame_util.productionRuleType) and

Line 3585: ame_rules.rule_type <> ame_util.productionRuleType) and

3581: (ame_rules.rule_type = ame_util.productionRuleType and
3582: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3583: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3584: (processProductionRulesIn = ame_util.booleanTrue or
3585: ame_rules.rule_type <> ame_util.productionRuleType) and
3586: engEffectiveRuleDate between
3587: ame_attributes.start_date and
3588: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3589: engEffectiveRuleDate between

Line 3596: ame_rules.start_date and

3592: engEffectiveRuleDate between
3593: ame_condition_usages.start_date and
3594: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3595: engEffectiveRuleDate between
3596: ame_rules.start_date and
3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3598: engEffectiveRuleDate between
3599: ame_rule_usages.start_date and
3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

Line 3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3593: ame_condition_usages.start_date and
3594: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3595: engEffectiveRuleDate between
3596: ame_rules.start_date and
3597: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3598: engEffectiveRuleDate between
3599: ame_rule_usages.start_date and
3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3601: order by

Line 3603: ame_rules.rule_type,

3599: ame_rule_usages.start_date and
3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3601: order by
3602: rule_item_class,
3603: ame_rules.rule_type,
3604: ame_rules.rule_id,
3605: ame_attributes.item_class_id;
3606: /*
3607: The tempACU tables are buffers between the active-condition-usage fetch and

Line 3604: ame_rules.rule_id,

3600: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3601: order by
3602: rule_item_class,
3603: ame_rules.rule_type,
3604: ame_rules.rule_id,
3605: ame_attributes.item_class_id;
3606: /*
3607: The tempACU tables are buffers between the active-condition-usage fetch and
3608: the engAC variables. The temp variables are indexed consecutively, while

Line 4387: ame_rules,

4383: (
4384: select 1
4385: from ame_conditions,
4386: ame_condition_usages,
4387: ame_rules,
4388: ame_rule_usages
4389: where ame_conditions.attribute_id = ame_attributes.attribute_id
4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id

Line 4391: and ame_condition_usages.rule_id = ame_rules.rule_id

4387: ame_rules,
4388: ame_rule_usages
4389: where ame_conditions.attribute_id = ame_attributes.attribute_id
4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4392: and ame_rules.rule_id = ame_rule_usages.rule_id

4388: ame_rule_usages
4389: where ame_conditions.attribute_id = ame_attributes.attribute_id
4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date

Line 4394: and ((engEffectiveRuleDate between ame_rules.start_date

4390: and ame_conditions.condition_id = ame_condition_usages.condition_id
4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4397: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4398: and engEffectiveRuleDate between ame_conditions.start_date

Line 4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

4391: and ame_condition_usages.rule_id = ame_rules.rule_id
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn
4394: and ((engEffectiveRuleDate between ame_rules.start_date
4395: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4396: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4397: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4398: and engEffectiveRuleDate between ame_conditions.start_date
4399: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)

Line 4407: ame_rules,

4403: select 1
4404: from ame_mandatory_attributes,
4405: ame_actions,
4406: ame_action_usages,
4407: ame_rules,
4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id

Line 4413: and ame_action_usages.rule_id = ame_rules.rule_id

4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4414: and ame_rules.rule_id = ame_rule_usages.rule_id

4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date

Line 4416: and ((engEffectiveRuleDate between ame_rules.start_date

4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date

Line 4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)

Line 7355: tempRuleKey ame_rules.rule_key%type;

7351: parameterTwoOut out nocopy varchar2) as
7352: errorCode integer;
7353: errorMessage ame_util.longestStringType;
7354: invalidNameException exception;
7355: tempRuleKey ame_rules.rule_key%type;
7356: parameterOne ame_conditions.parameter_one%type;
7357: parameterTwo ame_conditions.parameter_two%type;
7358: begin
7359: /* Checked for cached values. */