APPS.MSC_SUPPLY_PKG dependencies on MSC_ST_ITEM_WIPS_F

Line 1286: delete from msc_st_item_wips_f where st_transaction_id=p_st_transaction_id;

1282: msc_phub_util.log('msc_supply_pkg.export_item_wips_f');
1283: retcode := 0;
1284: errbuf := null;
1285:
1286: delete from msc_st_item_wips_f where st_transaction_id=p_st_transaction_id;
1287: commit;
1288:
1289: l_sql :=
1290: ' insert into msc_st_item_wips_f('||

Line 1290: ' insert into msc_st_item_wips_f('||

1286: delete from msc_st_item_wips_f where st_transaction_id=p_st_transaction_id;
1287: commit;
1288:
1289: l_sql :=
1290: ' insert into msc_st_item_wips_f('||
1291: ' st_transaction_id,'||
1292: ' error_code,'||
1293: ' sr_instance_id,'||
1294: ' organization_id,'||

Line 1526: l_staging_table varchar2(30) := 'msc_st_item_wips_f';

1522: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
1523: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
1524: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
1525: is
1526: l_staging_table varchar2(30) := 'msc_st_item_wips_f';
1527: l_fact_table varchar2(30) := 'msc_item_wips_f';
1528: l_result number := 0;
1529: begin
1530: msc_phub_util.log('msc_supply_pkg.import_item_wips_f');

Line 1576: from msc_st_item_wips_f

1572: wip_qty,
1573: 0, -23453, -23453,
1574: fnd_global.user_id, sysdate,
1575: fnd_global.user_id, sysdate, fnd_global.login_id
1576: from msc_st_item_wips_f
1577: where st_transaction_id=p_st_transaction_id and error_code=0;
1578:
1579: msc_phub_util.log('msc_supply_pkg.import_item_wips_f: inserted='||sql%rowcount);
1580: commit;