[Home] [Help]
138:
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;
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
148: OPEN C_CUSTOM_API(p_mvname);
149: fetch C_CUSTOM_API into L_CUSTOM_API;
155: FUNCTION GET_MV_THRESHOLDED_AT_RUNTIME (p_mvname VARCHAR2) RETURN VARCHAR2
156: IS
157: l_rtnbuf VARCHAR2(32767);
158: l_retcode VARCHAR2(32767);
159: L_CUSTOM_API bis_obj_properties.custom_api%type := NULL;
160: BEGIN
161: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
162: IF (L_CUSTOM_API is NOT NULL) THEN
163: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV threshold management: (' || p_mvname || ')');
188: PROCEDURE MV_INDEX_MANAGE(p_mvname VARCHAR2, p_mode VARCHAR2)
189: IS
190: l_rtnbuf VARCHAR2(32767);
191: l_retcode VARCHAR2(32767);
192: L_CUSTOM_API bis_obj_properties.custom_api%type := NULL;
193: BEGIN
194: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
195: IF (L_CUSTOM_API is NOT NULL) THEN
196: -- Now call the stored program
292: PROCEDURE custom_api_other(p_mvname VARCHAR2, p_mode VARCHAR2,p_mv_refresh_method varchar2)
293: IS
294: l_rtnbuf VARCHAR2(32767);
295: l_retcode VARCHAR2(32767);
296: L_CUSTOM_API bis_obj_properties.custom_api%type := NULL;
297: BEGIN
298: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
299: IF (L_CUSTOM_API is NOT NULL) THEN
300: -- Now call the stored program
701: FUNCTION IS_IMPLEMENTED(
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
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'
711: and object_name = P_MVNAME;
712: BEGIN
713: open C_IMPLEMENTATION_FLAG(P_MVNAME);
869: ---This procedure is added for bug 4406144
870: --It will compile MVs in RSG with status INVALID
871: procedure compile_mvs is
872: cursor c_mvs_from_bop is
873: SELECT OBJECT_NAME from BIS_OBJ_PROPERTIES where OBJECT_TYPE = 'MV';
874: l_mv_rec_bop c_mvs_from_bop%ROWTYPE;
875: cursor c_mvs_to_compile(mvNameFromBOP varchar2)
876: is
877: select
935: l.log_table log_table,
936: l.log_owner log_owner,
937: l.master master_name
938: from
939: bis_obj_properties a,
940: all_mviews b,
941: all_mview_refresh_times t,
942: all_mview_logs l
943: where a.object_type=''MV''
1018: ---as required by BISREL in 4247289
1019: l_check_mv_in_rsg varchar2(2000):='
1020: select nvl(b.implementation_flag,''N'') impl_flag
1021: from
1022: bis_obj_properties b
1023: where b.object_name =:1
1024: and b.object_type=''MV'''
1025: ;
1026:
1191: l.log_table log_table,
1192: l.log_owner log_owner,
1193: l.master master_name
1194: from
1195: bis_obj_properties a,
1196: all_mviews b,
1197: all_mview_refresh_times t,
1198: all_mview_logs l
1199: where a.object_type=''MV''