APPS.MSC_UTIL dependencies on AD_TSPACE_UTIL

Line 465: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);

461: lv_is_object_registered VARCHAR2(10);
462: lv_ts_exists VARCHAR2(10);
463: lv_is_new_ts_mode VARCHAR2(10);
464: BEGIN
465: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);
466: IF(upper(lv_is_new_ts_mode) = 'N') THEN-- code for old tabel space structure
467:
468: SELECT alt.tablespace_name,
469: alt.initial_extent,

Line 495: ad_tspace_util.get_object_tablespace(

491: END;
492:
493: ELSE --- start of code for new tablespace structure
494:
495: ad_tspace_util.get_object_tablespace(
496: x_product_short_name => p_schema,
497: x_object_name => p_table_name,
498: x_object_type => 'TABLE',
499: x_index_lookup_flag => 'N',

Line 504: ad_tspace_util.get_object_tablespace(

500: x_validate_ts_exists => 'Y',
501: x_is_object_registered => lv_is_object_registered,
502: x_ts_exists => lv_ts_exists,
503: x_tablespace => v_table_space);
504: ad_tspace_util.get_object_tablespace(
505: x_product_short_name => p_schema,
506: x_object_name => p_table_name,
507: x_object_type => 'TABLE',
508: x_index_lookup_flag => 'Y',

Line 705: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);

701: if lv_schema is not null then
702: return lv_schema;
703: end if;
704:
705: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);
706: IF(upper(lv_is_new_ts_mode) = 'N') THEN
707: SELECT a.oracle_username
708: INTO lv_schema
709: FROM FND_ORACLE_USERID a,

Line 715: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);

711: WHERE a.oracle_id = b.oracle_id
712: AND b.application_id = p_apps_id;
713:
714: ELSE
715: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);
716: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
717: END IF;
718:
719: RETURN lv_schema;

Line 1003: l_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_product);

999: l_industry VARCHAR2(30);
1000: l_schema VARCHAR2(30);
1001: l_prod_short_name VARCHAR2(30);
1002: BEGIN
1003: l_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_product);
1004: IF fnd_installation.get_app_info(l_prod_short_name, l_status, l_industry, l_schema) <> TRUE THEN
1005: RETURN FALSE;
1006: ELSE
1007: IF l_status = 'I' THEN