APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_UTILITY

Line 17: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;

13: l_dim_level_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;
14: l_dim_level_val BSC_SYS_FILTERS.dim_level_value%TYPE;
15: l_score_list VARCHAR2(30000);
16: l_level_view_name BSC_KPI_DIM_LEVELS_B.level_view_name%TYPE;
17: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;
18: l_dim_obj_rec VARCHAR2(200);
19: l_dim_obj_cnt NUMBER;
20: l_key_name VARCHAR2(1000);
21: l_dim_props BSC_UTILITY.varchar_tabletype;

Line 21: l_dim_props BSC_UTILITY.varchar_tabletype;

17: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;
18: l_dim_obj_rec VARCHAR2(200);
19: l_dim_obj_cnt NUMBER;
20: l_key_name VARCHAR2(1000);
21: l_dim_props BSC_UTILITY.varchar_tabletype;
22: l_dim_set_id VARCHAR2(20);
23: l_dim_level_index VARCHAR2(20);
24: l_def_key_id VARCHAR2(20);
25: l_cnt NUMBER;

Line 57: BSC_UTILITY.Parse_String

53: FND_MSG_PUB.Initialize;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55: IF(p_kpi_id IS NOT NULL AND p_params IS NOT NULL) THEN
56:
57: BSC_UTILITY.Parse_String
58: (
59: p_List => p_params,
60: p_Separator => ';',
61: p_List_Data => l_dim_obj_recs,

Line 66: BSC_UTILITY.Parse_String

62: p_List_number => l_dim_obj_cnt
63: );
64: FOR i IN 1..l_dim_obj_cnt LOOP
65: l_dim_obj_rec := l_dim_obj_recs(i);
66: BSC_UTILITY.Parse_String
67: (
68: p_List => l_dim_obj_rec,
69: p_Separator => ',',
70: p_List_Data => l_dim_props,

Line 395: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;

391: , x_msg_count OUT NOCOPY NUMBER
392: , x_msg_data OUT NOCOPY VARCHAR2
393: ) IS
394:
395: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;
396: l_dim_obj_rec VARCHAR2(200);
397: l_dim_obj_cnt NUMBER;
398: l_dim_props BSC_UTILITY.varchar_tabletype;
399: l_dim_set_id VARCHAR2(20);

Line 398: l_dim_props BSC_UTILITY.varchar_tabletype;

394:
395: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;
396: l_dim_obj_rec VARCHAR2(200);
397: l_dim_obj_cnt NUMBER;
398: l_dim_props BSC_UTILITY.varchar_tabletype;
399: l_dim_set_id VARCHAR2(20);
400: l_dim_level_id VARCHAR2(20);
401: l_dim_level_index VARCHAR2(20);
402: l_def_key_id VARCHAR2(20);

Line 438: BSC_UTILITY.Parse_String (

434: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: BSC_UTILITY.Parse_String (
439: p_List => p_params,
440: p_Separator => ';',
441: p_List_Data => l_dim_obj_recs,
442: p_List_number => l_dim_obj_cnt

Line 454: BSC_UTILITY.Parse_String(

450:
451: FOR i IN 1..l_dim_obj_cnt LOOP
452: l_dim_obj_rec := l_dim_obj_recs(i);
453:
454: BSC_UTILITY.Parse_String(
455: p_List => l_dim_obj_rec,
456: p_Separator => ',',
457: p_List_Data => l_dim_props,
458: p_List_number => l_cnt