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 DBMS_SQL

Line 71: c := dbms_sql.open_cursor;

67: raise_application_error(-20000,'The schema '||upper(aol_schema)||
68: ' does not exist.');
69: end if;
70:
71: c := dbms_sql.open_cursor;
72:
73: statement := 'select install_group_num from '||upper(aol_schema)||
74: '.fnd_oracle_userid where read_only_flag = ''U'''||
75: ' order by install_group_num' ;

Line 77: dbms_sql.parse(c, statement, dbms_sql.native);

73: statement := 'select install_group_num from '||upper(aol_schema)||
74: '.fnd_oracle_userid where read_only_flag = ''U'''||
75: ' order by install_group_num' ;
76:
77: dbms_sql.parse(c, statement, dbms_sql.native);
78: dbms_sql.define_column(c,1,install_group_num);
79: rows_processed := dbms_sql.execute(c);
80: -- loop through all install groups and create the multiple APPS_MLS
81: -- schemas as necessary

Line 78: dbms_sql.define_column(c,1,install_group_num);

74: '.fnd_oracle_userid where read_only_flag = ''U'''||
75: ' order by install_group_num' ;
76:
77: dbms_sql.parse(c, statement, dbms_sql.native);
78: dbms_sql.define_column(c,1,install_group_num);
79: rows_processed := dbms_sql.execute(c);
80: -- loop through all install groups and create the multiple APPS_MLS
81: -- schemas as necessary
82: loop

Line 79: rows_processed := dbms_sql.execute(c);

75: ' order by install_group_num' ;
76:
77: dbms_sql.parse(c, statement, dbms_sql.native);
78: dbms_sql.define_column(c,1,install_group_num);
79: rows_processed := dbms_sql.execute(c);
80: -- loop through all install groups and create the multiple APPS_MLS
81: -- schemas as necessary
82: loop
83: if dbms_sql.fetch_rows(c) > 0 then

Line 83: if dbms_sql.fetch_rows(c) > 0 then

79: rows_processed := dbms_sql.execute(c);
80: -- loop through all install groups and create the multiple APPS_MLS
81: -- schemas as necessary
82: loop
83: if dbms_sql.fetch_rows(c) > 0 then
84: dbms_sql.column_value(c,1,install_group_num);
85:
86: -- Process the install group
87:

Line 84: dbms_sql.column_value(c,1,install_group_num);

80: -- loop through all install groups and create the multiple APPS_MLS
81: -- schemas as necessary
82: loop
83: if dbms_sql.fetch_rows(c) > 0 then
84: dbms_sql.column_value(c,1,install_group_num);
85:
86: -- Process the install group
87:
88: -- get the APPS account name ( apps[][_] )

Line 98: dbms_sql.close_cursor(c);

94: apps_schema, apps_schema_mls, invoker_mode);
95:
96: else
97: -- no more product groups to process
98: dbms_sql.close_cursor(c);
99: exit;
100: end if;
101: end loop; -- loop over all product groups
102: exception

Line 104: dbms_sql.close_cursor(c);

100: end if;
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;

Line 139: c := dbms_sql.open_cursor;

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:
142: -- Bug 3611969 : FIXED FILE.SQL.35 GSCC WARNINGS
143: -- sraghuve (07/05/2004)

Line 161: dbms_sql.parse(c, statement, dbms_sql.native);

157: aol_schema||'.ak_language_attribute_xrefs '||
158: 'where language not in (select nls_language '||
159: 'from '||aol_schema||'.fnd_languages '||
160: 'where installed_flag = ''B'') ';
161: dbms_sql.parse(c, statement, dbms_sql.native);
162: dbms_sql.define_column(c,1,language_name,30);
163: dbms_sql.define_column(c,2,attribute_column_name,30);
164: dbms_sql.define_column(c,3,lset_number);
165: rows_processed := dbms_sql.execute(c);

Line 162: dbms_sql.define_column(c,1,language_name,30);

158: 'where language not in (select nls_language '||
159: 'from '||aol_schema||'.fnd_languages '||
160: 'where installed_flag = ''B'') ';
161: dbms_sql.parse(c, statement, dbms_sql.native);
162: dbms_sql.define_column(c,1,language_name,30);
163: dbms_sql.define_column(c,2,attribute_column_name,30);
164: dbms_sql.define_column(c,3,lset_number);
165: rows_processed := dbms_sql.execute(c);
166:

Line 163: dbms_sql.define_column(c,2,attribute_column_name,30);

159: 'from '||aol_schema||'.fnd_languages '||
160: 'where installed_flag = ''B'') ';
161: dbms_sql.parse(c, statement, dbms_sql.native);
162: dbms_sql.define_column(c,1,language_name,30);
163: dbms_sql.define_column(c,2,attribute_column_name,30);
164: dbms_sql.define_column(c,3,lset_number);
165: rows_processed := dbms_sql.execute(c);
166:
167: loop

Line 164: dbms_sql.define_column(c,3,lset_number);

160: 'where installed_flag = ''B'') ';
161: dbms_sql.parse(c, statement, dbms_sql.native);
162: dbms_sql.define_column(c,1,language_name,30);
163: dbms_sql.define_column(c,2,attribute_column_name,30);
164: dbms_sql.define_column(c,3,lset_number);
165: rows_processed := dbms_sql.execute(c);
166:
167: loop
168: if dbms_sql.fetch_rows(c) > 0 then

Line 165: rows_processed := dbms_sql.execute(c);

161: dbms_sql.parse(c, statement, dbms_sql.native);
162: dbms_sql.define_column(c,1,language_name,30);
163: dbms_sql.define_column(c,2,attribute_column_name,30);
164: dbms_sql.define_column(c,3,lset_number);
165: rows_processed := dbms_sql.execute(c);
166:
167: loop
168: if dbms_sql.fetch_rows(c) > 0 then
169: dbms_sql.column_value(c,1,language_name);

Line 168: if dbms_sql.fetch_rows(c) > 0 then

164: dbms_sql.define_column(c,3,lset_number);
165: rows_processed := dbms_sql.execute(c);
166:
167: loop
168: if dbms_sql.fetch_rows(c) > 0 then
169: dbms_sql.column_value(c,1,language_name);
170: dbms_sql.column_value(c,2,attribute_column_name);
171: dbms_sql.column_value(c,3,lset_number);
172: if lset_number = 1 then

Line 169: dbms_sql.column_value(c,1,language_name);

165: rows_processed := dbms_sql.execute(c);
166:
167: loop
168: if dbms_sql.fetch_rows(c) > 0 then
169: dbms_sql.column_value(c,1,language_name);
170: dbms_sql.column_value(c,2,attribute_column_name);
171: dbms_sql.column_value(c,3,lset_number);
172: if lset_number = 1 then
173: ldecode_1 := ldecode_1 || '''' || language_name ||

Line 170: dbms_sql.column_value(c,2,attribute_column_name);

166:
167: loop
168: if dbms_sql.fetch_rows(c) > 0 then
169: dbms_sql.column_value(c,1,language_name);
170: dbms_sql.column_value(c,2,attribute_column_name);
171: dbms_sql.column_value(c,3,lset_number);
172: if lset_number = 1 then
173: ldecode_1 := ldecode_1 || '''' || language_name ||
174: ''', "' || attribute_column_name || '", ';

Line 171: dbms_sql.column_value(c,3,lset_number);

167: loop
168: if dbms_sql.fetch_rows(c) > 0 then
169: dbms_sql.column_value(c,1,language_name);
170: dbms_sql.column_value(c,2,attribute_column_name);
171: dbms_sql.column_value(c,3,lset_number);
172: if lset_number = 1 then
173: ldecode_1 := ldecode_1 || '''' || language_name ||
174: ''', "' || attribute_column_name || '", ';
175: else

Line 181: dbms_sql.close_cursor(c);

177: ''', "' || attribute_column_name || '", ';
178: end if;
179: else
180: -- no more records
181: dbms_sql.close_cursor(c);
182: exit;
183: end if;
184: end loop;
185:

Line 194: dbms_sql.close_cursor(c);

190: end if;
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;

Line 223: c := dbms_sql.open_cursor;

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;
224: statement :=
225: 'select dtc.column_name, '||
226: ' decode(atc.column_name,'''',''N'',''Y'') mlsized, '||
227: ' translated_column_number '||

Line 236: dbms_sql.parse(c, statement, dbms_sql.native);

232: 'and dtc.owner = upper(:table_owner) '||
233: 'and atc.table_name (+) = dtc.table_name '||
234: 'and atc.column_name (+) = dtc.column_name '||
235: 'order by dtc.column_id ';
236: dbms_sql.parse(c, statement, dbms_sql.native);
237: dbms_sql.define_column(c,1,column_name,30);
238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);

Line 237: dbms_sql.define_column(c,1,column_name,30);

233: 'and atc.table_name (+) = dtc.table_name '||
234: 'and atc.column_name (+) = dtc.column_name '||
235: 'order by dtc.column_id ';
236: dbms_sql.parse(c, statement, dbms_sql.native);
237: dbms_sql.define_column(c,1,column_name,30);
238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);

Line 238: dbms_sql.define_column(c,2,mlsized,1);

234: 'and atc.column_name (+) = dtc.column_name '||
235: 'order by dtc.column_id ';
236: dbms_sql.parse(c, statement, dbms_sql.native);
237: dbms_sql.define_column(c,1,column_name,30);
238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);
242: rows_processed := dbms_sql.execute(c);

Line 239: dbms_sql.define_column(c,3,translated_column_number);

235: 'order by dtc.column_id ';
236: dbms_sql.parse(c, statement, dbms_sql.native);
237: dbms_sql.define_column(c,1,column_name,30);
238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);
242: rows_processed := dbms_sql.execute(c);
243: loop

Line 240: dbms_sql.bind_variable(c,'table_name',table_name);

236: dbms_sql.parse(c, statement, dbms_sql.native);
237: dbms_sql.define_column(c,1,column_name,30);
238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);
242: rows_processed := dbms_sql.execute(c);
243: loop
244: if dbms_sql.fetch_rows(c) > 0 then

Line 241: dbms_sql.bind_variable(c,'table_owner',table_owner);

237: dbms_sql.define_column(c,1,column_name,30);
238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);
242: rows_processed := dbms_sql.execute(c);
243: loop
244: if dbms_sql.fetch_rows(c) > 0 then
245:

Line 242: rows_processed := dbms_sql.execute(c);

238: dbms_sql.define_column(c,2,mlsized,1);
239: dbms_sql.define_column(c,3,translated_column_number);
240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);
242: rows_processed := dbms_sql.execute(c);
243: loop
244: if dbms_sql.fetch_rows(c) > 0 then
245:
246: -- only add commas between columns

Line 244: if dbms_sql.fetch_rows(c) > 0 then

240: dbms_sql.bind_variable(c,'table_name',table_name);
241: dbms_sql.bind_variable(c,'table_owner',table_owner);
242: rows_processed := dbms_sql.execute(c);
243: loop
244: if dbms_sql.fetch_rows(c) > 0 then
245:
246: -- only add commas between columns
247: if counter > 1 then
248: lview_column_list := lview_column_list || ', ';

Line 253: dbms_sql.column_value(c,1,column_name);

249: lselect_list := lselect_list || ', ';
250: end if;
251: counter := counter + 1;
252:
253: dbms_sql.column_value(c,1,column_name);
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

Line 254: dbms_sql.column_value(c,2,mlsized);

250: end if;
251: counter := counter + 1;
252:
253: dbms_sql.column_value(c,1,column_name);
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 ||

Line 255: dbms_sql.column_value(c,3,translated_column_number);

251: counter := counter + 1;
252:
253: dbms_sql.column_value(c,1,column_name);
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 ||'")' ;

Line 276: dbms_sql.close_cursor(c);

272: end if;
273:
274: else
275: -- no more records
276: dbms_sql.close_cursor(c);
277: exit;
278: end if;
279: end loop;
280: view_column_list := '('|| lview_column_list ||')';

Line 285: dbms_sql.close_cursor(c);

281: select_list := lselect_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;