APPS.MSC_DEMAND_PKG dependencies on MSC_ST_DEMANDS_CUM_F

Line 2252: delete from msc_st_demands_cum_f where st_transaction_id=p_st_transaction_id;

2248: msc_phub_util.log('msc_demand_pkg.export_demands_cum_f');
2249: retcode := 0;
2250: errbuf := null;
2251:
2252: delete from msc_st_demands_cum_f where st_transaction_id=p_st_transaction_id;
2253: commit;
2254:
2255: l_sql :=
2256: ' insert into msc_st_demands_cum_f('||

Line 2256: ' insert into msc_st_demands_cum_f('||

2252: delete from msc_st_demands_cum_f where st_transaction_id=p_st_transaction_id;
2253: commit;
2254:
2255: l_sql :=
2256: ' insert into msc_st_demands_cum_f('||
2257: ' st_transaction_id,'||
2258: ' error_code,'||
2259: ' sr_instance_id,'||
2260: ' organization_id,'||

Line 2546: l_staging_table varchar2(30) := 'msc_st_demands_cum_f';

2542: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
2543: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
2544: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
2545: is
2546: l_staging_table varchar2(30) := 'msc_st_demands_cum_f';
2547: l_fact_table varchar2(30) := 'msc_demands_cum_f';
2548: l_result number := 0;
2549: begin
2550: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f');

Line 2628: from msc_st_demands_cum_f

2624: cum_constrained_fcst_value2,
2625: 0, -23453, -23453,
2626: fnd_global.user_id, sysdate,
2627: fnd_global.user_id, sysdate, fnd_global.login_id
2628: from msc_st_demands_cum_f
2629: where st_transaction_id=p_st_transaction_id and error_code=0;
2630:
2631: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f: inserted='||sql%rowcount);
2632: commit;