REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \ REM dbdrv: checkfile:~PROD:~PATH:~FILE /*=======================================================================+ | Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA| | All rights reserved. | +=======================================================================+ | FILENAME | wffrmb.pls | DESCRIPTION | PL/SQL body for package: WF_FORMS *=======================================================================*/ SET VERIFY OFF WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; set arraysize 1 set scan off create or replace package body WF_FORMS as /* $Header: wffrmb.pls 26.13 2002/11/11 05:09:38 rosthoma ship $ */ -- -- Applet -- Generate the applet tag for WFForms -- IN -- fname - form function with format 'func1:PARAM1="&ID" PARAM2="&NAME"' -- port - port listened by the socket listener -- codebase - where the java classes can be located -- code - name for the class -- archive - first looks for java classes at this archive -- -- OUT -- status - true if is permitted to launch, false otherwise -- procedure Applet(fname in varchar2, dispname in varchar2 , port in varchar2 , codebase in varchar2 , code in varchar2 , archive in varchar2 , status out boolean) is l_func varchar2(240); l_colon pls_integer; begin l_colon := instr(fname, ':'); if (l_colon <> 0) then l_func := substr(fname, 1, l_colon - 1); else l_func := fname; end if; if (Fnd_Function.Test(l_func)) then htp.p(''|| ''||
          dispname||''); status := TRUE; else htp.p(''); status := FALSE; end if; exception when others then status := FALSE; wf_core.context('Wf_Forms', 'Applet', fname, port); raise; end Applet; -- -- AppletWindow -- Generate the applet window to call up a form -- IN -- fname - form function with format 'func1:PARAM1="&ID" PARAM2="&NAME"' -- port - port listened by the socket listener -- codebase - where the java classes can be located -- code - name for the class -- archive - first looks for java classes at this archive -- procedure AppletWindow(fname in varchar2, port in varchar2 , codebase in varchar2 , code in varchar2, archive in varchar2 ) is l_archive varchar2(2000) := Wf_Forms.java_loc|| 'oracle/apps/fnd/jar/wffrm.jar,'|| Wf_Forms.java_loc||'oracle/apps/fnd/jar/fndewt.jar,'|| Wf_Forms.java_loc||'oracle/apps/fnd/jar/fndswing.jar,'|| Wf_Forms.java_loc||'oracle/apps/fnd/jar/fndbalishare.jar'; l_func varchar2(240); l_colon pls_integer; l_ie_plugin_ver varchar2(80); -- IE version is delimited by ',' begin if (archive is not null) then l_archive := archive; end if; l_colon := instr(fname, ':'); if (l_colon <> 0) then l_func := substr(fname, 1, l_colon - 1); else l_func := fname; end if; htp.p(''); htp.p(''); htp.p(''||wf_core.translate('WFFRM_LAUNCHING')||''); htp.p(''); htp.p(''); htp.p(''); htp.p(''); htp.p(''); -- ### maybe we need to make the window closing time a configurable -- ### parameter in the future htp.p(''); htp.p('