APPS.MSC_SUPPLY_PKG dependencies on MSC_ST_SUPPLIES_F

Line 1065: delete from msc_st_supplies_f where st_transaction_id=p_st_transaction_id;

1061: msc_phub_util.log('msc_supply_pkg.export_supplies_f');
1062: retcode := 0;
1063: errbuf := null;
1064:
1065: delete from msc_st_supplies_f where st_transaction_id=p_st_transaction_id;
1066: commit;
1067:
1068: l_sql :=
1069: ' insert into msc_st_supplies_f('||

Line 1069: ' insert into msc_st_supplies_f('||

1065: delete from msc_st_supplies_f where st_transaction_id=p_st_transaction_id;
1066: commit;
1067:
1068: l_sql :=
1069: ' insert into msc_st_supplies_f('||
1070: ' st_transaction_id,'||
1071: ' error_code,'||
1072: ' sr_instance_id,'||
1073: ' organization_id,'||

Line 1346: l_staging_table varchar2(30) := 'msc_st_supplies_f';

1342: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
1343: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
1344: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
1345: is
1346: l_staging_table varchar2(30) := 'msc_st_supplies_f';
1347: l_fact_table varchar2(30) := 'msc_supplies_f';
1348: l_result number := 0;
1349: begin
1350: msc_phub_util.log('msc_supply_pkg.import_supplies_f');

Line 1499: from msc_st_supplies_f

1495: buy_order_count,
1496: 0, -23453, -23453,
1497: fnd_global.user_id, sysdate,
1498: fnd_global.user_id, sysdate, fnd_global.login_id
1499: from msc_st_supplies_f
1500: where st_transaction_id=p_st_transaction_id and error_code=0;
1501:
1502: msc_phub_util.log('msc_supply_pkg.import_supplies_f: inserted='||sql%rowcount);
1503: commit;