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

Line 65: l_cur := dbms_sql.open_cursor;

61: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
62: commit;
63: end if;
64:
65: l_cur := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
67: biv_core_pkg.bind_all_variables(l_cur);
68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
69: l_dummy := dbms_sql.execute(l_cur);

Line 66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

62: commit;
63: end if;
64:
65: l_cur := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
67: biv_core_pkg.bind_all_variables(l_cur);
68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
69: l_dummy := dbms_sql.execute(l_cur);
70: dbms_sql.close_cursor(l_cur);

Line 68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);

64:
65: l_cur := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
67: biv_core_pkg.bind_all_variables(l_cur);
68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
69: l_dummy := dbms_sql.execute(l_cur);
70: dbms_sql.close_cursor(l_cur);
71:
72: /**********************************************************************

Line 69: l_dummy := dbms_sql.execute(l_cur);

65: l_cur := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
67: biv_core_pkg.bind_all_variables(l_cur);
68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
69: l_dummy := dbms_sql.execute(l_cur);
70: dbms_sql.close_cursor(l_cur);
71:
72: /**********************************************************************
73: insert into biv_tmp_bin(report_code, col1, col2, col4,session_id)

Line 70: dbms_sql.close_cursor(l_cur);

66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
67: biv_core_pkg.bind_all_variables(l_cur);
68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
69: l_dummy := dbms_sql.execute(l_cur);
70: dbms_sql.close_cursor(l_cur);
71:
72: /**********************************************************************
73: insert into biv_tmp_bin(report_code, col1, col2, col4,session_id)
74: select 'BIV_BIN_SR_ESCALATION',lup.lookup_code,lup.meaning,

Line 159: l_cur := dbms_sql.open_cursor;

155: if (l_debug = 'Y') then
156: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
157: end if;
158: --
159: l_cur := dbms_sql.open_cursor;
160: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
161: biv_core_pkg.bind_all_variables(l_cur);
162: if (l_debug = 'Y') then
163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);

Line 160: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

156: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
157: end if;
158: --
159: l_cur := dbms_sql.open_cursor;
160: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
161: biv_core_pkg.bind_all_variables(l_cur);
162: if (l_debug = 'Y') then
163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);
164: end if;

Line 165: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);

161: biv_core_pkg.bind_all_variables(l_cur);
162: if (l_debug = 'Y') then
163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);
164: end if;
165: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
166: if (l_debug = 'Y') then
167: biv_core_pkg.biv_debug('Bef all binding',biv_core_pkg.g_report_id);
168: end if;
169: dbms_sql.bind_variable(l_cur,':all_meaning' , l_all );

Line 169: dbms_sql.bind_variable(l_cur,':all_meaning' , l_all );

165: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
166: if (l_debug = 'Y') then
167: biv_core_pkg.biv_debug('Bef all binding',biv_core_pkg.g_report_id);
168: end if;
169: dbms_sql.bind_variable(l_cur,':all_meaning' , l_all );
170: l_dummy := dbms_sql.execute(l_cur);
171:
172: -- web available employee count
173: /* 3/13/02 web available is being inserted in above statement.

Line 170: l_dummy := dbms_sql.execute(l_cur);

166: if (l_debug = 'Y') then
167: biv_core_pkg.biv_debug('Bef all binding',biv_core_pkg.g_report_id);
168: end if;
169: dbms_sql.bind_variable(l_cur,':all_meaning' , l_all );
170: l_dummy := dbms_sql.execute(l_cur);
171:
172: -- web available employee count
173: /* 3/13/02 web available is being inserted in above statement.
174: This is due to change sql Statment.

Line 189: l_cur := dbms_sql.open_cursor;

185: if (l_debug = 'Y') then
186: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
187: commit;
188: end if;
189: l_cur := dbms_sql.open_cursor;
190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
191: biv_core_pkg.bind_all_variables(l_cur);
192: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
193: l_dummy := dbms_sql.execute(l_cur);

Line 190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

186: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
187: commit;
188: end if;
189: l_cur := dbms_sql.open_cursor;
190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
191: biv_core_pkg.bind_all_variables(l_cur);
192: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
193: l_dummy := dbms_sql.execute(l_cur);
194: */

Line 192: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);

188: end if;
189: l_cur := dbms_sql.open_cursor;
190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
191: biv_core_pkg.bind_all_variables(l_cur);
192: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
193: l_dummy := dbms_sql.execute(l_cur);
194: */
195: /**************************************************************************
196: insert into biv_tmp_bin ( report_code, rowno, col1, col2, col4,session_id)

Line 193: l_dummy := dbms_sql.execute(l_cur);

189: l_cur := dbms_sql.open_cursor;
190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
191: biv_core_pkg.bind_all_variables(l_cur);
192: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
193: l_dummy := dbms_sql.execute(l_cur);
194: */
195: /**************************************************************************
196: insert into biv_tmp_bin ( report_code, rowno, col1, col2, col4,session_id)
197: select 'BIV_BIN_RESOURCE', rownum, id, descr, total,l_session_id

Line 280: l_cur := dbms_sql.open_cursor;

276:
277: if (l_debug = 'Y') then
278: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
279: end if;
280: l_cur := dbms_sql.open_cursor;
281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);
283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);

Line 281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

277: if (l_debug = 'Y') then
278: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
279: end if;
280: l_cur := dbms_sql.open_cursor;
281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);
283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);

Line 283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);

279: end if;
280: l_cur := dbms_sql.open_cursor;
281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);
283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);
286: update biv_tmp_rt2
287: set col1 = 'task' || biv_core_pkg.g_param_sep ||

Line 284: l_dummy := dbms_sql.execute(l_cur);

280: l_cur := dbms_sql.open_cursor;
281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);
283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);
286: update biv_tmp_rt2
287: set col1 = 'task' || biv_core_pkg.g_param_sep ||
288: 'task_id' || biv_core_pkg.g_value_sep || id

Line 285: dbms_sql.close_cursor(l_cur);

281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);
283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);
286: update biv_tmp_rt2
287: set col1 = 'task' || biv_core_pkg.g_param_sep ||
288: 'task_id' || biv_core_pkg.g_value_sep || id
289: ;