APPS.BIM_LEAD_RG_PKG dependencies on BIM_R_LEAD_SUM_FACTS

Line 42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';

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';
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:

Line 47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.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';
50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

Line 110: l_table_name := 'BIM_R_LEAD_SUM_FACTS';

106: ,res.resource_id
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:

Line 116: INTO bim_r_lead_sum_facts(

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
118: ,created_by
119: ,last_update_date
120: ,last_updated_by