DBA Data[Home] [Help]

APPS.AS_CATALOG_MIGRATION dependencies on FND_GRANTS

Line 639: FROM fnd_grants fg, fnd_objects fo

635:
636: BEGIN
637:
638: SELECT count(*) into l_num_cat_set_grants
639: FROM fnd_grants fg, fnd_objects fo
640: WHERE fg.object_id = fo.object_id
641: and fo.obj_name = l_category_set_object
642: and fg.instance_pk1_value=p_category_set_id;
643:

Line 651: fnd_grants_pkg.grant_function(

647: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Granting Access to Catalog');
649: end if;
650:
651: fnd_grants_pkg.grant_function(
652: p_api_version => 1.0,
653: p_menu_name => l_catalog_manager_resp ,
654: p_object_name => l_category_set_object,
655: p_instance_type => l_instance_type,