[Home] [Help]
1: PACKAGE BODY bim_segment_denorm_pkg AS
2: /* $Header: bimisgdb.pls 120.16.12010000.1 2008/07/29 21:04:45 appldev ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(22) := 'BIM_SEGMENT_DENORM_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimisgdb.pls';
1: PACKAGE BODY bim_segment_denorm_pkg AS
2: /* $Header: bimisgdb.pls 120.16.12010000.1 2008/07/29 21:04:45 appldev ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(22) := 'BIM_SEGMENT_DENORM_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimisgdb.pls';
6:
7: PROCEDURE COMMON_UTILITIES
8: ( l_global_start_date OUT NOCOPY DATE
18: l_global_start_date := l_global_date;
19:
20: BEGIN
21: /* Set up the Object */
22: IF NOT bis_collection_utilities.setup('BIM_SEGMENT_DENORM_PKG') THEN
23: bis_collection_utilities.log('Object Not Setup Properly ');
24: END IF;
25:
26: bis_collection_utilities.get_last_refresh_dates('BIM_SEGMENT_DENORM_PKG'
22: IF NOT bis_collection_utilities.setup('BIM_SEGMENT_DENORM_PKG') THEN
23: bis_collection_utilities.log('Object Not Setup Properly ');
24: END IF;
25:
26: bis_collection_utilities.get_last_refresh_dates('BIM_SEGMENT_DENORM_PKG'
27: ,l_start_date,l_end_date,l_period_from,l_period_to);
28:
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
261: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
262:
263: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_sgmt_denorm';
264:
265: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SEGMENT_DENORM_PKG');
266:
267: COMMON_UTILITIES(l_date,l_period_from,l_period_to,l_temp_start_date,l_start_date,l_end_date);
268:
269: ELSE
513: );
514:
515: END POPULATE_SEGMENT_DENORM;
516:
517: END BIM_SEGMENT_DENORM_PKG;