eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BSC_UPDATE_BASE_V2 dependencies on BSC_UPDATE_BASE_V2

Line 1: PACKAGE BODY BSC_UPDATE_BASE_V2 AS

1: PACKAGE BODY BSC_UPDATE_BASE_V2 AS
2: /* $Header: BSCDBV2B.pls 120.12.12000000.2 2007/01/30 10:04:30 rkumar ship $ */
3:
4: --
5: -- Package constants

Line 245: h_process := 'BSC_UPDATE_BASE_V2.Update_Base_Table_Job('||

241: h_correction_flag_t := 'FALSE';
242: END IF;
243: FOR h_j IN 1..h_num_partitions LOOP
244: h_job_name := x_base_table||'_P_'||h_j;
245: h_process := 'BSC_UPDATE_BASE_V2.Update_Base_Table_Job('||
246: ''''||x_base_table||''','||
247: ''''||x_input_table||''','||
248: h_correction_flag_t||','||
249: h_aw_flag_t||','||

Line 344: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

340: EXCEPTION
341: WHEN e_error_calc_base_table_v2 THEN
342: ROLLBACK;
343: BSC_MESSAGE.Add(x_message => h_error_message,
344: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
345: RETURN FALSE;
346:
347: WHEN e_periodicity_null THEN
348: ROLLBACK;

Line 350: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

346:
347: WHEN e_periodicity_null THEN
348: ROLLBACK;
349: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_BTABLE_CALCULATION_FAILED'),
350: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
351: RETURN FALSE;
352:
353: WHEN e_calc_period_input_table THEN
354: ROLLBACK;

Line 356: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

352:
353: WHEN e_calc_period_input_table THEN
354: ROLLBACK;
355: BSC_MESSAGE.Add(x_message => h_error_message,
356: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
357: RETURN FALSE;
358:
359: WHEN e_calc_period_base_table THEN
360: ROLLBACK;

Line 362: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

358:
359: WHEN e_calc_period_base_table THEN
360: ROLLBACK;
361: BSC_MESSAGE.Add(x_message => h_error_message,
362: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
363: RETURN FALSE;
364:
365: WHEN e_get_info_data_columns THEN
366: ROLLBACK;

Line 368: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

364:
365: WHEN e_get_info_data_columns THEN
366: ROLLBACK;
367: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_BTABLE_CALCULATION_FAILED'),
368: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
369: RETURN FALSE;
370:
371: WHEN e_get_info_key_columns THEN
372: ROLLBACK;

Line 374: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

370:
371: WHEN e_get_info_key_columns THEN
372: ROLLBACK;
373: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_BTABLE_CALCULATION_FAILED'),
374: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
375: RETURN FALSE;
376:
377: WHEN e_create_types_for_mv_load THEN
378: ROLLBACK;

Line 380: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

376:
377: WHEN e_create_types_for_mv_load THEN
378: ROLLBACK;
379: BSC_MESSAGE.Add(x_message => h_error_message,
380: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
381: RETURN FALSE;
382:
383: WHEN OTHERS THEN
384: ROLLBACK;

Line 386: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');

382:
383: WHEN OTHERS THEN
384: ROLLBACK;
385: BSC_MESSAGE.Add(x_message => SQLERRM,
386: x_source => 'BSC_UPDATE_BASE_V2.Calculate_Base_Table');
387: RETURN FALSE;
388:
389: END Calculate_Base_Table;
390:

Line 1482: x_source => 'BSC_UPDATE_BASE_V2.Create_Generic_Temp_Tables');

1478:
1479: EXCEPTION
1480: WHEN e_unexpected_error THEN
1481: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
1482: x_source => 'BSC_UPDATE_BASE_V2.Create_Generic_Temp_Tables');
1483: RETURN FALSE;
1484:
1485: WHEN OTHERS THEN
1486: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 1487: x_source => 'BSC_UPDATE_BASE_V2.Create_Generic_Temp_Tables');

1483: RETURN FALSE;
1484:
1485: WHEN OTHERS THEN
1486: BSC_MESSAGE.Add(x_message => SQLERRM,
1487: x_source => 'BSC_UPDATE_BASE_V2.Create_Generic_Temp_Tables');
1488: RETURN FALSE;
1489: END Create_Generic_Temp_Tables;
1490:
1491:

Line 4014: END BSC_UPDATE_BASE_V2;

4010: x_error_message := 'Update_Base_Table.e_others: '||SQLERRM;
4011:
4012: END Update_Base_Table;
4013:
4014: END BSC_UPDATE_BASE_V2;