eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DESIGNER_PVT dependencies on BSC_UPDATE_UTIL

Line 482: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

478: h_colum VARCHAR2(100);
479: h_key_name VARCHAR2(30);
480: h_condition VARCHAR2(1000);
481: h_sql VARCHAR2(32000);
482: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
483: x_num_columns NUMBER;
484: i NUMBER;
485: h_ag NUMBER;
486: h_aO NUMBER;

Line 510: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

506: --Move the record to negative . to later restore the values
507: h_Trg_kpi_neg := p_Trg_kpi * (-1);
508:
509: h_sql := 'DELETE ' || p_table_name || ' WHERE ' || h_condition;
510: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
511:
512: x_num_columns :=0;
513: OPEN c_column;
514: FETCH c_column INTO h_colum;

Line 549: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

545: END IF;
546: END LOOP;
547: h_sql:= h_sql || ' FROM ' || p_table_name;
548: h_sql:= h_sql || ' WHERE ' || h_condition;
549: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
550: --DBMS_OUTPUT.PUT_LINE(' Insertred into table :-' || p_table_name);
551: --BUG 1224991
552: IF UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
553: h_sql:= 'UPDATE ' || p_table_name;

Line 849: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

845: --h_msg := 'Reset_BscKpiDefaults Tab:' || h_tab_id;
846: --DBMS_OUTPUT.PUT_LINE(h_msg);
847: --Delete Records
848: h_sql :='DELETE BSC_KPI_DEFAULTS_B WHERE INDICATOR= :1'; --|| l_indicator;
849: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
850: Execute Immediate h_sql USING l_indicator;
851: --DBMS_OUTPUT.PUT_LINE(h_sql);
852:
853: h_sql :='DELETE BSC_KPI_DEFAULTS_TL WHERE INDICATOR= :1';-- || l_indicator;

Line 854: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

850: Execute Immediate h_sql USING l_indicator;
851: --DBMS_OUTPUT.PUT_LINE(h_sql);
852:
853: h_sql :='DELETE BSC_KPI_DEFAULTS_TL WHERE INDICATOR= :1';-- || l_indicator;
854: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
855: EXECUTE IMMEDIATE h_sql USING l_indicator;
856: --DBMS_OUTPUT.PUT_LINE(h_sql);
857:
858: -- Insert Defaults BSC_KPI_DEFAULTS_B

Line 862: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

858: -- Insert Defaults BSC_KPI_DEFAULTS_B
859: h_sql :='INSERT INTO BSC_KPI_DEFAULTS_B (TAB_ID,INDICATOR,' ||
860: 'LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)' ||
861: 'VALUES ('|| h_tab_id ||',' || l_indicator ||',SYSDATE,' || l_current_user ||',SYSDATE,' || l_current_user || ')';
862: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
863: --DBMS_OUTPUT.PUT_LINE(h_sql);
864:
865: -- Insert Defaults BSC_KPI_DEFAULTS_TL
866: h_sql :='INSERT INTO BSC_KPI_DEFAULTS_TL (TAB_ID,INDICATOR,LANGUAGE,SOURCE_LANG)' ||

Line 871: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

867: ' SELECT '|| h_tab_id ||' TAB_ID,' || l_indicator || ' INDICATOR,' ||
868: ' LANGUAGE_CODE,' || '''' || l_base_lang || '''' ||
869: ' FROM FND_LANGUAGES ' ||
870: ' WHERE INSTALLED_FLAG IN (''B'',''I'')';
871: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
872: --DBMS_OUTPUT.PUT_LINE(h_sql);
873: EXCEPTION
874: WHEN OTHERS THEN
875: --DBMS_OUTPUT.PUT_LINE('d' || SQLERRM);

Line 960: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300

956: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL SET ANALYSIS_OPTION0_NAME =NULL,' ||
957: ' ANALYSIS_OPTION1_NAME=NULL,ANALYSIS_OPTION2_NAME=NULL '||
958: ' WHERE INDICATOR = :1'; -- || l_indicator;
959: --DBMS_OUTPUT.PUT_LINE(h_sql);
960: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300
961: Execute Immediate h_sql USING l_indicator;
962:
963:
964: --Simulation Tree, Retrieve the default node captions----------------------------

Line 987: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300

