SYSTEM.AD_MLS dependencies on AD_MLS

Line 1: package body ad_mls as

1: package body ad_mls as
2: /* $Header: admlsb.pls 120.0 2005/05/25 12:06:15 appldev noship $ */
3:
4: mls_decode_1 varchar2(2000);
5: mls_decode_2 varchar2(2000);

Line 137: if ad_mls.mls_decode_1 is null then

133: ldecode_2 varchar2(2000);
134:
135: begin
136: -- only do the work if it hasn't been done before
137: if ad_mls.mls_decode_1 is null then
138:
139: c := dbms_sql.open_cursor;
140:
141:

Line 186: ad_mls.mls_decode_1 := ldecode_1;

182: exit;
183: end if;
184: end loop;
185:
186: ad_mls.mls_decode_1 := ldecode_1;
187: ad_mls.mls_decode_2 := ldecode_2;
188: else
189: null;
190: end if;

Line 187: ad_mls.mls_decode_2 := ldecode_2;

183: end if;
184: end loop;
185:
186: ad_mls.mls_decode_1 := ldecode_1;
187: ad_mls.mls_decode_2 := ldecode_2;
188: else
189: null;
190: end if;
191:

Line 219: if ad_mls.mls_decode_1 is null then

215: lselect_list varchar2(20000) := null;
216: counter number := 1;
217: begin
218: -- get value for mls_decode's
219: if ad_mls.mls_decode_1 is null then
220: build_lang_decode (aol_schema);
221: end if;
222:
223: c := dbms_sql.open_cursor;

Line 258: lselect_list := lselect_list || ad_mls.mls_decode_1 ||

254: dbms_sql.column_value(c,2,mlsized);
255: dbms_sql.column_value(c,3,translated_column_number);
256: if mlsized = 'Y' then
257: if translated_column_number = 1 then
258: lselect_list := lselect_list || ad_mls.mls_decode_1 ||
259: '"'||column_name || '"), "' || column_name ||'")' ;
260: lview_column_list := lview_column_list ||'"'|| column_name||'"';
261: elsif translated_column_number = 2 then
262: lselect_list := lselect_list || ad_mls.mls_decode_2 ||

Line 262: lselect_list := lselect_list || ad_mls.mls_decode_2 ||

258: lselect_list := lselect_list || ad_mls.mls_decode_1 ||
259: '"'||column_name || '"), "' || column_name ||'")' ;
260: lview_column_list := lview_column_list ||'"'|| column_name||'"';
261: elsif translated_column_number = 2 then
262: lselect_list := lselect_list || ad_mls.mls_decode_2 ||
263: '"'||column_name || '"), "' || column_name ||'")' ;
264: lview_column_list := lview_column_list ||'"'|| column_name||'"';
265: else
266: lselect_list := lselect_list||'"'|| column_name||'"';

Line 361: end ad_mls;

357:
358: end do_create_mls_schema;
359:
360:
361: end ad_mls;