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_OBJ_ANALYSIS_OPTIONS_PUB dependencies on FND_TABLE_OF_NUMBER

Line 1558: --l_Initial_Kpi_Meas FND_TABLE_OF_NUMBER;

1554: l_criteria VARCHAR2(2000);
1555: l_sql VARCHAR2(2000);
1556: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1557: l_commit VARCHAR2(2) := FND_API.G_FALSE;
1558: --l_Initial_Kpi_Meas FND_TABLE_OF_NUMBER;
1559: BEGIN
1560:
1561: SAVEPOINT Delete_Mind_Data_PVT;
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2324: l_olddim_set_ids FND_TABLE_OF_NUMBER;

2320: l_Initial_Options NUMBER := 0;
2321: l_Reset_Child_Defaults BOOLEAN := FALSE;
2322: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2323: l_commit VARCHAR2(2) := FND_API.G_FALSE;
2324: l_olddim_set_ids FND_TABLE_OF_NUMBER;
2325: l_newdim_set_ids FND_TABLE_OF_NUMBER;
2326: l_Removed_Dim_Set_Ids FND_TABLE_OF_NUMBER;
2327:
2328: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

Line 2325: l_newdim_set_ids FND_TABLE_OF_NUMBER;

2321: l_Reset_Child_Defaults BOOLEAN := FALSE;
2322: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2323: l_commit VARCHAR2(2) := FND_API.G_FALSE;
2324: l_olddim_set_ids FND_TABLE_OF_NUMBER;
2325: l_newdim_set_ids FND_TABLE_OF_NUMBER;
2326: l_Removed_Dim_Set_Ids FND_TABLE_OF_NUMBER;
2327:
2328: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
2329:

Line 2326: l_Removed_Dim_Set_Ids FND_TABLE_OF_NUMBER;

2322: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2323: l_commit VARCHAR2(2) := FND_API.G_FALSE;
2324: l_olddim_set_ids FND_TABLE_OF_NUMBER;
2325: l_newdim_set_ids FND_TABLE_OF_NUMBER;
2326: l_Removed_Dim_Set_Ids FND_TABLE_OF_NUMBER;
2327:
2328: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
2329:
2330: i NUMBER;

Line 2446: TABLE(CAST(l_olddim_set_ids AS FND_TABLE_OF_NUMBER)) t

2442: FROM
2443: (SELECT
2444: t.column_value
2445: FROM
2446: TABLE(CAST(l_olddim_set_ids AS FND_TABLE_OF_NUMBER)) t
2447: MINUS
2448: SELECT
2449: t.column_value
2450: FROM

Line 2451: TABLE(CAST(l_newdim_set_ids AS FND_TABLE_OF_NUMBER)) t );

2447: MINUS
2448: SELECT
2449: t.column_value
2450: FROM
2451: TABLE(CAST(l_newdim_set_ids AS FND_TABLE_OF_NUMBER)) t );
2452:
2453: FOR i in 1..l_Removed_Dim_Set_Ids.COUNT LOOP
2454: BSC_BIS_KPI_MEAS_PUB.Remove_Unused_PMF_Dimenison
2455: ( p_commit => FND_API.G_FALSE