983: ',ANALYSIS_OPTION0_NAME= :2' || --'''' || h_tmp || '''' ||
984: ' WHERE INDICATOR= :3' || --l_indicator ||
985: ' AND LANGUAGE= :4'; --|| '''' || h_lang || '''';
986: --DBMS_OUTPUT.PUT_LINE('A' || h_sql);
987: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300
988: Execute Immediate h_sql USING h_source_lang, h_tmp, l_indicator, h_lang;
989:
990:
991: --BUG 2610065 FETCH c_kpi_tree INTO h_name,h_lang,h_source_lang;

Line 999: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300

995: -- series name is null for a tree
996: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL SET SERIES_NAME=NULL' ||
997: ' WHERE INDICATOR=:1'; --|| l_indicator;
998: --DBMS_OUTPUT.PUT_LINE(h_sql);
999: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300
1000: Execute Immediate h_sql USING l_indicator;
1001: ELSE
1002: -- Get the default
1003: OPEN c_color_AO_DEFAULT;

Line 1041: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300

1037: ',ANALYSIS_OPTION0_NAME= :2' || --'''' || h_tmp || '''' ||
1038: ' WHERE INDICATOR= :3' || --l_indicator ||
1039: ' AND LANGUAGE= :4'; --|| '''' || h_lang || '''';
1040: --DBMS_OUTPUT.PUT_LINE(h_sql);
1041: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300
1042: Execute Immediate h_sql USING h_source_lang, h_tmp, l_indicator, h_lang;
1043:
1044: FETCH c_kpi_analysis INTO h_lang,h_source_lang,h_name;
1045: END LOOP;

Line 1067: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1063: ',ANALYSIS_OPTION0_NAME= :2' || --'''' || h_tmp || '''' ||
1064: ' WHERE INDICATOR= :3' || --l_indicator ||
1065: ' AND LANGUAGE= :4'; --|| '''' || h_lang || '''';
1066: --DBMS_OUTPUT.PUT_LINE(h_sql);
1067: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1068: Execute Immediate h_sql USING h_source_lang, h_tmp, l_indicator, h_lang;
1069:
1070: FETCH c_kpi_analysis INTO h_lang,h_source_lang,h_name;
1071: END LOOP;

Line 1091: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300

1087: ',ANALYSIS_OPTION0_NAME= :2' || --'''' || h_tmp || '''' ||
1088: ' WHERE INDICATOR= :3' || --l_indicator ||
1089: ' AND LANGUAGE= :4'; --|| '''' || h_lang || '''';
1090: --DBMS_OUTPUT.PUT_LINE(h_sql);
1091: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -- bug 3111300
1092: Execute Immediate h_sql USING h_source_lang, h_tmp, l_indicator, h_lang;
1093:
1094: FETCH c_kpi_analysis INTO h_lang,h_source_lang,h_name;
1095: END LOOP;

Line 1190: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1186: ' FORMAT_MASK =NULL,' ||
1187: ' COLOR_METHOD=NULL, ' ||
1188: ' MEASURE_SOURCE = ''BSC''' ||
1189: ' WHERE INDICATOR =:1'; -- || l_indicator;
1190: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1191: Execute Immediate h_sql USING l_indicator;
1192: --DBMS_OUTPUT.PUT_LINE(h_sql);
1193:
1194: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL SET ' ||

Line 1197: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1193:
1194: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL SET ' ||
1195: ' SERIES_NAME= NULL' ||
1196: ' WHERE INDICATOR =:1'; --|| l_indicator;
1197: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1198: Execute Immediate h_sql USING l_indicator;
1199: --DBMS_OUTPUT.PUT_LINE(h_sql);
1200:
1201: --Simulation Tree, Retrieve the default node captions----------------------------

Line 1220: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1216: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1217: ' FORMAT_MASK = :1' || --'''' || h_format_mask || '''' ||
1218: ',COLOR_METHOD=:2' || --h_color_method ||
1219: ' WHERE INDICATOR=:3'; --|| l_indicator;
1220: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1221: Execute Immediate h_sql USING h_format_mask, h_color_method, l_indicator;
1222: --DBMS_OUTPUT.PUT_LINE(h_sql);
1223: END IF;
1224: CLOSE c_kpi_tree;

Line 1228: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1224: CLOSE c_kpi_tree;
1225: -- series name is null for a tree
1226: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL SET SERIES_NAME=NULL' ||
1227: ' WHERE INDICATOR=:1'; -- || l_indicator;
1228: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1229: Execute Immediate h_sql USING l_indicator;
1230: --DBMS_OUTPUT.PUT_LINE(h_sql);
1231: ELSE
1232: --Get defaults

