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

Line 163: l_cursorid := DBMS_SQL.open_cursor;

159: EXECUTE IMMEDIATE l_query_statement
160: INTO l_count USING G_Entry_Table(i).Bundle_ID;
161: IF l_count = 0 THEN
162:
163: l_cursorid := DBMS_SQL.open_cursor;
164: DBMS_SQL.parse (l_cursorid, l_execute_statement, DBMS_SQL.v7);
165: DBMS_SQL.bind_variable (l_cursorid, ':1',
166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);

Line 164: DBMS_SQL.parse (l_cursorid, l_execute_statement, DBMS_SQL.v7);

160: INTO l_count USING G_Entry_Table(i).Bundle_ID;
161: IF l_count = 0 THEN
162:
163: l_cursorid := DBMS_SQL.open_cursor;
164: DBMS_SQL.parse (l_cursorid, l_execute_statement, DBMS_SQL.v7);
165: DBMS_SQL.bind_variable (l_cursorid, ':1',
166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);
168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);

Line 165: DBMS_SQL.bind_variable (l_cursorid, ':1',

161: IF l_count = 0 THEN
162:
163: l_cursorid := DBMS_SQL.open_cursor;
164: DBMS_SQL.parse (l_cursorid, l_execute_statement, DBMS_SQL.v7);
165: DBMS_SQL.bind_variable (l_cursorid, ':1',
166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);
168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);
169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');

Line 167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);

163: l_cursorid := DBMS_SQL.open_cursor;
164: DBMS_SQL.parse (l_cursorid, l_execute_statement, DBMS_SQL.v7);
165: DBMS_SQL.bind_variable (l_cursorid, ':1',
166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);
168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);
169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');
170: DBMS_SQL.bind_variable (l_cursorid, ':5', 'Win9x');
171:

Line 168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);

164: DBMS_SQL.parse (l_cursorid, l_execute_statement, DBMS_SQL.v7);
165: DBMS_SQL.bind_variable (l_cursorid, ':1',
166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);
168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);
169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');
170: DBMS_SQL.bind_variable (l_cursorid, ':5', 'Win9x');
171:
172: begin

Line 169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');

165: DBMS_SQL.bind_variable (l_cursorid, ':1',
166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);
168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);
169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');
170: DBMS_SQL.bind_variable (l_cursorid, ':5', 'Win9x');
171:
172: begin
173: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 170: DBMS_SQL.bind_variable (l_cursorid, ':5', 'Win9x');

166: G_Entry_Table(i).Bundle_Name || p_nls_language);
167: DBMS_SQL.bind_variable (l_cursorid, ':2', G_Entry_Table(i).Bundle_Link);
168: DBMS_SQL.bind_variable (l_cursorid, ':3', G_Entry_Table(i).Bundle_ID);
169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');
170: DBMS_SQL.bind_variable (l_cursorid, ':5', 'Win9x');
171:
172: begin
173: l_execute_status := DBMS_SQL.execute (l_cursorid);
174: exception

Line 173: l_execute_status := DBMS_SQL.execute (l_cursorid);

169: DBMS_SQL.bind_variable (l_cursorid, ':4', 'WinNT');
170: DBMS_SQL.bind_variable (l_cursorid, ':5', 'Win9x');
171:
172: begin
173: l_execute_status := DBMS_SQL.execute (l_cursorid);
174: exception
175: when others then
176: l_return_val := 'N';
177: end;

Line 178: DBMS_SQL.close_cursor (l_cursorid);

174: exception
175: when others then
176: l_return_val := 'N';
177: end;
178: DBMS_SQL.close_cursor (l_cursorid);
179: END IF;
180: Exit;
181: END IF;
182: END LOOP;