APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSD_DEM_SR_UTIL

Line 1426: x_sql := 'BEGIN :x_ou1 := MSD_DEM_SR_UTIL.GET_MASTER_ORGANIZATION' || x_dblink || '; END;';

1422:
1423: IF (x_instance_type IN (1,2,4))
1424: THEN
1425:
1426: x_sql := 'BEGIN :x_ou1 := MSD_DEM_SR_UTIL.GET_MASTER_ORGANIZATION' || x_dblink || '; END;';
1427: EXECUTE IMMEDIATE x_sql USING OUT x_return_value;
1428:
1429: ELSE
1430:

Line 1604: x_dummy_site VARCHAR2(100) := msd_dem_sr_util.get_null_code;

1600: p_customer_site_id IN NUMBER)
1601: RETURN VARCHAR2
1602: IS
1603: x_site VARCHAR2(255);
1604: x_dummy_site VARCHAR2(100) := msd_dem_sr_util.get_null_code;
1605: l_sql varchar2(1000) := null ;
1606: BEGIN
1607:
1608: IF (LG_VAR_SITE_CODE_FORMAT IS NULL)