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

Line 404: v_cursor := dbms_sql.open_cursor;

400: BEGIN
401:
402: /* Introduced the cursor to fix bug# 3051914 */
403:
404: v_cursor := dbms_sql.open_cursor;
405: dbms_sql.parse( v_cursor, v_desc_sql, dbms_sql.native);
406: dbms_sql.bind_variable(v_cursor, 'seg_val' , x_seg_val );
407:
408: IF ( v_type <> 'F' ) THEN

Line 405: dbms_sql.parse( v_cursor, v_desc_sql, dbms_sql.native);

401:
402: /* Introduced the cursor to fix bug# 3051914 */
403:
404: v_cursor := dbms_sql.open_cursor;
405: dbms_sql.parse( v_cursor, v_desc_sql, dbms_sql.native);
406: dbms_sql.bind_variable(v_cursor, 'seg_val' , x_seg_val );
407:
408: IF ( v_type <> 'F' ) THEN
409: dbms_sql.bind_variable(v_cursor, 'vset_id' , v_vsid );

Line 406: dbms_sql.bind_variable(v_cursor, 'seg_val' , x_seg_val );

402: /* Introduced the cursor to fix bug# 3051914 */
403:
404: v_cursor := dbms_sql.open_cursor;
405: dbms_sql.parse( v_cursor, v_desc_sql, dbms_sql.native);
406: dbms_sql.bind_variable(v_cursor, 'seg_val' , x_seg_val );
407:
408: IF ( v_type <> 'F' ) THEN
409: dbms_sql.bind_variable(v_cursor, 'vset_id' , v_vsid );
410:

Line 409: dbms_sql.bind_variable(v_cursor, 'vset_id' , v_vsid );

405: dbms_sql.parse( v_cursor, v_desc_sql, dbms_sql.native);
406: dbms_sql.bind_variable(v_cursor, 'seg_val' , x_seg_val );
407:
408: IF ( v_type <> 'F' ) THEN
409: dbms_sql.bind_variable(v_cursor, 'vset_id' , v_vsid );
410:
411: END IF;
412:
413:

Line 414: dbms_sql.define_column(v_cursor ,1,seg_desc,1000);

410:
411: END IF;
412:
413:
414: dbms_sql.define_column(v_cursor ,1,seg_desc,1000);
415: v_return := dbms_sql.execute (v_cursor ) ;
416: v_return := dbms_sql.fetch_rows ( v_cursor );
417:
418: if v_return = 0 then

Line 415: v_return := dbms_sql.execute (v_cursor ) ;

411: END IF;
412:
413:
414: dbms_sql.define_column(v_cursor ,1,seg_desc,1000);
415: v_return := dbms_sql.execute (v_cursor ) ;
416: v_return := dbms_sql.fetch_rows ( v_cursor );
417:
418: if v_return = 0 then
419: raise no_data_found;

Line 416: v_return := dbms_sql.fetch_rows ( v_cursor );

412:
413:
414: dbms_sql.define_column(v_cursor ,1,seg_desc,1000);
415: v_return := dbms_sql.execute (v_cursor ) ;
416: v_return := dbms_sql.fetch_rows ( v_cursor );
417:
418: if v_return = 0 then
419: raise no_data_found;
420: end if;

Line 422: dbms_sql.column_value(v_cursor,1,seg_desc);

418: if v_return = 0 then
419: raise no_data_found;
420: end if;
421:
422: dbms_sql.column_value(v_cursor,1,seg_desc);
423:
424: /* EXECUTE IMMEDIATE v_desc_sql
425: INTO seg_desc
426: USING x_seg_val; */

Line 428: dbms_sql.close_cursor(v_cursor);

424: /* EXECUTE IMMEDIATE v_desc_sql
425: INTO seg_desc
426: USING x_seg_val; */
427:
428: dbms_sql.close_cursor(v_cursor);
429:
430: EXCEPTION
431: WHEN no_data_found THEN
432: dbms_sql.close_cursor(v_cursor);

Line 432: dbms_sql.close_cursor(v_cursor);

428: dbms_sql.close_cursor(v_cursor);
429:
430: EXCEPTION
431: WHEN no_data_found THEN
432: dbms_sql.close_cursor(v_cursor);
433: return (NULL);
434: WHEN OTHERS THEN
435: dbms_sql.close_cursor(v_cursor);
436: return (NULL);

Line 435: dbms_sql.close_cursor(v_cursor);

431: WHEN no_data_found THEN
432: dbms_sql.close_cursor(v_cursor);
433: return (NULL);
434: WHEN OTHERS THEN
435: dbms_sql.close_cursor(v_cursor);
436: return (NULL);
437: END;
438:
439: RETURN seg_desc;