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.

APPS.BSC_TEMPLATE dependencies on DBMS_SQL

Line 269: l_cursor := DBMS_SQL.Open_Cursor;

265: if (l_count <> 0) then
266: l_sql_stmt := 'Drop Table BSC_D_TYPE_OF_ACCOUNT';
267: l_debug_stmt := l_sql_stmt;
268:
269: l_cursor := DBMS_SQL.Open_Cursor;
270: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
271: l_ignore := DBMS_SQL.Execute(l_cursor);
272: DBMS_SQL.Close_Cursor(l_cursor);
273: end if;

Line 270: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

266: l_sql_stmt := 'Drop Table BSC_D_TYPE_OF_ACCOUNT';
267: l_debug_stmt := l_sql_stmt;
268:
269: l_cursor := DBMS_SQL.Open_Cursor;
270: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
271: l_ignore := DBMS_SQL.Execute(l_cursor);
272: DBMS_SQL.Close_Cursor(l_cursor);
273: end if;
274:

Line 271: l_ignore := DBMS_SQL.Execute(l_cursor);

267: l_debug_stmt := l_sql_stmt;
268:
269: l_cursor := DBMS_SQL.Open_Cursor;
270: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
271: l_ignore := DBMS_SQL.Execute(l_cursor);
272: DBMS_SQL.Close_Cursor(l_cursor);
273: end if;
274:
275: Select count(*)

Line 272: DBMS_SQL.Close_Cursor(l_cursor);

268:
269: l_cursor := DBMS_SQL.Open_Cursor;
270: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
271: l_ignore := DBMS_SQL.Execute(l_cursor);
272: DBMS_SQL.Close_Cursor(l_cursor);
273: end if;
274:
275: Select count(*)
276: Into l_count

Line 284: l_cursor := DBMS_SQL.Open_Cursor;

280: if (l_count <> 0) then
281: l_sql_stmt := 'Drop Table BSC_D_ACCOUNT';
282: l_debug_stmt := l_sql_stmt;
283:
284: l_cursor := DBMS_SQL.Open_Cursor;
285: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
286: l_ignore := DBMS_SQL.Execute(l_cursor);
287: DBMS_SQL.Close_Cursor(l_cursor);
288: end if;

Line 285: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

281: l_sql_stmt := 'Drop Table BSC_D_ACCOUNT';
282: l_debug_stmt := l_sql_stmt;
283:
284: l_cursor := DBMS_SQL.Open_Cursor;
285: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
286: l_ignore := DBMS_SQL.Execute(l_cursor);
287: DBMS_SQL.Close_Cursor(l_cursor);
288: end if;
289:

Line 286: l_ignore := DBMS_SQL.Execute(l_cursor);

282: l_debug_stmt := l_sql_stmt;
283:
284: l_cursor := DBMS_SQL.Open_Cursor;
285: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
286: l_ignore := DBMS_SQL.Execute(l_cursor);
287: DBMS_SQL.Close_Cursor(l_cursor);
288: end if;
289:
290: Select count(*)

Line 287: DBMS_SQL.Close_Cursor(l_cursor);

283:
284: l_cursor := DBMS_SQL.Open_Cursor;
285: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
286: l_ignore := DBMS_SQL.Execute(l_cursor);
287: DBMS_SQL.Close_Cursor(l_cursor);
288: end if;
289:
290: Select count(*)
291: Into l_count

Line 299: l_cursor := DBMS_SQL.Open_Cursor;

295: if (l_count <> 0) then
296: l_sql_stmt := 'Drop Table BSC_D_SUBACCOUNT';
297: l_debug_stmt := l_sql_stmt;
298:
299: l_cursor := DBMS_SQL.Open_Cursor;
300: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
301: l_ignore := DBMS_SQL.Execute(l_cursor);
302: DBMS_SQL.Close_Cursor(l_cursor);
303: end if;

Line 300: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

296: l_sql_stmt := 'Drop Table BSC_D_SUBACCOUNT';
297: l_debug_stmt := l_sql_stmt;
298:
299: l_cursor := DBMS_SQL.Open_Cursor;
300: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
301: l_ignore := DBMS_SQL.Execute(l_cursor);
302: DBMS_SQL.Close_Cursor(l_cursor);
303: end if;
304:

Line 301: l_ignore := DBMS_SQL.Execute(l_cursor);

297: l_debug_stmt := l_sql_stmt;
298:
299: l_cursor := DBMS_SQL.Open_Cursor;
300: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
301: l_ignore := DBMS_SQL.Execute(l_cursor);
302: DBMS_SQL.Close_Cursor(l_cursor);
303: end if;
304:
305: if (x_template_type = 1) then -- Cross system

Line 302: DBMS_SQL.Close_Cursor(l_cursor);

298:
299: l_cursor := DBMS_SQL.Open_Cursor;
300: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
301: l_ignore := DBMS_SQL.Execute(l_cursor);
302: DBMS_SQL.Close_Cursor(l_cursor);
303: end if;
304:
305: if (x_template_type = 1) then -- Cross system
306:

Line 317: l_cursor := DBMS_SQL.Open_Cursor;

313:
314: l_sql_stmt := 'Drop Table BSC_D_PROJECT';
315: l_debug_stmt := l_sql_stmt;
316:
317: l_cursor := DBMS_SQL.Open_Cursor;
318: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
319: l_ignore := DBMS_SQL.Execute(l_cursor);
320: DBMS_SQL.Close_Cursor(l_cursor);
321:

Line 318: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

314: l_sql_stmt := 'Drop Table BSC_D_PROJECT';
315: l_debug_stmt := l_sql_stmt;
316:
317: l_cursor := DBMS_SQL.Open_Cursor;
318: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
319: l_ignore := DBMS_SQL.Execute(l_cursor);
320: DBMS_SQL.Close_Cursor(l_cursor);
321:
322: end if;

Line 319: l_ignore := DBMS_SQL.Execute(l_cursor);

315: l_debug_stmt := l_sql_stmt;
316:
317: l_cursor := DBMS_SQL.Open_Cursor;
318: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
319: l_ignore := DBMS_SQL.Execute(l_cursor);
320: DBMS_SQL.Close_Cursor(l_cursor);
321:
322: end if;
323:

Line 320: DBMS_SQL.Close_Cursor(l_cursor);

316:
317: l_cursor := DBMS_SQL.Open_Cursor;
318: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
319: l_ignore := DBMS_SQL.Execute(l_cursor);
320: DBMS_SQL.Close_Cursor(l_cursor);
321:
322: end if;
323:
324: END IF;