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_CONDITIONS

Line 687: includeLowerLimit ame_conditions.include_lower_limit%type;

683: attributeValueDate date;
684: errorCode integer;
685: errorMessage ame_util.longestStringType;
686: headerLevelCondition boolean;
687: includeLowerLimit ame_conditions.include_lower_limit%type;
688: includeUpperLimit ame_conditions.include_upper_limit%type;
689: parameterOne ame_conditions.parameter_one%type;
690: parameterOneDate date;
691: parameterOneNumber number;

Line 688: includeUpperLimit ame_conditions.include_upper_limit%type;

684: errorCode integer;
685: errorMessage ame_util.longestStringType;
686: headerLevelCondition boolean;
687: includeLowerLimit ame_conditions.include_lower_limit%type;
688: includeUpperLimit ame_conditions.include_upper_limit%type;
689: parameterOne ame_conditions.parameter_one%type;
690: parameterOneDate date;
691: parameterOneNumber number;
692: parameterThree ame_conditions.parameter_three%type;

Line 689: parameterOne ame_conditions.parameter_one%type;

685: errorMessage ame_util.longestStringType;
686: headerLevelCondition boolean;
687: includeLowerLimit ame_conditions.include_lower_limit%type;
688: includeUpperLimit ame_conditions.include_upper_limit%type;
689: parameterOne ame_conditions.parameter_one%type;
690: parameterOneDate date;
691: parameterOneNumber number;
692: parameterThree ame_conditions.parameter_three%type;
693: parameterTwo ame_conditions.parameter_two%type;

Line 692: parameterThree ame_conditions.parameter_three%type;

688: includeUpperLimit ame_conditions.include_upper_limit%type;
689: parameterOne ame_conditions.parameter_one%type;
690: parameterOneDate date;
691: parameterOneNumber number;
692: parameterThree ame_conditions.parameter_three%type;
693: parameterTwo ame_conditions.parameter_two%type;
694: parameterTwoDate date;
695: parameterTwoNumber number;
696: begin

Line 693: parameterTwo ame_conditions.parameter_two%type;

689: parameterOne ame_conditions.parameter_one%type;
690: parameterOneDate date;
691: parameterOneNumber number;
692: parameterThree ame_conditions.parameter_three%type;
693: parameterTwo ame_conditions.parameter_two%type;
694: parameterTwoDate date;
695: parameterTwoNumber number;
696: begin
697: /* Check whether the condition is on a header-level attribute. */

Line 3247: ame_conditions,

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
3249: where
3250: ame_conditions.condition_type <> ame_util.listModConditionType and
3251: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 3250: ame_conditions.condition_type <> ame_util.listModConditionType and

3246: from
3247: ame_conditions,
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

Line 3251: ame_conditions.condition_id = ame_condition_usages.condition_id and

3247: ame_conditions,
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

Line 3254: ame_conditions.start_date and

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
3257: ame_condition_usages.start_date and
3258: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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
3257: ame_condition_usages.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. */

Line 3487: ame_conditions,

3483: condition_id in
3484: (select ame_condition_usages.condition_id
3485: from
3486: ame_attributes,
3487: ame_conditions,
3488: ame_condition_usages,
3489: ame_rule_usages
3490: where
3491: ame_attributes.attribute_type = ame_util.stringAttributeType and

Line 3492: ame_attributes.attribute_id = ame_conditions.attribute_id and

3488: ame_condition_usages,
3489: ame_rule_usages
3490: where
3491: ame_attributes.attribute_type = ame_util.stringAttributeType and
3492: ame_attributes.attribute_id = ame_conditions.attribute_id and
3493: ame_conditions.condition_id = ame_condition_usages.condition_id and
3494: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3495: ame_rule_usages.item_id = engAmeApplicationId and
3496: engEffectiveRuleDate between

Line 3493: ame_conditions.condition_id = ame_condition_usages.condition_id and

3489: ame_rule_usages
3490: where
3491: ame_attributes.attribute_type = ame_util.stringAttributeType and
3492: ame_attributes.attribute_id = ame_conditions.attribute_id and
3493: ame_conditions.condition_id = ame_condition_usages.condition_id and
3494: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3495: ame_rule_usages.item_id = engAmeApplicationId and
3496: engEffectiveRuleDate between
3497: ame_attributes.start_date and

Line 3500: ame_conditions.start_date and

3496: engEffectiveRuleDate between
3497: ame_attributes.start_date and
3498: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3499: engEffectiveRuleDate between
3500: ame_conditions.start_date and
3501: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3502: engEffectiveRuleDate between
3503: ame_condition_usages.start_date and
3504: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3501: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3497: ame_attributes.start_date and
3498: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3499: engEffectiveRuleDate between
3500: ame_conditions.start_date and
3501: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3502: engEffectiveRuleDate between
3503: ame_condition_usages.start_date and
3504: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3505: engEffectiveRuleDate between

Line 3532: ame_conditions.condition_id condition_id,

3528: productionRulePriorityModeIn in varchar2,
3529: productionRuleThresholdIn in integer,
3530: headerItemClassIdIn in integer) is
3531: select
3532: ame_conditions.condition_id condition_id,
3533: ame_conditions.condition_type condition_type,
3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,

Line 3533: ame_conditions.condition_type condition_type,

3529: productionRuleThresholdIn in integer,
3530: headerItemClassIdIn in integer) is
3531: select
3532: ame_conditions.condition_id condition_id,
3533: ame_conditions.condition_type condition_type,
3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
3537: ame_conditions.parameter_three parameter_three,

