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.BIS_COLLECTION_UTILITIES dependencies on DBMS_SQL

Line 313: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

309: l_option_string:=null;
310: end if;
311: /**
312: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:errbuf, :retcode,:option_string); END;';
313: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);

Line 314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);

310: end if;
311: /**
312: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:errbuf, :retcode,:option_string); END;';
313: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);
318: l_rows:=DBMS_SQL.execute(l_cursor_id);

Line 315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);

311: /**
312: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:errbuf, :retcode,:option_string); END;';
313: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);
318: l_rows:=DBMS_SQL.execute(l_cursor_id);
319: DBMS_SQL.close_cursor(l_cursor_id);

Line 316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);

312: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:errbuf, :retcode,:option_string); END;';
313: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);
318: l_rows:=DBMS_SQL.execute(l_cursor_id);
319: DBMS_SQL.close_cursor(l_cursor_id);
320: **/

Line 317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);

313: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);
318: l_rows:=DBMS_SQL.execute(l_cursor_id);
319: DBMS_SQL.close_cursor(l_cursor_id);
320: **/
321: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:1, :2,:3); END;';

Line 318: l_rows:=DBMS_SQL.execute(l_cursor_id);

314: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);
318: l_rows:=DBMS_SQL.execute(l_cursor_id);
319: DBMS_SQL.close_cursor(l_cursor_id);
320: **/
321: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:1, :2,:3); END;';
322: execute immediate l_stmt using OUT errbuf,OUT retcode,IN l_option_string;

Line 319: DBMS_SQL.close_cursor(l_cursor_id);

315: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
316: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
317: DBMS_SQL.bind_variable(l_cursor_id,'option_string',l_option_string, 32767);
318: l_rows:=DBMS_SQL.execute(l_cursor_id);
319: DBMS_SQL.close_cursor(l_cursor_id);
320: **/
321: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:1, :2,:3); END;';
322: execute immediate l_stmt using OUT errbuf,OUT retcode,IN l_option_string;
323: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BSC_DBI_CALENDAR.load_dbi_cal_into_bsc');

Line 404: p_attribute_table OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

400: end get_last_refresh_dates;
401:
402: procedure get_last_user_attributes(
403: p_object_name IN VARCHAR2,
404: p_attribute_table OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
405: p_count OUT NOCOPY NUMBER ) is
406: l_allattribute varchar2(2400);
407: begin
408: p_count:=0;