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