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_HS_PROB_AVOID_REPORT_PKG dependencies on DBMS_SQL

Line 86: l_cur_id := DBMS_SQL.OPEN_CURSOR;

82: biv_core_pkg.biv_debug(g_query,g_report_code);
83: commit;
84: end if;
85:
86: l_cur_id := DBMS_SQL.OPEN_CURSOR;
87: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
88: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
89:
90: -- sessionid also written to biv_debug

Line 87: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);

83: commit;
84: end if;
85:
86: l_cur_id := DBMS_SQL.OPEN_CURSOR;
87: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
88: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
89:
90: -- sessionid also written to biv_debug
91: if (g_debug_flag = 'Y') then

Line 88: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);

84: end if;
85:
86: l_cur_id := DBMS_SQL.OPEN_CURSOR;
87: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
88: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
89:
90: -- sessionid also written to biv_debug
91: if (g_debug_flag = 'Y') then
92: biv_core_pkg.biv_debug('SessionId: '||g_session_id,

Line 96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);

92: biv_core_pkg.biv_debug('SessionId: '||g_session_id,
93: g_report_code);
94: end if;
95:
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
97: biv_core_pkg.bind_all_variables(l_cur_id);
98: dbms_sql.bind_variable(l_cur_id, ':session_id', l_session_id);
99: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
100:

Line 98: dbms_sql.bind_variable(l_cur_id, ':session_id', l_session_id);

94: end if;
95:
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
97: biv_core_pkg.bind_all_variables(l_cur_id);
98: dbms_sql.bind_variable(l_cur_id, ':session_id', l_session_id);
99: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
100:
101: -- update the total percentage column
102: g_query := 'UPDATE biv_tmp_hs1

Line 99: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

95:
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
97: biv_core_pkg.bind_all_variables(l_cur_id);
98: dbms_sql.bind_variable(l_cur_id, ':session_id', l_session_id);
99: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
100:
101: -- update the total percentage column
102: g_query := 'UPDATE biv_tmp_hs1
103: SET col12 =

Line 112: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);

108: biv_core_pkg.get_session_id
109: )),2)
110: WHERE report_code = ''BIV_HS_PROB_AVOID'' and
111: session_id = :session_id ';
112: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
113: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
114: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
115: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
116:

Line 113: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);

109: )),2)
110: WHERE report_code = ''BIV_HS_PROB_AVOID'' and
111: session_id = :session_id ';
112: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
113: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
114: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
115: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
116:
117: -- UPDATE COMP SUBCOMP DESC

Line 114: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

110: WHERE report_code = ''BIV_HS_PROB_AVOID'' and
111: session_id = :session_id ';
112: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
113: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
114: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
115: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
116:
117: -- UPDATE COMP SUBCOMP DESC
118: execute immediate '

Line 115: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

111: session_id = :session_id ';
112: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
113: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
114: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
115: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
116:
117: -- UPDATE COMP SUBCOMP DESC
118: execute immediate '
119: UPDATE biv_tmp_hs1

Line 277: l_cur_id := DBMS_SQL.OPEN_CURSOR;

273: biv_core_pkg.biv_debug(g_query,g_report_code);
274: commit;
275: end if;
276:
277: l_cur_id := DBMS_SQL.OPEN_CURSOR;
278: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
279: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_code',g_report_code);
280: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
281:

Line 278: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);

274: commit;
275: end if;
276:
277: l_cur_id := DBMS_SQL.OPEN_CURSOR;
278: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
279: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_code',g_report_code);
280: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
281:
282: biv_core_pkg.bind_all_variables(l_cur_id);

Line 279: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_code',g_report_code);

275: end if;
276:
277: l_cur_id := DBMS_SQL.OPEN_CURSOR;
278: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
279: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_code',g_report_code);
280: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
281:
282: biv_core_pkg.bind_all_variables(l_cur_id);
283: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

Line 280: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);

276:
277: l_cur_id := DBMS_SQL.OPEN_CURSOR;
278: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
279: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_code',g_report_code);
280: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
281:
282: biv_core_pkg.bind_all_variables(l_cur_id);
283: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
284:

Line 283: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

279: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_code',g_report_code);
280: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
281:
282: biv_core_pkg.bind_all_variables(l_cur_id);
283: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
284:
285: -- update the total percentage column
286: g_query := 'UPDATE biv_tmp_hs1
287: SET col4 =

Line 296: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);

292: biv_core_pkg.get_session_id
293: )),2)
294: WHERE report_code = ''BIV_HS_PROB_AVOID_RES'' and
295: session_id = :session_id ';
296: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
297: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
298: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
299: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
300:

Line 297: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);

293: )),2)
294: WHERE report_code = ''BIV_HS_PROB_AVOID_RES'' and
295: session_id = :session_id ';
296: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
297: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
298: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
299: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
300:
301: l_new_param_str := 'BIV_SERVICE_REQUEST' ||

Line 298: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

294: WHERE report_code = ''BIV_HS_PROB_AVOID_RES'' and
295: session_id = :session_id ';
296: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
297: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
298: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
299: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
300:
301: l_new_param_str := 'BIV_SERVICE_REQUEST' ||
302: biv_core_pkg.g_param_sep ||

Line 299: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

295: session_id = :session_id ';
296: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
297: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
298: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
299: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
300:
301: l_new_param_str := 'BIV_SERVICE_REQUEST' ||
302: biv_core_pkg.g_param_sep ||
303: biv_core_pkg.reconstruct_param_str;