DBA Data[Home] [Help]

APPS.BIS_IMPL_DEV_PKG dependencies on BIS_OBJ_DEPENDENCY_V

Line 417: --from bis_obj_dependency_v objdep

413: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = f.function_name)
414: UNION ALL
415: -- page in RSG repository but w/o corresponding form function defined
416: (select DISTINCT objdep.object_name object_name, /*objdep.user_object_name user_object_name*/ objdep.object_name user_object_name, 'N' oa_page
417: --from bis_obj_dependency_v objdep
418: from bis_obj_dependency objdep
419: where objdep.object_type = 'PAGE'
420: and not exists (select 1 from fnd_form_functions func
421: where (upper(func.web_html_call) = 'ORACLESSWA.SWITCHPAGE'

Line 532: from bis_obj_dependency_v d

528: AND prop.object_type = p_object_type)
529: UNION ALL
530: -- bis_obj_dependency object
531: (select distinct d.object_name
532: from bis_obj_dependency_v d
533: where d.object_type = p_object_type
534: and d.user_object_name = p_user_object_name
535: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
536: WHERE prop.object_type = d.object_type

Line 541: FROM bis_obj_dependency_v d

537: AND prop.object_name = d.object_name))
538: UNION ALL
539: -- bis_obj_dependency depend_object
540: (SELECT DISTINCT d.depend_object_name
541: FROM bis_obj_dependency_v d
542: WHERE d.depend_object_type = p_object_type
543: AND d.user_depend_object_name = p_user_object_name
544: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
545: WHERE prop.object_type = d.object_type

Line 572: from bis_obj_dependency_v d

568: AND prop.object_name = p_object_name)
569: UNION ALL
570: -- bis_obj_dependency object
571: (select distinct d.object_name
572: from bis_obj_dependency_v d
573: where d.object_type = p_object_type
574: and d.user_object_name = p_user_object_name
575: AND d.object_name = p_object_name
576: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

Line 582: FROM bis_obj_dependency_v d

578: AND prop.object_name = d.object_name))
579: UNION ALL
580: -- bis_obj_dependency depend_object
581: (SELECT DISTINCT d.depend_object_name
582: FROM bis_obj_dependency_v d
583: WHERE d.depend_object_type = p_object_type
584: AND d.depend_object_name = p_object_name
585: AND d.user_depend_object_name = p_user_object_name
586: AND NOT exists (SELECT 1 FROM bis_obj_properties prop