[Home] [Help]
PACKAGE: APPS.IBY_FNDCPT_TRXN_PUB
Source
1 PACKAGE IBY_FNDCPT_TRXN_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibyfctxs.pls 120.29.12020000.2 2012/07/12 14:55:08 sgogula ship $*/
3
4
5 ------------------------------------------------------------------------
6 -- I. Constant Declarations
7 ------------------------------------------------------------------------
8
9 -- Result Codes
10 --
11 G_RC_INVALID_EXTENSION_ATTRIB CONSTANT VARCHAR2(30) := 'INVALID_EXTENSION_ATTRIB';
12 G_RC_INVALID_EXTENSION_ID CONSTANT VARCHAR2(30) := 'INVALID_TXN_EXTENSION';
13 G_RC_EXTENSION_IMMUTABLE CONSTANT VARCHAR2(30) := 'EXTENSION_NOT_UPDATEABLE';
14 G_RC_INCMP_EXTENSION_GROUP CONSTANT VARCHAR2(30) := 'INCOMPATIBLE_EXTENSION_GROUP';
15 G_RC_DUP_EXTENSION_COPY CONSTANT VARCHAR2(30) := 'DUPLICATE_EXTENSION_COPY';
16 G_RC_DUPLICATE_AUTHORIZATION CONSTANT VARCHAR2(30) := 'DUPLICATE_AUTH';
17 G_RC_INVALID_AUTHORIZATION CONSTANT VARCHAR2(30) := 'INVALID_AUTHORIZATION';
18 G_RC_AUTH_CANCEL_UNSUPPORTED CONSTANT VARCHAR2(30) := 'AUTH_CANCEL_UNSUPPORTED';
19 G_RC_AUTH_SUCCESS CONSTANT VARCHAR2(30) := 'AUTH_SUCCESS';
20 G_RC_AUTH_UNSUPPORTED CONSTANT VARCHAR2(30) := 'AUTH_UNSUPPORTED';
21 G_RC_AUTH_PENDING CONSTANT VARCHAR2(30) := 'AUTH_PENDING';
22 G_RC_AUTH_RISK_THRESHOLD CONSTANT VARCHAR2(30) := 'RISK_THRESHOLD_EXCEEDED';
23 G_RC_AUTH_RISK_SEC_CODE CONSTANT VARCHAR2(30) := 'SECURITY_CODE_WARNING';
24 G_RC_INVALID_SETTLEMENT CONSTANT VARCHAR2(30) := 'INVALID_SETTLEMENT';
25 G_RC_DUPLICATE_RETURN CONSTANT VARCHAR2(30) := 'DUPLICATE_RETURN';
26 G_RC_INVALID_PAYEE CONSTANT VARCHAR2(30) := 'INVALID_PAYEE';
27 G_RC_INVALID_INSTRUMENT_TYPE CONSTANT VARCHAR2(30) := 'INVALID_INSTRUMENT_TYPE';
28 G_RC_SETTLEMENT_EXISTS CONSTANT VARCHAR2(30) := 'SETTLEMENT_EXISTS';
29
30 G_RC_DUPLICATE_SETTLEMENT CONSTANT VARCHAR2(30) := 'DUPLICATE_SETTLEMENT';
31 G_RC_AUTH_GROUPING_ERROR CONSTANT VARCHAR2(30) := 'AUTH_GROUPING_ERROR';
32 G_RC_INVALID_AMOUNT CONSTANT VARCHAR2(30) := 'INVALID_AMOUNT';
33 G_RC_INVALID_CURRENCY CONSTANT VARCHAR2(30) := 'INVALID_CURRENCY';
34 G_RC_REVERSAL_SUCCESS CONSTANT VARCHAR2(30) := 'REVERSAL_SUCCESS';
35 G_RC_REVERSAL_UNSUP_CARD_BRAND CONSTANT VARCHAR2(30) := 'REVERSAL_UNSUP_CARD_BRAND';
36 G_RC_REVERSAL_UNSUP_PMT_SYS CONSTANT VARCHAR2(30) := 'REVERSAL_UNSUP_PMT_SYS';
37 G_RC_DUPLICATE_REVERSAL CONSTANT VARCHAR2(30) := 'DUPLICATE_REVERSAL';
38 G_RC_CAPT_EX_AUTH_UNSUP_PS CONSTANT VARCHAR2(30) := 'CAPT_EXCEED_AUTH_UNSUP_PMT_SYS';
39 G_RC_CAPT_EX_AUTH_UNSUP_CB CONSTANT VARCHAR2(30) := 'CAPT_EXCEED_AUTH_UNSUP_CARD_BR';
40
41
42
43
44 -------------------------------------------------------------------------
45 -- II. Common Record Types
46 -------------------------------------------------------------------------
47
48 TYPE PayeeContext_rec_type IS RECORD
49 (
50 Org_Type VARCHAR2(30),
51 Org_Id NUMBER,
52 Int_Bank_Country_Code VARCHAR2(30)
53 );
54
55 TYPE TrxnExtension_rec_type IS RECORD
56 (
57 Originating_Application_Id NUMBER,
58 Order_Id VARCHAR2(75),
59 PO_Number VARCHAR2(100),
60 PO_Line_Number VARCHAR2(25),
61 Trxn_Ref_Number1 VARCHAR2(30),
62 Trxn_Ref_Number2 VARCHAR2(30),
63 Instrument_Security_Code VARCHAR2(30),
64 VoiceAuth_Flag VARCHAR2(1),
65 VoiceAuth_Date DATE,
66 VoiceAuth_Code VARCHAR2(100),
67 Additional_Info VARCHAR2(255),
68 Copy_Instr_Assign_Id NUMBER,
69 Seq_Type_Last VARCHAR2(1)
70 );
71
72 TYPE Amount_rec_type IS RECORD
73 (
74 Value NUMBER,
75 Currency_Code VARCHAR2(15)
76 );
77
78 -- Bug# 7707005. Adding the Receipt_Method_Id Qualifier for the routing rules.
79 TYPE AuthAttribs_rec_type IS RECORD
80 (
81 Payment_Factor_Flag VARCHAR2(1),
82 Memo VARCHAR2(80),
83 Order_Medium VARCHAR2(30),
84 Tax_Amount Amount_rec_type,
85 ShipFrom_SiteUse_Id NUMBER,
86 ShipFrom_PostalCode VARCHAR2(80),
87 ShipTo_SiteUse_Id NUMBER,
88 ShipTo_PostalCode VARCHAR2(80),
89 RiskEval_Enable_Flag VARCHAR2(1),
90 Receipt_Method_Id NUMBER := NULL
91 );
92
93 TYPE ReceiptAttribs_rec_type IS RECORD
94 (
95 Settlement_Date DATE,
96 Settlement_Due_Date DATE := NULL
97 );
98
99 TYPE RevAttribs_rec_type IS RECORD
100 (
101 Reauth_flag VARCHAR2(1) := 'N',
102 Revised_amount Amount_rec_type
103 );
104
105 TYPE RiskResult_rec_type IS RECORD
106 (
107 Risk_Score NUMBER,
108 Risk_Threshold_Val NUMBER,
109 Risky_Flag VARCHAR2(1)
110 );
111
112 TYPE AuthResult_rec_type IS RECORD
113 (
114 Auth_Id NUMBER,
115 Auth_Date DATE,
116 Auth_Code VARCHAR2(80),
117 AVS_Code VARCHAR2(80),
118 Instr_SecCode_Check VARCHAR2(5),
119 PaymentSys_Code VARCHAR2(40),
120 PaymentSys_Msg VARCHAR2(255),
121 Risk_Result RiskResult_rec_type
122 );
123
124
125
126
127 TYPE SettlementResult_rec_type IS RECORD (
128 Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,
129 Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
130 );
131
132 TYPE ReversalResult_rec_type IS RECORD (
133 Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,
134 Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
135 );
136
137
138 -- II.2 Table Types
139
140 TYPE SettlementResult_tbl_type IS TABLE OF SettlementResult_rec_type
141 INDEX BY BINARY_INTEGER;
142
143 TYPE ReversalResult_tbl_type IS TABLE OF ReversalResult_rec_type
144 INDEX BY BINARY_INTEGER;
145
146 ------------------------------------------------------------------------------
147 -- III. API Signatures
148 ------------------------------------------------------------------------------
149
150
151 -- 1. Create_Transaction_Extension
152 --
153 -- API name : Create_Transaction_Extension
154 -- Type : Public
155 -- Pre-reqs : None
156 -- Function : Creates a transaction extension entity
157 -- Current version : 1.0
158 -- Previous version: 1.0
159 -- Initial version : 1.0
160 --
161 PROCEDURE Create_Transaction_Extension
162 (
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_TRUE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
170 p_payer_equivalency IN VARCHAR2 :=
171 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
172 p_pmt_channel IN VARCHAR2,
173 p_instr_assignment IN NUMBER,
174 p_trxn_attribs IN TrxnExtension_rec_type,
175 x_entity_id OUT NOCOPY NUMBER,
176 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
177 );
178
179 -- 2. Update_Transaction_Extension
180 --
181 -- API name : Update_Transaction_Extension
182 -- Type : Public
183 -- Pre-reqs : None
184 -- Function : Update a transaction extension entity's attributes
185 -- Current version : 1.0
186 -- Previous version: 1.0
187 -- Initial version : 1.0
188 --
189 PROCEDURE Update_Transaction_Extension
190 (
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193 p_commit IN VARCHAR2 := FND_API.G_TRUE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
198 p_payer_equivalency IN VARCHAR2 :=
199 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
200 p_entity_id IN NUMBER,
201 p_pmt_channel IN VARCHAR2,
202 p_instr_assignment IN NUMBER,
203 p_trxn_attribs IN TrxnExtension_rec_type,
204 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
205 );
206
207 -- 3. Get_Transaction_Extension
208 --
209 -- API name : Get_Transaction_Extension
210 -- Type : Public
211 -- Pre-reqs : None
212 -- Function : Queries a transaction extension entity's attributes
213 -- Current version : 1.0
214 -- Previous version: 1.0
215 -- Initial version : 1.0
216 --
217 PROCEDURE Get_Transaction_Extension
218 (
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
225 p_entity_id IN NUMBER,
226 x_trxn_attribs OUT NOCOPY TrxnExtension_rec_type,
227 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
228 );
229
230 -- 4. Copy_Transaction_Extension
231 --
232 -- API name : Copy_Transaction_Extension
233 -- Type : Public
234 -- Pre-reqs : None
235 -- Function : Copies a transaction extension, along with all the
236 -- associated operations done to it; merge version of
237 -- the API
238 -- Current version : 1.0
239 -- Previous version: 1.0
240 -- Initial version : 1.0
241 --
242 PROCEDURE Copy_Transaction_Extension
243 (
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246 p_commit IN VARCHAR2 := FND_API.G_TRUE,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
251 p_payer_equivalency IN VARCHAR2 :=
252 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
253 p_entities IN IBY_FNDCPT_COMMON_PUB.Id_tbl_type,
254 p_trxn_attribs IN TrxnExtension_rec_type,
255 x_entity_id OUT NOCOPY NUMBER,
256 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
257 );
258
259 -- 5. Delete_Transaction_Extension
260 --
261 -- API name : Delete_Transaction_Extension
262 -- Type : Public
263 -- Pre-reqs : None
264 -- Function : Deletes/purges a transaction extension entity
265 -- Current version : 1.0
266 -- Previous version: 1.0
267 -- Initial version : 1.0
268 --
269 PROCEDURE Delete_Transaction_Extension
270 (
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273 p_commit IN VARCHAR2 := FND_API.G_TRUE,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
278 p_payer_equivalency IN VARCHAR2 :=
279 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
280 p_entity_id IN NUMBER,
281 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
282 );
283
284 PROCEDURE Secure_Wipe_Segment
285 (
286 p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE
287 );
288
289 -- 6. Create_Authorization
290 --
291 -- API name : Create_Authorization
292 -- Type : Public
293 -- Pre-reqs : None
294 -- Function : Creates an authorization
295 -- Current version : 1.0
296 -- Previous version: 1.0
297 -- Initial version : 1.0
298 --
299 PROCEDURE Create_Authorization
300 (
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
307 p_payer_equivalency IN VARCHAR2 :=
308 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
309 p_payee IN PayeeContext_rec_type,
310 p_trxn_entity_id IN NUMBER,
311 p_auth_attribs IN AuthAttribs_rec_type,
312 p_amount IN Amount_rec_type,
313 x_auth_result OUT NOCOPY AuthResult_rec_type,
314 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
315 );
316
317 -- 7. Get_Authorization
318 --
319 -- API name : Get_Authorization
320 -- Type : Public
321 -- Pre-reqs : None
322 -- Function : Queries an authorization
323 -- Current version : 1.0
324 -- Previous version: 1.0
325 -- Initial version : 1.0
326 --
327 PROCEDURE Get_Authorization
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 p_trxn_entity_id IN NUMBER,
336 x_auth_result OUT NOCOPY AuthResult_rec_type,
337 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
338 );
339
340 -- 8. Cancel_Authorization
341 --
342 -- API name : Cancel_Authorization
343 -- Type : Public
344 -- Pre-reqs : None
345 -- Function : Cancels an authorization
346 -- Current version : 1.0
347 -- Previous version: 1.0
348 -- Initial version : 1.0
349 --
350 PROCEDURE Cancel_Authorization
351 (
352 p_api_version IN NUMBER,
353 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
354 x_return_status OUT NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2,
357 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
358 p_auth_id IN NUMBER,
359 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
360 );
361
362
363 -- 9. Create_Settlement
364 --
365 -- API name : Create_Settlement
366 -- Type : Public
367 -- Pre-reqs : None
368 -- Function : Creates a settlement
369 -- Current version : 1.0
370 -- Previous version: 1.0
371 -- Initial version : 1.0
372 --
373 PROCEDURE Create_Settlement
374 (
375 p_api_version IN NUMBER,
376 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_count OUT NOCOPY NUMBER,
379 x_msg_data OUT NOCOPY VARCHAR2,
380 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
381 p_payer_equivalency IN VARCHAR2 :=
382 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
383 p_trxn_entity_id IN NUMBER,
384 p_amount IN Amount_rec_type,
385 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
386 );
387
388
389 -- 9.5 Create_Settlement (Overloaded)
390 -- Accepts ReceiptAttribs_rec_type as an additional
391 -- IN parameter
392 --
393 -- API name : Create_Settlement
394 -- Type : Public
395 -- Pre-reqs : None
396 -- Function : Creates a settlement
397 -- Current version : 1.0
398 -- Previous version: 1.0
399 -- Initial version : 1.0
400 --
401 PROCEDURE Create_Settlement
402 (
403 p_api_version IN NUMBER,
404 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405 x_return_status OUT NOCOPY VARCHAR2,
406 x_msg_count OUT NOCOPY NUMBER,
407 x_msg_data OUT NOCOPY VARCHAR2,
408 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
409 p_payer_equivalency IN VARCHAR2 :=
410 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
411 p_trxn_entity_id IN NUMBER,
412 p_amount IN Amount_rec_type,
413 p_receipt_attribs IN ReceiptAttribs_rec_type,
414 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
415 );
416
417
418 -- 13. Create_Return
419 --
420 -- API name : Create_Return
421 -- Type : Public
422 -- Pre-reqs : None
423 -- Function : Creates a return
424 -- Current version : 1.0
425 -- Previous version: 1.0
426 -- Initial version : 1.0
427 --
428 PROCEDURE Create_Return
429 (
430 p_api_version IN NUMBER,
431 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432 x_return_status OUT NOCOPY VARCHAR2,
433 x_msg_count OUT NOCOPY NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2,
435 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
436 p_payer_equivalency IN VARCHAR2 :=
437 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
438 p_trxn_entity_id IN NUMBER,
439 p_amount IN Amount_rec_type,
440 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
441 );
442
443 -- 13.5 Create_Return (Overloaded)
444 -- Accepts ReceiptAttribs_rec_type as an additional
445 -- IN parameter
446 --
447 -- API name : Create_Return
448 -- Type : Public
449 -- Pre-reqs : None
450 -- Function : Creates a return
451 -- Current version : 1.0
452 -- Previous version: 1.0
453 -- Initial version : 1.0
454 --
455 PROCEDURE Create_Return
456 (
457 p_api_version IN NUMBER,
458 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459 x_return_status OUT NOCOPY VARCHAR2,
460 x_msg_count OUT NOCOPY NUMBER,
461 x_msg_data OUT NOCOPY VARCHAR2,
462 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
463 p_payer_equivalency IN VARCHAR2 :=
464 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
465 p_trxn_entity_id IN NUMBER,
466 p_amount IN Amount_rec_type,
467 p_receipt_attribs IN ReceiptAttribs_rec_type,
468 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
469 );
470
471 -- 14. Create_Settlements
472 --
473 -- API name : create_settlements
474 -- Type : Public
475 -- Pre-reqs : None
476 -- Function : Pick up bulk settlment data from the the application
477 -- views to insert the settlement record in
478 -- IBY_TRXN_SUMMARIES_ALL
479 -- Current version : 1.0
480 -- Previous version: 1.0
481 -- Initial version : 1.0
482 --
483 PROCEDURE Create_Settlements (
484 p_api_version IN NUMBER,
485 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
486 p_calling_app_id IN NUMBER,
487 p_calling_app_request_code IN
488 IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
489 p_order_view_name IN VARCHAR2,
490 x_return_status OUT NOCOPY VARCHAR2,
491 x_msg_count OUT NOCOPY NUMBER,
492 x_msg_data OUT NOCOPY VARCHAR2,
493 x_responses OUT NOCOPY SettlementResult_tbl_type
494 );
495
496 -- 15. Create_Settlements
497 --
498 -- API name : create_settlements
499 -- Type : Public
500 -- Pre-reqs : None
501 -- Function : Overloaded version of the previous API. This version if the
502 -- API optionally returns a table of reversal response
503 -- Current version : 1.0
504 -- Previous version: 1.0
505 -- Initial version : 1.0
506 --
507 PROCEDURE Create_Settlements (
508 p_api_version IN NUMBER,
509 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
510 p_calling_app_id IN NUMBER,
511 p_calling_app_request_code IN
512 IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
513 p_order_view_name IN VARCHAR2,
514 x_return_status OUT NOCOPY VARCHAR2,
515 x_msg_count OUT NOCOPY NUMBER,
516 x_msg_data OUT NOCOPY VARCHAR2,
517 x_responses OUT NOCOPY SettlementResult_tbl_type,
518 x_rev_responses OUT NOCOPY ReversalResult_tbl_type
519 );
520
521 -- 16. Create_Reversal
522 --
523 -- API name : Create_Reversal
524 -- Type : Public
525 -- Pre-reqs : None
526 -- Function : Fully Reverses the authorization done against a
527 -- transaction extension
528 -- Current version : 1.0
529 -- Previous version: 1.0
530 -- Initial version : 1.0
531 --
532 PROCEDURE Create_Reversal
533 (
534 p_api_version IN NUMBER,
535 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
537 p_payer_equivalency IN VARCHAR2 :=
538 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
539 p_trxn_entity_id IN NUMBER,
540 p_rev_attribs IN RevAttribs_rec_type,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2,
544 x_reversal_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type,
545 x_reauth_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type,
546 x_reauth_result OUT NOCOPY AuthResult_rec_type
547 );
548
549
550 -- 100. Encrypt_Extensions
551 --
552 -- Function : Encrypt_Extensions
553 -- Type : Private
554 -- Purpose : Encrypts transaction extensions
555 --
556 PROCEDURE Encrypt_Extensions
557 (p_commit IN VARCHAR2 := FND_API.G_TRUE,
558 p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
559 x_err_code OUT NOCOPY VARCHAR2
560 );
561
562 -- 100.5 Encrypt_Security_Code
563 --
564 -- Function : Encrypt_Security_Code
565 -- Type : Private
566 -- Purpose : Encrypts the security code passed
567 --
568 PROCEDURE Encrypt_Security_Code
569 (p_commit IN VARCHAR2 := FND_API.G_TRUE,
570 p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
571 p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
572 x_segment_id OUT NOCOPY NUMBER,
573 x_err_code OUT NOCOPY VARCHAR2
574 );
575
576 -- 101. Decrypt_Extensions
577 --
578 -- Function : Decrypt_Extensions
579 -- Type : Private
580 -- Purpose : Decrypts transaction extensions
581 --
582 PROCEDURE Decrypt_Extensions
583 (p_commit IN VARCHAR2 := FND_API.G_TRUE,
584 p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
585 x_err_code OUT NOCOPY VARCHAR2
586 );
587
588 -- 101.5
589 --
590 -- Function : Get_Security_Code
591 -- Type : Private
592 -- Purpose : Gets the clear-text instrument security code
593 -- for a given segment_id
594 --
595 FUNCTION Get_Security_Code
596 (
597 p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE,
598 p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE,
599 p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
600 )
601 RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
602
603 -- 102.
604 --
605 -- Function : Get_Security_Code
606 -- Type : Private
607 -- Purpose : Gets the clear-text instrument security code
608 -- for a given extension_id
609 --
610 FUNCTION Get_Security_Code
611 (
612 p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
613 p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
614 )
615 RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
616
617 -- 102.5
618 -- Function : Get_Security_Code
619 -- Type : Private
620 -- Purpose : Gets the clear-text instrument security code
621 --
622 FUNCTION Get_Security_Code
623 (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
624 p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
625 p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
626 p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
627 )
628 RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
629
630 -- 103.
631 --
632 -- Function : Get_Tangible_Id
633 -- Type : Private
634 -- Purpose : Generates the tangible id
635 -- This function has been kept for backward
636 -- data compatibility. The overloaded API would
637 -- be used for new orders.
638 --
639 FUNCTION Get_Tangible_Id
640 (p_app_short_name IN fnd_application.application_short_name%TYPE,
641 p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
642 p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
643 p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
644 )
645 RETURN iby_trxn_summaries_all.tangibleid%TYPE;
646
647 -- 104.
648 --
649 -- Function : Get_Tangible_Id
650 -- Type : Private
651 -- Purpose : Generates the tangible id using the application
652 -- short name and the trxn_extension_id.
653 --
654 --Overloading this function for bug : 7628586
655 FUNCTION Get_Tangible_Id
656 (p_app_short_name IN fnd_application.application_short_name%TYPE,
657 p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
658 )
659 RETURN iby_trxn_summaries_all.tangibleid%TYPE;
660
661 /*--------------------------------------------------------------------
662 | NAME:
663 | print_debuginfo
664 |
665 | PURPOSE:
666 | This procedure prints the debug message to the concurrent manager
667 | log file.
668 |
669 | PARAMETERS:
670 | IN
671 | p_debug_text - The debug message to be printed
672 |
673 | OUT
674 |
675 |
676 | RETURNS:
677 |
678 | NOTES:
679 |
680 *---------------------------------------------------------------------*/
681 PROCEDURE print_debuginfo(
682 p_module IN VARCHAR2,
683 p_debug_text IN VARCHAR2
684 );
685
686 /*--------------------------------------------------------------------
687 | NAME:
688 | get_le_from_bankacct_id
689 |
690 |
691 | PURPOSE:
692 |
693 |
694 | PARAMETERS:
695 | IN
696 |
697 |
698 | OUT
699 |
700 |
701 | RETURNS:
702 |
703 | NOTES:
704 |
705 *---------------------------------------------------------------------*/
706 FUNCTION get_le_from_bankacct_id(
707 l_intbankacct_id IN IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE)
708 RETURN NUMBER;
709
710
711 END IBY_FNDCPT_TRXN_PUB;