PACKAGE BODY: APPS.AD_TABLESPACE_UTILS

Source

1 PACKAGE BODY AD_TABLESPACE_UTILS AS
2   -- $Header: adsputlb.pls 120.0 2005/05/25 11:50:10 appldev noship $
3 
4   --
5   -- Procedure to return tablespaces to used for Materialized Views.
6   -- All Materialized view must be created in APPS but using a set
7   -- of tablespaces for storage. In the current release, the
8   -- tablespaces associated with BIS will be used.
9   --
10 procedure get_mview_tablespaces
11            (X_data_tablespace  out nocopy varchar2,
12             X_index_tablespace out nocopy varchar2)
13 as
14     l_data_tablespace  varchar2(30);
15     l_index_tablespace varchar2(30);
16   begin
17 
18     select tablespace, index_tablespace
19     into   X_data_tablespace, X_index_tablespace
20     from   fnd_product_installations
21     where  application_id = 191 -- BIS application id
22     and    install_group_num in (0, 1);
23 
24   end;
25 
26 END;