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 678: attributeType ame_attributes.attribute_type%type;

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

Line 3486: ame_attributes,

3482: where
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

Line 3491: ame_attributes.attribute_type = ame_util.stringAttributeType and

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

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 3497: ame_attributes.start_date 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
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

Line 3498: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) 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
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

Line 3547: ame_attributes,

3543: headerItemClassIdIn) rule_item_class,
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

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 3587: ame_attributes.start_date and

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

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

Line 3605: ame_attributes.item_class_id;

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

Line 3916: ame_attributes.attribute_id attribute_id,

3912: procedure fetchAttributeValues(fetchInactivesIn in boolean) as
3913: cursor attributeCursor(applicationIdIn in integer,
3914: fetchInactivesIn in varchar2) is
3915: select
3916: ame_attributes.attribute_id attribute_id,
3917: ame_attributes.name attribute_name,
3918: ame_attributes.attribute_type attribute_type,
3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,

Line 3917: ame_attributes.name attribute_name,

3913: cursor attributeCursor(applicationIdIn in integer,
3914: fetchInactivesIn in varchar2) is
3915: select
3916: ame_attributes.attribute_id attribute_id,
3917: ame_attributes.name attribute_name,
3918: ame_attributes.attribute_type attribute_type,
3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,
3921: ame_attribute_usages.is_static

Line 3918: ame_attributes.attribute_type attribute_type,

3914: fetchInactivesIn in varchar2) is
3915: select
3916: ame_attributes.attribute_id attribute_id,
3917: ame_attributes.name attribute_name,
3918: ame_attributes.attribute_type attribute_type,
3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,
3921: ame_attribute_usages.is_static
3922: from

Line 3919: ame_attributes.item_class_id item_class_id,

3915: select
3916: ame_attributes.attribute_id attribute_id,
3917: ame_attributes.name attribute_name,
3918: ame_attributes.attribute_type attribute_type,
3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,
3921: ame_attribute_usages.is_static
3922: from
3923: ame_attributes,

Line 3923: ame_attributes,

3919: ame_attributes.item_class_id item_class_id,
3920: ame_attribute_usages.query_string,
3921: ame_attribute_usages.is_static
3922: from
3923: ame_attributes,
3924: ame_attribute_usages,
3925: ame_item_class_usages
3926: where
3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and

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

3923: ame_attributes,
3924: ame_attribute_usages,
3925: ame_item_class_usages
3926: where
3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3929: ame_attribute_usages.application_id = applicationIdIn and
3930: ame_item_class_usages.application_id = applicationIdIn and
3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

Line 3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

