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_KPI_PVT dependencies on BSC_KPI_DATA_TABLES

Line 661: -- Validate Records in BSC_KPI_DATA_TABLES

657:
658:
659: -- Added for Bug #3248729
660: IF BSC_UTILITY.isBscInProductionMode THEN
661: -- Validate Records in BSC_KPI_DATA_TABLES
662: SELECT COUNT(INDICATOR)
663: INTO l_count
664: FROM BSC_KPI_DATA_TABLES
665: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id

Line 664: FROM BSC_KPI_DATA_TABLES

660: IF BSC_UTILITY.isBscInProductionMode THEN
661: -- Validate Records in BSC_KPI_DATA_TABLES
662: SELECT COUNT(INDICATOR)
663: INTO l_count
664: FROM BSC_KPI_DATA_TABLES
665: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
666: AND TABLE_NAME IS NOT NULL; -- need to check if actual KPI Tables are there
667:
668: IF l_count > 0 THEN

Line 2624: l_db_object := 'BSC_KPI_DATA_TABLES';

2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: end if;
2623:
2624: l_db_object := 'BSC_KPI_DATA_TABLES';
2625:
2626: insert into BSC_KPI_DATA_TABLES( indicator
2627: ,periodicity_id
2628: ,dim_set_id

Line 2626: insert into BSC_KPI_DATA_TABLES( indicator

2622: end if;
2623:
2624: l_db_object := 'BSC_KPI_DATA_TABLES';
2625:
2626: insert into BSC_KPI_DATA_TABLES( indicator
2627: ,periodicity_id
2628: ,dim_set_id
2629: ,level_comb
2630: ,table_name

Line 2718: from BSC_KPI_DATA_TABLES

2714: ,filter_condition
2715: into x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Level_Comb
2716: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Table_Name
2717: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Filter_Condition
2718: from BSC_KPI_DATA_TABLES
2719: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
2720: and dim_set_id = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Set_Id
2721: and periodicity_id = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id;
2722:

Line 2829: update BSC_KPI_DATA_TABLES

2825: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Filter_Condition is not null then
2826: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Filter_Condition := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Filter_Condition;
2827: end if;
2828:
2829: update BSC_KPI_DATA_TABLES
2830: set level_comb = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Level_Comb
2831: ,table_name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Table_Name
2832: ,filter_condition = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Filter_Condition
2833: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id

Line 2925: FROM BSC_KPI_DATA_TABLES

2921: IF BSC_UTILITY.isBscInProductionMode THEN
2922:
2923: SELECT COUNT(INDICATOR)
2924: INTO l_count
2925: FROM BSC_KPI_DATA_TABLES
2926: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
2927: AND TABLE_NAME IS NOT NULL; -- need to check if actual KPI Tables are there
2928:
2929: IF l_count > 0 THEN

Line 2938: DELETE FROM BSC_KPI_DATA_TABLES

2934:
2935:
2936: IF (l_Delete_Kpi_Data) THEN
2937:
2938: DELETE FROM BSC_KPI_DATA_TABLES
2939: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2940:
2941: END IF;
2942:

Line 5474: /* Delete Rows in BSC_KPI_DATA_TABLES for the Share KPI

5470: set USER_LEVEL1 = USER_LEVEL0
5471: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5472:
5473: -- Fix issue in bug 3248729
5474: /* Delete Rows in BSC_KPI_DATA_TABLES for the Share KPI
5475: We can not use procedure Delete_Kpi_Data_tables because of the
5476: validation added when the KPI is deleting */
5477:
5478: DELETE FROM BSC_KPI_DATA_TABLES

Line 5478: DELETE FROM BSC_KPI_DATA_TABLES

5474: /* Delete Rows in BSC_KPI_DATA_TABLES for the Share KPI
5475: We can not use procedure Delete_Kpi_Data_tables because of the
5476: validation added when the KPI is deleting */
5477:
5478: DELETE FROM BSC_KPI_DATA_TABLES
5479: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5480: -- Fix issue in bug 3248729
5481:
5482: