[Home] [Help]
PACKAGE: APPS.IBY_FNDCPT_SETUP_PUB
Source
1 PACKAGE IBY_FNDCPT_SETUP_PUB AS
2 /*$Header: ibyfcsts.pls 120.18.12010000.3 2009/03/09 11:54:12 lmallick ship $*/
3
4
5 ------------------------------------------------------------------------
6 -- I. Constant Declarations
7 ------------------------------------------------------------------------
8
9 G_CHNNL_ATTRIB_USE_OPTIONAL CONSTANT VARCHAR2(30) := 'OPTIONAL';
10 G_CHNNL_ATTRIB_USE_REQUIRED CONSTANT VARCHAR2(30) := 'REQUIRED';
11 G_CHNNL_ATTRIB_USE_DISABLED CONSTANT VARCHAR2(30) := 'DISABLED';
12
13 G_PMT_FLOW_FNDCPT CONSTANT VARCHAR2(30) := 'FUNDS_CAPTURE';
14
15 -- Channel Types
16 G_CHANNEL_CREDIT_CARD CONSTANT VARCHAR2(30) := 'CREDIT_CARD';
17
18 -- Result Codes
19 G_RC_INVALID_CHNNL CONSTANT VARCHAR2(30) := 'INVALID_PMT_CHANNEL';
20 G_RC_INVALID_PMT_FUNCTION CONSTANT VARCHAR2(30) := 'INVALID_PMT_FUNCTION';
21 G_RC_INVALID_INSTRUMENT CONSTANT VARCHAR2(30) := 'INVALID_INSTRUMENT';
22 G_RC_INVALID_INSTR_ASSIGN CONSTANT VARCHAR2(30) := 'INVALID_INSTRUMENT_ASSIGNMENT';
23 G_RC_UNKNOWN_CARD CONSTANT VARCHAR2(30) := 'UNKNOWN_CARD';
24
25
26 -------------------------------------------------------------------------
27 -- II. Common Record Types
28 -------------------------------------------------------------------------
29
30
31 TYPE PayerAttributes_rec_type IS RECORD
32 (
33 Bank_Charge_Bearer VARCHAR2(30),
34 DirectDebit_BankInstruction VARCHAR2(30)
35 );
36
37 TYPE PmtChannel_rec_type IS RECORD
38 (
39 Pmt_Channel_Code VARCHAR2(30),
40 Instrument_Type VARCHAR2(30)
41 );
42
43 TYPE PmtChannelAssignment_rec_type IS RECORD
44 (
45 Pmt_Channel_Code VARCHAR2(30),
46 Default_Flag VARCHAR2(1),
47 Inactive_Date DATE
48 );
49
50 TYPE PmtChannel_AttribUses_rec_type IS RECORD
51 (
52 Instr_SecCode_Use VARCHAR2(30),
53 Instr_VoiceAuthFlag_Use VARCHAR2(30),
54 Instr_VoiceAuthCode_Use VARCHAR2(30),
55 Instr_VoiceAuthDate_Use VARCHAR2(30),
56 PO_Number_Use VARCHAR2(30),
57 PO_Line_Number_Use VARCHAR2(30),
58 AddInfo_Use VARCHAR2(30),
59 Instr_Billing_Address VARCHAR2(30)
60 );
61
62 TYPE PmtInstrument_rec_type IS RECORD
63 (
64 Instrument_Type VARCHAR2(30),
65 Instrument_Id NUMBER
66 );
67
68 TYPE PmtInstrAssignment_rec_type IS RECORD
69 (
70 Assignment_Id NUMBER,
71 Instrument PmtInstrument_rec_type,
72 Priority NUMBER,
73 Start_Date DATE,
74 End_Date DATE
75 );
76
77
78 TYPE CreditCard_rec_type IS RECORD
79 (
80 Card_Id NUMBER,
81 Owner_Id NUMBER,
82 Card_Holder_Name VARCHAR2(80),
83 Billing_Address_Id NUMBER,
84 Billing_Postal_Code VARCHAR2(50),
85 Billing_Address_Territory VARCHAR2(2),
86 Card_Number VARCHAR2(30),
87 Expiration_Date DATE,
88 Instrument_Type VARCHAR2(30),
89 PurchaseCard_Flag VARCHAR2(1),
90 PurchaseCard_SubType VARCHAR2(30),
91 Card_Issuer VARCHAR2(30),
92 FI_Name VARCHAR2(80),
93 Single_Use_Flag VARCHAR2(1),
94 Info_Only_Flag VARCHAR2(1),
95 Card_Purpose VARCHAR2(30),
96 Card_Description VARCHAR2(240),
97 Active_Flag VARCHAR2(1),
98 Inactive_Date DATE,
99 Address_Type VARCHAR2(1), -- Internal to payments, defaulted to 'S'
100 Attribute_category VARCHAR2(150),
101 Attribute1 VARCHAR2(150),
102 Attribute2 VARCHAR2(150),
103 Attribute3 VARCHAR2(150),
104 Attribute4 VARCHAR2(150),
105 Attribute5 VARCHAR2(150),
106 Attribute6 VARCHAR2(150),
107 Attribute7 VARCHAR2(150),
108 Attribute8 VARCHAR2(150),
109 Attribute9 VARCHAR2(150),
110 Attribute10 VARCHAR2(150),
111 Attribute11 VARCHAR2(150),
112 Attribute12 VARCHAR2(150),
113 Attribute13 VARCHAR2(150),
114 Attribute14 VARCHAR2(150),
115 Attribute15 VARCHAR2(150),
116 Attribute16 VARCHAR2(150),
117 Attribute17 VARCHAR2(150),
118 Attribute18 VARCHAR2(150),
119 Attribute19 VARCHAR2(150),
120 Attribute20 VARCHAR2(150),
121 Attribute21 VARCHAR2(150),
122 Attribute22 VARCHAR2(150),
123 Attribute23 VARCHAR2(150),
124 Attribute24 VARCHAR2(150),
125 Attribute25 VARCHAR2(150),
126 Attribute26 VARCHAR2(150),
127 Attribute27 VARCHAR2(150),
128 Attribute28 VARCHAR2(150),
129 Attribute29 VARCHAR2(150),
130 Attribute30 VARCHAR2(150)
131 );
132
133 -- II.2 Table Types
134
135 TYPE PmtChannel_tbl_type IS TABLE OF PmtChannel_rec_type
136 INDEX BY BINARY_INTEGER;
137
138 TYPE PmtChannelAssignment_tbl_type IS TABLE OF PmtChannelAssignment_rec_type
139 INDEX BY BINARY_INTEGER;
140
141 TYPE PmtInstrument_tbl_type IS TABLE OF PmtInstrument_rec_type
142 INDEX BY BINARY_INTEGER;
143
144 TYPE PmtInstrAssignment_tbl_type IS TABLE OF PmtInstrAssignment_rec_type
145 INDEX BY BINARY_INTEGER;
146
147
148 ------------------------------------------------------------------------------
149 -- III. API Signatures
150 ------------------------------------------------------------------------------
151
152 -- 1. Set_Payer_Attributes
153 --
154 -- API name : Set_Payer_Attributes
155 -- Type : Public
156 -- Pre-reqs : None
157 -- Function : Sets payment-specific payer attributes
158 -- Current version : 1.0
159 -- Previous version: 1.0
160 -- Initial version : 1.0
161 --
162 PROCEDURE Set_Payer_Attributes
163 (
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_TRUE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
171 p_payer_attributes IN PayerAttributes_rec_type,
172 x_payer_attribs_id OUT NOCOPY NUMBER,
173 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
174 );
175
176 -- 2. Get_Payer_Attributes
177 --
178 -- API name : Get_Payer_Attributes
179 -- Type : Public
180 -- Pre-reqs : None
181 -- Function : Gets payment-specific payer attributes
182 -- Current version : 1.0
183 -- Previous version: 1.0
184 -- Initial version : 1.0
185 --
186 PROCEDURE Get_Payer_Attributes
187 (
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
194 x_payer_attributes OUT NOCOPY PayerAttributes_rec_type,
195 x_payer_attribs_id OUT NOCOPY NUMBER,
196 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
197 );
198
199 -- 3. Get_Payment_Channel_Attribs
200 --
201 -- API name : Get_Payment_Channel_Attribs
202 -- Type : Public
203 -- Pre-reqs : None
204 -- Function : Gets payment channel attribute usages
205 -- Current version : 1.0
206 -- Previous version: 1.0
207 -- Initial version : 1.0
208 --
209 PROCEDURE Get_Payment_Channel_Attribs
210 (
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_channel_code IN VARCHAR2,
217 x_channel_attrib_uses OUT NOCOPY PmtChannel_AttribUses_rec_type,
218 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
219 );
220
221 -- 4. Set_Payer_Default_Pmt_Channel
222 --
223 -- API name : Set_Payer_Default_Pmt_Channel
224 -- Type : Public
225 -- Pre-reqs : None
226 -- Function : Sets a payer's default payment channel
227 -- Current version : 1.0
228 -- Previous version: 1.0
229 -- Initial version : 1.0
230 --
231 PROCEDURE Set_Payer_Default_Pmt_Channel
232 (
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235 p_commit IN VARCHAR2 := FND_API.G_TRUE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
240 p_channel_assignment IN PmtChannelAssignment_rec_type,
241 x_assignment_id OUT NOCOPY NUMBER,
242 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
243 );
244
245 -- 5. Get_Payer_Default_Pmt_Channel
246 --
247 -- API name : Get_Payer_Default_Payment_Channel
248 -- Type : Public
249 -- Pre-reqs : None
250 -- Function : Gets the payer's default payment channel
251 -- Current version : 1.0
252 -- Previous version: 1.0
253 -- Initial version : 1.0
254 --
255 PROCEDURE Get_Payer_Default_Pmt_Channel
256 (
257 p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
263 x_channel_assignment OUT NOCOPY PmtChannelAssignment_rec_type,
264 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
265 );
266
267 -- 6. Get_Trxn_Appl_Payment_Channels
268 --
269 -- API name : Get_Trxn_Applicable_Payment_Channels
270 -- Type : Public
271 -- Pre-reqs : None
272 -- Function : Gets the payment channels applicable to the trxn
273 -- Current version : 1.0
274 -- Previous version: 1.0
275 -- Initial version : 1.0
276 --
277 PROCEDURE Get_Trxn_Appl_Pmt_Channels
278 (
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
285 p_payer_equivalency IN VARCHAR2
286 := IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
287 p_conditions IN IBY_FNDCPT_COMMON_PUB.TrxnContext_rec_type,
288 p_result_limit IN IBY_FNDCPT_COMMON_PUB.ResultLimit_rec_type,
289 x_channels OUT NOCOPY PmtChannel_tbl_type,
290 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
291 );
292
293 -- 7. Set_Payer_Instr_Assignment
294 --
295 -- API name : Set_Payer_Instr_Assignment
296 -- Type : Public
297 -- Pre-reqs : None
298 -- Function : Assigns instrument to the payer
299 -- Current version : 1.0
300 -- Previous version: 1.0
301 -- Initial version : 1.0
302 --
303 PROCEDURE Set_Payer_Instr_Assignment
304 (
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307 p_commit IN VARCHAR2 := FND_API.G_TRUE,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
312 p_assignment_attribs IN PmtInstrAssignment_rec_type,
313 x_assign_id OUT NOCOPY NUMBER,
314 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
315 );
316
317 -- 8. Get_Payer_Instr_Assignments
318 --
319 -- API name :
320 -- Type : Public
321 -- Pre-reqs : None
322 -- Function : Gets all instrument assignments for the payer
323 -- Current version : 1.0
324 -- Previous version: 1.0
325 -- Initial version : 1.0
326 --
327 PROCEDURE Get_Payer_Instr_Assignments
328 (
329 p_api_version IN NUMBER,
330 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
331 x_return_status OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2,
334 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
335 x_assignments OUT NOCOPY PmtInstrAssignment_tbl_type,
336 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
337 );
338
339 -- 9. Get_Payer_All_Instruments
340 --
341 -- API name : Get_Payer_All_Instruments
342 -- Type : Public
343 -- Pre-reqs : None
344 -- Function : Get all instruments owned by the payer
345 -- Current version : 1.0
346 -- Previous version: 1.0
347 -- Initial version : 1.0
348 --
349 PROCEDURE Get_Payer_All_Instruments
350 (
351 p_api_version IN NUMBER,
352 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353 x_return_status OUT NOCOPY VARCHAR2,
354 x_msg_count OUT NOCOPY NUMBER,
355 x_msg_data OUT NOCOPY VARCHAR2,
356 p_party_id IN NUMBER,
357 x_instruments OUT NOCOPY PmtInstrument_tbl_type,
358 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
359 );
360
361 -- 10. Get_Trxn_Appl_Instr_Assign
362 --
363 -- API name : Get_Trxn_Appl_Instr_Assign
364 -- Type : Public
365 -- Pre-reqs : None
366 -- Function : Gets applicable instrument assignments for the trxn
367 -- Current version : 1.0
368 -- Previous version: 1.0
369 -- Initial version : 1.0
370 --
371 PROCEDURE Get_Trxn_Appl_Instr_Assign
372 (
373 p_api_version IN NUMBER,
374 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
375 x_return_status OUT NOCOPY VARCHAR2,
376 x_msg_count OUT NOCOPY NUMBER,
377 x_msg_data OUT NOCOPY VARCHAR2,
378 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
379 p_payer_equivalency IN VARCHAR2 :=
380 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
381 p_conditions IN IBY_FNDCPT_COMMON_PUB.TrxnContext_rec_type,
382 p_result_limit IN IBY_FNDCPT_COMMON_PUB.ResultLimit_rec_type,
383 x_assignments OUT NOCOPY PmtInstrAssignment_tbl_type,
384 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
385 );
386
387 -- 11. Create_Card
388 --
389 -- API name : Create_Card
390 -- Type : Public
391 -- Pre-reqs : None
392 -- Function : Creates a credit card instrument
393 -- Current version : 1.0
394 -- Previous version: 1.0
395 -- Initial version : 1.0
396 --
397 PROCEDURE Create_Card
398 (
399 p_api_version IN NUMBER,
400 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401 p_commit IN VARCHAR2 := FND_API.G_TRUE,
402 x_return_status OUT NOCOPY VARCHAR2,
403 x_msg_count OUT NOCOPY NUMBER,
404 x_msg_data OUT NOCOPY VARCHAR2,
405 p_card_instrument IN CreditCard_rec_type,
406 x_card_id OUT NOCOPY NUMBER,
407 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
408 );
409
410 -- 12. Update_Card
411 --
412 -- API name : Update_Card
413 -- Type : Public
414 -- Pre-reqs : None
415 -- Function : Modifies a credit card instrument
416 -- Current version : 1.0
417 -- Previous version: 1.0
418 -- Initial version : 1.0
419 --
420 PROCEDURE Update_Card
421 (
422 p_api_version IN NUMBER,
423 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
424 p_commit IN VARCHAR2 := FND_API.G_TRUE,
425 x_return_status OUT NOCOPY VARCHAR2,
426 x_msg_count OUT NOCOPY NUMBER,
427 x_msg_data OUT NOCOPY VARCHAR2,
428 p_card_instrument IN CreditCard_rec_type,
429 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
430 );
431
432 -- 13. Get_Card
433 --
434 -- API name : Get_Card
435 -- Type : Public
436 -- Pre-reqs : None
437 -- Function : Queries a credit card instrument
438 -- Current version : 1.0
439 -- Previous version: 1.0
440 -- Initial version : 1.0
441 --
442 PROCEDURE Get_Card
443 (
444 p_api_version IN NUMBER,
445 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
446 x_return_status OUT NOCOPY VARCHAR2,
447 x_msg_count OUT NOCOPY NUMBER,
448 x_msg_data OUT NOCOPY VARCHAR2,
449 p_card_id NUMBER,
450 x_card_instrument OUT NOCOPY CreditCard_rec_type,
451 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
452 );
453
454 -- 15. Card_Exists
455 --
456 -- API name : Card_Exists
457 -- Type : Public
458 -- Pre-reqs : None
459 -- Function : Queries if credit card is already registered;
460 -- identity is based on the card number and owning
461 -- party
462 -- Current version : 1.0
463 -- Previous version: 1.0
464 -- Initial version : 1.0
465 --
466 PROCEDURE Card_Exists
467 (
468 p_api_version IN NUMBER,
469 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_msg_count OUT NOCOPY NUMBER,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_owner_id NUMBER,
474 p_card_number VARCHAR2,
475 x_card_instrument OUT NOCOPY CreditCard_rec_type,
476 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type,
477 p_card_instr_type IN VARCHAR2 DEFAULT NULL
478 );
479
480 -- 16. Process_Credit_Card
481 --
482 -- API name : Process_Credit_Card
483 -- Type : Public
484 -- Pre-reqs : None
485 -- Function : Creates a credit card and instrument assignment.
486 -- Current version : 1.0
487 -- Previous version: 1.0
488 -- Initial version : 1.0
489 --
490 PROCEDURE Process_Credit_Card
491 (
492 p_api_version IN NUMBER,
493 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494 p_commit IN VARCHAR2 := FND_API.G_TRUE,
495 x_return_status OUT NOCOPY VARCHAR2,
496 x_msg_count OUT NOCOPY NUMBER,
497 x_msg_data OUT NOCOPY VARCHAR2,
498 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
499 p_credit_card IN CreditCard_rec_type,
500 p_assignment_attribs IN PmtInstrAssignment_rec_type,
501 x_assign_id OUT NOCOPY NUMBER,
502 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
503 );
504 -- 17. Update_Card_Wrapper
505 --
506 -- API name : Update_Card_Wrapper
507 -- Type : Public Wrapper for Java calls only to be used by Payments
508 -- Pre-reqs : None
509 -- Function : Modifies a credit card instrument
510 -- Current version : 1.0
511 -- Previous version: 1.0
512 -- Initial version : 1.0
513 PROCEDURE Update_Card_Wrapper
514 (
515 p_commit IN VARCHAR2,
516 p_instr_id IN iby_creditcard.instrid%TYPE,
517 p_owner_id IN iby_creditcard.card_owner_id%TYPE,
518 p_holder_name IN iby_creditcard.chname%TYPE,
519 p_billing_address_id IN iby_creditcard.addressid%TYPE,
520 p_address_type IN VARCHAR2,
521 p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
522 p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
523 p_expiry_date IN iby_creditcard.expirydate%TYPE,
524 p_instr_type IN iby_creditcard.instrument_type%TYPE,
525 p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
526 p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
527 p_fi_name IN iby_creditcard.finame%TYPE,
528 p_single_use IN iby_creditcard.single_use_flag%TYPE,
529 p_info_only IN iby_creditcard.information_only_flag%TYPE,
530 p_purpose IN iby_creditcard.card_purpose%TYPE,
531 p_desc IN iby_creditcard.description%TYPE,
532 p_active_flag IN iby_creditcard.active_flag%TYPE,
533 p_inactive_date IN iby_creditcard.inactive_date%TYPE,
534 p_attribute_category IN iby_creditcard.attribute_category%TYPE,
535 p_attribute1 IN iby_creditcard.attribute1%TYPE,
536 p_attribute2 IN iby_creditcard.attribute2%TYPE,
537 p_attribute3 IN iby_creditcard.attribute3%TYPE,
538 p_attribute4 IN iby_creditcard.attribute4%TYPE,
539 p_attribute5 IN iby_creditcard.attribute5%TYPE,
540 p_attribute6 IN iby_creditcard.attribute6%TYPE,
541 p_attribute7 IN iby_creditcard.attribute7%TYPE,
542 p_attribute8 IN iby_creditcard.attribute8%TYPE,
543 p_attribute9 IN iby_creditcard.attribute9%TYPE,
544 p_attribute10 IN iby_creditcard.attribute10%TYPE,
545 p_attribute11 IN iby_creditcard.attribute11%TYPE,
546 p_attribute12 IN iby_creditcard.attribute12%TYPE,
547 p_attribute13 IN iby_creditcard.attribute13%TYPE,
548 p_attribute14 IN iby_creditcard.attribute14%TYPE,
549 p_attribute15 IN iby_creditcard.attribute15%TYPE,
550 p_attribute16 IN iby_creditcard.attribute16%TYPE,
551 p_attribute17 IN iby_creditcard.attribute17%TYPE,
552 p_attribute18 IN iby_creditcard.attribute18%TYPE,
553 p_attribute19 IN iby_creditcard.attribute19%TYPE,
554 p_attribute20 IN iby_creditcard.attribute20%TYPE,
555 p_attribute21 IN iby_creditcard.attribute21%TYPE,
556 p_attribute22 IN iby_creditcard.attribute22%TYPE,
557 p_attribute23 IN iby_creditcard.attribute23%TYPE,
558 p_attribute24 IN iby_creditcard.attribute24%TYPE,
559 p_attribute25 IN iby_creditcard.attribute25%TYPE,
560 p_attribute26 IN iby_creditcard.attribute26%TYPE,
561 p_attribute27 IN iby_creditcard.attribute27%TYPE,
562 p_attribute28 IN iby_creditcard.attribute28%TYPE,
563 p_attribute29 IN iby_creditcard.attribute29%TYPE,
564 p_attribute30 IN iby_creditcard.attribute30%TYPE,
565 x_result_code OUT NOCOPY VARCHAR2,
566 x_return_status OUT NOCOPY VARCHAR2
567 );
568
569 -- 18. Create_Card_Wrapper
570 --
571 -- API name : Create_Card_Wrapper
572 -- Type : Public Wrapper for Java calls only to be used by Payments
573 -- Pre-reqs : None
574 -- Function : Creates a credit card instrument
575 -- Current version : 1.0
576 -- Previous version: 1.0
577 -- Initial version : 1.0
578
579 PROCEDURE Create_Card_Wrapper
580 (p_commit IN VARCHAR2,
581 p_owner_id IN iby_creditcard.card_owner_id%TYPE,
582 p_holder_name IN iby_creditcard.chname%TYPE,
583 p_billing_address_id IN iby_creditcard.addressid%TYPE,
584 p_address_type IN VARCHAR2,
585 p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
586 p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
587 p_card_number IN iby_creditcard.ccnumber%TYPE,
588 p_expiry_date IN iby_creditcard.expirydate%TYPE,
589 p_instr_type IN iby_creditcard.instrument_type%TYPE,
590 p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
591 p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
592 p_issuer IN iby_creditcard.card_issuer_code%TYPE,
593 p_fi_name IN iby_creditcard.finame%TYPE,
594 p_single_use IN iby_creditcard.single_use_flag%TYPE,
595 p_info_only IN iby_creditcard.information_only_flag%TYPE,
596 p_purpose IN iby_creditcard.card_purpose%TYPE,
597 p_desc IN iby_creditcard.description%TYPE,
598 p_active_flag IN iby_creditcard.active_flag%TYPE,
599 p_inactive_date IN iby_creditcard.inactive_date%TYPE,
600 p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
601 p_attribute_category IN iby_creditcard.attribute_category%TYPE,
602 p_attribute1 IN iby_creditcard.attribute1%TYPE,
603 p_attribute2 IN iby_creditcard.attribute2%TYPE,
604 p_attribute3 IN iby_creditcard.attribute3%TYPE,
605 p_attribute4 IN iby_creditcard.attribute4%TYPE,
606 p_attribute5 IN iby_creditcard.attribute5%TYPE,
607 p_attribute6 IN iby_creditcard.attribute6%TYPE,
608 p_attribute7 IN iby_creditcard.attribute7%TYPE,
609 p_attribute8 IN iby_creditcard.attribute8%TYPE,
610 p_attribute9 IN iby_creditcard.attribute9%TYPE,
611 p_attribute10 IN iby_creditcard.attribute10%TYPE,
612 p_attribute11 IN iby_creditcard.attribute11%TYPE,
613 p_attribute12 IN iby_creditcard.attribute12%TYPE,
614 p_attribute13 IN iby_creditcard.attribute13%TYPE,
615 p_attribute14 IN iby_creditcard.attribute14%TYPE,
616 p_attribute15 IN iby_creditcard.attribute15%TYPE,
617 p_attribute16 IN iby_creditcard.attribute16%TYPE,
618 p_attribute17 IN iby_creditcard.attribute17%TYPE,
619 p_attribute18 IN iby_creditcard.attribute18%TYPE,
620 p_attribute19 IN iby_creditcard.attribute19%TYPE,
621 p_attribute20 IN iby_creditcard.attribute20%TYPE,
622 p_attribute21 IN iby_creditcard.attribute21%TYPE,
623 p_attribute22 IN iby_creditcard.attribute22%TYPE,
624 p_attribute23 IN iby_creditcard.attribute23%TYPE,
625 p_attribute24 IN iby_creditcard.attribute24%TYPE,
626 p_attribute25 IN iby_creditcard.attribute25%TYPE,
627 p_attribute26 IN iby_creditcard.attribute26%TYPE,
628 p_attribute27 IN iby_creditcard.attribute27%TYPE,
629 p_attribute28 IN iby_creditcard.attribute28%TYPE,
630 p_attribute29 IN iby_creditcard.attribute29%TYPE,
631 p_attribute30 IN iby_creditcard.attribute30%TYPE,
632 x_result_code OUT NOCOPY VARCHAR2,
633 x_return_status OUT NOCOPY VARCHAR2,
634 x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
635 );
636
637 ------------------------------------------------------------------------------
638 -- IV. Utility Functions
639 ------------------------------------------------------------------------------
640
641 PROCEDURE Get_Payer_Id
642 (
643 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
644 p_validation_level IN VARCHAR2,
645 x_payer_level OUT NOCOPY VARCHAR2,
646 x_payer_id OUT NOCOPY iby_external_payers_all.ext_payer_id%TYPE,
647 x_payer_attribs OUT NOCOPY PayerAttributes_rec_type
648 );
649
650
651 FUNCTION Get_Hash(p_number IN VARCHAR2, p_salt IN VARCHAR2) RETURN VARCHAR2;
652
653 FUNCTION Get_Hash(p_number IN VARCHAR2, p_salt IN VARCHAR2, p_site_salt IN VARCHAR2)
654 RETURN VARCHAR2;
655
656
657 PROCEDURE Get_Trxn_Payer_Attributes
658 (
659 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
660 p_payer_equivalency IN VARCHAR2
661 := IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
662 x_payer_attributes OUT NOCOPY PayerAttributes_rec_type
663 );
664
665 END IBY_FNDCPT_SETUP_PUB;