DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSD_DEM_ENTITIES_INUSE

Line 408: /* Deletes the msd_dem_entities_inuse table if the new demantra schema is intstalled

404: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
405: retcode := -1;
406: END;
407:
408: /* Deletes the msd_dem_entities_inuse table if the new demantra schema is intstalled
409: * this will ensure that there will be no mapping between the seeded units in APPS and
410: * the (display uints,exchange rate,indexes) in Demantra */
411: PROCEDURE cleanup_entities_inuse(errbuf out nocopy varchar2, retcode out nocopy varchar2)
412: as

Line 413: /*Deletes the msd_dem_entities_inuse table */

409: * this will ensure that there will be no mapping between the seeded units in APPS and
410: * the (display uints,exchange rate,indexes) in Demantra */
411: PROCEDURE cleanup_entities_inuse(errbuf out nocopy varchar2, retcode out nocopy varchar2)
412: as
413: /*Deletes the msd_dem_entities_inuse table */
414: BEGIN
415:
416: delete msd_dem_entities_inuse;
417: commit;

Line 416: delete msd_dem_entities_inuse;

412: as
413: /*Deletes the msd_dem_entities_inuse table */
414: BEGIN
415:
416: delete msd_dem_entities_inuse;
417: commit;
418: EXCEPTION
419: when others then
420: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));