1 package hr_util_web AUTHID CURRENT_USER as
2 /* $Header: hrutlweb.pkh 120.1.12000000.1 2007/01/21 19:19:33 appldev ship $ */
3 --
4 -- We don't normally need to specify the host and agent since netscape
5 -- will work with relative paths. The one place where it's needed is in
6 -- workflow when launching html from email attachments. Then the host
7 -- and agent are not set up for you. Use hr_offer_custom.g_owa2 in these
8 -- cases.
9 --
10 g_owa varchar2(2000) := null;
11
12 TYPE g_varchar2_tab_type IS TABLE OF varchar2(2000) INDEX BY BINARY_INTEGER;
13 -- Use this when the routine raising the error has completely handled
14 -- the situation.
15 g_error_handled exception;
16 --
17 -- Default Varchar2 PL/SQL Table
18 --
19 --
20 -- ------------------------------------------------------------------------
21 -- |---------------------< prepare_parameter >-----------------------------|
22 -- ------------------------------------------------------------------------
23 --
24 -- Description:
25 -- This procedure takes in a parameter and makes it URL ready by changing
26 -- spaces to '+' and placing a '&' at the front of the parmameter name
27 -- when p_prefix is true (the parameter is not first in the list).
28 --
29 -- Pre Conditions:
30 --
31 -- In Arguments:
32 -- Name Reqd Type Description
33 -- p_name Yes varchar2 Parameter name
34 -- p_value Yes varchar2 Parameter value
35 -- p_prefix No boolean Set to false if the paramenter is the
36 -- first parm to be used in the URL. If
37 -- p_prefix is true, an '&' will be placed
38 -- at the front of the parm.
39 --
40 -- Post Success:
41 -- Returns the parameter in a varchar2.
42 --
43 -- Post Failure:
44 -- This procedure should never fail.
45 --
46 -- Developer Implementation Notes:
47 --
48 -- Access Status:
49 --
50 -- -----------------------------------------------------------------------------
51 function prepare_parameter
52 (p_name in varchar2
53 ,p_value in varchar2
54 ,p_prefix in boolean default true) return varchar2;
55
56
57 -- -------------------------------------------------------------------------
58 -- |---------------------------< proxyforURL >-----------------------------|
59 -- -------------------------------------------------------------------------
60 -- Returns the possibly null proxy string based on configuration stored
61 -- in profile options
62 --
63 function proxyforURL(p_url in varchar2) return varchar2 ;
64 end hr_util_web;