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_COPY_INDICATOR_PUB dependencies on BSC_KPIS_B

Line 54: l_Group_Id bsc_kpis_b.ind_group_id%TYPE;

50: p_Indicator IN NUMBER
51: )
52: RETURN NUMBER IS
53:
54: l_Group_Id bsc_kpis_b.ind_group_id%TYPE;
55:
56: CURSOR c_Ind_Group_Id IS
57: SELECT
58: a.ind_group_id

Line 60: bsc_kpis_b a

56: CURSOR c_Ind_Group_Id IS
57: SELECT
58: a.ind_group_id
59: FROM
60: bsc_kpis_b a
61: WHERE
62: a.indicator = p_Indicator;
63: BEGIN
64: OPEN c_Ind_Group_Id;

Line 254: bsc_kpis_b

250: SELECT COUNT(1)
251: INTO
252: l_Kpi_Count
253: FROM
254: bsc_kpis_b
255: WHERE
256: ind_group_id = p_New_Indicator_Group
257: AND prototype_flag <> -2
258: AND share_flag <> 2;

Line 446: l_Display_Order bsc_kpis_b.disp_order%TYPE := 1;

442: , x_msg_count OUT NOCOPY NUMBER
443: , x_msg_data OUT NOCOPY VARCHAR2
444: ) IS
445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
446: l_Display_Order bsc_kpis_b.disp_order%TYPE := 1;
447: l_Current_Disp_Order bsc_kpis_b.disp_order%TYPE := 1;
448: CURSOR c_Group_Indicators IS
449: SELECT
450: indicator

Line 447: l_Current_Disp_Order bsc_kpis_b.disp_order%TYPE := 1;

443: , x_msg_data OUT NOCOPY VARCHAR2
444: ) IS
445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
446: l_Display_Order bsc_kpis_b.disp_order%TYPE := 1;
447: l_Current_Disp_Order bsc_kpis_b.disp_order%TYPE := 1;
448: CURSOR c_Group_Indicators IS
449: SELECT
450: indicator
451: FROM

Line 452: bsc_kpis_b

448: CURSOR c_Group_Indicators IS
449: SELECT
450: indicator
451: FROM
452: bsc_kpis_b
453: WHERE
454: ind_group_id = p_New_Indicator_Group
455: AND prototype_flag <> 2
456: AND share_flag <> 2

Line 465: bsc_kpis_b

461: CURSOR c_shared_obj(p_Indicator_id NUMBER) IS
462: SELECT
463: indicator
464: FROM
465: bsc_kpis_b
466: WHERE
467: source_indicator = p_Indicator_id
468: AND share_flag = 2
469: AND prototype_flag <> 2;

Line 610: l_old_group_id bsc_kpis_b.ind_group_id%TYPE;

606: , x_msg_count OUT NOCOPY NUMBER
607: , x_msg_data OUT NOCOPY VARCHAR2
608: )
609: IS
610: l_old_group_id bsc_kpis_b.ind_group_id%TYPE;
611: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
612: CURSOR c_shared_obj IS
613: SELECT
614: indicator

Line 616: bsc_kpis_b

612: CURSOR c_shared_obj IS
613: SELECT
614: indicator
615: FROM
616: bsc_kpis_b
617: WHERE
618: source_indicator = p_Indicator
619: AND share_flag = 2
620: AND prototype_flag <> 2;

Line 775: l_EDW_Flag bsc_kpis_b.edw_flag%TYPE;

771: , x_msg_count OUT NOCOPY NUMBER
772: , x_msg_data OUT NOCOPY VARCHAR2
773: ) IS
774:
775: l_EDW_Flag bsc_kpis_b.edw_flag%TYPE;
776: l_PMF_Meas_Cnt NUMBER := 0;
777: l_sql VARCHAR2(32000);
778: TYPE c_cur_type IS REF CURSOR;
779: c_cursor c_cur_type;

Line 780: l_indicator_type bsc_kpis_b.indicator_type%TYPE;

776: l_PMF_Meas_Cnt NUMBER := 0;
777: l_sql VARCHAR2(32000);
778: TYPE c_cur_type IS REF CURSOR;
779: c_cursor c_cur_type;
780: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
781: l_config_type bsc_kpis_b.config_type%TYPE;
782: BEGIN
783:
784: FND_MSG_PUB.Initialize;

Line 781: l_config_type bsc_kpis_b.config_type%TYPE;

777: l_sql VARCHAR2(32000);
778: TYPE c_cur_type IS REF CURSOR;
779: c_cursor c_cur_type;
780: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
781: l_config_type bsc_kpis_b.config_type%TYPE;
782: BEGIN
783:
784: FND_MSG_PUB.Initialize;
785: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 791: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT NVL(edw_flag,0) FROM bsc_kpis_b');

787: SAVEPOINT BscValIndCopyUIWrap;
788:
789: IF BSC_DESIGNER_PVT.g_DbLink_Name IS NOT NULL THEN
790:
791: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT NVL(edw_flag,0) FROM bsc_kpis_b');
792: l_sql := l_sql || ' WHERE indicator = :1';
793: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
794: FETCH c_cursor INTO l_EDW_Flag;
795: CLOSE c_cursor;

Line 802: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT indicator_type,config_type FROM bsc_kpis_b');

798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801:
802: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT indicator_type,config_type FROM bsc_kpis_b');
803: l_sql := l_sql || ' WHERE indicator = :1';
804: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
805: FETCH c_cursor INTO l_indicator_type,l_config_type;
806: CLOSE c_cursor;

Line 1261: l_Source_Calendar bsc_kpis_b.calendar_id%TYPE;

