APPS.AME_ATTRIBUTE_API dependencies on AME_ACTION_USAGES

Line 842: ame_action_usages

838: into tempCount
839: from
840: ame_mandatory_attributes,
841: ame_actions,
842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and

Line 846: ame_actions.action_id = ame_action_usages.action_id and

842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and

Line 847: ame_action_usages.rule_id = tempRule.rule_id and

843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

Line 852: ((sysdate between ame_action_usages.start_date and

848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));

Line 853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));
857: if(tempCount > 0) then

Line 854: (sysdate < ame_action_usages.start_date and

850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));
857: if(tempCount > 0) then
858: useCount := useCount + 1;

Line 855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));
857: if(tempCount > 0) then
858: useCount := useCount + 1;
859: end if;

Line 856: ame_action_usages.start_date + ame_util.oneSecond)));

852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
856: ame_action_usages.start_date + ame_util.oneSecond)));
857: if(tempCount > 0) then
858: useCount := useCount + 1;
859: end if;
860: end if;