APPS.AME_API3 dependencies on AME_ATTRIBUTES

Line 706: ame_attributes.name,

702: currencyCodeOut out nocopy varchar2,
703: allowedValuesOut out nocopy ame_util.longestStringList) as
704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,
708: ame_attributes.description,
709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,

Line 707: ame_attributes.attribute_type,

703: allowedValuesOut out nocopy ame_util.longestStringList) as
704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,
708: ame_attributes.description,
709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,
711: ame_conditions.include_lower_limit,

Line 708: ame_attributes.description,

704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,
708: ame_attributes.description,
709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,
711: ame_conditions.include_lower_limit,
712: ame_conditions.include_upper_limit,

Line 724: ame_attributes,

720: includeLowerLimitOut,
721: includeUpperLimitOut,
722: currencyCodeOut
723: from
724: ame_attributes,
725: ame_conditions
726: where
727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and

Line 727: ame_attributes.attribute_id = ame_conditions.attribute_id and

723: from
724: ame_attributes,
725: ame_conditions
726: where
727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 730: ame_attributes.start_date and

726: where
727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

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

727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
735: if(attributeTypeOut = ame_util.stringAttributeType) then

Line 1889: decode(ame_attributes.attribute_type,

1885: cursor conditionCursor(ruleIdIn in integer) is
1886: select
1887: ame_conditions.condition_id,
1888: ame_condition_pkg.getDescription(ame_conditions.condition_id),
1889: decode(ame_attributes.attribute_type,
1890: ame_util.stringAttributeType, ame_util.booleanTrue,
1891: /* default */ ame_util.booleanFalse)
1892: from
1893: ame_conditions,

Line 1895: ame_attributes

1891: /* default */ ame_util.booleanFalse)
1892: from
1893: ame_conditions,
1894: ame_condition_usages,
1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 1899: ame_attributes.attribute_id = ame_conditions.attribute_id and

1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between

Line 1907: ame_attributes.start_date and

1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between
1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is
1910: select
1911: ame_rules.rule_type,

Line 1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between
1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is
1910: select
1911: ame_rules.rule_type,
1912: ame_rules.description