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 261: select_sql1_c := dbms_sql.open_cursor;

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

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

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

Line 272: select_sql2_c := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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