1 PACKAGE BODY fnd_proxy_util AS
2 /* $Header: AFPRXUTB.pls 120.1 2005/07/02 04:13:56 appldev noship $ */
3 -- Internal Constants
4 c_wp_svc constant VARCHAR2(32) := 'WEB_PROXY';
5 c_wp_un constant VARCHAR2(32) := 'USERNAME';
6 c_wp_pw constant VARCHAR2(32) := 'PASSWORD';
7
8 -- GET the Web Proxy Username
9
10 FUNCTION get_web_proxy_username RETURN VARCHAR2
11 IS
12 BEGIN
13 return fnd_vault.get(c_wp_svc, c_wp_un);
14 END get_web_proxy_username;
15
16 -- GET the Web Proxy Password
17
18 FUNCTION get_web_proxy_pw RETURN VARCHAR2
19 IS
20 BEGIN
21 return fnd_vault.get(c_wp_svc, c_wp_pw);
22 END get_web_proxy_pw;
23
24
25 -- PUT the Web Proxy Username
26
27 PROCEDURE put_web_proxy_username(p_val IN VARCHAR2)
28 IS
29 BEGIN
30 fnd_vault.put(c_wp_svc, c_wp_un, p_val);
31 END put_web_proxy_username;
32
33 -- PUT the Web Proxy Password
34
35 PROCEDURE put_web_proxy_pw(p_val IN VARCHAR2)
36 IS
37 BEGIN
38 fnd_vault.put(c_wp_svc, c_wp_pw, p_val);
39 END put_web_proxy_pw;
40
41
42 -- DELete the Web Proxy Username
43
44 PROCEDURE del_web_proxy_username
45 IS
46 BEGIN
47 fnd_vault.del(c_wp_svc, c_wp_un);
48 END del_web_proxy_username;
49
50 -- DELete the Web Proxy Password
51
52 PROCEDURE del_web_proxy_pw
53 IS
54 BEGIN
55 fnd_vault.del(c_wp_svc, c_wp_pw);
56 END del_web_proxy_pw;
57
58 END;