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_SIMULATION_VIEW_PVT dependencies on FND_FORM_FUNCTIONS

Line 288: --////////////Fnd form functions table //////////////

284: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
285: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
286:
287:
288: --////////////Fnd form functions table //////////////
289: x_Table_Number := x_Table_Number + 1;
290: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS';
291: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
292: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;

Line 290: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS';

286:
287:
288: --////////////Fnd form functions table //////////////
289: x_Table_Number := x_Table_Number + 1;
290: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS';
291: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
292: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;
293: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
294: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;

Line 298: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS_TL';

294: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
295:
296:
297: x_Table_Number := x_Table_Number + 1;
298: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS_TL';
299: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
300: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;
301: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
302: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;

Line 333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;

329: l_new_region_code AK_REGIONS.region_code%TYPE;
330: l_region_code AK_REGIONS.region_code%TYPE;
331: l_count NUMBER;
332: l_owner all_tab_columns.owner%TYPE;
333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
334: l_old_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
335: l_parameters FND_FORM_FUNCTIONS.parameters%TYPE;
336: cd BSC_BIS_LOCKS_PUB.t_cursor;
337:

Line 334: l_old_function_id FND_FORM_FUNCTIONS.function_id%TYPE;

330: l_region_code AK_REGIONS.region_code%TYPE;
331: l_count NUMBER;
332: l_owner all_tab_columns.owner%TYPE;
333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
334: l_old_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
335: l_parameters FND_FORM_FUNCTIONS.parameters%TYPE;
336: cd BSC_BIS_LOCKS_PUB.t_cursor;
337:
338:

Line 335: l_parameters FND_FORM_FUNCTIONS.parameters%TYPE;

331: l_count NUMBER;
332: l_owner all_tab_columns.owner%TYPE;
333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
334: l_old_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
335: l_parameters FND_FORM_FUNCTIONS.parameters%TYPE;
336: cd BSC_BIS_LOCKS_PUB.t_cursor;
337:
338:
339: CURSOR c_column IS

Line 380: IF(p_table_name = 'FND_FORM_FUNCTIONS_TL')THEN

376: h_key_name := 'FUNCTION_NAME';
377: l_new_function_id := p_new_form_function;
378: h_condition := 'FUNCTION_NAME =''' || l_region_code || '''';
379:
380: IF(p_table_name = 'FND_FORM_FUNCTIONS_TL')THEN
381: IF p_DbLink_Name IS NULL THEN
382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';
383: ELSE
384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';

Line 382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';

378: h_condition := 'FUNCTION_NAME =''' || l_region_code || '''';
379:
380: IF(p_table_name = 'FND_FORM_FUNCTIONS_TL')THEN
381: IF p_DbLink_Name IS NULL THEN
382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';
383: ELSE
384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';
385: END IF;
386: OPEN cd FOR h_sql USING l_region_code;

Line 384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';

380: IF(p_table_name = 'FND_FORM_FUNCTIONS_TL')THEN
381: IF p_DbLink_Name IS NULL THEN
382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';
383: ELSE
384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';
385: END IF;
386: OPEN cd FOR h_sql USING l_region_code;
387: FETCH cd INTO l_old_function_id;
388: CLOSE cd;

Line 442: IF(p_table_name = 'FND_FORM_FUNCTIONS')THEN

438:
439: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
440: END IF;
441:
442: IF(p_table_name = 'FND_FORM_FUNCTIONS')THEN
443: UPDATE FND_FORM_FUNCTIONS
444: SET PARAMETERS = REPLACE(PARAMETERS,''||l_region_code||'',''|| l_new_region_code || '')
445: WHERE FUNCTION_ID = l_new_function_id;
446: END IF;

Line 443: UPDATE FND_FORM_FUNCTIONS

439: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
440: END IF;
441:
442: IF(p_table_name = 'FND_FORM_FUNCTIONS')THEN
443: UPDATE FND_FORM_FUNCTIONS
444: SET PARAMETERS = REPLACE(PARAMETERS,''||l_region_code||'',''|| l_new_region_code || '')
445: WHERE FUNCTION_ID = l_new_function_id;
446: END IF;
447:

Line 1279: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;

1275: SELECT node_id
1276: FROM bsc_kpi_tree_nodes_vl
1277: WHERE indicator =p_target_kpi;
1278:
1279: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
1280:
1281:
1282: BEGIN
1283: SAVEPOINT copysimmetadata;

Line 1298: SELECT FND_FORM_FUNCTIONS_S.NEXTVAL

1294: );
1295:
1296: l_new_region_code := BSC_BIS_KPI_CRUD_PUB.Generate_Unique_Region_Code();
1297:
1298: SELECT FND_FORM_FUNCTIONS_S.NEXTVAL
1299: INTO l_new_function_id
1300: FROM dual;
1301:
1302:

Line 1460: l_function_id FND_FORM_FUNCTIONS.function_id%TYPE;

1456: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1457: l_Table_Number NUMBER;
1458: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
1459: l_region_code AK_REGIONS.region_code%TYPE;
1460: l_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
1461: l_source_kpi BSC_KPIS_B.indicator%TYPE;
1462: l_target_kpi BSC_KPIS_B.indicator%TYPE;
1463: l_default_node BSC_SYS_DATASETS_VL.dataset_id%TYPE;
1464: l_count NUMBER;

Line 1466: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;

1462: l_target_kpi BSC_KPIS_B.indicator%TYPE;
1463: l_default_node BSC_SYS_DATASETS_VL.dataset_id%TYPE;
1464: l_count NUMBER;
1465: l_shared_Obj_Tbl BSC_SIMULATION_VIEW_PVT.Bsc_Shared_Obj_Tbl_Type ;
1466: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1467:
1468: BEGIN
1469:
1470: --First delete the entries from bsc_tab_view_labels,bsc_kpi_tree_nodes,ak_region tables

Line 1771: FROM fnd_form_functions_vl

1767: ) IS
1768:
1769: CURSOR c_form_functions IS
1770: SELECT parameters
1771: FROM fnd_form_functions_vl
1772: WHERE function_name =p_ind_Sht_Name;
1773:
1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;
1775: l_dim_dimobjs_record BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;

Line 1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;

1770: SELECT parameters
1771: FROM fnd_form_functions_vl
1772: WHERE function_name =p_ind_Sht_Name;
1773:
1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;
1775: l_dim_dimobjs_record BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
1776: l_non_time_counter NUMBER;
1777: l_attribute2 ak_region_items_vl.attribute2%TYPE;
1778: l_default_value NUMBER;