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.

APPS.BIM_SEGMENT_DENORM_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 22: IF NOT bis_collection_utilities.setup('BIM_SEGMENT_DENORM_PKG') THEN

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'

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

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'
27: ,l_start_date,l_end_date,l_period_from,l_period_to);

Line 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

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

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

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

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

Line 243: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);

239:
240:
241: l_source := l_master_type;
242: END IF;
243: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);
244: Execute Immediate 'INSERT INTO source_query_sgdb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
245: l_source := NULL;
246: l_query_string := NULL;
247: l_sql_id := NULL;

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

255:
256: IF p_load_type = 'F' THEN
257:
258: --it is a call for First/Inital load, then truncate the denorm table first
259: bis_collection_utilities.log('Truncating the Denorm Table ');
260:
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';

Line 265: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SEGMENT_DENORM_PKG');

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

Line 299: bis_collection_utilities.log('Updating leaf node flags for incremental load ');

295:
296:
297: IF l_period_to IS NOT NULL THEN
298:
299: bis_collection_utilities.log('Updating leaf node flags for incremental load ');
300:
301:
302: UPDATE bim_i_sgmt_denorm
303: SET leaf_node_flag = 'N'

Line 380: bis_collection_utilities.log('Records Inserted for Incremental load ');

376: ' WHERE s.cell_id = x.parent_segment_id' ;
377:
378: Execute Immediate ' DROP TABLE source_query_sgdb ';
379:
380: bis_collection_utilities.log('Records Inserted for Incremental load ');
381:
382: ELSE
383:
384: /**********************FOR INITITAL LOAD**********************/

Line 385: bis_collection_utilities.log('Initial Load of Segment Denorm Program');

381:
382: ELSE
383:
384: /**********************FOR INITITAL LOAD**********************/
385: bis_collection_utilities.log('Initial Load of Segment Denorm Program');
386:
387: Execute Immediate ' INSERT INTO bim_i_sgmt_denorm ' ||
388: ' ( segment_id ' ||
389: ' ,parent_segment_id ' ||

Line 468: bis_collection_utilities.log('Records Inserted for Initial load ');

464: FROM dual ;*/
465:
466: Execute Immediate ' DROP TABLE source_query_sgdb ';
467:
468: bis_collection_utilities.log('Records Inserted for Initial load ');
469: END IF;
470:
471: commit;
472:

Line 473: bis_collection_utilities.log('Segment Denorm Concurrent Program Completed Succesfully ');

469: END IF;
470:
471: commit;
472:
473: bis_collection_utilities.log('Segment Denorm Concurrent Program Completed Succesfully ');
474:
475: bis_collection_utilities.wrapup(p_status => TRUE
476: ,p_count => sql%rowcount
477: ,p_period_from => l_temp_start_date

Line 475: bis_collection_utilities.wrapup(p_status => TRUE

471: commit;
472:
473: bis_collection_utilities.log('Segment Denorm Concurrent Program Completed Succesfully ');
474:
475: bis_collection_utilities.wrapup(p_status => TRUE
476: ,p_count => sql%rowcount
477: ,p_period_from => l_temp_start_date
478: ,p_period_to => sysdate
479: );