APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSD_DEM_COMMON_UTILITIES

Line 1: PACKAGE BODY MSD_DEM_COMMON_UTILITIES AS

1: PACKAGE BODY MSD_DEM_COMMON_UTILITIES AS
2: /* $Header: msddemcub.pls 120.11 2008/01/03 07:19:35 nallkuma noship $ */
3:
4: /*** PRIVATE PROCEDURES ***
5: * MSD_UOM_CONVERSION

Line 403: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

399: END IF;
400: commit;
401: EXCEPTION
402: WHEN OTHERS THEN
403: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
404: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
405: retcode := -1;
406: END;
407:

Line 404: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

400: commit;
401: EXCEPTION
402: WHEN OTHERS THEN
403: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
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

Line 420: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

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));
421: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
422: retcode := -1;
423: END;
424:

Line 421: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

417: commit;
418: EXCEPTION
419: when others then
420: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
421: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
422: retcode := -1;
423: END;
424:
425:

Line 471: msd_dem_common_utilities.get_dblink (

467:
468: BEGIN
469:
470: /* Get the db link to the source instance */
471: msd_dem_common_utilities.get_dblink (
472: x_errbuf,
473: x_retcode,
474: p_sr_instance_id,
475: x_dblink);

Line 543: L_DM := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

539: FETCH C1 INTO L_DM;
540: CLOSE C1;
541: */
542:
543: L_DM := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
544:
545: L_STMT := 'SELECT TIME_BUCKET FROM '||
546: L_DM||
547: ' WHERE IS_ACTIVE=1 ';

Line 997: if (upper(msd_dem_common_utilities.dm_time_level) <> 'DAY') then

993: open c2 (p_plan_id);
994: fetch c2 into l_ret;
995: close c2;
996:
997: if (upper(msd_dem_common_utilities.dm_time_level) <> 'DAY') then
998: open c3(l_ret);
999: fetch c3 into l_ret;
1000: close c3;
1001: end if;

Line 1022: || msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS')

1018: BEGIN
1019:
1020: EXECUTE IMMEDIATE 'SELECT datet FROM ( '
1021: || ' SELECT datet FROM '
1022: || msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS')
1023: || ' WHERE datet > sysdate '
1024: || ' ORDER BY datet ) '
1025: || ' WHERE rownum < 2 '
1026: INTO x_dummy_date;

Line 1120: IF (upper(msd_dem_common_utilities.dm_time_level) = 'DAY')

1116: IS
1117: x_max_date DATE := NULL;
1118: BEGIN
1119:
1120: IF (upper(msd_dem_common_utilities.dm_time_level) = 'DAY')
1121: THEN
1122: RETURN 1;
1123: END IF;
1124:

Line 1302: END MSD_DEM_COMMON_UTILITIES;

1298: RETURN 2;
1299:
1300: END IS_SUPPLIER_CALENDAR_PRESENT;
1301:
1302: END MSD_DEM_COMMON_UTILITIES;