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

Line 259: select_sql1_c := dbms_sql.open_cursor;

255: ------------------------------------------------
256:
257: BEGIN
258: arp_standard.debug( ' Parsing select_sql1 stmt');
259: select_sql1_c := dbms_sql.open_cursor;
260: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
261:
262: EXCEPTION
263: WHEN OTHERS THEN

Line 260: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );

256:
257: BEGIN
258: arp_standard.debug( ' Parsing select_sql1 stmt');
259: select_sql1_c := dbms_sql.open_cursor;
260: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: arp_standard.debug( 'EXCEPTION: Error parsing select_sql1 stmt' );

Line 270: select_sql2_c := dbms_sql.open_cursor;

266: END;
267:
268: BEGIN
269: arp_standard.debug( ' Parsing select_sql2 stmt');
270: select_sql2_c := dbms_sql.open_cursor;
271: dbms_sql.parse( select_sql2_c, select_sql2, dbms_sql.v7 );
272:
273: EXCEPTION
274: WHEN OTHERS THEN

Line 271: dbms_sql.parse( select_sql2_c, select_sql2, dbms_sql.v7 );

267:
268: BEGIN
269: arp_standard.debug( ' Parsing select_sql2 stmt');
270: select_sql2_c := dbms_sql.open_cursor;
271: dbms_sql.parse( select_sql2_c, select_sql2, dbms_sql.v7 );
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: arp_standard.debug( 'EXCEPTION: Error parsing select_sql2 stmt' );

Line 282: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);

278:
279: arp_standard.debug( 'Completed parsing select stmts' );
280:
281: arp_standard.debug( 'define_columns for select_sql1_c');
282: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);
283:
284: arp_standard.debug( 'define_columns for select_sql2_c');
285: dbms_sql.define_column( select_sql2_c, 1, select_rec2.language, 4);
286:

Line 285: dbms_sql.define_column( select_sql2_c, 1, select_rec2.language, 4);

281: arp_standard.debug( 'define_columns for select_sql1_c');
282: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);
283:
284: arp_standard.debug( 'define_columns for select_sql2_c');
285: dbms_sql.define_column( select_sql2_c, 1, select_rec2.language, 4);
286:
287: arp_standard.debug( ' Executing select_sql1' );
288: BEGIN
289: l_ignore := dbms_sql.execute( select_sql1_c );

Line 289: l_ignore := dbms_sql.execute( select_sql1_c );

285: dbms_sql.define_column( select_sql2_c, 1, select_rec2.language, 4);
286:
287: arp_standard.debug( ' Executing select_sql1' );
288: BEGIN
289: l_ignore := dbms_sql.execute( select_sql1_c );
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: arp_standard.debug( 'EXCEPTION: Error executing select_sql1' );

Line 299: l_ignore := dbms_sql.execute( select_sql2_c );

295: END;
296:
297: arp_standard.debug( ' Executing select_sql2' );
298: BEGIN
299: l_ignore := dbms_sql.execute( select_sql2_c );
300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: arp_standard.debug( 'EXCEPTION: Error executing select_sql2' );

Line 314: if (dbms_sql.fetch_rows( select_sql1_c ) > 0)

310: arp_standard.debug( ' Fetching select_sql1 stmt');
311:
312: begin
313: loop
314: if (dbms_sql.fetch_rows( select_sql1_c ) > 0)
315: then
316:
317: arp_standard.debug(' fetched a row' );
318: select_rec1 := null_rec;

Line 322: dbms_sql.column_value( select_sql1_c, 1, select_rec1.language );

318: select_rec1 := null_rec;
319: ------------------------------------------------------
320: -- Get column values
321: ------------------------------------------------------
322: dbms_sql.column_value( select_sql1_c, 1, select_rec1.language );
323: arp_standard.debug( 'Language code: ' || select_rec1.language );
324:
325: if (lang_str is null) then
326:

Line 344: if (dbms_sql.fetch_rows( select_sql2_c ) > 0)

340:
341: -- concatenate languages from select_sql2_c if it has languages not yet in lang_str
342: begin
343: loop
344: if (dbms_sql.fetch_rows( select_sql2_c ) > 0)
345: then
346:
347: arp_standard.debug(' fetched a row' );
348: select_rec2 := null_rec;

Line 352: dbms_sql.column_value( select_sql2_c, 1, select_rec2.language );

348: select_rec2 := null_rec;
349: ------------------------------------------------------
350: -- Get column values
351: ------------------------------------------------------
352: dbms_sql.column_value( select_sql2_c, 1, select_rec2.language );
353: arp_standard.debug( 'Language code: ' || select_rec2.language );
354:
355: if (lang_str is null) then
356: