DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSD_DEM_ENTITIES_INUSE

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

911: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
912: retcode := -1;
913: END;
914:
915: /* Deletes the msd_dem_entities_inuse table if the new demantra schema is intstalled
916: * this will ensure that there will be no mapping between the seeded units in APPS and
917: * the (display uints,exchange rate,indexes) in Demantra */
918: PROCEDURE cleanup_entities_inuse(errbuf out nocopy varchar2, retcode out nocopy varchar2)
919: as

Line 920: /*Deletes the msd_dem_entities_inuse table */

916: * this will ensure that there will be no mapping between the seeded units in APPS and
917: * the (display uints,exchange rate,indexes) in Demantra */
918: PROCEDURE cleanup_entities_inuse(errbuf out nocopy varchar2, retcode out nocopy varchar2)
919: as
920: /*Deletes the msd_dem_entities_inuse table */
921: BEGIN
922:
923: delete msd_dem_entities_inuse;
924: commit;

Line 923: delete msd_dem_entities_inuse;

919: as
920: /*Deletes the msd_dem_entities_inuse table */
921: BEGIN
922:
923: delete msd_dem_entities_inuse;
924: commit;
925: EXCEPTION
926: when others then
927: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));