APPS.BSC_BIA_WRAPPER dependencies on BSC_BIA_WRAPPER

Line 1: PACKAGE BODY BSC_BIA_WRAPPER AS

1: PACKAGE BODY BSC_BIA_WRAPPER AS
2: /* $Header: BSCBIAWB.pls 120.3 2006/04/19 11:46:08 meastmon noship $ */
3:
4:
5: /*===========================================================================+

Line 89: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',

85: EXCEPTION
86: WHEN e_error THEN
87: BSC_MESSAGE.flush;
88: BSC_MESSAGE.Add(x_message => l_error_message,
89: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',
90: x_mode => 'I');
91: COMMIT;
92:
93: WHEN OTHERS THEN

Line 95: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',

91: COMMIT;
92:
93: WHEN OTHERS THEN
94: BSC_MESSAGE.Add(x_message => SQLERRM,
95: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',
96: x_mode => 'I');
97: COMMIT;
98:
99: END Drop_Rpt_Key_Table_VB;

Line 166: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',

162: EXCEPTION
163: WHEN e_error THEN
164: BSC_MESSAGE.flush;
165: BSC_MESSAGE.Add(x_message => l_error_message,
166: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',
167: x_mode => 'I');
168: COMMIT;
169:
170: WHEN OTHERS THEN

Line 172: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',

168: COMMIT;
169:
170: WHEN OTHERS THEN
171: BSC_MESSAGE.Add(x_message => SQLERRM,
172: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',
173: x_mode => 'I');
174: COMMIT;
175:
176: END Drop_Summary_MV_VB;

Line 367: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',

363: EXCEPTION
364: WHEN e_error THEN
365: BSC_MESSAGE.flush;
366: BSC_MESSAGE.Add(x_message => l_error_message||'. p_kpi='||p_kpi,
367: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',
368: x_mode => 'I');
369: COMMIT;
370:
371: WHEN OTHERS THEN

Line 373: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',

369: COMMIT;
370:
371: WHEN OTHERS THEN
372: BSC_MESSAGE.Add(x_message => SQLERRM||'. p_kpi='||p_kpi,
373: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',
374: x_mode => 'I');
375: COMMIT;
376:
377: END Implement_Bsc_MV_VB;

Line 505: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',

501: EXCEPTION
502: WHEN e_error THEN
503: BSC_MESSAGE.flush;
504: BSC_MESSAGE.Add(x_message => l_error_message,
505: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',
506: x_mode => 'I');
507: COMMIT;
508:
509: WHEN OTHERS THEN

Line 511: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',

507: COMMIT;
508:
509: WHEN OTHERS THEN
510: BSC_MESSAGE.Add(x_message => SQLERRM,
511: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',
512: x_mode => 'I');
513: COMMIT;
514:
515: END Load_Reporting_Calendar_VB;

Line 552: AND BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) = p_mv;

548: SELECT DISTINCT T.INDICATOR
549: FROM BSC_KPI_DATA_TABLES T, BSC_DB_TABLES_RELS R
550: WHERE T.TABLE_NAME = R.TABLE_NAME
551: AND R.RELATION_TYPE = 1
552: AND BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) = p_mv;
553:
554: BEGIN
555:
556: -- Get the KPI using the given MV

Line 646: END BSC_BIA_WRAPPER;

642: RETURN h_b;
643: END Refresh_Summary_MV_AT;
644:
645:
646: END BSC_BIA_WRAPPER;