APPS.MSC_DEMANTRA_PKG dependencies on MSC_ST_DEMANTRA_F

Line 1350: delete from msc_st_demantra_f where st_transaction_id=p_st_transaction_id;

1346: msc_phub_util.log('msc_demantra_pkg.export_demantra_f');
1347: retcode := 0;
1348: errbuf := null;
1349:
1350: delete from msc_st_demantra_f where st_transaction_id=p_st_transaction_id;
1351: commit;
1352:
1353: if (p_source_version > '11.5.10') then
1354: l_sql :=

Line 1355: ' insert into msc_st_demantra_f('||

1351: commit;
1352:
1353: if (p_source_version > '11.5.10') then
1354: l_sql :=
1355: ' insert into msc_st_demantra_f('||
1356: ' st_transaction_id,'||
1357: ' error_code,'||
1358: ' sr_instance_id,'||
1359: ' organization_id,'||

Line 1511: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: insert into msc_st_demantra_f: '||sql%rowcount);

1507: ' and cmv.region_id(+)=f.region_id'||
1508: ' and cmv.sr_instance_id(+)=decode(f.region_id,-23453,cmv.sr_instance_id(+),f.owning_inst_id)';
1509:
1510: execute immediate l_sql using p_st_transaction_id, p_plan_run_id;
1511: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: insert into msc_st_demantra_f: '||sql%rowcount);
1512: else
1513: l_sql :=
1514: ' select min(start_date), max(start_date)'||
1515: ' from '||l_apps_schema||'.msc_demantra_f'||l_suffix||

Line 1523: ' insert into msc_st_demantra_f('||

1519: execute immediate l_sql into l_plan_start_date, l_plan_cutoff_date using p_plan_run_id;
1520: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: l_plan_start_date='||l_plan_start_date||', l_plan_cutoff_date='||l_plan_cutoff_date);
1521:
1522: l_sql :=
1523: ' insert into msc_st_demantra_f('||
1524: ' st_transaction_id,'||
1525: ' error_code,'||
1526: ' sr_instance_id,'||
1527: ' organization_id,'||

Line 1732: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: insert into msc_st_demantra_f: '||sql%rowcount);

1728: ' f.start_date';
1729:
1730: msc_phub_util.log_sql(l_sql);
1731: execute immediate l_sql using p_st_transaction_id, p_plan_run_id, l_plan_start_date, l_plan_cutoff_date;
1732: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: insert into msc_st_demantra_f: '||sql%rowcount);
1733: commit;
1734: end if;
1735: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: complete, retcode='||retcode);
1736: