Search from 700 + Posts

Mar 8, 2011

fnd_global.apps_initialize (in Oracle 11i)

Below is sample script to set the context (in order to use the views like or_order_lines, oe_order_headers,po_lines,pl_headers etc), and then Verify if the context is set properly or not.

 declare
l_security_group_id  NUMBER:=NULL;
l_server_id            NUMBER:=NULL;
a varchar2(1000);
begin
apps.fnd_global.apps_initialize (
 user_id => 1318,
 resp_id => 21623,
 resp_appl_id => 660,
 security_group_id => l_security_group_id,
 server_id => l_server_id);
Select SUBSTRB(SYS_CONTEXT('USERENV','CLIENT_INFO'),1,10)
into a
from dual;

dbms_output.put_line('a  = '||a);
end;

No comments:

Post a Comment