DBA Data[Home] [Help]

APPS.BSC_CALCULATIONS_PUB dependencies on BSC_UTILITY

Line 35: l_calc_recs BSC_UTILITY.varchar_tabletype;

31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2
33: )
34: IS
35: l_calc_recs BSC_UTILITY.varchar_tabletype;
36: l_rec_cnt NUMBER;
37: l_calc_props BSC_UTILITY.varchar_tabletype;
38: l_prop_cnt NUMBER;
39: l_calc_id NUMBER;

Line 37: l_calc_props BSC_UTILITY.varchar_tabletype;

33: )
34: IS
35: l_calc_recs BSC_UTILITY.varchar_tabletype;
36: l_rec_cnt NUMBER;
37: l_calc_props BSC_UTILITY.varchar_tabletype;
38: l_prop_cnt NUMBER;
39: l_calc_id NUMBER;
40: l_is_sel VARCHAR2(3);
41: l_def_val NUMBER;

Line 68: BSC_UTILITY.Parse_String(

64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: x_msg_data := x_msg_data || ' INSUFFICIENT DATA ';
66: RETURN;
67: ELSE
68: BSC_UTILITY.Parse_String(
69: p_List => p_params,
70: p_Separator => ';',
71: p_List_Data => l_calc_recs,
72: p_List_number => l_rec_cnt

Line 77: BSC_UTILITY.Parse_String(

73: );
74: SAVEPOINT BSCPCLCB_save_obj_calculations;
75:
76: FOR i IN 1..l_rec_cnt LOOP
77: BSC_UTILITY.Parse_String(
78: p_List => l_calc_recs(i),
79: p_Separator => ',',
80: p_List_Data => l_calc_props,
81: p_List_number => l_prop_cnt

Line 375: l_calc_recs BSC_UTILITY.varchar_tabletype;

371: ,x_msg_count OUT NOCOPY NUMBER
372: ,x_msg_data OUT NOCOPY VARCHAR2
373: ) IS
374:
375: l_calc_recs BSC_UTILITY.varchar_tabletype;
376: l_calc_props BSC_UTILITY.varchar_tabletype;
377: l_calc_recs_cnt NUMBER;
378: l_calc_props_cnt NUMBER;
379: l_calc_rec VARCHAR2(500);

Line 376: l_calc_props BSC_UTILITY.varchar_tabletype;

372: ,x_msg_data OUT NOCOPY VARCHAR2
373: ) IS
374:
375: l_calc_recs BSC_UTILITY.varchar_tabletype;
376: l_calc_props BSC_UTILITY.varchar_tabletype;
377: l_calc_recs_cnt NUMBER;
378: l_calc_props_cnt NUMBER;
379: l_calc_rec VARCHAR2(500);
380: ulv0 NUMBER;

Line 408: BSC_UTILITY.Parse_String (

404:
405:
406: SAVEPOINT bscpclcb_savepoint_save_calcs;
407:
408: BSC_UTILITY.Parse_String (
409: p_List => p_calcs_list,
410: p_Separator => ';',
411: p_List_Data => l_calc_recs,
412: p_List_number => l_calc_recs_cnt

Line 418: BSC_UTILITY.Parse_String (

414:
415: FOR i IN 1..l_calc_recs_cnt LOOP
416: IF (l_calc_recs(i) IS NOT NULL) THEN
417:
418: BSC_UTILITY.Parse_String (
419: p_List => l_calc_recs(i),
420: p_Separator => ',',
421: p_List_Data => l_calc_props,
422: p_List_number => l_calc_props_cnt

Line 697: WHILE (bsc_utility.Is_More(l_measure_col_formula, l_measure_col)) LOOP

693: l_measure_col_formula := REPLACE (l_measure_col_formula, '*',',');
694: l_measure_col_formula := REPLACE (l_measure_col_formula, '/',',');
695:
696:
697: WHILE (bsc_utility.Is_More(l_measure_col_formula, l_measure_col)) LOOP
698: IF (NOT FALSE) THEN
699: FOR cd1 IN c_db_measure_cols (l_measure_col) LOOP
700: IF (cd1.measure_type = 2) THEN
701: RETURN 'Y';