APPS.HR_UTILITY dependencies on DBMS_SQL

Line 489: --optionally installed need to use DBMS_SQL

485: procedure private_trace_on(trace_mode in varchar2 default null,
486: session_identifier in varchar2 default null ) is
487:
488: --Retrieves the session_id value from ICX_SESSIONS. As web server is only
489: --optionally installed need to use DBMS_SQL
490: function get_web_id return number is
491: l_cursor integer;
492: l_retval varchar2(40) := 'NULL'; -- Need to initialize
493: l_ignore number ;

Line 496: l_cursor := dbms_sql.open_cursor ;

492: l_retval varchar2(40) := 'NULL'; -- Need to initialize
493: l_ignore number ;
494: begin
495:
496: l_cursor := dbms_sql.open_cursor ;
497: dbms_sql.parse(l_cursor,
498: 'begin :retval := icx_sec.getID(icx_sec.pv_session_id);end;',
499: dbms_sql.v7);
500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);

Line 497: dbms_sql.parse(l_cursor,

493: l_ignore number ;
494: begin
495:
496: l_cursor := dbms_sql.open_cursor ;
497: dbms_sql.parse(l_cursor,
498: 'begin :retval := icx_sec.getID(icx_sec.pv_session_id);end;',
499: dbms_sql.v7);
500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);
501: l_ignore := dbms_sql.execute(l_cursor);

Line 499: dbms_sql.v7);

495:
496: l_cursor := dbms_sql.open_cursor ;
497: dbms_sql.parse(l_cursor,
498: 'begin :retval := icx_sec.getID(icx_sec.pv_session_id);end;',
499: dbms_sql.v7);
500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);
501: l_ignore := dbms_sql.execute(l_cursor);
502: dbms_sql.variable_value(l_cursor,':retval' , l_retval ) ;
503:

Line 500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);

496: l_cursor := dbms_sql.open_cursor ;
497: dbms_sql.parse(l_cursor,
498: 'begin :retval := icx_sec.getID(icx_sec.pv_session_id);end;',
499: dbms_sql.v7);
500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);
501: l_ignore := dbms_sql.execute(l_cursor);
502: dbms_sql.variable_value(l_cursor,':retval' , l_retval ) ;
503:
504: return( fnd_number.canonical_to_number(l_retval) ) ;

Line 501: l_ignore := dbms_sql.execute(l_cursor);

497: dbms_sql.parse(l_cursor,
498: 'begin :retval := icx_sec.getID(icx_sec.pv_session_id);end;',
499: dbms_sql.v7);
500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);
501: l_ignore := dbms_sql.execute(l_cursor);
502: dbms_sql.variable_value(l_cursor,':retval' , l_retval ) ;
503:
504: return( fnd_number.canonical_to_number(l_retval) ) ;
505:

Line 502: dbms_sql.variable_value(l_cursor,':retval' , l_retval ) ;

498: 'begin :retval := icx_sec.getID(icx_sec.pv_session_id);end;',
499: dbms_sql.v7);
500: dbms_sql.bind_variable(l_cursor,':retval',l_retval);
501: l_ignore := dbms_sql.execute(l_cursor);
502: dbms_sql.variable_value(l_cursor,':retval' , l_retval ) ;
503:
504: return( fnd_number.canonical_to_number(l_retval) ) ;
505:
506: end get_web_id ;