APPS.MSC_UTIL dependencies on AD_TSPACE_UTIL

Line 525: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);

521: lv_is_object_registered VARCHAR2(10);
522: lv_ts_exists VARCHAR2(10);
523: lv_is_new_ts_mode VARCHAR2(10);
524: BEGIN
525: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);
526: IF(upper(lv_is_new_ts_mode) = 'N') THEN-- code for old tabel space structure
527:
528: SELECT alt.tablespace_name,
529: alt.initial_extent,

Line 555: ad_tspace_util.get_object_tablespace(

551: END;
552:
553: ELSE --- start of code for new tablespace structure
554:
555: ad_tspace_util.get_object_tablespace(
556: x_product_short_name => p_schema,
557: x_object_name => p_table_name,
558: x_object_type => 'TABLE',
559: x_index_lookup_flag => 'N',

Line 564: ad_tspace_util.get_object_tablespace(

560: x_validate_ts_exists => 'Y',
561: x_is_object_registered => lv_is_object_registered,
562: x_ts_exists => lv_ts_exists,
563: x_tablespace => v_table_space);
564: ad_tspace_util.get_object_tablespace(
565: x_product_short_name => p_schema,
566: x_object_name => p_table_name,
567: x_object_type => 'TABLE',
568: x_index_lookup_flag => 'Y',

Line 963: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);

959: if lv_schema is not null then
960: return lv_schema;
961: end if;
962:
963: ad_tspace_util.is_new_ts_mode(lv_is_new_ts_mode);
964: IF(upper(lv_is_new_ts_mode) = 'N') THEN
965: SELECT a.oracle_username
966: INTO lv_schema
967: FROM FND_ORACLE_USERID a,

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

969: WHERE a.oracle_id = b.oracle_id
970: AND b.application_id = p_apps_id;
971:
972: ELSE
973: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);
974: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
975: END IF;
976:
977: RETURN lv_schema;

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

1257: l_industry VARCHAR2(30);
1258: l_schema VARCHAR2(30);
1259: l_prod_short_name VARCHAR2(30);
1260: BEGIN
1261: l_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_product);
1262: IF fnd_installation.get_app_info(l_prod_short_name, l_status, l_industry, l_schema) <> TRUE THEN
1263: RETURN FALSE;
1264: ELSE
1265: IF l_status = 'I' THEN