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_ATTRIBUTES

Line 680: attributeType ame_attributes.attribute_type%type;

676: itemClassIdIn in integer,
677: itemIndexIn in integer) return boolean as
678: attributeId integer;
679: attributeNumberValue number;
680: attributeType ame_attributes.attribute_type%type;
681: attributeTypeException exception;
682: attributeValue1 ame_util.attributeValueType;
683: attributeValue2 ame_util.attributeValueType;
684: attributeValue3 ame_util.attributeValueType;

Line 3526: ame_attributes,

3522: where
3523: condition_id in
3524: (select ame_condition_usages.condition_id
3525: from
3526: ame_attributes,
3527: ame_conditions,
3528: ame_condition_usages,
3529: ame_rule_usages
3530: where

Line 3531: ame_attributes.attribute_type = ame_util.stringAttributeType and

3527: ame_conditions,
3528: ame_condition_usages,
3529: ame_rule_usages
3530: where
3531: ame_attributes.attribute_type = ame_util.stringAttributeType and
3532: ame_attributes.attribute_id = ame_conditions.attribute_id and
3533: ame_conditions.condition_id = ame_condition_usages.condition_id and
3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3535: ame_rule_usages.item_id = engAmeApplicationId and

Line 3532: ame_attributes.attribute_id = ame_conditions.attribute_id and

3528: ame_condition_usages,
3529: ame_rule_usages
3530: where
3531: ame_attributes.attribute_type = ame_util.stringAttributeType and
3532: ame_attributes.attribute_id = ame_conditions.attribute_id and
3533: ame_conditions.condition_id = ame_condition_usages.condition_id and
3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3535: ame_rule_usages.item_id = engAmeApplicationId and
3536: engEffectiveRuleDate between

Line 3537: ame_attributes.start_date and

3533: ame_conditions.condition_id = ame_condition_usages.condition_id and
3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3535: ame_rule_usages.item_id = engAmeApplicationId and
3536: engEffectiveRuleDate between
3537: ame_attributes.start_date and
3538: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3539: engEffectiveRuleDate between
3540: ame_conditions.start_date and
3541: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3538: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3534: ame_condition_usages.rule_id = ame_rule_usages.rule_id and
3535: ame_rule_usages.item_id = engAmeApplicationId and
3536: engEffectiveRuleDate between
3537: ame_attributes.start_date and
3538: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3539: engEffectiveRuleDate between
3540: ame_conditions.start_date and
3541: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3542: engEffectiveRuleDate between

Line 3587: ame_attributes,

3583: headerItemClassIdIn) rule_item_class,
3584: ame_rule_usages.priority priority,
3585: ame_rule_usages.approver_category
3586: from
3587: ame_attributes,
3588: ame_conditions,
3589: ame_condition_usages,
3590: ame_rules,
3591: ame_rule_usages

Line 3593: ame_attributes.attribute_id = ame_conditions.attribute_id and

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

Line 3627: ame_attributes.start_date and

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
3630: ame_conditions.start_date and
3631: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3628: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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
3630: ame_conditions.start_date and
3631: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3632: engEffectiveRuleDate between

Line 3645: ame_attributes.item_class_id;

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
3649: the engAC variables are indexed by condition ID or rule ID.

Line 3956: ame_attributes.attribute_id attribute_id,

3952: procedure fetchAttributeValues(fetchInactivesIn in boolean) as
3953: cursor attributeCursor(applicationIdIn in integer,
3954: fetchInactivesIn in varchar2) is
3955: select
3956: ame_attributes.attribute_id attribute_id,
3957: ame_attributes.name attribute_name,
3958: ame_attributes.attribute_type attribute_type,
3959: ame_attributes.item_class_id item_class_id,
3960: ame_attribute_usages.query_string,

Line 3957: ame_attributes.name attribute_name,

3953: cursor attributeCursor(applicationIdIn in integer,
3954: fetchInactivesIn in varchar2) is
3955: select
3956: ame_attributes.attribute_id attribute_id,
3957: ame_attributes.name attribute_name,
3958: ame_attributes.attribute_type attribute_type,
3959: ame_attributes.item_class_id item_class_id,
3960: ame_attribute_usages.query_string,
3961: ame_attribute_usages.is_static

Line 3958: ame_attributes.attribute_type attribute_type,

3954: fetchInactivesIn in varchar2) is
3955: select
3956: ame_attributes.attribute_id attribute_id,
3957: ame_attributes.name attribute_name,
3958: ame_attributes.attribute_type attribute_type,
3959: ame_attributes.item_class_id item_class_id,
3960: ame_attribute_usages.query_string,
3961: ame_attribute_usages.is_static
3962: from

