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 3243: ame_rules.rule_id rule_id,

3239: productionRulePriorityModeIn in varchar2,
3240: productionRuleThresholdIn in integer,
3241: headerItemClassIdIn in integer) is
3242: select
3243: ame_rules.rule_id rule_id,
3244: nvl(ame_rules.item_class_id,
3245: headerItemClassIdIn) item_class_id,
3246: ame_rules.rule_type rule_type,
3247: ame_rule_usages.priority priority,

Line 3244: nvl(ame_rules.item_class_id,

3240: productionRuleThresholdIn in integer,
3241: headerItemClassIdIn in integer) is
3242: select
3243: ame_rules.rule_id rule_id,
3244: nvl(ame_rules.item_class_id,
3245: headerItemClassIdIn) item_class_id,
3246: ame_rules.rule_type rule_type,
3247: ame_rule_usages.priority priority,
3248: ame_rule_usages.approver_category approver_category

Line 3246: ame_rules.rule_type rule_type,

3242: select
3243: ame_rules.rule_id rule_id,
3244: nvl(ame_rules.item_class_id,
3245: headerItemClassIdIn) item_class_id,
3246: ame_rules.rule_type rule_type,
3247: ame_rule_usages.priority priority,
3248: ame_rule_usages.approver_category approver_category
3249: from
3250: ame_rules,

Line 3250: ame_rules,

3246: ame_rules.rule_type rule_type,
3247: ame_rule_usages.priority priority,
3248: ame_rule_usages.approver_category approver_category
3249: from
3250: ame_rules,
3251: ame_rule_usages,
3252: ame_item_class_usages
3253: where
3254: ame_rules.rule_id = ame_rule_usages.rule_id and

Line 3254: ame_rules.rule_id = ame_rule_usages.rule_id and

