32:
33: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
34:
35: l_table_name := 'BIM_R_LEAD_GRP_MGR';
36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
38: fnd_file.put_line(fnd_file.log,fnd_message.get);
39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
33: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
34:
35: l_table_name := 'BIM_R_LEAD_GRP_MGR';
36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
38: fnd_file.put_line(fnd_file.log,fnd_message.get);
39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
41:
34:
35: l_table_name := 'BIM_R_LEAD_GRP_MGR';
36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
38: fnd_file.put_line(fnd_file.log,fnd_message.get);
39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
43: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
44: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
45: fnd_file.put_line(fnd_file.log,fnd_message.get);
46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
43: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
44: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
45: fnd_file.put_line(fnd_file.log,fnd_message.get);
46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
48:
41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
43: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
44: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
45: fnd_file.put_line(fnd_file.log,fnd_message.get);
46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';
46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';
50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';
50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';
50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
59: fnd_file.put_line(fnd_file.log,fnd_message.get);
60:
61:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
59: fnd_file.put_line(fnd_file.log,fnd_message.get);
60:
61:
62: INSERT
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
59: fnd_file.put_line(fnd_file.log,fnd_message.get);
60:
61:
62: INSERT
63: INTO bim_r_lead_grp_mgr(
107: ) inner;
108: COMMIT;
109:
110: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
111: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
112: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
113: fnd_file.put_line(fnd_file.log,fnd_message.get);
114:
115: INSERT
108: COMMIT;
109:
110: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
111: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
112: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
113: fnd_file.put_line(fnd_file.log,fnd_message.get);
114:
115: INSERT
116: INTO bim_r_lead_sum_facts(
109:
110: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
111: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
112: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
113: fnd_file.put_line(fnd_file.log,fnd_message.get);
114:
115: INSERT
116: INTO bim_r_lead_sum_facts(
117: creation_date
350: ;
351: COMMIT;
352:
353: l_table_name := 'BIM_R_LEAD_RES_DENORM';
354: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
356: fnd_file.put_line(fnd_file.log,fnd_message.get);
357:
358: INSERT
351: COMMIT;
352:
353: l_table_name := 'BIM_R_LEAD_RES_DENORM';
354: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
356: fnd_file.put_line(fnd_file.log,fnd_message.get);
357:
358: INSERT
359: INTO bim_r_lead_res_denorm(
352:
353: l_table_name := 'BIM_R_LEAD_RES_DENORM';
354: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
356: fnd_file.put_line(fnd_file.log,fnd_message.get);
357:
358: INSERT
359: INTO bim_r_lead_res_denorm(
360: creation_date
449: 'LEAD_RG',
450: sysdate);
451: COMMIT;
452:
453: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
454: fnd_message.set_token('PROGRAM_NAME','GROUP HIERARCHY SUM OF LEADS',FALSE);
455: fnd_file.put_line(fnd_file.log,fnd_message.get);
456:
457:
450: sysdate);
451: COMMIT;
452:
453: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
454: fnd_message.set_token('PROGRAM_NAME','GROUP HIERARCHY SUM OF LEADS',FALSE);
455: fnd_file.put_line(fnd_file.log,fnd_message.get);
456:
457:
458: EXCEPTION
451: COMMIT;
452:
453: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
454: fnd_message.set_token('PROGRAM_NAME','GROUP HIERARCHY SUM OF LEADS',FALSE);
455: fnd_file.put_line(fnd_file.log,fnd_message.get);
456:
457:
458: EXCEPTION
459: