DBA Data[Home] [Help]

APPS.AME_ITU_BUS dependencies on AME_UTILITY_PKG

Line 338: select ame_utility_pkg.validate_query(p_item_id_query,'1',ame_util2.itemClassObject)

334: fnd_message.raise_error;
335: end if;
336: l_temp_count := l_temp_count + 1;
337: end loop;
338: select ame_utility_pkg.validate_query(p_item_id_query,'1',ame_util2.itemClassObject)
339: into l_query_validation
340: from dual;
341: if l_query_validation <> 'Y' then
342: fnd_message.raise_error;

Line 592: ame_utility_pkg.check_seeddb = 'N' and

588: cursor c_sel1 Is
589: select null
590: from ame_item_class_usages
591: where
592: ame_utility_pkg.check_seeddb = 'N' and
593: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
594: item_class_id = p_item_class_id and
595: application_id = p_application_id ;
596: l_exists varchar2(1);

Line 593: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and

589: select null
590: from ame_item_class_usages
591: where
592: ame_utility_pkg.check_seeddb = 'N' and
593: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
594: item_class_id = p_item_class_id and
595: application_id = p_application_id ;
596: l_exists varchar2(1);
597: begin