DBA Data[Home] [Help]

APPS.BSC_COMMON_DIMENSIONS_PUB dependencies on BSC_UTILITY

Line 173: l_new_dim_obj_recs BSC_UTILITY.varchar_tabletype;

169: WHERE indicator IN (SELECT DISTINCT ti.indicator
170: FROM bsc_tab_indicators ti
171: WHERE ti.tab_id = p_tab_id);
172:
173: l_new_dim_obj_recs BSC_UTILITY.varchar_tabletype;
174: l_new_dim_obj_cnt NUMBER;
175: l_new_dim_props BSC_UTILITY.varchar_tabletype;
176: l_new_cnt NUMBER;
177:

Line 175: l_new_dim_props BSC_UTILITY.varchar_tabletype;

171: WHERE ti.tab_id = p_tab_id);
172:
173: l_new_dim_obj_recs BSC_UTILITY.varchar_tabletype;
174: l_new_dim_obj_cnt NUMBER;
175: l_new_dim_props BSC_UTILITY.varchar_tabletype;
176: l_new_cnt NUMBER;
177:
178: l_old_dim_obj_recs BSC_UTILITY.varchar_tabletype;
179: l_old_dim_obj_cnt NUMBER;

Line 178: l_old_dim_obj_recs BSC_UTILITY.varchar_tabletype;

174: l_new_dim_obj_cnt NUMBER;
175: l_new_dim_props BSC_UTILITY.varchar_tabletype;
176: l_new_cnt NUMBER;
177:
178: l_old_dim_obj_recs BSC_UTILITY.varchar_tabletype;
179: l_old_dim_obj_cnt NUMBER;
180: l_old_dim_props BSC_UTILITY.varchar_tabletype;
181: l_old_cnt NUMBER;
182:

Line 180: l_old_dim_props BSC_UTILITY.varchar_tabletype;

176: l_new_cnt NUMBER;
177:
178: l_old_dim_obj_recs BSC_UTILITY.varchar_tabletype;
179: l_old_dim_obj_cnt NUMBER;
180: l_old_dim_props BSC_UTILITY.varchar_tabletype;
181: l_old_cnt NUMBER;
182:
183: l_index NUMBER;
184: l_user_id NUMBER;

Line 194: BSC_UTILITY.Parse_String(

190:
191: IF (p_old_list_config IS NULL) THEN
192: l_old_dim_obj_cnt := 0;
193: ELSE
194: BSC_UTILITY.Parse_String(
195: p_List => p_old_list_config,
196: p_Separator => ';',
197: p_List_Data => l_old_dim_obj_recs,
198: p_List_number => l_old_dim_obj_cnt

Line 205: BSC_UTILITY.Parse_String(

201:
202: IF (p_new_list_config IS NULL) THEN
203: l_new_dim_obj_cnt := 0;
204: ELSE
205: BSC_UTILITY.Parse_String(
206: p_List => p_new_list_config,
207: p_Separator => ';',
208: p_List_Data => l_new_dim_obj_recs,
209: p_List_number => l_new_dim_obj_cnt

Line 263: BSC_UTILITY.Parse_String(

259: l_login_id := fnd_global.LOGIN_ID;
260: FOR cd IN c_tab_responsibilities LOOP
261: FOR i IN 1..l_new_dim_obj_cnt LOOP
262: l_new_cnt := 0;
263: BSC_UTILITY.Parse_String(
264: p_List => l_new_dim_obj_recs(i),
265: p_Separator => ',',
266: p_List_Data => l_new_dim_props,
267: p_List_number => l_new_cnt);