eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HR_SSO_UTL

Source


1 package hr_sso_utl as
2 /* $Header: hrssoutl.pkh 120.0 2005/05/31 02:55:47 appldev noship $ */
3 
4 FUNCTION get_sso_schema RETURN VARCHAR2;
5 
6 FUNCTION get_sso_query_path
7   (
8   p_url      IN VARCHAR2,
9   p_schema   IN VARCHAR2 DEFAULT get_sso_schema
10   ) RETURN VARCHAR2;
11 
12 FUNCTION encrypt_ps_password
13   (
14   p_password IN VARCHAR2
15   ) RETURN VARCHAR2;
16 
17 FUNCTION decrypt_ps_password
18   (
19   p_password IN VARCHAR2
20   ) RETURN VARCHAR2;
21 
22 FUNCTION encrypt_ps_username
23   (
24   p_username IN VARCHAR2
25   ) RETURN VARCHAR2;
26 
27 FUNCTION decrypt_ps_username
28   (
29   p_username IN VARCHAR2
30   ) RETURN VARCHAR2;
31 
32 FUNCTION get_user RETURN VARCHAR2;
33 
34 PROCEDURE pstore_add_application
35   (
36   P_APPNAME    IN  VARCHAR2,
37   P_APPTYPE    IN  VARCHAR2,
38   P_APPURL     IN  VARCHAR2,
39   P_LOGOUT_URL IN  VARCHAR2,
40   P_USERFLD    IN  VARCHAR2,
41   P_PWDFLD     IN  VARCHAR2,
42   P_AUTHUSED   IN  VARCHAR2,
43   P_FNAME1     IN  VARCHAR2 DEFAULT NULL,
44   P_FVAL1      IN  VARCHAR2 DEFAULT NULL,
45   P_FNAME2     IN  VARCHAR2 DEFAULT NULL,
46   P_FVAL2      IN  VARCHAR2 DEFAULT NULL,
47   P_FNAME3     IN  VARCHAR2 DEFAULT NULL,
48   P_FVAL3      IN  VARCHAR2 DEFAULT NULL,
49   P_FNAME4     IN  VARCHAR2 DEFAULT NULL,
50   P_FVAL4      IN  VARCHAR2 DEFAULT NULL,
51   P_FNAME5     IN  VARCHAR2 DEFAULT NULL,
52   P_FVAL5      IN  VARCHAR2 DEFAULT NULL,
53   P_FNAME6     IN  VARCHAR2 DEFAULT NULL,
54   P_FVAL6      IN  VARCHAR2 DEFAULT NULL,
55   P_FNAME7     IN  VARCHAR2 DEFAULT NULL,
56   P_FVAL7      IN  VARCHAR2 DEFAULT NULL,
57   P_FNAME8     IN  VARCHAR2 DEFAULT NULL,
58   P_FVAL8      IN  VARCHAR2 DEFAULT NULL,
59   P_FNAME9     IN  VARCHAR2 DEFAULT NULL,
60   P_FVAL9      IN  VARCHAR2 DEFAULT NULL,
61   P_APPID      OUT NOCOPY VARCHAR2
62   );
63 
64 PROCEDURE pstore_modify_app_info
65   (
66   P_APPID      IN  VARCHAR2,
67   P_APP_NAME   IN  VARCHAR2,
68   P_APPTYPE    IN  VARCHAR2,
69   P_APPURL     IN  VARCHAR2,
70   P_LOGOUT_URL IN  VARCHAR2,
71   P_USERFIELD  IN  VARCHAR2,
72   P_PWDFIELD   IN  VARCHAR2,
73   P_AUTHNEEDED IN  VARCHAR2,
74   P_FNAME1     IN  VARCHAR2 DEFAULT NULL,
75   P_FVAL1      IN  VARCHAR2 DEFAULT NULL,
76   P_FNAME2     IN  VARCHAR2 DEFAULT NULL,
77   P_FVAL2      IN  VARCHAR2 DEFAULT NULL,
78   P_FNAME3     IN  VARCHAR2 DEFAULT NULL,
79   P_FVAL3      IN  VARCHAR2 DEFAULT NULL,
80   P_FNAME4     IN  VARCHAR2 DEFAULT NULL,
81   P_FVAL4      IN  VARCHAR2 DEFAULT NULL,
82   P_FNAME5     IN  VARCHAR2 DEFAULT NULL,
83   P_FVAL5      IN  VARCHAR2 DEFAULT NULL,
84   P_FNAME6     IN  VARCHAR2 DEFAULT NULL,
85   P_FVAL6      IN  VARCHAR2 DEFAULT NULL,
86   P_FNAME7     IN  VARCHAR2 DEFAULT NULL,
87   P_FVAL7      IN  VARCHAR2 DEFAULT NULL,
88   P_FNAME8     IN  VARCHAR2 DEFAULT NULL,
89   P_FVAL8      IN  VARCHAR2 DEFAULT NULL,
90   P_FNAME9     IN  VARCHAR2 DEFAULT NULL,
91   P_FVAL9      IN  VARCHAR2 DEFAULT NULL
92   );
93 
94 PROCEDURE pstore_get_app_info
95   (
96   P_APPID      IN  VARCHAR2,
97   P_APP_NAME   OUT NOCOPY VARCHAR2,
98   P_APPTYPE    OUT NOCOPY VARCHAR2,
99   P_APPURL     OUT NOCOPY VARCHAR2,
100   P_LOGOUT_URL OUT NOCOPY VARCHAR2,
101   P_USERFIELD  OUT NOCOPY VARCHAR2,
102   P_PWDFIELD   OUT NOCOPY VARCHAR2,
103   P_AUTHNEEDED OUT NOCOPY VARCHAR2,
104   P_FNAME1     OUT NOCOPY VARCHAR2,
105   P_FVAL1      OUT NOCOPY VARCHAR2,
106   P_FNAME2     OUT NOCOPY VARCHAR2,
107   P_FVAL2      OUT NOCOPY VARCHAR2,
108   P_FNAME3     OUT NOCOPY VARCHAR2,
109   P_FVAL3      OUT NOCOPY VARCHAR2,
110   P_FNAME4     OUT NOCOPY VARCHAR2,
111   P_FVAL4      OUT NOCOPY VARCHAR2,
112   P_FNAME5     OUT NOCOPY VARCHAR2,
113   P_FVAL5      OUT NOCOPY VARCHAR2,
114   P_FNAME6     OUT NOCOPY VARCHAR2,
115   P_FVAL6      OUT NOCOPY VARCHAR2,
116   P_FNAME7     OUT NOCOPY VARCHAR2,
117   P_FVAL7      OUT NOCOPY VARCHAR2,
118   P_FNAME8     OUT NOCOPY VARCHAR2,
119   P_FVAL8      OUT NOCOPY VARCHAR2,
120   P_FNAME9     OUT NOCOPY VARCHAR2,
121   P_FVAL9      OUT NOCOPY VARCHAR2
122   );
123 
124 PROCEDURE pstore_add_userinfo
125   (
126   P_APP_ID     IN  VARCHAR2,
127   P_SSOUSER    IN  VARCHAR2,
128   P_APP_USER   IN  VARCHAR2,
129   P_APP_PWD    IN  VARCHAR2,
130   P_FNAME1     IN  VARCHAR2 DEFAULT NULL,
131   P_FVAL1      IN  VARCHAR2 DEFAULT NULL,
132   P_FNAME2     IN  VARCHAR2 DEFAULT NULL,
133   P_FVAL2      IN  VARCHAR2 DEFAULT NULL,
134   P_FNAME3     IN  VARCHAR2 DEFAULT NULL,
135   P_FVAL3      IN  VARCHAR2 DEFAULT NULL,
136   P_FNAME4     IN  VARCHAR2 DEFAULT NULL,
137   P_FVAL4      IN  VARCHAR2 DEFAULT NULL,
138   P_FNAME5     IN  VARCHAR2 DEFAULT NULL,
139   P_FVAL5      IN  VARCHAR2 DEFAULT NULL,
140   P_FNAME6     IN  VARCHAR2 DEFAULT NULL,
141   P_FVAL6      IN  VARCHAR2 DEFAULT NULL,
142   P_FNAME7     IN  VARCHAR2 DEFAULT NULL,
143   P_FVAL7      IN  VARCHAR2 DEFAULT NULL,
144   P_FNAME8     IN  VARCHAR2 DEFAULT NULL,
145   P_FVAL8      IN  VARCHAR2 DEFAULT NULL,
146   P_FNAME9     IN  VARCHAR2 DEFAULT NULL,
147   P_FVAL9      IN  VARCHAR2 DEFAULT NULL,
148   P_USER_PREFS IN  VARCHAR2
149   );
150 
151 PROCEDURE pstore_modify_userinfo
152   (
153   P_APP_ID     IN  VARCHAR2,
154   P_SSOUSER    IN  VARCHAR2,
155   P_APP_USER   IN  VARCHAR2,
156   P_APP_PWD    IN  VARCHAR2,
157   P_FNAME1     IN  VARCHAR2 DEFAULT NULL,
158   P_FVAL1      IN  VARCHAR2 DEFAULT NULL,
159   P_FNAME2     IN  VARCHAR2 DEFAULT NULL,
160   P_FVAL2      IN  VARCHAR2 DEFAULT NULL,
161   P_FNAME3     IN  VARCHAR2 DEFAULT NULL,
162   P_FVAL3      IN  VARCHAR2 DEFAULT NULL,
163   P_FNAME4     IN  VARCHAR2 DEFAULT NULL,
164   P_FVAL4      IN  VARCHAR2 DEFAULT NULL,
165   P_FNAME5     IN  VARCHAR2 DEFAULT NULL,
166   P_FVAL5      IN  VARCHAR2 DEFAULT NULL,
167   P_FNAME6     IN  VARCHAR2 DEFAULT NULL,
168   P_FVAL6      IN  VARCHAR2 DEFAULT NULL,
169   P_FNAME7     IN  VARCHAR2 DEFAULT NULL,
170   P_FVAL7      IN  VARCHAR2 DEFAULT NULL,
171   P_FNAME8     IN  VARCHAR2 DEFAULT NULL,
172   P_FVAL8      IN  VARCHAR2 DEFAULT NULL,
173   P_FNAME9     IN  VARCHAR2 DEFAULT NULL,
174   P_FVAL9      IN  VARCHAR2 DEFAULT NULL,
175   P_USER_PREFS IN  VARCHAR2
176   );
177 
178 PROCEDURE pstore_get_userinfo
179   (
180   P_APP_ID     IN  VARCHAR2,
181   P_SSOUSER    IN  VARCHAR2,
182   P_APP_USER   OUT NOCOPY VARCHAR2,
183   P_APP_PWD    OUT NOCOPY VARCHAR2,
184   P_FNAME1     OUT NOCOPY VARCHAR2,
185   P_FVAL1      OUT NOCOPY VARCHAR2,
186   P_FNAME2     OUT NOCOPY VARCHAR2,
187   P_FVAL2      OUT NOCOPY VARCHAR2,
188   P_FNAME3     OUT NOCOPY VARCHAR2,
189   P_FVAL3      OUT NOCOPY VARCHAR2,
190   P_FNAME4     OUT NOCOPY VARCHAR2,
191   P_FVAL4      OUT NOCOPY VARCHAR2,
192   P_FNAME5     OUT NOCOPY VARCHAR2,
193   P_FVAL5      OUT NOCOPY VARCHAR2,
194   P_FNAME6     OUT NOCOPY VARCHAR2,
195   P_FVAL6      OUT NOCOPY VARCHAR2,
196   P_FNAME7     OUT NOCOPY VARCHAR2,
197   P_FVAL7      OUT NOCOPY VARCHAR2,
198   P_FNAME8     OUT NOCOPY VARCHAR2,
199   P_FVAL8      OUT NOCOPY VARCHAR2,
200   P_FNAME9     OUT NOCOPY VARCHAR2,
201   P_FVAL9      OUT NOCOPY VARCHAR2,
202   P_USER_PREFS OUT NOCOPY VARCHAR2
203   );
204 
205 PROCEDURE delete_application(
206   p_appid IN  VARCHAR2
207 , p_error OUT NOCOPY NUMBER
208 );
209 
210 END hr_sso_utl;