DBA Data[Home] [Help]

APPS.BIM_KPI_FACT dependencies on BIM_R_KPI_FACTS

Line 222: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_kpi_facts';

218: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT START');
219:
220: ams_utility_pvt.debug_message('POPULATE BIM_R_KPI_FACT START');
221:
222: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_kpi_facts';
223:
224:
225: INSERT
226: INTO bim_r_kpi_facts(

Line 226: INTO bim_r_kpi_facts(

222: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_kpi_facts';
223:
224:
225: INSERT
226: INTO bim_r_kpi_facts(
227: creation_date,
228: created_by,
229: last_update_date,
230: last_updated_by,

Line 2392: UPDATE bim_r_kpi_facts

2388: COMMIT;
2389:
2390: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT END');
2391:
2392: UPDATE bim_r_kpi_facts
2393: SET cost_cur_period=0
2394: ,cost_pre_period=0
2395: WHERE status = 'CANCELLED';
2396: COMMIT;