APPS.BSC_DIMENSION_EDIT dependencies on BSC_UPDATE_UTIL

Line 24: h_installed_languages BSC_UPDATE_UTIL.t_array_of_varchar2;

20: | 16-NOV-2006 ankgoel Color By KPI enh#5244136 |
21: | |
22: +==========================================================================+*/
23:
24: h_installed_languages BSC_UPDATE_UTIL.t_array_of_varchar2;
25: h_num_installed_languages NUMBER;
26:
27: CURSOR LEVEL is
28: SELECT DISTINCT L.DIM_LEVEL_ID, D.LEVEL_TABLE_NAME

Line 71: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);

67: END LOOP;
68:
69: close LEVEL;
70:
71: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);
72: IF h_num_installed_languages = -1 THEN
73: RAISE e_unexpected_error;
74: END IF;
75:

Line 80: deleted_code BSC_UPDATE_UTIL.t_array_of_number;

76: end security_sync;
77:
78: procedure deleteNormalRow( l_dim_table IN VARCHAR2,
79: l_deleted_code IN NUMBER) is
80: deleted_code BSC_UPDATE_UTIL.t_array_of_number;
81: temp boolean;
82: begin
83: deleted_code(1):=l_deleted_code;
84: temp:=BSC_UPDATE_DIM.Delete_Codes_Cascade(

Line 253: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);

249: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);
250: l_source_lang:=USERENV('LANG');
251:
252: IF h_num_installed_languages is NULL THEN
253: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);
254: IF h_num_installed_languages = -1 THEN
255: RAISE e_unexpected_error;
256: END IF;
257: END IF;

Line 341: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);

337: l_code:=BSC_UPDATE_DIM.get_new_code(l_dim_table);
338: l_source_lang:=USERENV('LANG');
339:
340: IF h_num_installed_languages is NULL THEN
341: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);
342: IF h_num_installed_languages = -1 THEN
343: RAISE e_unexpected_error;
344: END IF;
345: END IF;

Line 523: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

519: FETCH c_base_tables INTO h_base_table;
520: While c_base_tables%FOUND LOOP
521: h_sql := 'DELETE FROM '||h_base_table||
522: ' WHERE '||h_condition;
523: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
524: FETCH c_base_tables INTO h_base_table;
525: END LOOP;
526: CLOSE c_base_tables;
527:

Line 532: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

528:
529: -- Delete from dimension table
530: h_sql := 'DELETE FROM '||x_dim_table||
531: ' WHERE '||h_condition;
532: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
533:
534: RETURN TRUE;
535:
536: EXCEPTION

Line 599: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);

595: end loop;
596:
597:
598: IF h_num_installed_languages is NULL THEN
599: h_num_installed_languages := BSC_UPDATE_UTIL.Get_Installed_Languages(h_installed_languages);
600: IF h_num_installed_languages = -1 THEN
601: RAISE e_unexpected_error;
602: END IF;
603: END IF;