1 package ad_mls as
2 /* $Header: admlss.pls 120.0 2005/05/25 11:44:13 appldev noship $ */
3 --
4 -- Package
5 -- AD_MLS
6 -- Purpose
7 -- Support for R10 multi-lingual view based solution.
8 -- Notes
9 -- 1. This package is created in a priviledged account.
10 -- It is recommended that this package be created in 'system'
11 -- 2. The priviledged account requires the following explicit
12 -- priviledges to run (i.e. these priviledges cannot be obtained
13 -- from a role, like 'dba'):
14 -- grant create user to system;
15 -- grant select any table to system;
16 -- grant create any procedure to system;
17 -- grant create any trigger to system;
18 -- grant create any view to system;
19 -- grant execute any procedure to system;
20 -- grant drop any procedure to system;
21 -- grant drop any trigger to system;
22 -- grant drop any view to system;
23 -- grant drop any synonym to system;
24 -- grant unlimited tablespace to system with admin option;
25 -- These privledges should be granted to system in addbXXX.sql.
26 --
27 -- History
28 -- 15-NOV-94 B Lind Created
29 -- 10-APR-97 nvijayap Split adorgs.pls into two
30 -- - admlss.pls, adaprs.pls -
31 -- - this is admlss.pls
32 --
33
34 -- Bug 3611969 : FIXED FILE.SQL.35 GSCC WARNINGS
35 -- sraghuve (07/05/2004)
36
37 procedure create_mls_schema
38 (aol_schema in varchar2);
39
40 procedure create_mls_schema
41 (aol_schema in varchar2,
42 invoker_mode in varchar2);
43 --
44 -- Procedure
45 -- create_mls_schema
46 -- Purpose
47 -- Build/Create the 'mls appsuser' account.
48 -- Arguments
49 -- apps_schema The oracle username for the apps account
50 -- invoker_mode Running in Invoker's Rights mode? 'TRUE' or 'FALSE'
51 -- Example
52 -- none
53 -- Notes
54 -- 1. None
55 --
56
57 procedure build_lang_decode
58 (aol_schema in varchar2);
59 --
60 -- Purpose
61 -- Build decode on language to attributex
62 -- The format of the output is:
63 -- decode(substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),
64 -- '_')-1),lang1,attributex,lang2,attributey,...
65 -- Each output is of the same form, but maps different columns to the
66 -- languages
67 -- Arguments
68 -- aoluser The applsys oracle user name
69 -- Example
70 -- none
71 -- Notes
72
73 procedure build_mls_column_list
74 (table_name in varchar2,
75 table_owner in varchar2,
76 aol_schema in varchar2,
77 view_column_list out nocopy varchar2,
78 select_list out nocopy varchar2);
79 --
80 -- Purpose
81 -- Build the column lists:
82 -- one for the view columns
83 -- two for the select statement for the view
84 -- Arguments
85 -- mls_decode_1 output from build_lang_decode
86 -- mls_decode_2 output from build_lang_decode
87 -- table_name Table for which the view is being created
88 -- aoluser Schema in which table ak_partitioned_tables exists
89 -- Example
90 -- none
91 -- Notes
92 -- 1. none
93 --
94
95
96 end ad_mls;