1 package OracleApps AUTHID CURRENT_USER as
2 /* $Header: ICXSEXS.pls 120.0.12020000.2 2012/10/18 13:17:54 ctilley ship $ */
3
4 -- added to support menu
5 TYPE menuItem IS RECORD (
6 menuId number,
7 userMenuName varchar2(80),
8 menuURL varchar2(2000));
9
10 TYPE menuItemTable IS TABLE OF menuItem
11 index by binary_integer;
12
13 type l_v80_table is table of varchar2(80)
14 index by binary_integer;
15
16 type l_v240_table is table of varchar2(240)
17 index by binary_integer;
18
19 type l_v2000_table is table of varchar2(2000)
20 index by binary_integer;
21
22 procedure VL(i_1 in varchar2 default NULL,
23 i_2 in varchar2 default NULL,
24 i_3 in varchar2 default NULL,
25 home_url in varchar2 default NULL);
26
27 procedure DMM;
28
29 procedure DRM;
30
31 /* Bug 1545083 - added E param for forms call to use one time ticket */
32 procedure LF(F in varchar2 default NULL,
33 P in varchar2 default NULL,
34 E IN varchar2 default NULL);
35
36 function createRFLink( p_text varchar2,
37 p_application_id number,
38 p_responsibility_id number,
39 p_security_group_id number,
40 p_function_id number,
41 p_target varchar2 default '_top',
42 p_session_id number default null )
43 return varchar2;
44
45 procedure RF(F in varchar2,
46 P in varchar2 default NULL);
47
48 function Login(i_1 in varchar2 default NULL,
49 i_2 in varchar2 default NULL,
50 i_3 out nocopy number)
51 return BOOLEAN;
52
53 function Login(i_1 in varchar2 default NULL,
54 i_2 in varchar2 default NULL,
55 i_3 in varchar2,
56 i_4 out nocopy number)
57 return BOOLEAN;
58
59 procedure displayLogin(c_message in varchar2 default null,
60 c_display in varchar2 default 'IC',
61 c_logo in varchar2 default 'Y',
62 i_direct IN VARCHAR2 DEFAULT NULL,
63 i_mode IN NUMBER DEFAULT '2',
64 recreate IN VARCHAR2 DEFAULT NULL,
65 p_home_url IN VARCHAR2 DEFAULT NULL);
66
67 procedure redirectURL(i_1 in varchar2,
68 i_2 in varchar2,
69 URL in varchar2,
70 A in varchar2 default null,
71 R in varchar2 default null,
72 S in varchar2 default null);
73
74 procedure redirectURL(i_1 in varchar2,
75 i_2 in varchar2,
76 URL in varchar2,
77 F in varchar2,
78 A in varchar2 default null,
79 R in varchar2 default null,
80 S in varchar2 default null);
81
82 procedure displayResps(nri in varchar2 default NULL,
83 c_toolbar in varchar2 default 'Y');
84
85 procedure DSM(Q in varchar2);
86
87 procedure DSM_frame(Q in varchar2);
88
89 procedure runFunction(c_function_id in number,
90 n_session_id in number,
91 c_parameters in varchar2 default null,
92 p_resp_appl_id in number default null,
93 p_responsibility_id in number default null,
94 p_security_group_id in number default null,
95 p_menu_id in number default null,
96 p_function_type in varchar2 default null,
97 p_page_id in number default null);
98
99 procedure unpackParameters(p_parameters in varchar2,
100 p_names out nocopy l_v80_table,
101 p_values out nocopy l_v2000_table);
102
103 procedure unpackParameters(p_parameters in varchar2,
104 p_names out nocopy l_v80_table,
105 p_values out nocopy l_v240_table);
106
107 function getFunctions
108 return varchar2;
109
110 procedure DU;
111
112 procedure displayWebUser;
113 procedure displayWebUserlocal(p_message_flag varchar2 default 'Y');
114
115 procedure UUI(
116 i_1 in varchar2,
117 i_2 in varchar2,
118 i_3 in varchar2,
119 i_4 in varchar2,
120 i_5 in varchar2,
121 i_6 in varchar2,
122 i_7 in varchar2,
123 i_8 in varchar2 default null,
124 i_9 in varchar2,
125 i_10 in varchar2,
126 i_11 IN VARCHAR2 DEFAULT NULL,
127 i_12 IN VARCHAR2 DEFAULT NULL);
128
129 procedure updateWebUser(
130 c_KNOWN_AS in varchar2 default null,
131 c_LANGUAGE in varchar2 default null,
132 c_DATE_FORMAT in varchar2 default null,
133 c_PASSWORD1 in varchar2 default null,
134 c_PASSWORD2 in varchar2 default null,
135 c_PASSWORD3 in varchar2 default null,
136 c_MAILPREF in varchar2 default null,
137 c_DMPREF in varchar2 default null,
138 c_NUMERIC_CHARACTERS in varchar2 default null,
139 c_TERRITORY in varchar2 default null,
140 c_TIMEZONE IN VARCHAR2 DEFAULT NULL,
141 c_ENCODING IN VARCHAR2 DEFAULT NULL);
142
143 procedure NP;
144
145 procedure displayNewPassword(i_1 in varchar2 default null,
146 c_url in varchar2 default null,
147 c_mode_code in varchar2 default '115P');
148
149 procedure UNP(
150 i_1 in varchar2,
151 i_2 in varchar2,
152 i_3 in varchar2,
153 i_4 in varchar2,
154 c_mode_code in varchar2,
155 c_url in varchar2 default null);
156
157 procedure updateNewFndPassword(
158 c_USERNAME in varchar2 default null,
159 c_PASSWORD1 in varchar2 default null,
160 c_PASSWORD2 in varchar2 default null,
161 c_PASSWORD3 in varchar2 default null,
162 p_mode_code in varchar2,
163 c_url in varchar2);
164
165 procedure updateNewPassword(
166 c_USERNAME in varchar2 default null,
167 c_PASSWORD1 in varchar2 default null,
168 c_PASSWORD2 in varchar2 default null,
169 c_PASSWORD3 in varchar2 default null);
170
171 procedure icxLogin (rmode in number,
172 i_1 in varchar2,
173 i_2 in varchar2);
174
175 --added DF mputman 793404
176 PROCEDURE DF(i_direct IN VARCHAR2 DEFAULT NULL,
177 i_mode IN NUMBER DEFAULT NULL);
178
179
180 c_ampersand constant varchar2(1) := '&';
181
182 G_RED constant varchar2(7) := 'CC0000';
183 G_GREEN constant varchar2(7) := '006666';
184 G_BROWN constant varchar2(7) := '993300';
185 G_PURPLE constant varchar2(7) := '6600CC';
186
187 G_BLUE constant varchar2(7) := '0033FF';
188 G_OLIVE constant varchar2(7) := '426300';
189
190 /* Bug 1673370 - wrapper function for FORMS call to get one time ticket
191 NOTE: this should only be called from the FORMS tier, never via the web */
192 function FormsLF_prep( c_string varchar2,
193 c_session_id number default null) return varchar2;
194
195 PROCEDURE recreate_session (i_1 IN VARCHAR2,
196 i_2 IN VARCHAR2,
197 p_enc_session IN VARCHAR2,
198 p_mode IN VARCHAR2 DEFAULT '115p');
199
200 procedure ForgotPwd(c_user_name in varchar2);
201
202 procedure connectLogin(c_message in varchar2 default null,
203 c_display in varchar2 default 'IC',
204 c_logo in varchar2 default 'Y',
205 c_mode IN NUMBER DEFAULT '2',
206 c_lang IN VARCHAR2 DEFAULT NULL);
207
208 procedure convertSession(c_token in VARCHAR2,
209 i_1 IN VARCHAR2 DEFAULT NULL,
210 i_2 IN VARCHAR2 DEFAULT NULL,
211 i_S IN VARCHAR2 DEFAULT NULL,
212 c_message in varchar2 default null);
213
214
215 end OracleApps;