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

Line 57: t_cursor_name := dbms_sql.open_cursor;

53: ) <> 'SELECT'
54: then
55: x_query_correct := FND_API.G_FALSE;
56: end if;
57: t_cursor_name := dbms_sql.open_cursor;
58: dbms_sql.parse
59: ( t_cursor_name
60: , p_sql_query
61: , dbms_sql.native

Line 58: dbms_sql.parse

54: then
55: x_query_correct := FND_API.G_FALSE;
56: end if;
57: t_cursor_name := dbms_sql.open_cursor;
58: dbms_sql.parse
59: ( t_cursor_name
60: , p_sql_query
61: , dbms_sql.native
62: );

Line 61: , dbms_sql.native

57: t_cursor_name := dbms_sql.open_cursor;
58: dbms_sql.parse
59: ( t_cursor_name
60: , p_sql_query
61: , dbms_sql.native
62: );
63: dbms_sql.close_cursor
64: ( t_cursor_name
65: );

Line 63: dbms_sql.close_cursor

59: ( t_cursor_name
60: , p_sql_query
61: , dbms_sql.native
62: );
63: dbms_sql.close_cursor
64: ( t_cursor_name
65: );
66: x_query_correct := FND_API.G_TRUE;
67: -- Standard call to get message count and if count is 1, get message info.

Line 103: if dbms_sql.is_open

99: FND_MSG_PUB.Count_And_Get
100: ( p_count => x_msg_count
101: , p_data => x_msg_data
102: );
103: if dbms_sql.is_open
104: (t_cursor_name
105: )
106: then
107: dbms_sql.close_cursor

Line 107: dbms_sql.close_cursor

103: if dbms_sql.is_open
104: (t_cursor_name
105: )
106: then
107: dbms_sql.close_cursor
108: (t_cursor_name
109: );
110: end if;
111: x_query_correct := FND_API.G_FALSE;

Line 139: rec_tab dbms_sql.desc_tab;

135:
136: c_query number;
137: t_dummy number;
138: col_count integer;
139: rec_tab dbms_sql.desc_tab;
140: col_num number;
141: t_header varchar2(2000);
142: t_header_line varchar2(2000);
143: t_result varchar2(32767);

Line 145: t_rec dbms_sql.desc_rec;

141: t_header varchar2(2000);
142: t_header_line varchar2(2000);
143: t_result varchar2(32767);
144: t_msg_text varchar2(32767);
145: t_rec dbms_sql.desc_rec;
146: t_col_var varchar2(2000);
147: t_col_num number;
148: t_col_dat date;
149: t_col_row rowid;

Line 390: c_query := dbms_sql.open_cursor;

386: );
387: fnd_msg_pub.add;
388: raise FND_API.G_EXC_UNEXPECTED_ERROR;
389: else
390: c_query := dbms_sql.open_cursor;
391: -- Start a new block to be able to trap exceptions
392: -- when parsing it fails.
393: begin
394: dbms_sql.parse

Line 394: dbms_sql.parse

390: c_query := dbms_sql.open_cursor;
391: -- Start a new block to be able to trap exceptions
392: -- when parsing it fails.
393: begin
394: dbms_sql.parse
395: ( c_query
396: , t_sqlstring
397: , dbms_sql.native
398: );

Line 397: , dbms_sql.native

393: begin
394: dbms_sql.parse
395: ( c_query
396: , t_sqlstring
397: , dbms_sql.native
398: );
399: t_dummy := dbms_sql.execute
400: ( c_query
401: );

Line 399: t_dummy := dbms_sql.execute

395: ( c_query
396: , t_sqlstring
397: , dbms_sql.native
398: );
399: t_dummy := dbms_sql.execute
400: ( c_query
401: );
402: dbms_sql.describe_columns
403: ( c_query

Line 402: dbms_sql.describe_columns

398: );
399: t_dummy := dbms_sql.execute
400: ( c_query
401: );
402: dbms_sql.describe_columns
403: ( c_query
404: , col_count
405: , rec_tab
406: );

Line 431: dbms_sql.define_column

427: , t_rec.col_max_len
428: , '-'
429: )
430: || ' ';
431: dbms_sql.define_column
432: ( c_query
433: , col_num
434: , t_col_var
435: , t_rec.col_max_len

Line 459: dbms_sql.define_column

455: , t_length
456: , '-'
457: )
458: || ' ';
459: dbms_sql.define_column
460: ( c_query
461: , col_num
462: , t_col_num
463: );

Line 480: dbms_sql.define_column_rowid

476: , 18
477: , '-'
478: )
479: || ' ';
480: dbms_sql.define_column_rowid
481: ( c_query
482: , col_num
483: , t_col_row
484: );

Line 501: dbms_sql.define_column

497: , 9
498: , '-'
499: )
500: || ' ';
501: dbms_sql.define_column
502: ( c_query
503: , col_num
504: , t_col_dat
505: );

Line 517: if dbms_sql.fetch_rows

513: end if;
514: end loop;
515: t_result := '';
516: loop
517: if dbms_sql.fetch_rows
518: ( c_query
519: ) > 0
520: then
521: -- get column values of the row

Line 530: dbms_sql.column_value

526: if t_rec.col_type in ( 1
527: , 96
528: ) --char
529: then
530: dbms_sql.column_value
531: ( c_query
532: , col_num
533: , t_col_var
534: );

Line 544: dbms_sql.column_value

540: )
541: || ' ';
542: elsif t_rec.col_type = 2 --number
543: then
544: dbms_sql.column_value
545: ( c_query
546: , col_num
547: , t_col_num
548: );

Line 567: dbms_sql.column_value_rowid

563: )
564: || ' ';
565: elsif t_rec.col_type = 11 --ROWID
566: then
567: dbms_sql.column_value_rowid
568: ( c_query
569: , col_num
570: , t_col_row
571: );

Line 577: dbms_sql.column_value

573: || t_col_row
574: || ' ';
575: elsif t_rec.col_type = 12 --date
576: then
577: dbms_sql.column_value
578: ( c_query
579: , col_num
580: , t_col_dat
581: );

Line 641: dbms_sql.close_cursor

637: end if;
638: exception
639: when others
640: then
641: dbms_sql.close_cursor
642: ( c_query
643: );
644: fnd_message.set_name
645: ( 'CSF'

Line 651: dbms_sql.close_cursor

647: );
648: fnd_msg_pub.add;
649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
650: end;
651: dbms_sql.close_cursor
652: ( c_query
653: );
654: end if;
655: -- Executing of the query is finished here.