eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYSTEM.AD_MLS dependencies on AD_APPS_PRIVATE

Line 51: ad_apps_private.error_buf := null; -- reset error buffer

47: apps_schema varchar2(30);
48: apps_schema_mls varchar2(30);
49: begin
50:
51: ad_apps_private.error_buf := null; -- reset error buffer
52:
53: if ad_apps_private.is_mls is null then
54: ad_apps_private.initialize(aol_schema);
55: end if;

Line 53: if ad_apps_private.is_mls is null then

49: begin
50:
51: ad_apps_private.error_buf := null; -- reset error buffer
52:
53: if ad_apps_private.is_mls is null then
54: ad_apps_private.initialize(aol_schema);
55: end if;
56:
57: if ad_apps_private.is_mls = TRUE then

Line 54: ad_apps_private.initialize(aol_schema);

50:
51: ad_apps_private.error_buf := null; -- reset error buffer
52:
53: if ad_apps_private.is_mls is null then
54: ad_apps_private.initialize(aol_schema);
55: end if;
56:
57: if ad_apps_private.is_mls = TRUE then
58:

Line 57: if ad_apps_private.is_mls = TRUE then

53: if ad_apps_private.is_mls is null then
54: ad_apps_private.initialize(aol_schema);
55: end if;
56:
57: if ad_apps_private.is_mls = TRUE then
58:
59: declare
60: c integer;
61: rows_processed integer;

Line 66: if not ad_apps_private.check_if_schema_exists(aol_schema) then

62: install_group_num number;
63: statement varchar2(500);
64: begin
65: -- check existence of aol_schema account
66: if not ad_apps_private.check_if_schema_exists(aol_schema) then
67: raise_application_error(-20000,'The schema '||upper(aol_schema)||
68: ' does not exist.');
69: end if;
70:

Line 89: ad_apps_private.get_apps_schema_name(install_group_num, aol_schema,

85:
86: -- Process the install group
87:
88: -- get the APPS account name ( apps[][_] )
89: ad_apps_private.get_apps_schema_name(install_group_num, aol_schema,
90: apps_schema, apps_schema_mls);
91:
92: -- create the MLS APPS schema
93: do_create_mls_schema(install_group_num, aol_schema,

Line 105: ad_apps_private.error_buf := 'statement='||

101: end loop; -- loop over all product groups
102: exception
103: when others then
104: dbms_sql.close_cursor(c);
105: ad_apps_private.error_buf := 'statement='||
106: statement||':'||
107: ad_apps_private.error_buf;
108: raise;
109: end;

Line 107: ad_apps_private.error_buf;

103: when others then
104: dbms_sql.close_cursor(c);
105: ad_apps_private.error_buf := 'statement='||
106: statement||':'||
107: ad_apps_private.error_buf;
108: raise;
109: end;
110:
111: end if;

Line 115: ad_apps_private.error_buf := 'create_mls_schema('||aol_schema||

111: end if;
112:
113: exception
114: when others then
115: ad_apps_private.error_buf := 'create_mls_schema('||aol_schema||
116: ', '||invoker_mode||'):'||
117: ad_apps_private.error_buf;
118: raise;
119:

Line 117: ad_apps_private.error_buf;

113: exception
114: when others then
115: ad_apps_private.error_buf := 'create_mls_schema('||aol_schema||
116: ', '||invoker_mode||'):'||
117: ad_apps_private.error_buf;
118: raise;
119:
120: end create_mls_schema;
121:

Line 195: ad_apps_private.error_buf := 'build_lang_decode('||aol_schema||

191:
192: exception
193: when others then
194: dbms_sql.close_cursor(c);
195: ad_apps_private.error_buf := 'build_lang_decode('||aol_schema||
196: '):'||ad_apps_private.error_buf;
197: raise;
198: end build_lang_decode;
199:

Line 196: '):'||ad_apps_private.error_buf;

192: exception
193: when others then
194: dbms_sql.close_cursor(c);
195: ad_apps_private.error_buf := 'build_lang_decode('||aol_schema||
196: '):'||ad_apps_private.error_buf;
197: raise;
198: end build_lang_decode;
199:
200:

Line 286: ad_apps_private.error_buf := 'build_mls_column_list('||

282:
283: exception
284: when others then
285: dbms_sql.close_cursor(c);
286: ad_apps_private.error_buf := 'build_mls_column_list('||
287: ','||table_name||','||table_owner||','||aol_schema||
288: lview_column_list||','||lselect_list||
289: '):'||ad_apps_private.error_buf;
290: raise;

Line 289: '):'||ad_apps_private.error_buf;

285: dbms_sql.close_cursor(c);
286: ad_apps_private.error_buf := 'build_mls_column_list('||
287: ','||table_name||','||table_owner||','||aol_schema||
288: lview_column_list||','||lselect_list||
289: '):'||ad_apps_private.error_buf;
290: raise;
291: end;
292:
293: procedure do_create_mls_schema

Line 303: if not ad_apps_private.check_if_schema_exists(apps_mls_schema) then

299: is
300:
301: begin
302: -- Step 1) Check for existence of apps_mls_schema
303: if not ad_apps_private.check_if_schema_exists(apps_mls_schema) then
304: -- Error out if it doesn't exist
305: raise_application_error(-20000,'The schema '||
306: upper(apps_mls_schema)||' does not exist.');
307: end if;

Line 311: ad_apps_private.check_for_apps_ddl(apps_schema);

307: end if;
308:
309: -- Step 2) Check for existence of APPS*DDL in apps_schema and
310: -- apps_mls_schema;
311: ad_apps_private.check_for_apps_ddl(apps_schema);
312: ad_apps_private.check_for_apps_ddl(apps_mls_schema);
313:
314: -- Step 4) Create grants/synonyms for tables and seqs to APPS
315: ad_apps_private.create_synonyms(apps_schema, apps_mls_schema,

Line 312: ad_apps_private.check_for_apps_ddl(apps_mls_schema);

308:
309: -- Step 2) Check for existence of APPS*DDL in apps_schema and
310: -- apps_mls_schema;
311: ad_apps_private.check_for_apps_ddl(apps_schema);
312: ad_apps_private.check_for_apps_ddl(apps_mls_schema);
313:
314: -- Step 4) Create grants/synonyms for tables and seqs to APPS
315: ad_apps_private.create_synonyms(apps_schema, apps_mls_schema,
316: apps_schema);

