DBA Data[Home] [Help]

APPS.AME_ITC_BUS dependencies on AME_ITEM_CLASSES

Line 50: (p_associated_column1 => 'AME_ITEM_CLASSES.NAME'

46: hr_utility.set_location(' Leaving:'||l_proc,30);
47: exception
48: when app_exception.application_exception then
49: if hr_multi_message.exception_add
50: (p_associated_column1 => 'AME_ITEM_CLASSES.NAME'
51: ) then
52: hr_utility.set_location(' Leaving:'||l_proc, 40);
53: raise;
54: end if;

Line 91: from ame_item_classes

87: ) IS
88: --
89: cursor csr_name is
90: select null
91: from ame_item_classes
92: where name = p_name
93: and p_effective_date between start_date and
94: nvl(end_date - ame_util.oneSecond, p_effective_date);
95: --

Line 115: (p_associated_column1 => 'AME_ITEM_CLASSES.UNIQUE'

111: hr_utility.set_location(' Leaving:'||l_proc,30);
112: exception
113: when app_exception.application_exception then
114: if hr_multi_message.exception_add
115: (p_associated_column1 => 'AME_ITEM_CLASSES.UNIQUE'
116: ) then
117: hr_utility.set_location(' Leaving:'||l_proc, 40);
118: raise;
119: end if;

Line 155: from ame_item_classes

151: ) IS
152: --
153: cursor csr_isSeeded is
154: select null
155: from ame_item_classes
156: where item_class_id = p_item_class_id
157: and p_effective_date between start_date and
158: nvl(end_date - ame_util.oneSecond, p_effective_date)
159: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;