1257: l_Target_Per_Type bsc_sys_periodicities.periodicity_type%TYPE;
1258: l_sql VARCHAR2(32000);
1259: TYPE c_cur_type IS REF CURSOR;
1260: c_cursor c_cur_type;
1261: l_Source_Calendar bsc_kpis_b.calendar_id%TYPE;
1262: l_Default_Periodicity bsc_kpis_b.periodicity_id%TYPE;
1263: l_New_Periodicity bsc_kpis_b.periodicity_id%TYPE := NULL;
1264: l_Count NUMBER := 0;
1265: l_Deleted_Periodicities FND_TABLE_OF_NUMBER;

Line 1262: l_Default_Periodicity bsc_kpis_b.periodicity_id%TYPE;

1258: l_sql VARCHAR2(32000);
1259: TYPE c_cur_type IS REF CURSOR;
1260: c_cursor c_cur_type;
1261: l_Source_Calendar bsc_kpis_b.calendar_id%TYPE;
1262: l_Default_Periodicity bsc_kpis_b.periodicity_id%TYPE;
1263: l_New_Periodicity bsc_kpis_b.periodicity_id%TYPE := NULL;
1264: l_Count NUMBER := 0;
1265: l_Deleted_Periodicities FND_TABLE_OF_NUMBER;
1266: l_Periodicity_Id bsc_sys_periodicities.periodicity_id%TYPE;

Line 1263: l_New_Periodicity bsc_kpis_b.periodicity_id%TYPE := NULL;

1259: TYPE c_cur_type IS REF CURSOR;
1260: c_cursor c_cur_type;
1261: l_Source_Calendar bsc_kpis_b.calendar_id%TYPE;
1262: l_Default_Periodicity bsc_kpis_b.periodicity_id%TYPE;
1263: l_New_Periodicity bsc_kpis_b.periodicity_id%TYPE := NULL;
1264: l_Count NUMBER := 0;
1265: l_Deleted_Periodicities FND_TABLE_OF_NUMBER;
1266: l_Periodicity_Id bsc_sys_periodicities.periodicity_id%TYPE;
1267: l_Found BOOLEAN := FALSE;

Line 1332: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT calendar_id FROM bsc_kpis_b');

1328: indicator = p_Target_Indicator AND
1329: periodicity_id = p_Old_Periodicities(i);
1330: END IF;
1331:
1332: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT calendar_id FROM bsc_kpis_b');
1333: l_sql := l_sql || 'WHERE indicator = :1';
1334:
1335: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
1336: FETCH c_cursor INTO l_Source_Calendar;

Line 1391: bsc_kpis_b

1387: periodicity_id
1388: INTO
1389: l_Default_Periodicity
1390: FROM
1391: bsc_kpis_b
1392: WHERE
1393: indicator = p_Target_Indicator;
1394:
1395: FOR i IN 1..p_Old_Periodicities.COUNT LOOP

Line 1416: bsc_kpis_b

1412: display_order;
1413: END IF;
1414:
1415: UPDATE
1416: bsc_kpis_b
1417: SET
1418: periodicity_id = l_New_Periodicity ,
1419: calendar_id = p_Target_Calendar
1420: WHERE

Line 2095: l_Indic_Type bsc_kpis_b.indicator_type%TYPE;

2091: , x_msg_count OUT NOCOPY NUMBER
2092: , x_msg_data OUT NOCOPY VARCHAR2
2093: )IS
2094: l_sql VARCHAR2(32000);
2095: l_Indic_Type bsc_kpis_b.indicator_type%TYPE;
2096: l_Config_Type bsc_kpis_b.config_type%TYPE;
2097: TYPE c_cur_type IS REF CURSOR;
2098: c_cursor c_cur_type;
2099:

Line 2096: l_Config_Type bsc_kpis_b.config_type%TYPE;

2092: , x_msg_data OUT NOCOPY VARCHAR2
2093: )IS
2094: l_sql VARCHAR2(32000);
2095: l_Indic_Type bsc_kpis_b.indicator_type%TYPE;
2096: l_Config_Type bsc_kpis_b.config_type%TYPE;
2097: TYPE c_cur_type IS REF CURSOR;
2098: c_cursor c_cur_type;
2099:
2100: CURSOR c_Indic IS

Line 2439: l_Target_Indicator bsc_kpis_b.indicator%TYPE;

2435: , x_msg_count OUT NOCOPY NUMBER
2436: , x_msg_data OUT NOCOPY VARCHAR2
2437: ) IS
2438: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2439: l_Target_Indicator bsc_kpis_b.indicator%TYPE;
2440: l_sql VARCHAR2(32000);
2441: l_Responsibility_Key_List VARCHAR2(200);
2442: l_Short_Name bsc_kpis_b.short_name%TYPE;
2443: l_Region_Code ak_regions.region_code%TYPE;

Line 2442: l_Short_Name bsc_kpis_b.short_name%TYPE;

2438: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2439: l_Target_Indicator bsc_kpis_b.indicator%TYPE;
2440: l_sql VARCHAR2(32000);
2441: l_Responsibility_Key_List VARCHAR2(200);
2442: l_Short_Name bsc_kpis_b.short_name%TYPE;
2443: l_Region_Code ak_regions.region_code%TYPE;
2444: BEGIN
2445:
2446: FND_MSG_PUB.Initialize;

Line 2515: bsc_kpis_b

2511: short_name
2512: INTO
2513: l_Short_Name
2514: FROM
2515: bsc_kpis_b
2516: WHERE
2517: indicator = l_Target_Indicator;
2518:
2519: Move_Indicator (