Line 1246: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1242: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1243: ' FORMAT_MASK = :1' || --'''' || h_format_mask || '''' ||
1244: ',COLOR_METHOD=:2' || --h_color_method ||
1245: ' WHERE INDICATOR=:3'; --|| l_indicator;
1246: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1247: Execute Immediate h_sql USING h_format_mask, h_color_method, l_indicator;
1248: --DBMS_OUTPUT.PUT_LINE(h_sql);
1249: END IF;
1250: CLOSE c_analisys_measure;

Line 1262: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1258: 'SOURCE_LANG = :1' || --'''' || h_source_lang || '''' ||
1259: ',SERIES_NAME=:2' || --'''' || h_tmp || '''' ||
1260: ' WHERE INDICATOR=:3' || --l_indicator ||
1261: ' AND LANGUAGE=:4'; --|| '''' || h_lang || '''';
1262: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1263: Execute Immediate h_sql USING h_source_lang, h_tmp, l_indicator, h_lang;
1264: --DBMS_OUTPUT.PUT_LINE(h_sql);
1265:
1266:

Line 1295: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1291: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1292: ' MEASURE_SOURCE = :1' || --'''' || h_kpi_measure_source || '''' ||
1293: ' WHERE INDICATOR=:2'; --|| l_indicator;
1294:
1295: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1296: Execute Immediate h_sql USING h_kpi_measure_source, l_indicator;
1297:
1298:
1299: END IF;

Line 1338: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

1334: ' DIM_SET_ID = (SELECT DIM_SET_ID ' ||
1335: ' FROM BSC_DB_COLOR_KPI_DEFAULTS_V DB ' ||
1336: ' WHERE KD.INDICATOR = DB.INDICATOR (+)) ' ||
1337: ' WHERE KD.INDICATOR =:1'; --|| l_indicator;
1338: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1339: Execute Immediate h_sql USING l_indicator;
1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN

Line 1415: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2

1411: ' WHERE KDL.DIM_LEVEL_INDEX = 7 ' ||
1412: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1413: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID) ' ||
1414: ' WHERE KD.INDICATOR =:1'; --|| l_indicator;
1415: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2
1416: Execute Immediate h_sql USING l_indicator;
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: --DBMS_OUTPUT.PUT_LINE('h' || SQLERRM);

Line 1503: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1499: ' DIM_LEVEL4_NAME=NULL,DIM_LEVEL5_NAME=NULL,'||
1500: ' DIM_LEVEL6_NAME=NULL,DIM_LEVEL7_NAME=NULL,'||
1501: ' DIM_LEVEL8_NAME=NULL ' ||
1502: ' WHERE INDICATOR =:1'; --|| l_indicator;
1503: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1504: Execute Immediate h_sql USING l_indicator;
1505:
1506: FOR h_i IN 0..7 LOOP
1507: --New