3250: ame_rules,
3251: ame_rule_usages,
3252: ame_item_class_usages
3253: where
3254: ame_rules.rule_id = ame_rule_usages.rule_id and
3255: ame_rule_usages.item_id = engAmeApplicationId and
3256: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3257: ame_item_class_usages.application_id = engAmeApplicationId and
3258: (processPrioritiesIn = ame_util.booleanFalse or

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

3252: ame_item_class_usages
3253: where
3254: ame_rules.rule_id = ame_rule_usages.rule_id and
3255: ame_rule_usages.item_id = engAmeApplicationId and
3256: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3257: ame_item_class_usages.application_id = engAmeApplicationId and
3258: (processPrioritiesIn = ame_util.booleanFalse or
3259: (ame_rules.rule_type = ame_util.combinationRuleType and
3260: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3255: ame_rule_usages.item_id = engAmeApplicationId and
3256: nvl(ame_rules.item_class_id, headerItemClassIdIn) = ame_item_class_usages.item_class_id and
3257: ame_item_class_usages.application_id = engAmeApplicationId and
3258: (processPrioritiesIn = ame_util.booleanFalse or
3259: (ame_rules.rule_type = ame_util.combinationRuleType and
3260: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3261: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3262: (ame_rules.rule_type = ame_util.authorityRuleType and
3263: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3258: (processPrioritiesIn = ame_util.booleanFalse or
3259: (ame_rules.rule_type = ame_util.combinationRuleType and
3260: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3261: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3262: (ame_rules.rule_type = ame_util.authorityRuleType and
3263: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3264: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3265: (ame_rules.rule_type = ame_util.exceptionRuleType and
3266: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3261: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3262: (ame_rules.rule_type = ame_util.authorityRuleType and
3263: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3264: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3265: (ame_rules.rule_type = ame_util.exceptionRuleType and
3266: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3267: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3268: (ame_rules.rule_type = ame_util.listModRuleType and
3269: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3264: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3265: (ame_rules.rule_type = ame_util.exceptionRuleType and
3266: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3267: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3268: (ame_rules.rule_type = ame_util.listModRuleType and
3269: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3270: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3271: (ame_rules.rule_type = ame_util.substitutionRuleType and
3272: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3267: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3268: (ame_rules.rule_type = ame_util.listModRuleType and
3269: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3270: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3271: (ame_rules.rule_type = ame_util.substitutionRuleType and
3272: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3273: substRuleThresholdIn >= ame_rule_usages.priority)) or
3274: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3275: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3270: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3271: (ame_rules.rule_type = ame_util.substitutionRuleType and
3272: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3273: substRuleThresholdIn >= ame_rule_usages.priority)) or
3274: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3275: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3276: preRuleThresholdIn >= ame_rule_usages.priority)) or
3277: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3278: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3273: substRuleThresholdIn >= ame_rule_usages.priority)) or
3274: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3275: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3276: preRuleThresholdIn >= ame_rule_usages.priority)) or
3277: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3278: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3279: postRuleThresholdIn >= ame_rule_usages.priority)) or
3280: (ame_rules.rule_type = ame_util.productionRuleType and
3281: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3276: preRuleThresholdIn >= ame_rule_usages.priority)) or
3277: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3278: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3279: postRuleThresholdIn >= ame_rule_usages.priority)) or
3280: (ame_rules.rule_type = ame_util.productionRuleType and
3281: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3282: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3283: (processProductionRulesIn = ame_util.booleanTrue or
3284: ame_rules.rule_type <> ame_util.productionRuleType) and

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

3280: (ame_rules.rule_type = ame_util.productionRuleType and
3281: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3282: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3283: (processProductionRulesIn = ame_util.booleanTrue or
3284: ame_rules.rule_type <> ame_util.productionRuleType) and
3285: not exists (select *
3286: from
3287: ame_conditions,
3288: ame_condition_usages

Line 3292: ame_condition_usages.rule_id = ame_rules.rule_id and

3288: ame_condition_usages
3289: where
3290: ame_conditions.condition_type <> ame_util.listModConditionType and
3291: ame_conditions.condition_id = ame_condition_usages.condition_id and
3292: ame_condition_usages.rule_id = ame_rules.rule_id and
3293: engEffectiveRuleDate between
3294: ame_conditions.start_date and
3295: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3296: engEffectiveRuleDate between

Line 3302: ame_rules.start_date and

3298: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3299: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3300: rownum < 2) and
3301: engEffectiveRuleDate between
3302: ame_rules.start_date and
3303: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3304: engEffectiveRuleDate between
3305: ame_rule_usages.start_date and
3306: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

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

3299: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3300: rownum < 2) and
3301: engEffectiveRuleDate between
3302: ame_rules.start_date and
3303: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3304: engEffectiveRuleDate between
3305: ame_rule_usages.start_date and
3306: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3307: engEffectiveRuleDate between

Line 3313: ame_rules.rule_type,

3309: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3310: order by
3311: ame_item_class_usages.item_class_order_number,
3312: item_class_id,
3313: ame_rules.rule_type,
3314: ame_rules.rule_id;
3315: conditionlessItemClassIds ame_util.idList;
3316: conditionlessRuleApprCats ame_util.charList;
3317: conditionlessRuleIds ame_util.idList;

Line 3314: ame_rules.rule_id;

3310: order by
3311: ame_item_class_usages.item_class_order_number,
3312: item_class_id,
3313: ame_rules.rule_type,
3314: ame_rules.rule_id;
3315: conditionlessItemClassIds ame_util.idList;
3316: conditionlessRuleApprCats ame_util.charList;
3317: conditionlessRuleIds ame_util.idList;
3318: conditionlessRulePriorities ame_util.idList;

Line 3581: ame_rules.rule_type rule_type,

3577: ame_conditions.parameter_three parameter_three,
3578: ame_conditions.include_lower_limit,
3579: ame_conditions.include_upper_limit,
3580: ame_condition_usages.rule_id rule_id,
3581: ame_rules.rule_type rule_type,
3582: nvl(ame_rules.item_class_id,
3583: headerItemClassIdIn) rule_item_class,
3584: ame_rule_usages.priority priority,
3585: ame_rule_usages.approver_category

Line 3582: nvl(ame_rules.item_class_id,

3578: ame_conditions.include_lower_limit,
3579: ame_conditions.include_upper_limit,
3580: ame_condition_usages.rule_id rule_id,
3581: ame_rules.rule_type rule_type,
3582: nvl(ame_rules.item_class_id,
3583: headerItemClassIdIn) rule_item_class,
3584: ame_rule_usages.priority priority,
3585: ame_rule_usages.approver_category
3586: from

Line 3590: ame_rules,

3586: from
3587: ame_attributes,
3588: ame_conditions,
3589: ame_condition_usages,
3590: ame_rules,
3591: ame_rule_usages
3592: where
3593: ame_attributes.attribute_id = ame_conditions.attribute_id and
3594: ame_conditions.condition_type <> ame_util.listModConditionType and

Line 3596: ame_condition_usages.rule_id = ame_rules.rule_id and

3592: where
3593: ame_attributes.attribute_id = ame_conditions.attribute_id and
3594: ame_conditions.condition_type <> ame_util.listModConditionType and
3595: ame_conditions.condition_id = ame_condition_usages.condition_id and
3596: ame_condition_usages.rule_id = ame_rules.rule_id and
3597: ame_rules.rule_id = ame_rule_usages.rule_id and
3598: ame_rule_usages.item_id = engAmeApplicationId and
3599: (processPrioritiesIn = ame_util.booleanFalse or
3600: (ame_rules.rule_type = ame_util.combinationRuleType and

Line 3597: ame_rules.rule_id = ame_rule_usages.rule_id and

3593: ame_attributes.attribute_id = ame_conditions.attribute_id and
3594: ame_conditions.condition_type <> ame_util.listModConditionType and
3595: ame_conditions.condition_id = ame_condition_usages.condition_id and
3596: ame_condition_usages.rule_id = ame_rules.rule_id and
3597: ame_rules.rule_id = ame_rule_usages.rule_id and
3598: ame_rule_usages.item_id = engAmeApplicationId and
3599: (processPrioritiesIn = ame_util.booleanFalse or
3600: (ame_rules.rule_type = ame_util.combinationRuleType and
3601: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3596: ame_condition_usages.rule_id = ame_rules.rule_id and
3597: ame_rules.rule_id = ame_rule_usages.rule_id and
3598: ame_rule_usages.item_id = engAmeApplicationId and
3599: (processPrioritiesIn = ame_util.booleanFalse or
3600: (ame_rules.rule_type = ame_util.combinationRuleType and
3601: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3602: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3603: (ame_rules.rule_type = ame_util.authorityRuleType and
3604: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3599: (processPrioritiesIn = ame_util.booleanFalse or
3600: (ame_rules.rule_type = ame_util.combinationRuleType and
3601: (combinationRulePriorityModeIn <> ame_util.absoluteRulePriority or
3602: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3603: (ame_rules.rule_type = ame_util.authorityRuleType and
3604: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3605: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3606: (ame_rules.rule_type = ame_util.exceptionRuleType and
3607: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3602: combinationRuleThresholdIn >= ame_rule_usages.priority)) or
3603: (ame_rules.rule_type = ame_util.authorityRuleType and
3604: (authorityRulePriorityModeIn <> ame_util.absoluteRulePriority or
3605: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3606: (ame_rules.rule_type = ame_util.exceptionRuleType and
3607: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3608: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3609: (ame_rules.rule_type = ame_util.listModRuleType and
3610: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3605: authorityRuleThresholdIn >= ame_rule_usages.priority)) or
3606: (ame_rules.rule_type = ame_util.exceptionRuleType and
3607: (exceptionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3608: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3609: (ame_rules.rule_type = ame_util.listModRuleType and
3610: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3611: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3612: (ame_rules.rule_type = ame_util.substitutionRuleType and
3613: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3608: exceptionRuleThresholdIn >= ame_rule_usages.priority)) or
3609: (ame_rules.rule_type = ame_util.listModRuleType and
3610: (listModRulePriorityModeIn <> ame_util.absoluteRulePriority or
3611: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3612: (ame_rules.rule_type = ame_util.substitutionRuleType and
3613: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3614: substRuleThresholdIn >= ame_rule_usages.priority)) or
3615: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3616: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3611: listModRuleThresholdIn >= ame_rule_usages.priority)) or
3612: (ame_rules.rule_type = ame_util.substitutionRuleType and
3613: (substRulePriorityModeIn <> ame_util.absoluteRulePriority or
3614: substRuleThresholdIn >= ame_rule_usages.priority)) or
3615: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3616: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3617: preRuleThresholdIn >= ame_rule_usages.priority)) or
3618: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3619: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3614: substRuleThresholdIn >= ame_rule_usages.priority)) or
3615: (ame_rules.rule_type = ame_util.preListGroupRuleType and
3616: (preRulePriorityModeIn <> ame_util.absoluteRulePriority or
3617: preRuleThresholdIn >= ame_rule_usages.priority)) or
3618: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3619: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3620: postRuleThresholdIn >= ame_rule_usages.priority)) or
3621: (ame_rules.rule_type = ame_util.productionRuleType and
3622: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or

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

3617: preRuleThresholdIn >= ame_rule_usages.priority)) or
3618: (ame_rules.rule_type = ame_util.postListGroupRuleType and
3619: (postRulePriorityModeIn <> ame_util.absoluteRulePriority or
3620: postRuleThresholdIn >= ame_rule_usages.priority)) or
3621: (ame_rules.rule_type = ame_util.productionRuleType and
3622: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3623: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3624: (processProductionRulesIn = ame_util.booleanTrue or
3625: ame_rules.rule_type <> ame_util.productionRuleType) and

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

3621: (ame_rules.rule_type = ame_util.productionRuleType and
3622: (productionRulePriorityModeIn <> ame_util.absoluteRulePriority or
3623: productionRuleThresholdIn >= ame_rule_usages.priority))) and
3624: (processProductionRulesIn = ame_util.booleanTrue or
3625: ame_rules.rule_type <> ame_util.productionRuleType) and
3626: engEffectiveRuleDate between
3627: ame_attributes.start_date and
3628: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3629: engEffectiveRuleDate between

Line 3636: ame_rules.start_date and

3632: engEffectiveRuleDate between
3633: ame_condition_usages.start_date and
3634: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3635: engEffectiveRuleDate between
3636: ame_rules.start_date and
3637: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3638: engEffectiveRuleDate between
3639: ame_rule_usages.start_date and
3640: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

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

3633: ame_condition_usages.start_date and
3634: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3635: engEffectiveRuleDate between
3636: ame_rules.start_date and
3637: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3638: engEffectiveRuleDate between
3639: ame_rule_usages.start_date and
3640: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3641: order by

Line 3643: ame_rules.rule_type,

3639: ame_rule_usages.start_date and
3640: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3641: order by
3642: rule_item_class,
3643: ame_rules.rule_type,
3644: ame_rules.rule_id,
3645: ame_attributes.item_class_id;
3646: /*
3647: The tempACU tables are buffers between the active-condition-usage fetch and

Line 3644: ame_rules.rule_id,

3640: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3641: order by
3642: rule_item_class,
3643: ame_rules.rule_type,
3644: ame_rules.rule_id,
3645: ame_attributes.item_class_id;
3646: /*
3647: The tempACU tables are buffers between the active-condition-usage fetch and
3648: the engAC variables. The temp variables are indexed consecutively, while

Line 4427: ame_rules,

4423: (
4424: select 1
4425: from ame_conditions,
4426: ame_condition_usages,
4427: ame_rules,
4428: ame_rule_usages
4429: where ame_conditions.attribute_id = ame_attributes.attribute_id
4430: and ame_conditions.condition_id = ame_condition_usages.condition_id
4431: and ame_condition_usages.rule_id = ame_rules.rule_id

Line 4431: and ame_condition_usages.rule_id = ame_rules.rule_id

4427: ame_rules,
4428: ame_rule_usages
4429: where ame_conditions.attribute_id = ame_attributes.attribute_id
4430: and ame_conditions.condition_id = ame_condition_usages.condition_id
4431: and ame_condition_usages.rule_id = ame_rules.rule_id
4432: and ame_rules.rule_id = ame_rule_usages.rule_id
4433: and ame_rule_usages.item_id = applicationIdIn
4434: and ((engEffectiveRuleDate between ame_rules.start_date
4435: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4432: and ame_rules.rule_id = ame_rule_usages.rule_id

4428: ame_rule_usages
4429: where ame_conditions.attribute_id = ame_attributes.attribute_id
4430: and ame_conditions.condition_id = ame_condition_usages.condition_id
4431: and ame_condition_usages.rule_id = ame_rules.rule_id
4432: and ame_rules.rule_id = ame_rule_usages.rule_id
4433: and ame_rule_usages.item_id = applicationIdIn
4434: and ((engEffectiveRuleDate between ame_rules.start_date
4435: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4436: and ((engEffectiveRuleDate between ame_rule_usages.start_date

Line 4434: and ((engEffectiveRuleDate between ame_rules.start_date

4430: and ame_conditions.condition_id = ame_condition_usages.condition_id
4431: and ame_condition_usages.rule_id = ame_rules.rule_id
4432: and ame_rules.rule_id = ame_rule_usages.rule_id
4433: and ame_rule_usages.item_id = applicationIdIn
4434: and ((engEffectiveRuleDate between ame_rules.start_date
4435: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4436: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4437: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4438: and engEffectiveRuleDate between ame_conditions.start_date

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

4431: and ame_condition_usages.rule_id = ame_rules.rule_id
4432: and ame_rules.rule_id = ame_rule_usages.rule_id
4433: and ame_rule_usages.item_id = applicationIdIn
4434: and ((engEffectiveRuleDate between ame_rules.start_date
4435: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4436: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4437: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4438: and engEffectiveRuleDate between ame_conditions.start_date
4439: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)

Line 4447: ame_rules,

4443: select 1
4444: from ame_mandatory_attributes,
4445: ame_actions,
4446: ame_action_usages,
4447: ame_rules,
4448: ame_rule_usages
4449: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4450: and ame_mandatory_attributes.action_type_id =
4451: ame_actions.action_type_id

Line 4453: and ame_action_usages.rule_id = ame_rules.rule_id

4449: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4450: and ame_mandatory_attributes.action_type_id =
4451: ame_actions.action_type_id
4452: and ame_actions.action_id = ame_action_usages.action_id
4453: and ame_action_usages.rule_id = ame_rules.rule_id
4454: and ame_rules.rule_id = ame_rule_usages.rule_id
4455: and ame_rule_usages.item_id = applicationIdIn
4456: and ((engEffectiveRuleDate between ame_rules.start_date
4457: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4454: and ame_rules.rule_id = ame_rule_usages.rule_id

4450: and ame_mandatory_attributes.action_type_id =
4451: ame_actions.action_type_id
4452: and ame_actions.action_id = ame_action_usages.action_id
4453: and ame_action_usages.rule_id = ame_rules.rule_id
4454: and ame_rules.rule_id = ame_rule_usages.rule_id
4455: and ame_rule_usages.item_id = applicationIdIn
4456: and ((engEffectiveRuleDate between ame_rules.start_date
4457: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4458: and ((engEffectiveRuleDate between ame_rule_usages.start_date

Line 4456: and ((engEffectiveRuleDate between ame_rules.start_date

4452: and ame_actions.action_id = ame_action_usages.action_id
4453: and ame_action_usages.rule_id = ame_rules.rule_id
4454: and ame_rules.rule_id = ame_rule_usages.rule_id
4455: and ame_rule_usages.item_id = applicationIdIn
4456: and ((engEffectiveRuleDate between ame_rules.start_date
4457: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4458: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4459: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4460: and engEffectiveRuleDate between ame_mandatory_attributes.start_date

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

4453: and ame_action_usages.rule_id = ame_rules.rule_id
4454: and ame_rules.rule_id = ame_rule_usages.rule_id
4455: and ame_rule_usages.item_id = applicationIdIn
4456: and ((engEffectiveRuleDate between ame_rules.start_date
4457: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4458: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4459: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4460: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4461: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)

Line 7633: tempRuleKey ame_rules.rule_key%type;

7629: parameterTwoOut out nocopy varchar2) as
7630: errorCode integer;
7631: errorMessage ame_util.longestStringType;
7632: invalidNameException exception;
7633: tempRuleKey ame_rules.rule_key%type;
7634: parameterOne ame_conditions.parameter_one%type;
7635: parameterTwo ame_conditions.parameter_two%type;
7636: begin
7637: /* Checked for cached values. */