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

Line 92: l_cur_id := DBMS_SQL.OPEN_CURSOR;

88: to_char(g_session_id),g_report_code);
89: commit;
90: end if;
91:
92: l_cur_id := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);

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

89: commit;
90: end if;
91:
92: l_cur_id := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);

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

91:
92: l_cur_id := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);

Line 96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);

92: l_cur_id := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);

Line 97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);

93: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);

Line 98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);

94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);

Line 99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);

95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);

Line 100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);

96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);

Line 101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);

97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);

Line 102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);

98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);
99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);

Line 103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);

99: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_a',g_sev_4);
100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);

Line 104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);

100: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_a',g_sev_5);
101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);

Line 105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);

101: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_b',g_sev_1);
102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);

Line 106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);

102: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_b',g_sev_2);
103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);

Line 107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);

103: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_b',g_sev_3);
104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);

Line 108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);

104: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_b',g_sev_4);
105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
112: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

Line 109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);

105: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_b',g_sev_5);
106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
112: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
113: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

Line 110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);

106: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_c',g_sev_1);
107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
112: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
113: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
114: commit;

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

107: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_c',g_sev_2);
108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
112: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
113: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
114: commit;
115:

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

108: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_c',g_sev_3);
109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
112: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
113: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
114: commit;
115:
116: -- update the average, URL

Line 113: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

109: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_4_c',g_sev_4);
110: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_5_c',g_sev_5);
111: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_report_code',g_report_code);
112: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
113: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
114: commit;
115:
116: -- update the average, URL
117: if (g_debug_flag = 'Y') then