Line 1535: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1531: END IF;
1532: h_sql := h_sql ||' WHERE INDICATOR = :1' || --l_indicator ||
1533: ' AND LANGUAGE = :2'; --|| ' ''' || h_lang || '''';
1534:
1535: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1536: Execute Immediate h_sql USING l_indicator, h_lang;
1537:
1538: --DBMS_OUTPUT.PUT_LINE(h_sql);
1539: FETCH c_dimnames INTO h_dim_set_id,h_lang,h_name,h_text;

Line 1554: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1550: --Assigned
1551: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL SET DIM_LEVEL' || (h_dim_level_index + 1) || '_TEXT= :1' || --'''' || h_dim_txt || '''' ||
1552: ' WHERE INDICATOR =:2'; --|| l_indicator;
1553:
1554: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1555: Execute Immediate h_sql USING h_dim_txt, l_indicator;
1556: --DBMS_OUTPUT.PUT_LINE(h_sql);
1557:
1558: FETCH c_kpi_dim INTO h_dim_set_id,h_dim_level_index,h_level_view_name,h_value_order_by;

Line 1571: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1567: ' WHERE CODE = :1' || --l_DEFAULT_KEY_VALUE ||
1568: ' AND '||
1569: ' DTL.LANGUAGE =LANGUAGE) WHERE INDICATOR = :2'; --|| l_indicator;
1570:
1571: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1572: Execute Immediate h_sql USING l_DEFAULT_KEY_VALUE, l_indicator;
1573:
1574:
1575: FETCH c_key_item INTO h_dim_set_id,h_dim_level_index,l_LEVEL_TABLE_NAME,l_DEFAULT_KEY_VALUE;

Line 1709: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1705: h_sql := 'UPDATE BSC_KPI_DEFAULTS_TL KD SET '||
1706: ' PERIOD_NAME =:1' || --'''' || h_str || '''' ||
1707: ' WHERE KD.INDICATOR =:2'; --|| l_indicator;
1708:
1709: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1710: Execute Immediate h_sql USING h_str, l_indicator;
1711:
1712: --DBMS_OUTPUT.PUT_LINE(h_sql);
1713: ELSE

Line 1727: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

1723: ' AND P.PERIODICITY_ID = :2' || --h_periodicity ||
1724: ' AND P.PERIOD_ID = :3' || ')' || --h_cur_period || ')' ||
1725: ' WHERE KD.INDICATOR = :4'; --|| l_indicator;
1726:
1727: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
1728: Execute Immediate h_sql USING h_year , h_periodicity, h_cur_period, l_indicator;
1729: --DBMS_OUTPUT.PUT_LINE(h_sql);
1730: END IF;
1731:

Line 1778: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

1774: h_colum VARCHAR2(100);
1775: h_key_name VARCHAR2(30);
1776: h_condition VARCHAR2(1000);
1777: h_sql VARCHAR2(32000);
1778: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1779: x_num_columns NUMBER;
1780: i NUMBER;
1781: h_ag NUMBER;
1782: h_aO NUMBER;

Line 1804: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

1800: --Move the record to negative . to later restore the values
1801: h_Trg_kpi_neg := x_Trg_kpi * -1;
1802:
1803: h_sql := 'DELETE ' || x_table_name || ' WHERE ' || h_condition;
1804: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1805:
1806: --Open COLUMNS by table cursor
1807: x_num_columns :=0;
1808: OPEN c_column;

Line 1846: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

1842: END IF;
1843: END LOOP;
1844: h_sql:= h_sql || ' FROM ' || x_table_name;
1845: h_sql:= h_sql || ' WHERE ' || h_condition;
1846: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1847: --BUG 1224991
1848: IF UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
1849: h_sql:= 'UPDATE ' || x_table_name;
1850: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';

Line 1852: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2

1848: IF UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
1849: h_sql:= 'UPDATE ' || x_table_name;
1850: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';
1851: h_sql:= h_sql || ' WHERE INDICATOR = :2'; --|| x_Trg_kpi;
1852: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2
1853: Execute Immediate h_sql USING x_Trg_kpi, x_Trg_kpi;
1854: END IF;
1855:
1856: --Bug 2258410 don't override the user wizard preferences

Line 1870: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -bug 3111300 ,part2

1866: h_sql := h_sql || ' AND ANALYSIS_GROUP_ID = :3'; --|| h_ag ;
1867: h_sql := h_sql || ' AND OPTION_ID = :4'; --|| h_aO ;
1868: h_sql := h_sql || ' AND PARENT_OPTION_ID = :5'; --|| h_aOP ;
1869: h_sql := h_sql || ' AND GRANDPARENT_OPTION_ID = :6'; --|| h_aOG ;
1870: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); -bug 3111300 ,part2
1871: Execute Immediate h_sql USING h_usl, x_Trg_kpi, h_ag, h_aO, h_aOP, h_aOG;
1872:
1873: FETCH c_userwizard INTO h_ag,h_aO,h_aOP,h_aOG,h_usl;
1874: END LOOP;

Line 1907: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

1903: ORDER BY column_name;
1904:
1905: h_sql VARCHAR2(32000);
1906: h_column VARCHAR2(100);
1907: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1908: x_num_columns NUMBER;
1909:
1910: BEGIN
1911: -- Initialize BSC/APPS global variables

Line 1959: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

1955: h_sql:= h_sql || ' AND kpi_measure_id IS NULL';
1956: ELSE
1957: h_sql:= h_sql || ' AND kpi_measure_id = ' || p_src_kpi_measure_id;
1958: END IF;
1959: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1960:
1961: END IF;
1962:
1963: EXCEPTION

Line 2063: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

2059: FOR i IN 1 .. g_num_obj_kpi_metadata_tables LOOP
2060: IF (g_obj_kpi_metadata_tables(i).duplicate_data = BSC_UTILITY.YES) THEN
2061: h_sql := 'DELETE ' || g_obj_kpi_metadata_tables(i).table_name ||
2062: ' WHERE indicator = ' || p_trg_kpi;
2063: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
2064:
2065: END IF;
2066: END LOOP;
2067:

Line 2154: x_arr BSC_UPDATE_UTIL.t_array_of_varchar2;

2150: l_num_kpi_metadata_tables NUMBER := 0;
2151: h_table_name VARCHAR2(30);
2152: h_condition VARCHAR2(1000);
2153: h_sql VARCHAR2(32000);
2154: x_arr BSC_UPDATE_UTIL.t_array_of_varchar2;
2155: x_arrayShared_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
2156: x_num NUMBER;
2157: i NUMBER;
2158: h_CSF_id NUMBER;

Line 2155: x_arrayShared_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

2151: h_table_name VARCHAR2(30);
2152: h_condition VARCHAR2(1000);
2153: h_sql VARCHAR2(32000);
2154: x_arr BSC_UPDATE_UTIL.t_array_of_varchar2;
2155: x_arrayShared_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
2156: x_num NUMBER;
2157: i NUMBER;
2158: h_CSF_id NUMBER;
2159: h_Ind_group_id NUMBER;

Line 2364: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2

2360: BEGIN
2361: --Validation
2362: h_sql := 'UPDATE BSC_KPIS_B SET ' || x_Field || ' = :1 '
2363: || ' WHERE INDICATOR=:2'; --|| x_Ind;
2364: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2
2365: Execute Immediate h_sql USING x_Val, x_Ind;
2366: --DBMS_OUTPUT.PUT_LINE('h_sql :' || h_sql );
2367:
2368: EXCEPTION

Line 2381: x_array IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

2377: | FUNCTION Decompose_Varchar_List
2378: +============================================================================*/
2379: FUNCTION Decompose_Varchar_List(
2380: x_string IN VARCHAR2,
2381: x_array IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
2382: x_separator IN VARCHAR2
2383: ) RETURN NUMBER IS
2384:
2385: h_num_items NUMBER := 0;

Line 2960: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

2956: l_colum VARCHAR2(100);
2957: l_key_name VARCHAR2(30);
2958: l_condition VARCHAR2(1000);
2959: l_sql VARCHAR2(32000);
2960: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
2961: l_num_columns NUMBER;
2962: i NUMBER;
2963: BEGIN
2964: -- Initialize BSC/APPS global variables

Line 3065: x_array IN BSC_UPDATE_UTIL.t_array_of_varchar2,

3061: -- Function :
3062: ***********************************************************************************/
3063: FUNCTION Item_Belong_To_Array_Varchar2(
3064: x_item IN VARCHAR2,
3065: x_array IN BSC_UPDATE_UTIL.t_array_of_varchar2,
3066: x_num_items IN NUMBER
3067: ) RETURN BOOLEAN IS
3068:
3069: h_i NUMBER;

Line 3108: l_src_languages BSC_UPDATE_UTIL.t_array_of_varchar2;

3104:
3105: TYPE t_cursor IS REF CURSOR;
3106: c_cursor t_cursor;
3107:
3108: l_src_languages BSC_UPDATE_UTIL.t_array_of_varchar2;
3109: l_num_src_languages NUMBER := 0;
3110: l_trg_languages BSC_UPDATE_UTIL.t_array_of_varchar2;
3111: l_num_trg_languages NUMBER := 0;
3112:

Line 3110: l_trg_languages BSC_UPDATE_UTIL.t_array_of_varchar2;

3106: c_cursor t_cursor;
3107:
3108: l_src_languages BSC_UPDATE_UTIL.t_array_of_varchar2;
3109: l_num_src_languages NUMBER := 0;
3110: l_trg_languages BSC_UPDATE_UTIL.t_array_of_varchar2;
3111: l_num_trg_languages NUMBER := 0;
3112:
3113: l_src_base_language VARCHAR2(4);
3114: l_owner all_tab_columns.owner%TYPE;

Line 3135: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

3131: l_condition VARCHAR2(1000);
3132: l_sql VARCHAR2(32000);
3133: l_insert VARCHAR2(32000);
3134: l_select VARCHAR2(32000);
3135: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
3136: l_num_columns NUMBER;
3137: i NUMBER;
3138: l_Count NUMBER := 0;
3139: BEGIN