APPS.MSC_DEMANTRA_PKG dependencies on MSC_ST_DEMANTRA_ODS_F

Line 1177: select 1 from msc_st_demantra_ods_f

1173: commit;
1174:
1175: if (p_fact_type = 4 and l_publish_mode = 2) then
1176: delete from msc_demantra_ods_f f where exists (
1177: select 1 from msc_st_demantra_ods_f
1178: where st_transaction_id=p_transfer_id and error_code=0
1179: and sr_instance_id=f.sr_instance_id
1180: and organization_id=f.organization_id
1181: and owning_inst_id=f.owning_inst_id

Line 1757: delete from msc_st_demantra_ods_f where st_transaction_id=p_st_transaction_id;

1753: msc_phub_util.log('msc_demantra_pkg.export_demantra_ods_f');
1754: retcode := 0;
1755: errbuf := null;
1756:
1757: delete from msc_st_demantra_ods_f where st_transaction_id=p_st_transaction_id;
1758: commit;
1759:
1760: l_sql :=
1761: ' insert into msc_st_demantra_ods_f('||

Line 1761: ' insert into msc_st_demantra_ods_f('||

1757: delete from msc_st_demantra_ods_f where st_transaction_id=p_st_transaction_id;
1758: commit;
1759:
1760: l_sql :=
1761: ' insert into msc_st_demantra_ods_f('||
1762: ' st_transaction_id,'||
1763: ' error_code,'||
1764: ' sr_instance_id,'||
1765: ' organization_id,';