APPS.BSC_AOP_TPLATE dependencies on BSC_TEMPLATE

Line 5: G_PF_Tbl BSC_TEMPLATE.Proj_Field_Tbl_Type;

1: PACKAGE BODY BSC_AOP_TPLATE AS
2: /* $Header: BSCUAOPB.pls 115.10 2003/06/20 22:24:09 meastmon ship $ */
3:
4:
5: G_PF_Tbl BSC_TEMPLATE.Proj_Field_Tbl_Type;
6: G_PD_Tbl BSC_TEMPLATE.Proj_Data_Tbl_Type;
7: G_Cal_Tbl BSC_TEMPLATE.Cal_Tbl_Type;
8:
9: /*===========================================================================+

Line 6: G_PD_Tbl BSC_TEMPLATE.Proj_Data_Tbl_Type;

2: /* $Header: BSCUAOPB.pls 115.10 2003/06/20 22:24:09 meastmon ship $ */
3:
4:
5: G_PF_Tbl BSC_TEMPLATE.Proj_Field_Tbl_Type;
6: G_PD_Tbl BSC_TEMPLATE.Proj_Data_Tbl_Type;
7: G_Cal_Tbl BSC_TEMPLATE.Cal_Tbl_Type;
8:
9: /*===========================================================================+
10: |

Line 7: G_Cal_Tbl BSC_TEMPLATE.Cal_Tbl_Type;

3:
4:
5: G_PF_Tbl BSC_TEMPLATE.Proj_Field_Tbl_Type;
6: G_PD_Tbl BSC_TEMPLATE.Proj_Data_Tbl_Type;
7: G_Cal_Tbl BSC_TEMPLATE.Cal_Tbl_Type;
8:
9: /*===========================================================================+
10: |
11: | Name: Create_Analysis_Options

Line 263: 'FROM '||BSC_TEMPLATE.LOOKUP_VALUES_TABLE||' FEM '||

259: 'SUBSTR(FEM.MEANING,1,50) AS HELP, '||
260: '-1 AS MEASURE_GROUP_ID, '||
261: '3 AS PROJECTION_ID, '||
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;

Line 307: 'FROM '||BSC_TEMPLATE.LOOKUP_VALUES_TABLE||' FEM '||

303: 'FEM.LANGUAGE AS LANGUAGE, '||
304: 'FEM.SOURCE_LANG AS SOURCE_LANG, '||
305: 'SUBSTR(FEM.MEANING,1,20) AS NAME, '||
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:

Line 345: X_Source => 'bsc_template.create_crx_template',

341: X_Mode => 'I');
342:
343: BSC_MESSAGE.Add(
344: X_Message => l_debug_stmt,
345: X_Source => 'bsc_template.create_crx_template',
346: x_type => 3,
347: X_Mode => 'I');
348:
349: Return(FALSE);