APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_EDIT_VLIST

Line 2583: l_level_table_names BSC_EDIT_VLIST;

2579: l_dim_short_names VARCHAR2(32000);
2580: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2581: l_temp_var VARCHAR2(32000);
2582: l_kpi_flag_change BOOLEAN := FALSE;
2583: l_level_table_names BSC_EDIT_VLIST;
2584: l_key_item_values FND_TABLE_OF_NUMBER;
2585: l_key_item NUMBER;
2586:
2587: CURSOR c_kpi_ids IS

Line 2605: TABLE(CAST(l_level_table_names AS BSC_EDIT_VLIST));

2601: INTERSECT
2602: SELECT
2603: column_value level_table_name
2604: FROM
2605: TABLE(CAST(l_level_table_names AS BSC_EDIT_VLIST));
2606: BEGIN
2607: SAVEPOINT AssBSCDimToDSetPMD;
2608: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Assign_Dims_To_Dim_Set procedure');
2609: FND_MSG_PUB.Initialize;

Line 2922: l_level_table_names BSC_EDIT_VLIST;

2918: l_unassign_dim_objs VARCHAR2(32000);
2919: l_temp VARCHAR2(32000);
2920:
2921: l_flag BOOLEAN;
2922: l_level_table_names BSC_EDIT_VLIST;
2923: l_key_item_values FND_TABLE_OF_NUMBER;
2924: l_key_item NUMBER;
2925:
2926: CURSOR c_Dim_Levels IS

Line 2938: TABLE(CAST(l_level_table_names AS BSC_EDIT_VLIST));

2934: INTERSECT
2935: SELECT
2936: column_value level_table_name
2937: FROM
2938: TABLE(CAST(l_level_table_names AS BSC_EDIT_VLIST));
2939:
2940:
2941: BEGIN
2942: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Assign_Unassign_Dimensions procedure');