Line 3959: ame_attributes.item_class_id item_class_id,

3955: select
3956: ame_attributes.attribute_id attribute_id,
3957: ame_attributes.name attribute_name,
3958: ame_attributes.attribute_type attribute_type,
3959: ame_attributes.item_class_id item_class_id,
3960: ame_attribute_usages.query_string,
3961: ame_attribute_usages.is_static
3962: from
3963: ame_attributes,

Line 3963: ame_attributes,

3959: ame_attributes.item_class_id item_class_id,
3960: ame_attribute_usages.query_string,
3961: ame_attribute_usages.is_static
3962: from
3963: ame_attributes,
3964: ame_attribute_usages,
3965: ame_item_class_usages
3966: where
3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and

Line 3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and

3963: ame_attributes,
3964: ame_attribute_usages,
3965: ame_item_class_usages
3966: where
3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3969: ame_attribute_usages.application_id = applicationIdIn and
3970: ame_item_class_usages.application_id = applicationIdIn and
3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

Line 3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

3964: ame_attribute_usages,
3965: ame_item_class_usages
3966: where
3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3969: ame_attribute_usages.application_id = applicationIdIn and
3970: ame_item_class_usages.application_id = applicationIdIn and
3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3972: (fetchInactivesIn = ame_util.booleanTrue or

Line 3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

3967: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3968: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3969: ame_attribute_usages.application_id = applicationIdIn and
3970: ame_item_class_usages.application_id = applicationIdIn and
3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3972: (fetchInactivesIn = ame_util.booleanTrue or
3973: ame_attribute_usages.use_count > 0 or
3974: ame_attributes.attribute_id in
3975: (select ame_attributes2.attribute_id

Line 3974: ame_attributes.attribute_id in

3970: ame_item_class_usages.application_id = applicationIdIn and
3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3972: (fetchInactivesIn = ame_util.booleanTrue or
3973: ame_attribute_usages.use_count > 0 or
3974: ame_attributes.attribute_id in
3975: (select ame_attributes2.attribute_id
3976: from
3977: ame_attributes ame_attributes2,
3978: ame_mandatory_attributes

Line 3975: (select ame_attributes2.attribute_id

3971: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3972: (fetchInactivesIn = ame_util.booleanTrue or
3973: ame_attribute_usages.use_count > 0 or
3974: ame_attributes.attribute_id in
3975: (select ame_attributes2.attribute_id
3976: from
3977: ame_attributes ame_attributes2,
3978: ame_mandatory_attributes
3979: where

Line 3977: ame_attributes ame_attributes2,

3973: ame_attribute_usages.use_count > 0 or
3974: ame_attributes.attribute_id in
3975: (select ame_attributes2.attribute_id
3976: from
3977: ame_attributes ame_attributes2,
3978: ame_mandatory_attributes
3979: where
3980: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3981: ame_mandatory_attributes.action_type_id = -1 and

Line 3980: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and

3976: from
3977: ame_attributes ame_attributes2,
3978: ame_mandatory_attributes
3979: where
3980: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3981: ame_mandatory_attributes.action_type_id = -1 and
3982: engEffectiveRuleDate between
3983: ame_attributes2.start_date and
3984: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3983: ame_attributes2.start_date and

3979: where
3980: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3981: ame_mandatory_attributes.action_type_id = -1 and
3982: engEffectiveRuleDate between
3983: ame_attributes2.start_date and
3984: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3985: engEffectiveRuleDate between
3986: ame_mandatory_attributes.start_date and
3987: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and

Line 3984: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3980: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3981: ame_mandatory_attributes.action_type_id = -1 and
3982: engEffectiveRuleDate between
3983: ame_attributes2.start_date and
3984: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3985: engEffectiveRuleDate between
3986: ame_mandatory_attributes.start_date and
3987: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3988: engEffectiveRuleDate between

Line 3989: ame_attributes.start_date and

3985: engEffectiveRuleDate between
3986: ame_mandatory_attributes.start_date and
3987: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3988: engEffectiveRuleDate between
3989: ame_attributes.start_date and
3990: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3991: engEffectiveRuleDate between
3992: ame_attribute_usages.start_date and
3993: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3990: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3986: ame_mandatory_attributes.start_date and
3987: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3988: engEffectiveRuleDate between
3989: ame_attributes.start_date and
3990: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3991: engEffectiveRuleDate between
3992: ame_attribute_usages.start_date and
3993: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3994: engEffectiveRuleDate between

Line 4006: ame_attributes.name;

4002: */
4003: order by
4004: ame_item_class_usages.item_class_order_number,
4005: ame_item_class_usages.item_class_id,
4006: ame_attributes.name;
4007: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4008: select
4009: attribute_value_1,
4010: attribute_value_2,

Line 4050: tempAttributeName ame_attributes.name%type;

4046: queryStrings ame_util.longestStringList;
4047: rowCountException exception;
4048: rowsFound integer;
4049: tempAttributeId integer;
4050: tempAttributeName ame_attributes.name%type;
4051: tempAttributeType ame_attributes.attribute_type%type;
4052: tempAttributeValue1 ame_util.attributeValueType;
4053: tempAttributeValue2 ame_util.attributeValueType;
4054: tempAttributeValue3 ame_util.attributeValueType;

Line 4051: tempAttributeType ame_attributes.attribute_type%type;

4047: rowCountException exception;
4048: rowsFound integer;
4049: tempAttributeId integer;
4050: tempAttributeName ame_attributes.name%type;
4051: tempAttributeType ame_attributes.attribute_type%type;
4052: tempAttributeValue1 ame_util.attributeValueType;
4053: tempAttributeValue2 ame_util.attributeValueType;
4054: tempAttributeValue3 ame_util.attributeValueType;
4055: tempAttributeValueIndex integer;

Line 4381: ame_attributes.attribute_id attribute_id,

4377: end fetchAttributeValues;
4378: procedure fetchOtherAttributeValues as
4379: cursor attributeCursor(applicationIdIn in integer) is
4380: select
4381: ame_attributes.attribute_id attribute_id,
4382: ame_attributes.name attribute_name,
4383: ame_attributes.attribute_type attribute_type,
4384: ame_attributes.item_class_id item_class_id,
4385: ame_attribute_usages.query_string,

Line 4382: ame_attributes.name attribute_name,

4378: procedure fetchOtherAttributeValues as
4379: cursor attributeCursor(applicationIdIn in integer) is
4380: select
4381: ame_attributes.attribute_id attribute_id,
4382: ame_attributes.name attribute_name,
4383: ame_attributes.attribute_type attribute_type,
4384: ame_attributes.item_class_id item_class_id,
4385: ame_attribute_usages.query_string,
4386: ame_attribute_usages.is_static

Line 4383: ame_attributes.attribute_type attribute_type,

4379: cursor attributeCursor(applicationIdIn in integer) is
4380: select
4381: ame_attributes.attribute_id attribute_id,
4382: ame_attributes.name attribute_name,
4383: ame_attributes.attribute_type attribute_type,
4384: ame_attributes.item_class_id item_class_id,
4385: ame_attribute_usages.query_string,
4386: ame_attribute_usages.is_static
4387: from

Line 4384: ame_attributes.item_class_id item_class_id,

4380: select
4381: ame_attributes.attribute_id attribute_id,
4382: ame_attributes.name attribute_name,
4383: ame_attributes.attribute_type attribute_type,
4384: ame_attributes.item_class_id item_class_id,
4385: ame_attribute_usages.query_string,
4386: ame_attribute_usages.is_static
4387: from
4388: ame_attributes,

Line 4388: ame_attributes,

4384: ame_attributes.item_class_id item_class_id,
4385: ame_attribute_usages.query_string,
4386: ame_attribute_usages.is_static
4387: from
4388: ame_attributes,
4389: ame_attribute_usages,
4390: ame_item_class_usages
4391: where
4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and

Line 4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and

4388: ame_attributes,
4389: ame_attribute_usages,
4390: ame_item_class_usages
4391: where
4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4394: ame_attribute_usages.application_id = applicationIdIn and
4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

Line 4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

4389: ame_attribute_usages,
4390: ame_item_class_usages
4391: where
4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4394: ame_attribute_usages.application_id = applicationIdIn and
4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4397: (ame_attribute_usages.use_count = 0 and

Line 4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

4392: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4393: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4394: ame_attribute_usages.application_id = applicationIdIn and
4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4397: (ame_attribute_usages.use_count = 0 and
4398: ame_attributes.attribute_id not in
4399: (select ame_attributes2.attribute_id
4400: from

Line 4398: ame_attributes.attribute_id not in

4394: ame_attribute_usages.application_id = applicationIdIn and
4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4397: (ame_attribute_usages.use_count = 0 and
4398: ame_attributes.attribute_id not in
4399: (select ame_attributes2.attribute_id
4400: from
4401: ame_attributes ame_attributes2,
4402: ame_mandatory_attributes

Line 4399: (select ame_attributes2.attribute_id

4395: ame_item_class_usages.application_id = applicationIdIn and
4396: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4397: (ame_attribute_usages.use_count = 0 and
4398: ame_attributes.attribute_id not in
4399: (select ame_attributes2.attribute_id
4400: from
4401: ame_attributes ame_attributes2,
4402: ame_mandatory_attributes
4403: where

Line 4401: ame_attributes ame_attributes2,

4397: (ame_attribute_usages.use_count = 0 and
4398: ame_attributes.attribute_id not in
4399: (select ame_attributes2.attribute_id
4400: from
4401: ame_attributes ame_attributes2,
4402: ame_mandatory_attributes
4403: where
4404: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4405: ame_mandatory_attributes.action_type_id = -1 and

Line 4404: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and

4400: from
4401: ame_attributes ame_attributes2,
4402: ame_mandatory_attributes
4403: where
4404: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4405: ame_mandatory_attributes.action_type_id = -1 and
4406: sysdate between
4407: ame_attributes2.start_date and
4408: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and

Line 4407: ame_attributes2.start_date and

4403: where
4404: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4405: ame_mandatory_attributes.action_type_id = -1 and
4406: sysdate between
4407: ame_attributes2.start_date and
4408: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4409: sysdate between
4410: ame_mandatory_attributes.start_date and
4411: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and

Line 4408: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and

4404: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4405: ame_mandatory_attributes.action_type_id = -1 and
4406: sysdate between
4407: ame_attributes2.start_date and
4408: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4409: sysdate between
4410: ame_mandatory_attributes.start_date and
4411: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4412: sysdate between

Line 4413: ame_attributes.start_date and

4409: sysdate between
4410: ame_mandatory_attributes.start_date and
4411: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4412: sysdate between
4413: ame_attributes.start_date and
4414: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4415: sysdate between
4416: ame_attribute_usages.start_date and
4417: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

Line 4414: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

4410: ame_mandatory_attributes.start_date and
4411: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4412: sysdate between
4413: ame_attributes.start_date and
4414: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4415: sysdate between
4416: ame_attribute_usages.start_date and
4417: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
4418: sysdate between

Line 4429: where ame_conditions.attribute_id = ame_attributes.attribute_id

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

Line 4449: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id

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
4452: and ame_actions.action_id = ame_action_usages.action_id
4453: and ame_action_usages.rule_id = ame_rules.rule_id

Line 4476: ame_attributes.name;

4472: */
4473: order by
4474: ame_item_class_usages.item_class_order_number,
4475: ame_item_class_usages.item_class_id,
4476: ame_attributes.name;
4477: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4478: select
4479: attribute_value_1,
4480: attribute_value_2,

Line 4520: tempAttributeName ame_attributes.name%type;

4516: queryStrings ame_util.longestStringList;
4517: rowCountException exception;
4518: rowsFound integer;
4519: tempAttributeId integer;
4520: tempAttributeName ame_attributes.name%type;
4521: tempAttributeType ame_attributes.attribute_type%type;
4522: tempAttributeValue1 ame_util.attributeValueType;
4523: tempAttributeValue2 ame_util.attributeValueType;
4524: tempAttributeValue3 ame_util.attributeValueType;

Line 4521: tempAttributeType ame_attributes.attribute_type%type;

4517: rowCountException exception;
4518: rowsFound integer;
4519: tempAttributeId integer;
4520: tempAttributeName ame_attributes.name%type;
4521: tempAttributeType ame_attributes.attribute_type%type;
4522: tempAttributeValue1 ame_util.attributeValueType;
4523: tempAttributeValue2 ame_util.attributeValueType;
4524: tempAttributeValue3 ame_util.attributeValueType;
4525: tempAttributeValueIndex integer;

Line 10894: both rules' ordinary conditions must be defined on the same attributes. (If

10890: ame_util.copyIdList(idListIn => tempExcOrdCondAttributeIds,
10891: idListOut => tempAttributeIdsToMatch);
10892: /*
10893: For an applicable exception to override an otherwise applicable authority rule,
10894: both rules' ordinary conditions must be defined on the same attributes. (If
10895: neither rule has any ordinary conditions, the exception overrides the authority
10896: rule.) Here tempBoolean indicates whether each of the authority rule's
10897: attributes were matched, and tempBoolean2 indicates whether the target authority
10898: rule has been found in the engACU variables.