APPS.BIM_PROGRAMS_DENORM_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 23: IF NOT bis_collection_utilities.setup('BIM_SOURCE_DENORM') THEN

19: l_global_start_date := l_global_date;
20:
21: BEGIN
22: /* Set up the Object */
23: IF NOT bis_collection_utilities.setup('BIM_SOURCE_DENORM') THEN
24: bis_collection_utilities.log('Object Not Setup Properly ');
25: END IF;
26:
27: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_DENORM'

Line 24: bis_collection_utilities.log('Object Not Setup Properly ');

20:
21: BEGIN
22: /* Set up the Object */
23: IF NOT bis_collection_utilities.setup('BIM_SOURCE_DENORM') THEN
24: bis_collection_utilities.log('Object Not Setup Properly ');
25: END IF;
26:
27: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_DENORM'
28: ,l_start_date,l_end_date,l_period_from,l_period_to);

Line 27: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_DENORM'

23: IF NOT bis_collection_utilities.setup('BIM_SOURCE_DENORM') THEN
24: bis_collection_utilities.log('Object Not Setup Properly ');
25: END IF;
26:
27: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_DENORM'
28: ,l_start_date,l_end_date,l_period_from,l_period_to);
29:
30: EXCEPTION
31: WHEN NO_DATA_FOUND THEN

Line 33: bis_collection_utilities.log('First time running the concurrent program ');

29:
30: EXCEPTION
31: WHEN NO_DATA_FOUND THEN
32: l_end_date := NULL;
33: bis_collection_utilities.log('First time running the concurrent program ');
34: WHEN OTHERS THEN
35: bis_collection_utilities.log('program '|| sqlerrm(sqlcode));
36: END;
37:

Line 35: bis_collection_utilities.log('program '|| sqlerrm(sqlcode));

31: WHEN NO_DATA_FOUND THEN
32: l_end_date := NULL;
33: bis_collection_utilities.log('First time running the concurrent program ');
34: WHEN OTHERS THEN
35: bis_collection_utilities.log('program '|| sqlerrm(sqlcode));
36: END;
37:
38: /* End of the code for checking the data will be loaded for the first time or not. */
39:

Line 209: bis_collection_utilities.log('Truncating the Source Denorm Table ');

205:
206: IF p_load_type = 'F' THEN
207:
208: --it is a call for First/Inital load, then truncate the denorm table first
209: bis_collection_utilities.log('Truncating the Source Denorm Table ');
210:
211: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
212:
213: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_source_denorm';

Line 215: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SOURCE_DENORM');

211: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
212:
213: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_source_denorm';
214:
215: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SOURCE_DENORM');
216:
217: ELSE
218: /* This piece of code is for the objects that had an update somewhere in their hierarachy chain. */
219:

Line 273: BIS_COLLECTION_UTILITIES.log('Updating leaf node flags for incremental load ');

269: );
270:
271: IF l_period_to IS NOT NULL THEN
272:
273: BIS_COLLECTION_UTILITIES.log('Updating leaf node flags for incremental load ');
274: --add update logic here
275: UPDATE bim_i_source_denorm SET leaf_node_flag = 'N'
276: WHERE source_code_id
277: IN

Line 375: bis_collection_utilities.log('Initial Load of Source Denorm Concurrent Program');

371: ELSE
372: -- for initial load
373: -- No not exist condition for the for intial load
374: --additional union all for unassigned values
375: bis_collection_utilities.log('Initial Load of Source Denorm Concurrent Program');
376:
377: /*************FOR CAMPAIGNS AND EVENTS OBJECTS ******************************/
378:
379: INSERT INTO bim_i_source_denorm

Line 469: bis_collection_utilities.log('Source Denorm Concurrent Program Completed Succesfully ');

465:
466: END IF;
467:
468: commit;
469: bis_collection_utilities.log('Source Denorm Concurrent Program Completed Succesfully ');
470:
471: /********* commented becuase same package is being use to load programs denorm table also so only one wrapup is required*/
472: bis_collection_utilities.wrapup(p_status => TRUE
473: ,p_count => sql%rowcount

Line 472: bis_collection_utilities.wrapup(p_status => TRUE

468: commit;
469: bis_collection_utilities.log('Source Denorm Concurrent Program Completed Succesfully ');
470:
471: /********* commented becuase same package is being use to load programs denorm table also so only one wrapup is required*/
472: bis_collection_utilities.wrapup(p_status => TRUE
473: ,p_count => sql%rowcount
474: ,p_period_from => l_temp_start_date
475: ,p_period_to => sysdate
476: );