APPS.BSC_APPS dependencies on AD_TSPACE_UTIL

Line 655: AD_TSPACE_UTIL.is_new_ts_mode(l_new_tbs_mode);

651: -- Summary Tables must be created in the BSCD schema
652: -- Got an OK from Pavel that its ok to create MVs in BSCD schema for old
653: l_tablespace_type := x_tablespace_type;
654:
655: AD_TSPACE_UTIL.is_new_ts_mode(l_new_tbs_mode);
656: IF (l_new_tbs_mode = 'Y') THEN -- NEW MODE, no changes
657: null;
658: ELSE -- OLD MODE
659: --See if we need to switch summary tables to Transaction table space

Line 671: AD_TSPACE_UTIL.get_tablespace_name(

667: END IF;
668: END IF;
669: IF l_tablespace_type = dimension_table_tbs_type THEN
670: IF dimension_table_tbs_name IS NULL THEN
671: AD_TSPACE_UTIL.get_tablespace_name(
672: x_product_short_name => bsc_apps_short_name,
673: x_tablespace_type => 'TRANSACTION_TABLES',
674: x_validate_ts_exists => 'N',
675: x_ts_exists => h_ts_exists,

Line 682: AD_TSPACE_UTIL.get_tablespace_name(

678: RETURN dimension_table_tbs_name;
679:
680: ELSIF l_tablespace_type = dimension_index_tbs_type THEN
681: IF dimension_index_tbs_name IS NULL THEN
682: AD_TSPACE_UTIL.get_tablespace_name(
683: x_product_short_name => bsc_apps_short_name,
684: x_tablespace_type => 'TRANSACTION_INDEXES',
685: x_validate_ts_exists => 'N',
686: x_ts_exists => h_ts_exists,

Line 693: AD_TSPACE_UTIL.get_tablespace_name(

689: RETURN dimension_index_tbs_name;
690:
691: ELSIF l_tablespace_type = input_table_tbs_type THEN
692: IF input_table_tbs_name IS NULL THEN
693: AD_TSPACE_UTIL.get_tablespace_name(
694: x_product_short_name => bsc_apps_short_name,
695: x_tablespace_type => 'INTERFACE',
696: x_validate_ts_exists => 'N',
697: x_ts_exists => h_ts_exists,

Line 704: AD_TSPACE_UTIL.get_tablespace_name(

700: RETURN input_table_tbs_name;
701:
702: ELSIF l_tablespace_type = input_index_tbs_type THEN
703: IF input_index_tbs_name IS NULL THEN
704: AD_TSPACE_UTIL.get_tablespace_name(
705: x_product_short_name => bsc_apps_short_name,
706: x_tablespace_type => 'INTERFACE',
707: x_validate_ts_exists => 'N',
708: x_ts_exists => h_ts_exists,

Line 715: AD_TSPACE_UTIL.get_tablespace_name(

711: RETURN input_index_tbs_name;
712:
713: ELSIF l_tablespace_type = base_table_tbs_type THEN
714: IF base_table_tbs_name IS NULL THEN
715: AD_TSPACE_UTIL.get_tablespace_name(
716: x_product_short_name => bsc_apps_short_name,
717: x_tablespace_type => 'SUMMARY',
718: x_validate_ts_exists => 'N',
719: x_ts_exists => h_ts_exists,

Line 726: AD_TSPACE_UTIL.get_tablespace_name(

722: RETURN base_table_tbs_name;
723:
724: ELSIF l_tablespace_type = base_index_tbs_type THEN
725: IF base_index_tbs_name IS NULL THEN
726: AD_TSPACE_UTIL.get_tablespace_name(
727: x_product_short_name => bsc_apps_short_name,
728: x_tablespace_type => 'SUMMARY',
729: x_validate_ts_exists => 'N',
730: x_ts_exists => h_ts_exists,

Line 737: AD_TSPACE_UTIL.get_tablespace_name(

733: RETURN base_index_tbs_name;
734:
735: ELSIF l_tablespace_type = summary_table_tbs_type THEN
736: IF summary_table_tbs_name IS NULL THEN
737: AD_TSPACE_UTIL.get_tablespace_name(
738: x_product_short_name => bsc_apps_short_name,
739: x_tablespace_type => 'SUMMARY',
740: x_validate_ts_exists => 'N',
741: x_ts_exists => h_ts_exists,

Line 748: AD_TSPACE_UTIL.get_tablespace_name(

744: RETURN summary_table_tbs_name;
745:
746: ELSIF l_tablespace_type = summary_index_tbs_type THEN
747: IF summary_index_tbs_name IS NULL THEN
748: AD_TSPACE_UTIL.get_tablespace_name(
749: x_product_short_name => bsc_apps_short_name,
750: x_tablespace_type => 'SUMMARY',
751: x_validate_ts_exists => 'N',
752: x_ts_exists => h_ts_exists,

Line 759: AD_TSPACE_UTIL.get_tablespace_name(

755: RETURN summary_index_tbs_name;
756:
757: ELSIF l_tablespace_type = other_table_tbs_type THEN
758: IF other_table_tbs_name IS NULL THEN
759: AD_TSPACE_UTIL.get_tablespace_name(
760: x_product_short_name => bsc_apps_short_name,
761: x_tablespace_type => 'TRANSACTION_TABLES',
762: x_validate_ts_exists => 'N',
763: x_ts_exists => h_ts_exists,

Line 770: AD_TSPACE_UTIL.get_tablespace_name(

766: RETURN other_table_tbs_name;
767:
768: ELSIF l_tablespace_type = other_index_tbs_type THEN
769: IF other_index_tbs_name IS NULL THEN
770: AD_TSPACE_UTIL.get_tablespace_name(
771: x_product_short_name => bsc_apps_short_name,
772: x_tablespace_type => 'TRANSACTION_INDEXES',
773: x_validate_ts_exists => 'N',
774: x_ts_exists => h_ts_exists,

Line 781: AD_TSPACE_UTIL.get_tablespace_name(

777: RETURN other_index_tbs_name;
778:
779: ELSE
780: -- use TRANSACTION_TABLES
781: AD_TSPACE_UTIL.get_tablespace_name(
782: x_product_short_name => bsc_apps_short_name,
783: x_tablespace_type => 'TRANSACTION_TABLES',
784: x_validate_ts_exists => 'N',
785: x_ts_exists => h_ts_exists,