Line 315: ad_apps_private.create_synonyms(apps_schema, apps_mls_schema,

311: ad_apps_private.check_for_apps_ddl(apps_schema);
312: ad_apps_private.check_for_apps_ddl(apps_mls_schema);
313:
314: -- Step 4) Create grants/synonyms for tables and seqs to APPS
315: ad_apps_private.create_synonyms(apps_schema, apps_mls_schema,
316: apps_schema);
317:
318: -- Step 5) Create odd synonyms in MLS account
319: ad_apps_private.copy_odd_synonyms(apps_schema, apps_mls_schema);

Line 319: ad_apps_private.copy_odd_synonyms(apps_schema, apps_mls_schema);

315: ad_apps_private.create_synonyms(apps_schema, apps_mls_schema,
316: apps_schema);
317:
318: -- Step 5) Create odd synonyms in MLS account
319: ad_apps_private.copy_odd_synonyms(apps_schema, apps_mls_schema);
320:
321: -- Step 6) Create MLS views in MLS schema
322: --
323: -- This doesn't work, as ak_translated_columns is obsolete in Rel 11.5

Line 330: ad_apps_private.create_special_views(install_group_num,

326: -- and then know we need to fix something than just comment out the call
327: -- and get the wrong behavior silently.
328: --
329:
330: ad_apps_private.create_special_views(install_group_num,
331: aol_schema, apps_mls_schema, TRUE);
332:
333:
334: -- Step 7)Copy views from APPS to MLS

Line 335: ad_apps_private.copy_views(aol_schema, apps_schema, apps_mls_schema);

331: aol_schema, apps_mls_schema, TRUE);
332:
333:
334: -- Step 7)Copy views from APPS to MLS
335: ad_apps_private.copy_views(aol_schema, apps_schema, apps_mls_schema);
336:
337: -- Step 8)Copy stored programs from APPS to MLS
338:
339: if invoker_mode = 'FALSE' then

Line 340: ad_apps_private.copy_stored_progs(apps_schema, apps_mls_schema,

336:
337: -- Step 8)Copy stored programs from APPS to MLS
338:
339: if invoker_mode = 'FALSE' then
340: ad_apps_private.copy_stored_progs(apps_schema, apps_mls_schema,
341: 'A', null,'none');
342: else
343: ad_invoker.invoker_mrc_grants(apps_schema, apps_mls_schema);
344: end if;

Line 353: ad_apps_private.error_buf := 'do_create_mls_schema('||aol_schema||', '

349: ad_inst.compile_schema(apps_mls_schema);
350:
351: exception
352: when others then
353: ad_apps_private.error_buf := 'do_create_mls_schema('||aol_schema||', '
354: ||apps_schema||', '||apps_mls_schema||', '||
355: invoker_mode||'):'||ad_apps_private.error_buf;
356: raise;
357:

Line 355: invoker_mode||'):'||ad_apps_private.error_buf;

351: exception
352: when others then
353: ad_apps_private.error_buf := 'do_create_mls_schema('||aol_schema||', '
354: ||apps_schema||', '||apps_mls_schema||', '||
355: invoker_mode||'):'||ad_apps_private.error_buf;
356: raise;
357:
358: end do_create_mls_schema;
359: