APPS.BIS_MV_REFRESH dependencies on BIS_OBJ_DEPENDENCY

Line 105: CURSOR C_MV_CSTATE ( P_MVNAME bis_obj_dependency.object_name%TYPE, p_apps_schema_name varchar2 )

101: l_errbuf varchar2(2000);
102: l_retcode number;
103: l_compile_state all_mviews.compile_state%type;
104:
105: CURSOR C_MV_CSTATE ( P_MVNAME bis_obj_dependency.object_name%TYPE, p_apps_schema_name varchar2 )
106: IS
107: select NVL(compile_state, 'NA')
108: from all_mviews
109: where mview_name = p_mvname

Line 143: CURSOR C_CUSTOM_API ( P_MVNAME bis_obj_dependency.object_name%type )

139: -- added for enhancement 3022739, MV threshold at runtime.
140: FUNCTION GET_CUSTOMAPI (p_mvname VARCHAR2) RETURN VARCHAR2
141: IS
142: L_CUSTOM_API bis_obj_properties.custom_api%type := NULL;
143: CURSOR C_CUSTOM_API ( P_MVNAME bis_obj_dependency.object_name%type )
144: IS
145: select CUSTOM_API from bis_obj_properties
146: where object_name = p_mvname;
147: BEGIN

Line 662: l_portlet_name bis_obj_dependency.object_name%type;

658:
659: PROCEDURE updCacheByTopPortlet(
660: P_MVNAME IN VARCHAR2
661: ) IS
662: l_portlet_name bis_obj_dependency.object_name%type;
663: l_function_id fnd_form_functions.function_id%type;
664: CURSOR C_PORTLETS ( P_MVNAME bis_obj_dependency.object_name%type )
665: IS
666:

Line 664: CURSOR C_PORTLETS ( P_MVNAME bis_obj_dependency.object_name%type )

660: P_MVNAME IN VARCHAR2
661: ) IS
662: l_portlet_name bis_obj_dependency.object_name%type;
663: l_function_id fnd_form_functions.function_id%type;
664: CURSOR C_PORTLETS ( P_MVNAME bis_obj_dependency.object_name%type )
665: IS
666:
667: select distinct object_name, function_id
668: from bis_obj_dependency, fnd_form_functions

Line 668: from bis_obj_dependency, fnd_form_functions

664: CURSOR C_PORTLETS ( P_MVNAME bis_obj_dependency.object_name%type )
665: IS
666:
667: select distinct object_name, function_id
668: from bis_obj_dependency, fnd_form_functions
669: where depend_object_type = 'MV'
670: and object_type = 'PORTLET'
671: and function_name(+) = depend_object_name
672: and depend_object_name = P_MVNAME;

Line 676: from bis_obj_dependency

672: and depend_object_name = P_MVNAME;
673:
674: /*
675: select distinct object_name
676: from bis_obj_dependency
677: where depend_object_type = 'MV'
678: and object_type = 'PORTLET'
679: and depend_object_name = P_MVNAME;
680: */

Line 706: CURSOR C_IMPLEMENTATION_FLAG ( P_MVNAME bis_obj_dependency.object_name%type )

702: P_MVNAME IN VARCHAR2
703: ) RETURN BOOLEAN
704: IS
705: l_impl_flag bis_obj_properties.implementation_flag%type;
706: CURSOR C_IMPLEMENTATION_FLAG ( P_MVNAME bis_obj_dependency.object_name%type )
707: IS
708: select NVL( implementation_flag, 'N')
709: from bis_obj_properties
710: where object_type = 'MV'