APPS.AME_ATTRIBUTE_API dependencies on AME_ATTRIBUTE_USAGES

Line 261: -- insert the row in ame_attribute_usages

257: -- Process Logic
258: --
259: -- Set the effective date to the sysdate
260: l_effective_date := sysdate;
261: -- insert the row in ame_attribute_usages
262: ame_atu_ins.ins(p_attribute_id => p_attribute_id
263: ,p_application_id => p_application_id
264: ,p_effective_date => l_effective_date
265: ,p_use_count => l_use_count

Line 526: -- update the row in ame_attribute_usages. Parent row locking not needed.

522: --
523: -- Set the effective date to the sysdate
524: l_effective_date := sysdate;
525: l_atu_object_version_number := p_object_version_number;
526: -- update the row in ame_attribute_usages. Parent row locking not needed.
527: ame_atu_upd.upd(p_effective_date => l_effective_date
528: ,p_datetrack_mode => 'UPDATE'
529: ,p_attribute_id => p_attribute_id
530: ,p_application_id => p_application_id

Line 677: -- delete the row in ame_attribute_usages

673: -- Set the effective date to the sysdate
674: l_effective_date := sysdate;
675: l_atu_object_version_number := p_object_version_number;
676: --
677: -- delete the row in ame_attribute_usages
678: ame_atu_del.del(p_effective_date => l_effective_date
679: ,p_datetrack_mode => 'DELETE'
680: ,p_attribute_id => p_attribute_id
681: ,p_application_id => p_application_id

Line 693: from ame_attribute_usages

689: --
690:
691: select count(*)
692: into l_usage_count
693: from ame_attribute_usages
694: where attribute_id = p_attribute_id
695: and l_effective_date between start_date and
696: nvl(end_date - ame_util.oneSecond,sysdate);
697: