The following lines contain the word 'select', 'insert', 'update' or 'delete':
2) Removed insert/delete into/from fnd_sessions
Changes to log_at... procedures
1) Replaced if-then-else checks for p_message
with nvl call
2) Removed local variable l_message
3) added local procedure set_location_trace
4) added call to set_location_hr_trace_internal
5) added lower() calls to set module names to
lower case
PZWALKER 24-AUG-2001 Added AOL Logging to set_location()
added following procedures for AOL logging:
log_at_statement_level()
log_at_procedure_level()
log_at_event_level()
log_at_exception_level()
log_at_error_level()
log_at_unexpected_level()
switch_logging_on()
switch_logging_off()
changed != to <>
NBRISTOW 18-JUL-2001 Added read_trace_table to improve PYUPIP
performance.
DKERR 24-SEP-1999 Call dbms_output.enable(1000000) if trace dest
set appropriately
DHARRIS 23-AUG-1999 115.12
Performance changes for set_location which
comprise of:
1) Added the following new PRIVATE global variables
g_trace_on, g_sl_x, g_sl_mess_text
2) Set the g_trace_on boolean trace indicator variable
to TRUE in private_trace_on.
3) Set the g_trace_on boolean trace indicator variable
to FALSE in trace_off.
4) The set_location procedure has been re-written for
performance:
- no local variables are initialised
- all global package variables are fully qualified
- the new sub-procedure set_location_trace is only
- called when trace is on.
TBATTOO 24-MAY-1999 changed chk_product_install to use hr_legislation_installations
MREID 18-MAY-1999 Added I to language code check for 11i
DKERR 13-MAY-1999 Replaced chr() with fnd_global.local_chr()
which is portable.
DKERR 12-May-1999 trace/set_location can use dbms_output.
scgrant 21-Apr-1999 Multi-radix changes.
DKERR 23-MAR-1999 Added set_trace_options and support for
writing to the rdbms trace file.
MREID 06-NOV-1998 Added language parameter to chk_product_install
DKERR 19-AUG-1998 523846: changed substr to substrb
DKERR 20-JUL-1998 Changes to trace to ensure compatiblity with NT
Added trace_udf to allow trace statements
to be added to formula.
MREID 02-JUL-1998 Change to chk_product_install - only accept
fully installed.
ACHAUHAN 17-OCT-1997 Changed the chk_product_install to check
the fnd_application table against the
application short name and not the application
name. If the product is passed as
'Oracle Payroll' then the application short
name is formed as 'PAY'.
D Kerr 22-SEP-1997 Fix to get_message to ensure it works in
the same way as R10. ie calling it still leaves
the message on the FND message stack.
D Kerr 27-JUL-1997 R11 changes.
WARNING : Not compatible with R10
Removed most of the code from message routines as it
was either accessing obsoleted tables or was non NLS compliant
or both. The code now uses FND_MESSAGE routines rather than
accessing tables directly. Package globals are still maintained
for use in get_message and get_message_details.
Removed : show_error, get_token_details.
110.1 10-JUL-1997 M.J.Hoyes Bug 513048. Switched the cursors in the
10.7 version 40.14 set_message procedure to validate against
fnd_new_messages and then fnd_messages
rather than vice versa. Re coded the
set message token procedure to use cursors
rather than PLSQL blocks and switched the
first table to drive off to fnd_new_messages.
K Mundair 02-JUN-1997 Added procedure chk_product_install
D Kerr 29-Nov-1996 New trace functionality
1. trace_on now takes a parameter which can
be used to give an alternative name to
the pipe.
2. read_trace_pipe routine moves the pipe
handling code from PYUPIP to this package.
T Mathers 18-Aug-1996 Changed message and message token code
to use fnd_new_messages id there is no row
in fnd_messages. Behave as normal if not in
both.
D Kerr 08-Jul-1996 Set a message in the case of pipe timeout
D Kerr 03-Jul-1996 Added timeout parameter to send_message calls
in trace and set_location.
D Harris 24-Jun-1995 merged trace with set_location to improve
performance.
T Mathers 28-Jun-1995 Added joins to fnd_current_language_view
for fnd_messages cursor in set_message
and set_message_token. WWBUG#288067
D Harris 22-Jun-1995 Increased g_message_text from 240 to
2048 (max length required for use
in dbms_standard.raise_application_error).
P Gowers 28-NOV-1994 G1682: Always call fnd_message.set_name()
D Harris 07-OCT-1994 Increment length of set_location pipe
details from 40 to 72.
D Harris 16-SEP-1993 Changes made for 10x compatibility for
forms 4 and aol api's.
P Gowers 04-MAY-1993 Handle hint messages in set_message
P Gowers 05-APR-1993 Add get_message_details, get_token_details
P Gowers 02-MAR-1993 Add set_message_token which translates token
P Gowers 20-JAN-1993 Big bang.
Sathkris 12-DEC-2008 Added get_icx_val function
*/
--
-- Private Package variables
--
g_warning_flag boolean default FALSE;
select p.pid
from v$process p,
v$session s
where s.paddr = p.addr
and s.audsid = userenv('sessionid');
select 'PIPE' || userenv('sessionid')
into g_pipe_session
from dual;
fnd_insert
DESCRIPTION
Inserts a row into FND_SESSIONS for the date passed for the current
session id
*/
procedure fnd_insert (l_effective_date in date) is
begin
insert into fnd_sessions (session_id, effective_date)
values (userenv('SESSIONID'), trunc(l_effective_date));
end fnd_insert;
select 1
from v$session
where audsid = replace(p_pipename,'PIPE')
and status <> 'KILLED' ;
select 1
from v$session
where audsid = replace(p_pipename,'PIPE')
and status <> 'KILLED' ;
l_rettab.delete;
select 'x'
into v_chk
from hr_legislation_installations
where l_short_name=application_short_name
and nvl(p_legislation,'x')=nvl(legislation_code,'x')
and (status='I' or action is not NULL);
select usr.user_id
from fnd_user usr
where usr.user_name = 'SYSADMIN';
select fur.responsibility_id, fur.responsibility_application_id
from fnd_user_resp_groups fur
where fur.user_id = p_user_id
order by fur.responsibility_id;
select resp.application_id
from fnd_responsibility resp
where resp.responsibility_id = p_resp_id;
select usr.user_id
from fnd_user usr
where usr.user_name = 'SYSADMIN';
select fur.responsibility_id, fur.responsibility_application_id
from fnd_user_resp_groups fur
where fur.user_id = p_user_id
order by fur.responsibility_id;
select resp.application_id
from fnd_responsibility resp
where resp.responsibility_id = p_resp_id;
SELECT value
FROM icx_session_attributes
WHERE session_id = p_sess_id
AND name = p_att_name;