1 package iby_bepinfo_pkg AUTHID CURRENT_USER as
2 /*$Header: ibybepis.pls 115.17 2003/12/19 20:32:33 jleybovi ship $*/
3
4 -- constants for IBY_BEPINFO.BEP_TYPE
5 --
6 C_BEPTYPE_GATEWAY CONSTANT VARCHAR2(20) := 'GATEWAY';
7 C_BEPTYPE_PROCESSOR CONSTANT VARCHAR2(20) := 'PROCESSOR';
8
9
10 /*
11 ** Name : iby_bepinfo_pkg.
12 ** Purpose : This package creates or deletes Back end processor entry in
13 ** BEP Table.
14 */
15
16 /*
17 ** Function: SuffixExists.
18 ** Purpose: Check if suffix with the same name already exists in the system.
19 */
20 function suffixExists (i_bepsuffix in iby_bepinfo.suffix%type,
21 i_bepid in iby_bepinfo.bepid%type)
22 return boolean;
23
24 /*
25 ** Function: bepNameExists.
26 ** Purpose: Check if any bep Name already exists in the system.
27 */
28 function bepNameExists (i_bepname in iby_bepinfo.name%type,
29 i_bepid in iby_bepinfo.bepid%type)
30 return boolean;
31
32 /*
33 ** Procedure Name : createBEPInfo
34 ** Purpose : creates an entry in Back end processor information table.
35 ** Returns the id created for the entry.
36 **
37 ** Parameters:
38 **
39 ** In : i_bepname, i_bepurl, i_beptype, i_srvrimm, i_modsupport,
40 ** i_bepusername, i_beppassword, i_psusername, i_pspassword,
41 ** i_login, i_logout.
42 ** i_cancsupport, io_depid
43 ** Out : io_bepid.
44 **
45 */
46 procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
47 i_bepurl in iby_bepinfo.baseurl%type,
48 i_bepsuffix in iby_bepinfo.suffix%type,
49 i_bep_type in iby_bepinfo.bep_type%type,
50 i_bepusername in iby_bepinfo.bepusername%type,
51 i_beppassword in iby_bepinfo.beppassword%type,
52 i_psusername in iby_bepinfo.psusername%type,
53 i_pspassword in iby_bepinfo.pspassword%type,
54 i_adminurl in iby_bepinfo.adminurl%type,
55 i_login in iby_bepinfo.loginurl%type,
56 i_logout in iby_bepinfo.logouturl%type,
57 i_supportedop in iby_bepinfo.supportedOp%type,
58 i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59 i_leadtime in iby_bepinfo.leadtime%type,
60 i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61 i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62 i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63 i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
64 i_securityscheme in iby_bepinfo.securityscheme%type,
65 i_partyid in NUMBER,
66 i_preNLSLang in iby_beplangs.beplang%type,
67 i_opt1NLSLang in iby_beplangs.beplang%type,
68 i_opt2NLSLang in iby_beplangs.beplang%type,
69 io_bepid in out nocopy iby_bepinfo.bepid%type);
70
71 /*
72 ** Procedure Name : modBEPInfo
73 ** Purpose : modifies an entry in Back end processor information table.
74 **
75 ** Parameters:
76 **
77 ** In : i_bepid, i_bepname, i_bepurl, i_beptype, i_srvrimm, i_modsupport,
78 ** i_bepusername, i_beppassword, i_psusername, i_pspassword,
79 ** i_login, i_logout.
80 ** i_cancsupport, io_depid
81 ** Out : io_bepid.
82 **
83 */
84 procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
85 i_bepname in iby_bepinfo.name%type,
86 i_bepurl in iby_bepinfo.baseurl%type,
87 i_bepsuffix in iby_bepinfo.suffix%type,
88 i_bep_type in iby_bepinfo.bep_type%type,
89 i_bepusername in iby_bepinfo.bepusername%type,
90 i_beppassword in iby_bepinfo.beppassword%type,
91 i_psusername in iby_bepinfo.psusername%type,
92 i_pspassword in iby_bepinfo.pspassword%type,
93 i_adminurl in iby_bepinfo.adminurl%type,
94 i_login in iby_bepinfo.loginurl%type,
95 i_logout in iby_bepinfo.logouturl%type,
96 i_supportedop in iby_bepinfo.supportedOp%type,
97 i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98 i_leadtime in iby_bepinfo.leadtime%type,
99 i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100 i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101 i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102 i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
103 i_securityscheme in iby_bepinfo.securityscheme%type,
104 i_partyid in NUMBER,
105 i_preNLSLang in iby_beplangs.beplang%type,
106 i_opt1NLSLang in iby_beplangs.beplang%type,
107 i_opt2NLSLang in iby_beplangs.beplang%type,
108 i_object_version in iby_bepinfo.object_version_number%type);
109
110 /*
111 ** Procedure Name : getBEPInfo
112 ** Purpose : retrieves Back end processor information table.
113 **
114 ** Parameters:
115 **
116 ** In : i_bepid.
117 ** Out : o_bepname, o_bepurl, o_beptype, o_srvrimm, o_modsupport,
118 ** o_bepusername, o_beppassword, o_psusername, o_pspassword,
119 ** o_login, o_logout.
120 ** o_cancsupport, io_depid
121 **
122 */
123 procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
124 o_bepname out nocopy iby_bepinfo.name%type,
125 o_bepurl out nocopy iby_bepinfo.baseurl%type,
126 o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127 o_bep_type out nocopy iby_bepinfo.bep_type%type,
128 o_bepusername out nocopy iby_bepinfo.bepusername%type,
129 o_beppassword out nocopy iby_bepinfo.beppassword%type,
130 o_psusername out nocopy iby_bepinfo.psusername%type,
131 o_pspassword out nocopy iby_bepinfo.pspassword%type,
132 o_adminurl out nocopy iby_bepinfo.adminurl%type,
133 o_login out nocopy iby_bepinfo.loginurl%type,
134 o_logout out nocopy iby_bepinfo.logouturl%type,
135 o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136 o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137 o_leadtime out nocopy iby_bepinfo.leadtime%type,
138 o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139 o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140 o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141 o_activestatus out nocopy iby_bepinfo.activestatus%type,
142 o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
143 o_partyid out nocopy NUMBER,
144 o_preNLSLang out nocopy iby_beplangs.beplang%type,
145 o_opt1NLSLang out nocopy iby_beplangs.beplang%type,
146 o_opt2NLSLang out nocopy iby_beplangs.beplang%type,
147 o_object_version out nocopy iby_bepinfo.object_version_number%type);
148
149
150 /*
151 ** Procedure Name : setBEPStatus
152 ** Purpose : Sets BEP status to the given value.
153 **
154 ** Parameters:
155 **
156 ** In : i_bepid, i_status.
157 ** Out : o_flag
158 **
159 */
160 procedure setBEPStatus(i_bepid in iby_bepinfo.bepid%type,
161 i_status in iby_bepinfo.activestatus%type,
162 o_flag out nocopy int);
163
164
165 /*
166 ** Function: getBepName
167 ** Purpose: return the bep name that matches the id passed
168 */
169
170 function getBEPName(i_id iby_bepinfo.bepid%type)
171 return varchar;
172
173 /*
174 ** Function: getBEPId.
175 ** Purpose: returnt he bep id that matches the name passed.
176 */
177 function getBEPId(i_name iby_bepinfo.name%type)
178 return int;
179
180
181
182 -- This is a wrapper of createBEPInfo(). It is to handle
183 -- FND_API.G_MISS_XXX.
184 -- Note the validation in createBEPInfo() is not enough
185 -- We should add more to it later. No validation is done
186 -- in this wrapper.
187 -- FZ 5/20/02
188 procedure create_BEPInfo(
189 i_bepname in iby_bepinfo.name%type,
190 i_bepurl in iby_bepinfo.baseurl%type,
191 i_bepsuffix in iby_bepinfo.suffix%type,
192 i_bep_type in iby_bepinfo.bep_type%type,
193 i_bepusername in iby_bepinfo.bepusername%type,
194 i_beppassword in iby_bepinfo.beppassword%type,
195 i_psusername in iby_bepinfo.psusername%type,
196 i_pspassword in iby_bepinfo.pspassword%type,
197 i_adminurl in iby_bepinfo.adminurl%type,
198 i_login in iby_bepinfo.loginurl%type,
199 i_logout in iby_bepinfo.logouturl%type,
200 i_supportedop in iby_bepinfo.supportedOp%type,
201 i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202 i_leadtime in iby_bepinfo.leadtime%type,
203 i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204 i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205 i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206 i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
207 i_securityscheme in iby_bepinfo.securityscheme%type,
208 i_partyid in NUMBER,
209 i_preNLSLang in iby_beplangs.beplang%type,
210 i_opt1NLSLang in iby_beplangs.beplang%type,
211 i_opt2NLSLang in iby_beplangs.beplang%type,
212 io_bepid in out nocopy iby_bepinfo.bepid%type
213 );
214
215
216
217 -- This is similar to modBEPInfo(), however we add code to
218 -- to handle FND_API.G_MISS_XXX
219 -- FZ 5/20/02
220 procedure update_BEPInfo(
221 i_bepid in iby_bepinfo.bepid%type,
222 i_bepname in iby_bepinfo.name%type,
223 i_bepurl in iby_bepinfo.baseurl%type,
224 i_bepsuffix in iby_bepinfo.suffix%type,
225 i_bep_type in iby_bepinfo.bep_type%type,
226 i_bepusername in iby_bepinfo.bepusername%type,
227 i_beppassword in iby_bepinfo.beppassword%type,
228 i_psusername in iby_bepinfo.psusername%type,
229 i_pspassword in iby_bepinfo.pspassword%type,
230 i_adminurl in iby_bepinfo.adminurl%type,
231 i_login in iby_bepinfo.loginurl%type,
232 i_logout in iby_bepinfo.logouturl%type,
233 i_supportedop in iby_bepinfo.supportedOp%type,
234 i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235 i_leadtime in iby_bepinfo.leadtime%type,
236 i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237 i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238 i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239 i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
240 i_securityscheme in iby_bepinfo.securityscheme%type,
241 i_partyid in NUMBER,
242 i_preNLSLang in iby_beplangs.beplang%type,
243 i_opt1NLSLang in iby_beplangs.beplang%type,
244 i_opt2NLSLang in iby_beplangs.beplang%type,
245 i_object_version in iby_bepinfo.object_version_number%type
246 );
247
248
249 end iby_bepinfo_pkg;