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 BSC_KPIS_B

Line 6: p_indicator IN BSC_KPIS_B.indicator%TYPE

2: /* $Header: BSCSIMVB.pls 120.6.12000000.1 2007/07/17 07:44:29 appldev noship $ */
3:
4: FUNCTION Get_Default_Node
5: (
6: p_indicator IN BSC_KPIS_B.indicator%TYPE
7: )RETURN NUMBER IS
8: l_node_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;
9: BEGIN
10:

Line 104: FROM bsc_kpis_b

100: l_dataset_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;
101: BEGIN
102: SELECT short_name
103: INTO l_region_Code
104: FROM bsc_kpis_b
105: WHERE config_Type =BSC_SIMULATION_VIEW_PUB.c_TYPE
106: AND indicator = p_tarInd;
107:
108: SELECT dat.dataset_id

Line 366: h_sql := 'SELECT short_name FROM bsc_kpis_b WHERE indicator = :1';

362:
363: IF(p_Src_kpi IS NOT NULL AND p_Trg_kpi IS NOT NULL) THEN
364:
365: IF p_DbLink_Name IS NULL THEN
366: h_sql := 'SELECT short_name FROM bsc_kpis_b WHERE indicator = :1';
367: ELSE
368: h_sql := 'SELECT short_name FROM bsc_kpis_b@'|| p_DbLink_Name || ' WHERE indicator = :1';
369: END IF;
370: OPEN cd FOR h_sql USING p_Src_kpi;

Line 368: h_sql := 'SELECT short_name FROM bsc_kpis_b@'|| p_DbLink_Name || ' WHERE indicator = :1';

364:
365: IF p_DbLink_Name IS NULL THEN
366: h_sql := 'SELECT short_name FROM bsc_kpis_b WHERE indicator = :1';
367: ELSE
368: h_sql := 'SELECT short_name FROM bsc_kpis_b@'|| p_DbLink_Name || ' WHERE indicator = :1';
369: END IF;
370: OPEN cd FOR h_sql USING p_Src_kpi;
371: FETCH cd INTO l_region_code;
372: CLOSE cd;

Line 635: FROM bsc_kpis_b

631: -- of the calculated kpis which were created for the duplicate objective
632:
633: SELECT short_name
634: INTO l_region_Code
635: FROM bsc_kpis_b
636: WHERE config_Type =BSC_SIMULATION_VIEW_PUB.c_TYPE
637: AND indicator = p_source_kpi;
638:
639: FOR cd IN c_cust_labels LOOP

Line 784: FROM bsc_kpis_b B,

780: l_attribute21 bis_ak_region_extension.attribute21%TYPE;
781:
782: CURSOR c_kpi IS
783: SELECT A.region_code,A.region_application_id
784: FROM bsc_kpis_b B,
785: ak_regions A
786: WHERE A.region_code =B.short_name
787: AND B.indicator = p_indicator
788: AND B.config_type = BSC_SIMULATION_VIEW_PUB.c_TYPE;

Line 1322: UPDATE bsc_kpis_b

1318: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi,l_new_region_code,l_new_function_id);
1319: END IF;
1320: END LOOP;
1321:
1322: UPDATE bsc_kpis_b
1323: SET short_name =l_new_region_code
1324: WHERE indicator =p_target_kpi;
1325:
1326: UPDATE ak_regions

Line 1339: p_indicator IN BSC_KPIS_B.indicator%TYPE

1335:
1336:
1337: PROCEDURE Set_Ak_Format_Id
1338: (
1339: p_indicator IN BSC_KPIS_B.indicator%TYPE
1340: ,p_dataset_Id IN BSC_SYS_DATASETS_VL.dataset_id%TYPE
1341: ,p_format_Id IN BSC_KPI_TREE_NODES_VL.format_id%TYPE
1342: ,x_return_status OUT NOCOPY VARCHAR2
1343: ,x_msg_count OUT NOCOPY NUMBER

Line 1443: p_indicator IN BSC_KPIS_B.indicator%TYPE

1439:
1440:
1441: PROCEDURE Handle_Shared_Objectives
1442: (
1443: p_indicator IN BSC_KPIS_B.indicator%TYPE
1444: ,x_return_status OUT NOCOPY VARCHAR2
1445: ,x_msg_count OUT NOCOPY NUMBER
1446: ,x_msg_data OUT NOCOPY VARCHAR2
1447: ) IS

Line 1451: FROM BSC_KPIS_B

1447: ) IS
1448:
1449: CURSOR c_kpi_ids IS
1450: SELECT indicator,short_name
1451: FROM BSC_KPIS_B
1452: WHERE Source_Indicator = p_indicator
1453: AND config_type =7
1454: AND Prototype_Flag <> 2;
1455:

Line 1461: l_source_kpi BSC_KPIS_B.indicator%TYPE;

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;
1465: l_shared_Obj_Tbl BSC_SIMULATION_VIEW_PVT.Bsc_Shared_Obj_Tbl_Type ;

Line 1462: l_target_kpi BSC_KPIS_B.indicator%TYPE;

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;
1465: l_shared_Obj_Tbl BSC_SIMULATION_VIEW_PVT.Bsc_Shared_Obj_Tbl_Type ;
1466: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;

Line 1762: p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE

1758: /****************************************/
1759:
1760: PROCEDURE Set_Sim_Key_Values
1761: (
1762: p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE
1763: ,p_indicator IN BSC_KPIS_B.indicator%TYPE
1764: ,x_return_status OUT NOCOPY VARCHAR2
1765: ,x_msg_count OUT NOCOPY NUMBER
1766: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1763: ,p_indicator IN BSC_KPIS_B.indicator%TYPE

1759:
1760: PROCEDURE Set_Sim_Key_Values
1761: (
1762: p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE
1763: ,p_indicator IN BSC_KPIS_B.indicator%TYPE
1764: ,x_return_status OUT NOCOPY VARCHAR2
1765: ,x_msg_count OUT NOCOPY NUMBER
1766: ,x_msg_data OUT NOCOPY VARCHAR2
1767: ) IS