3924: ame_attribute_usages,
3925: ame_item_class_usages
3926: where
3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3929: ame_attribute_usages.application_id = applicationIdIn and
3930: ame_item_class_usages.application_id = applicationIdIn and
3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3932: (fetchInactivesIn = ame_util.booleanTrue or

Line 3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

3927: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
3928: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3929: ame_attribute_usages.application_id = applicationIdIn and
3930: ame_item_class_usages.application_id = applicationIdIn and
3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3932: (fetchInactivesIn = ame_util.booleanTrue or
3933: ame_attribute_usages.use_count > 0 or
3934: ame_attributes.attribute_id in
3935: (select ame_attributes2.attribute_id

Line 3934: ame_attributes.attribute_id in

3930: ame_item_class_usages.application_id = applicationIdIn and
3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3932: (fetchInactivesIn = ame_util.booleanTrue or
3933: ame_attribute_usages.use_count > 0 or
3934: ame_attributes.attribute_id in
3935: (select ame_attributes2.attribute_id
3936: from
3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes

Line 3935: (select ame_attributes2.attribute_id

3931: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
3932: (fetchInactivesIn = ame_util.booleanTrue or
3933: ame_attribute_usages.use_count > 0 or
3934: ame_attributes.attribute_id in
3935: (select ame_attributes2.attribute_id
3936: from
3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes
3939: where

Line 3937: ame_attributes ame_attributes2,

3933: ame_attribute_usages.use_count > 0 or
3934: ame_attributes.attribute_id in
3935: (select ame_attributes2.attribute_id
3936: from
3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes
3939: where
3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and

Line 3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and

3936: from
3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes
3939: where
3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and
3942: engEffectiveRuleDate between
3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3943: ame_attributes2.start_date and

3939: where
3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and
3942: engEffectiveRuleDate between
3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3945: engEffectiveRuleDate between
3946: ame_mandatory_attributes.start_date and
3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and

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

3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and
3942: engEffectiveRuleDate between
3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3945: engEffectiveRuleDate between
3946: ame_mandatory_attributes.start_date and
3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3948: engEffectiveRuleDate between

Line 3949: ame_attributes.start_date and

3945: engEffectiveRuleDate between
3946: ame_mandatory_attributes.start_date and
3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3948: engEffectiveRuleDate between
3949: ame_attributes.start_date and
3950: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3951: engEffectiveRuleDate between
3952: ame_attribute_usages.start_date and
3953: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

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

3946: ame_mandatory_attributes.start_date and
3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3948: engEffectiveRuleDate between
3949: ame_attributes.start_date and
3950: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3951: engEffectiveRuleDate between
3952: ame_attribute_usages.start_date and
3953: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3954: engEffectiveRuleDate between

Line 3966: ame_attributes.name;

3962: */
3963: order by
3964: ame_item_class_usages.item_class_order_number,
3965: ame_item_class_usages.item_class_id,
3966: ame_attributes.name;
3967: cursor testTransCurrencyCursor(attributeIdIn in integer) is
3968: select
3969: attribute_value_1,
3970: attribute_value_2,

Line 4010: tempAttributeName ame_attributes.name%type;

4006: queryStrings ame_util.longestStringList;
4007: rowCountException exception;
4008: rowsFound integer;
4009: tempAttributeId integer;
4010: tempAttributeName ame_attributes.name%type;
4011: tempAttributeType ame_attributes.attribute_type%type;
4012: tempAttributeValue1 ame_util.attributeValueType;
4013: tempAttributeValue2 ame_util.attributeValueType;
4014: tempAttributeValue3 ame_util.attributeValueType;

Line 4011: tempAttributeType ame_attributes.attribute_type%type;

4007: rowCountException exception;
4008: rowsFound integer;
4009: tempAttributeId integer;
4010: tempAttributeName ame_attributes.name%type;
4011: tempAttributeType ame_attributes.attribute_type%type;
4012: tempAttributeValue1 ame_util.attributeValueType;
4013: tempAttributeValue2 ame_util.attributeValueType;
4014: tempAttributeValue3 ame_util.attributeValueType;
4015: tempAttributeValueIndex integer;

Line 4341: ame_attributes.attribute_id attribute_id,

4337: end fetchAttributeValues;
4338: procedure fetchOtherAttributeValues as
4339: cursor attributeCursor(applicationIdIn in integer) is
4340: select
4341: ame_attributes.attribute_id attribute_id,
4342: ame_attributes.name attribute_name,
4343: ame_attributes.attribute_type attribute_type,
4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,

Line 4342: ame_attributes.name attribute_name,

4338: procedure fetchOtherAttributeValues as
4339: cursor attributeCursor(applicationIdIn in integer) is
4340: select
4341: ame_attributes.attribute_id attribute_id,
4342: ame_attributes.name attribute_name,
4343: ame_attributes.attribute_type attribute_type,
4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,
4346: ame_attribute_usages.is_static

Line 4343: ame_attributes.attribute_type attribute_type,

4339: cursor attributeCursor(applicationIdIn in integer) is
4340: select
4341: ame_attributes.attribute_id attribute_id,
4342: ame_attributes.name attribute_name,
4343: ame_attributes.attribute_type attribute_type,
4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,
4346: ame_attribute_usages.is_static
4347: from

Line 4344: ame_attributes.item_class_id item_class_id,

4340: select
4341: ame_attributes.attribute_id attribute_id,
4342: ame_attributes.name attribute_name,
4343: ame_attributes.attribute_type attribute_type,
4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,
4346: ame_attribute_usages.is_static
4347: from
4348: ame_attributes,

Line 4348: ame_attributes,

4344: ame_attributes.item_class_id item_class_id,
4345: ame_attribute_usages.query_string,
4346: ame_attribute_usages.is_static
4347: from
4348: ame_attributes,
4349: ame_attribute_usages,
4350: ame_item_class_usages
4351: where
4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and

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

4348: ame_attributes,
4349: ame_attribute_usages,
4350: ame_item_class_usages
4351: where
4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4354: ame_attribute_usages.application_id = applicationIdIn and
4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

Line 4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

4349: ame_attribute_usages,
4350: ame_item_class_usages
4351: where
4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4354: ame_attribute_usages.application_id = applicationIdIn and
4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4357: (ame_attribute_usages.use_count = 0 and

Line 4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and

4352: ame_attributes.name not in (ame_util.workflowItemKeyAttribute, ame_util.workflowItemTypeAttribute) and
4353: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4354: ame_attribute_usages.application_id = applicationIdIn and
4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4357: (ame_attribute_usages.use_count = 0 and
4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id
4360: from

Line 4358: ame_attributes.attribute_id not in

4354: ame_attribute_usages.application_id = applicationIdIn and
4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4357: (ame_attribute_usages.use_count = 0 and
4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id
4360: from
4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes

Line 4359: (select ame_attributes2.attribute_id

4355: ame_item_class_usages.application_id = applicationIdIn and
4356: ame_attributes.item_class_id = ame_item_class_usages.item_class_id and
4357: (ame_attribute_usages.use_count = 0 and
4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id
4360: from
4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes
4363: where

Line 4361: ame_attributes ame_attributes2,

4357: (ame_attribute_usages.use_count = 0 and
4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id
4360: from
4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes
4363: where
4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and

Line 4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and

4360: from
4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes
4363: where
4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and
4366: sysdate between
4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and

Line 4367: ame_attributes2.start_date and

4363: where
4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and
4366: sysdate between
4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4369: sysdate between
4370: ame_mandatory_attributes.start_date and
4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and

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

4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and
4366: sysdate between
4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4369: sysdate between
4370: ame_mandatory_attributes.start_date and
4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4372: sysdate between

Line 4373: ame_attributes.start_date and

4369: sysdate between
4370: ame_mandatory_attributes.start_date and
4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4372: sysdate between
4373: ame_attributes.start_date and
4374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4375: sysdate between
4376: ame_attribute_usages.start_date and
4377: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

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

4370: ame_mandatory_attributes.start_date and
4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4372: sysdate between
4373: ame_attributes.start_date and
4374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4375: sysdate between
4376: ame_attribute_usages.start_date and
4377: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
4378: sysdate between

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 4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id

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

Line 4436: ame_attributes.name;

4432: */
4433: order by
4434: ame_item_class_usages.item_class_order_number,
4435: ame_item_class_usages.item_class_id,
4436: ame_attributes.name;
4437: cursor testTransCurrencyCursor(attributeIdIn in integer) is
4438: select
4439: attribute_value_1,
4440: attribute_value_2,

Line 4480: tempAttributeName ame_attributes.name%type;

4476: queryStrings ame_util.longestStringList;
4477: rowCountException exception;
4478: rowsFound integer;
4479: tempAttributeId integer;
4480: tempAttributeName ame_attributes.name%type;
4481: tempAttributeType ame_attributes.attribute_type%type;
4482: tempAttributeValue1 ame_util.attributeValueType;
4483: tempAttributeValue2 ame_util.attributeValueType;
4484: tempAttributeValue3 ame_util.attributeValueType;

Line 4481: tempAttributeType ame_attributes.attribute_type%type;

4477: rowCountException exception;
4478: rowsFound integer;
4479: tempAttributeId integer;
4480: tempAttributeName ame_attributes.name%type;
4481: tempAttributeType ame_attributes.attribute_type%type;
4482: tempAttributeValue1 ame_util.attributeValueType;
4483: tempAttributeValue2 ame_util.attributeValueType;
4484: tempAttributeValue3 ame_util.attributeValueType;
4485: tempAttributeValueIndex integer;

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

10453: ame_util.copyIdList(idListIn => tempExcOrdCondAttributeIds,
10454: idListOut => tempAttributeIdsToMatch);
10455: /*
10456: For an applicable exception to override an otherwise applicable authority rule,
10457: both rules' ordinary conditions must be defined on the same attributes. (If
10458: neither rule has any ordinary conditions, the exception overrides the authority
10459: rule.) Here tempBoolean indicates whether each of the authority rule's
10460: attributes were matched, and tempBoolean2 indicates whether the target authority
10461: rule has been found in the engACU variables.