DBA Data[Home] [Help]

APPS.BSC_AOP_TPLATE dependencies on BSC_APPS

Line 147: l_debug_stmt := bsc_apps.get_message('BSC_ERROR_CREATE_AO');

143: G_PD_Tbl(3).num_of_calc := 7;
144:
145:
146: if (NOT create_option_relations(l_num_of_options, l_num_of_data)) then
147: l_debug_stmt := bsc_apps.get_message('BSC_ERROR_CREATE_AO');
148: Raise BSC_AOP_ERROR;
149: end if;
150:
151: Return(TRUE);

Line 266: BSC_APPS.Execute_Immediate(l_sql);

262: 'NULL AS MEASURE_TYPE '||
263: 'FROM '||BSC_TEMPLATE.LOOKUP_VALUES_TABLE||' FEM '||
264: 'WHERE FEM.LOOKUP_TYPE = ''BSC_TPLATE_TAB_DATASET_NAME'' AND '||
265: 'FEM.LOOKUP_CODE = '''||G_PF_Tbl(i_option).Measure_id||'''';
266: BSC_APPS.Execute_Immediate(l_sql);
267: end if;
268: End Loop; -- analysis option loop
269:
270:

Line 310: BSC_APPS.Execute_Immediate(l_sql);

306: 'SUBSTR(FEM.MEANING,1,80) AS HELP '||
307: 'FROM '||BSC_TEMPLATE.LOOKUP_VALUES_TABLE||' FEM '||
308: 'WHERE FEM.LOOKUP_TYPE = ''BSC_TPLATE_TAB_DATASET_NAME'' AND '||
309: 'FEM.LOOKUP_CODE = '''||G_PD_Tbl(i_data).Dataset_id||'''';
310: BSC_APPS.Execute_Immediate(l_sql);
311:
312: For i_proj_calc In 0 .. (G_PD_Tbl(i_data).num_of_calc -1)
313: Loop
314: