[Home] [Help]
PACKAGE: APPS.PON_USER_PROFILE_PKG
Source
1 PACKAGE PON_USER_PROFILE_PKG AUTHID CURRENT_USER as
2 /*$Header: PONUSPRS.pls 120.5 2006/03/31 05:50:28 rpatel noship $ */
3
4 --This ref cursor type is used for any cursors we need to pass out
5 --to Java. Namely addresses and all the subset preference stuff:
6 --payment methods, credit card types, payment terms, carrier,
7 --freight terms, fob.
8 type refCurTyp is Ref Cursor;
9
10 UPDATE_SUPPLIER_CONTACT_E EXCEPTION;
11
12
13 procedure update_user_lang(
14 p_username IN VARCHAR2
15 , p_user_language IN VARCHAR2
16 , x_status OUT NOCOPY VARCHAR2
17 , x_exception_msg OUT NOCOPY VARCHAR2
18 );
19
20 procedure update_user_info(
21 p_username IN VARCHAR2
22 , P_USER_NAME_PREFIX IN VARCHAR2
23 , P_USER_NAME_F IN VARCHAR2
24 , P_USER_NAME_M IN VARCHAR2
25 , P_USER_NAME_L IN VARCHAR2
26 , P_USER_NAME_SUFFIX IN VARCHAR2
27 , P_USER_TITLE IN VARCHAR2
28 , P_USER_EMAIL IN VARCHAR2
29 , P_USER_COUNTRY_CODE IN VARCHAR2
30 , P_USER_AREA_CODE IN VARCHAR2
31 , P_USER_PHONE IN VARCHAR2
32 , P_USER_EXTENSION IN VARCHAR2
33 , P_USER_FAX_COUNTRY_CODE IN VARCHAR2
34 , P_USER_FAX_AREA_CODE IN VARCHAR2
35 , P_USER_FAX IN VARCHAR2
36 , P_USER_FAX_EXTENSION IN VARCHAR2
37 , P_USER_TIMEZONE IN VARCHAR2
38 , P_USER_LANGUAGE IN VARCHAR2
39 , P_USER_DATEFORMAT IN VARCHAR2
40 , P_USER_LOCALE IN VARCHAR2
41 , P_USER_ENCODINGOPTION IN VARCHAR2
42 , x_status OUT NOCOPY VARCHAR2
43 , x_exception_msg OUT NOCOPY VARCHAR2
44 );
45
46
47 procedure retrieve_vendor_user_info(
48 p_username IN VARCHAR2
49 , x_user_party_id OUT NOCOPY NUMBER
50 , X_USER_NAME_PREFIX OUT NOCOPY VARCHAR2
51 , X_USER_NAME_F OUT NOCOPY VARCHAR2
52 , X_USER_NAME_M OUT NOCOPY VARCHAR2
53 , X_USER_NAME_L OUT NOCOPY VARCHAR2
54 , X_USER_NAME_SUFFIX OUT NOCOPY VARCHAR2
55 , X_USER_TITLE OUT NOCOPY VARCHAR2
56 , X_USER_EMAIL OUT NOCOPY VARCHAR2
57 , X_USER_COUNTRY_CODE OUT NOCOPY VARCHAR2
58 , X_USER_AREA_CODE OUT NOCOPY VARCHAR2
59 , X_USER_PHONE OUT NOCOPY VARCHAR2
60 , X_USER_EXTENSION OUT NOCOPY VARCHAR2
61 , X_USER_FAX_COUNTRY_CODE OUT NOCOPY VARCHAR2
62 , X_USER_FAX_AREA_CODE OUT NOCOPY VARCHAR2
63 , X_USER_FAX OUT NOCOPY VARCHAR2
64 , X_USER_FAX_EXTENSION OUT NOCOPY VARCHAR2
65 , X_USER_ENCODINGOPTION OUT NOCOPY VARCHAR2
66 , x_status OUT NOCOPY VARCHAR2
67 , x_exception_msg OUT NOCOPY VARCHAR2
68 );
69
70 procedure retrieve_enterprise_user_info(
71 p_username IN VARCHAR2
72 , x_user_party_id OUT NOCOPY NUMBER
73 , X_USER_NAME_PREFIX OUT NOCOPY VARCHAR2
74 , X_USER_NAME_F OUT NOCOPY VARCHAR2
75 , X_USER_NAME_M OUT NOCOPY VARCHAR2
76 , X_USER_NAME_L OUT NOCOPY VARCHAR2
77 , X_USER_NAME_SUFFIX OUT NOCOPY VARCHAR2
78 , X_USER_TITLE OUT NOCOPY VARCHAR2
79 , X_USER_EMAIL OUT NOCOPY VARCHAR2
80 , X_USER_COUNTRY_CODE OUT NOCOPY VARCHAR2
81 , X_USER_AREA_CODE OUT NOCOPY VARCHAR2
82 , X_USER_PHONE OUT NOCOPY VARCHAR2
83 , X_USER_EXTENSION OUT NOCOPY VARCHAR2
84 , X_USER_FAX_COUNTRY_CODE OUT NOCOPY VARCHAR2
85 , X_USER_FAX_AREA_CODE OUT NOCOPY VARCHAR2
86 , X_USER_FAX OUT NOCOPY VARCHAR2
87 , X_USER_FAX_EXTENSION OUT NOCOPY VARCHAR2
88 , X_USER_ENCODINGOPTION OUT NOCOPY VARCHAR2
89 , x_status OUT NOCOPY VARCHAR2
90 , x_exception_msg OUT NOCOPY VARCHAR2
91 );
92
93 procedure retrieve_user_info(
94 p_username IN VARCHAR2
95 , x_user_party_id OUT NOCOPY NUMBER
96 , X_USER_NAME_PREFIX OUT NOCOPY VARCHAR2
97 , X_USER_NAME_F OUT NOCOPY VARCHAR2
98 , X_USER_NAME_M OUT NOCOPY VARCHAR2
99 , X_USER_NAME_L OUT NOCOPY VARCHAR2
100 , X_USER_NAME_SUFFIX OUT NOCOPY VARCHAR2
101 , X_USER_TITLE OUT NOCOPY VARCHAR2
102 , X_USER_EMAIL OUT NOCOPY VARCHAR2
103 , X_USER_COUNTRY_CODE OUT NOCOPY VARCHAR2
104 , X_USER_AREA_CODE OUT NOCOPY VARCHAR2
105 , X_USER_PHONE OUT NOCOPY VARCHAR2
106 , X_USER_EXTENSION OUT NOCOPY VARCHAR2
107 , X_USER_FAX_COUNTRY_CODE OUT NOCOPY VARCHAR2
108 , X_USER_FAX_AREA_CODE OUT NOCOPY VARCHAR2
109 , X_USER_FAX OUT NOCOPY VARCHAR2
110 , X_USER_FAX_EXTENSION OUT NOCOPY VARCHAR2
111 , X_USER_TIMEZONE OUT NOCOPY VARCHAR2
112 , X_USER_DEFAULT_LANGUAGE OUT NOCOPY VARCHAR2
113 , X_USER_DEFAULT_DATEFORMAT OUT NOCOPY VARCHAR2
114 , X_USER_LOCALE OUT NOCOPY VARCHAR2
115 , X_USER_ENCODINGOPTION OUT NOCOPY VARCHAR2
116 , x_status OUT NOCOPY VARCHAR2
117 , x_exception_msg OUT NOCOPY VARCHAR2
118 );
119
120 procedure change_password(
121 p_username IN VARCHAR2
122 , p_new_password IN VARCHAR2
123 , x_status OUT NOCOPY VARCHAR2
124 , x_exception_msg OUT NOCOPY VARCHAR2
125 );
126
127 procedure login(
128 p_username IN VARCHAR2
129 , p_change_password OUT NOCOPY VARCHAR2
130 , x_status OUT NOCOPY VARCHAR2
131 , x_exception_msg OUT NOCOPY VARCHAR2
132 );
133
134
135 PROCEDURE delete_user(
136 p_username IN VARCHAR2
137 , x_status OUT NOCOPY VARCHAR2
138 , x_exception_msg OUT NOCOPY VARCHAR2
139 );
140
141 procedure retrieve_pwd_challenge(
142 p_user_party_id IN NUMBER
143 , X_USER_PWD_QUESTION OUT NOCOPY VARCHAR2
144 , X_USER_PWD_RESPONSE OUT NOCOPY VARCHAR2
145 , x_status OUT NOCOPY VARCHAR2
146 , x_exception_msg OUT NOCOPY VARCHAR2
147 , x_enc_foundation OUT NOCOPY VARCHAR2
148 );
149
150 procedure update_pwd_challenge(
151 p_user_party_id IN NUMBER
152 , P_USER_PWD_QUESTION IN VARCHAR2
153 , P_USER_PWD_RESPONSE IN VARCHAR2
154 , p_enc_foundation IN VARCHAR2
155 , x_status OUT NOCOPY VARCHAR2
156 , x_exception_msg OUT NOCOPY VARCHAR2
157 );
158
159 procedure retrieve_user_data(
160 p_username IN VARCHAR2
161 , x_user_party_id OUT NOCOPY NUMBER
162 , X_USER_NAME_PREFIX OUT NOCOPY VARCHAR2
163 , X_USER_NAME_F OUT NOCOPY VARCHAR2
164 , X_USER_NAME_M OUT NOCOPY VARCHAR2
165 , X_USER_NAME_L OUT NOCOPY VARCHAR2
166 , X_USER_NAME_SUFFIX OUT NOCOPY VARCHAR2
167 , X_USER_TITLE OUT NOCOPY VARCHAR2
168 , X_USER_EMAIL OUT NOCOPY VARCHAR2
169 , X_USER_COUNTRY_CODE OUT NOCOPY VARCHAR2
170 , X_USER_AREA_CODE OUT NOCOPY VARCHAR2
171 , X_USER_PHONE OUT NOCOPY VARCHAR2
172 , X_USER_EXTENSION OUT NOCOPY VARCHAR2
173 , X_USER_FAX_COUNTRY_CODE OUT NOCOPY VARCHAR2
174 , X_USER_FAX_AREA_CODE OUT NOCOPY VARCHAR2
175 , X_USER_FAX OUT NOCOPY VARCHAR2
176 , X_USER_FAX_EXTENSION OUT NOCOPY VARCHAR2
177 , X_USER_ENCODINGOPTION OUT NOCOPY VARCHAR2
178 , X_DUMMY_DATA OUT NOCOPY VARCHAR2
179 , X_EXTRA_INFO OUT NOCOPY VARCHAR2
180 , X_ROW_IN_HR OUT NOCOPY VARCHAR2
181 , X_VENDOR_RELATIONSHIP OUT NOCOPY VARCHAR2
182 , X_ENTERPRISE_RELATIONSHIP OUT NOCOPY VARCHAR2
183 , x_status OUT NOCOPY VARCHAR2
184 , x_exception_msg OUT NOCOPY VARCHAR2
185 );
186
187 END PON_USER_PROFILE_PKG;