Line 3534: ame_conditions.attribute_id attribute_id,

3530: headerItemClassIdIn in integer) is
3531: select
3532: ame_conditions.condition_id condition_id,
3533: ame_conditions.condition_type condition_type,
3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
3537: ame_conditions.parameter_three parameter_three,
3538: ame_conditions.include_lower_limit,

Line 3535: ame_conditions.parameter_one parameter_one,

3531: select
3532: ame_conditions.condition_id condition_id,
3533: ame_conditions.condition_type condition_type,
3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
3537: ame_conditions.parameter_three parameter_three,
3538: ame_conditions.include_lower_limit,
3539: ame_conditions.include_upper_limit,

Line 3536: ame_conditions.parameter_two parameter_two,

3532: ame_conditions.condition_id condition_id,
3533: ame_conditions.condition_type condition_type,
3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
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,

Line 3537: ame_conditions.parameter_three parameter_three,

3533: ame_conditions.condition_type condition_type,
3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
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,

Line 3538: ame_conditions.include_lower_limit,

3534: ame_conditions.attribute_id attribute_id,
3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
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,

Line 3539: ame_conditions.include_upper_limit,

3535: ame_conditions.parameter_one parameter_one,
3536: ame_conditions.parameter_two parameter_two,
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,

Line 3548: ame_conditions,

3544: ame_rule_usages.priority priority,
3545: ame_rule_usages.approver_category
3546: from
3547: ame_attributes,
3548: ame_conditions,
3549: ame_condition_usages,
3550: ame_rules,
3551: ame_rule_usages
3552: where

Line 3553: ame_attributes.attribute_id = ame_conditions.attribute_id and

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

Line 3554: ame_conditions.condition_type <> ame_util.listModConditionType and

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

Line 3555: ame_conditions.condition_id = ame_condition_usages.condition_id and

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

Line 3590: ame_conditions.start_date and

3586: engEffectiveRuleDate between
3587: ame_attributes.start_date and
3588: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3589: engEffectiveRuleDate between
3590: ame_conditions.start_date and
3591: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3592: engEffectiveRuleDate between
3593: ame_condition_usages.start_date and
3594: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3591: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3587: ame_attributes.start_date and
3588: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3589: engEffectiveRuleDate between
3590: ame_conditions.start_date and
3591: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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

Line 4385: from ame_conditions,

4381: -- Condition to check whether the attribute is used in the rule
4382: exists
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

Line 4389: where ame_conditions.attribute_id = ame_attributes.attribute_id

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
4392: and ame_rules.rule_id = ame_rule_usages.rule_id
4393: and ame_rule_usages.item_id = applicationIdIn

Line 4390: and ame_conditions.condition_id = ame_condition_usages.condition_id

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

Line 4398: and engEffectiveRuleDate between ame_conditions.start_date

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)
4400: and ((engEffectiveRuleDate between ame_condition_usages.start_date
4401: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))
4402: union

Line 4399: and nvl(ame_conditions.end_date - (1/86400), engEffectiveRuleDate)

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)
4400: and ((engEffectiveRuleDate between ame_condition_usages.start_date
4401: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))
4402: union
4403: select 1

Line 7356: parameterOne ame_conditions.parameter_one%type;

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. */
7360: if(not engLMParameterOnes.exists(ruleIdIn)) then

Line 7357: parameterTwo ame_conditions.parameter_two%type;

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. */
7360: if(not engLMParameterOnes.exists(ruleIdIn)) then
7361: /* Select the values, as they were not cached. */

Line 7363: ame_conditions.parameter_one,

7359: /* Checked for cached values. */
7360: if(not engLMParameterOnes.exists(ruleIdIn)) then
7361: /* Select the values, as they were not cached. */
7362: select
7363: ame_conditions.parameter_one,
7364: ame_conditions.parameter_two
7365: into
7366: parameterOne,
7367: parameterTwo

Line 7364: ame_conditions.parameter_two

7360: if(not engLMParameterOnes.exists(ruleIdIn)) then
7361: /* Select the values, as they were not cached. */
7362: select
7363: ame_conditions.parameter_one,
7364: ame_conditions.parameter_two
7365: into
7366: parameterOne,
7367: parameterTwo
7368: from

Line 7369: ame_conditions,

7365: into
7366: parameterOne,
7367: parameterTwo
7368: from
7369: ame_conditions,
7370: ame_condition_usages
7371: where
7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and

Line 7373: ame_condition_usages.condition_id = ame_conditions.condition_id and

7369: ame_conditions,
7370: ame_condition_usages
7371: where
7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and
7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 7374: ame_conditions.condition_type = ame_util.listModConditionType and

7370: ame_condition_usages
7371: where
7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and
7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7378: engEffectiveRuleDate between

Line 7376: ame_conditions.start_date and

7372: ame_condition_usages.rule_id = ruleIdIn and
7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and
7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7378: engEffectiveRuleDate between
7379: ame_condition_usages.start_date and
7380: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

7373: ame_condition_usages.condition_id = ame_conditions.condition_id and
7374: ame_conditions.condition_type = ame_util.listModConditionType and
7375: engEffectiveRuleDate between
7376: ame_conditions.start_date and
7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7378: engEffectiveRuleDate between
7379: ame_condition_usages.start_date and
7380: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7381: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */