APPS.MSC_RESOURCE_PKG dependencies on MSC_ST_RESOURCES_CUM_F

Line 908: delete from msc_st_resources_cum_f where st_transaction_id=p_st_transaction_id;

904: msc_phub_util.log('msc_resource_pkg.export_resources_cum_f');
905: retcode := 0;
906: errbuf := null;
907:
908: delete from msc_st_resources_cum_f where st_transaction_id=p_st_transaction_id;
909: commit;
910:
911: l_sql :=
912: ' insert into msc_st_resources_cum_f('||

Line 912: ' insert into msc_st_resources_cum_f('||

908: delete from msc_st_resources_cum_f where st_transaction_id=p_st_transaction_id;
909: commit;
910:
911: l_sql :=
912: ' insert into msc_st_resources_cum_f('||
913: ' st_transaction_id,'||
914: ' error_code,'||
915: ' sr_instance_id,'||
916: ' organization_id,'||

Line 1085: l_staging_table varchar2(30) := 'msc_st_resources_cum_f';

1081: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
1082: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
1083: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
1084: is
1085: l_staging_table varchar2(30) := 'msc_st_resources_cum_f';
1086: l_fact_table varchar2(30) := 'msc_resources_cum_f';
1087: l_result number := 0;
1088: begin
1089: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f');

Line 1140: from msc_st_resources_cum_f

1136: cum_net_resource_avail,
1137: 0, '-23453',
1138: fnd_global.user_id, sysdate,
1139: fnd_global.user_id, sysdate, fnd_global.login_id
1140: from msc_st_resources_cum_f
1141: where st_transaction_id=p_st_transaction_id and error_code=0;
1142:
1143: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f: inserted='||sql%rowcount);
1144: commit;