[Home] [Help]
PACKAGE: APPS.IBY_FNDCPT_TRXN_PUB
Source
1 PACKAGE IBY_FNDCPT_TRXN_PUB AS
2 /*$Header: ibyfctxs.pls 120.18.12010000.5 2009/01/15 14:52:03 lmallick 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
28 G_RC_DUPLICATE_SETTLEMENT CONSTANT VARCHAR2(30) := 'DUPLICATE_SETTLEMENT';
29 G_RC_AUTH_GROUPING_ERROR CONSTANT VARCHAR2(30) := 'AUTH_GROUPING_ERROR';
30 G_RC_INVALID_AMOUNT CONSTANT VARCHAR2(30) := 'INVALID_AMOUNT';
31
32
33
34
35 -------------------------------------------------------------------------
36 -- II. Common Record Types
37 -------------------------------------------------------------------------
38
39 TYPE PayeeContext_rec_type IS RECORD
40 (
41 Org_Type VARCHAR2(30),
42 Org_Id NUMBER
43 );
44
45 TYPE TrxnExtension_rec_type IS RECORD
46 (
47 Originating_Application_Id NUMBER,
48 Order_Id VARCHAR2(75),
49 PO_Number VARCHAR2(100),
50 PO_Line_Number VARCHAR2(25),
51 Trxn_Ref_Number1 VARCHAR2(20),
52 Trxn_Ref_Number2 VARCHAR2(20),
53 Instrument_Security_Code VARCHAR2(30),
54 VoiceAuth_Flag VARCHAR2(1),
55 VoiceAuth_Date DATE,
56 VoiceAuth_Code VARCHAR2(100),
57 Additional_Info VARCHAR2(255),
58 Copy_Instr_Assign_Id NUMBER
59 );
60
61 TYPE Amount_rec_type IS RECORD
62 (
63 Value NUMBER,
64 Currency_Code VARCHAR2(15)
65 );
66
67 TYPE AuthAttribs_rec_type IS RECORD
68 (
69 Payment_Factor_Flag VARCHAR2(1),
70 Memo VARCHAR2(80),
71 Order_Medium VARCHAR2(30),
72 Tax_Amount Amount_rec_type,
73 ShipFrom_SiteUse_Id NUMBER,
74 ShipFrom_PostalCode VARCHAR2(80),
75 ShipTo_SiteUse_Id NUMBER,
76 ShipTo_PostalCode VARCHAR2(80),
77 RiskEval_Enable_Flag VARCHAR2(1)
78 );
79
80 TYPE ReceiptAttribs_rec_type IS RECORD
81 (
82 Settlement_Date DATE,
83 Settlement_Due_Date DATE := NULL
84 );
85
86 TYPE RiskResult_rec_type IS RECORD
87 (
88 Risk_Score NUMBER,
89 Risk_Threshold_Val NUMBER,
90 Risky_Flag VARCHAR2(1)
91 );
92
93 TYPE AuthResult_rec_type IS RECORD
94 (
95 Auth_Id NUMBER,
96 Auth_Date DATE,
97 Auth_Code VARCHAR2(80),
98 AVS_Code VARCHAR2(80),
99 Instr_SecCode_Check VARCHAR2(5),
100 PaymentSys_Code VARCHAR2(40),
101 PaymentSys_Msg VARCHAR2(255),
102 Risk_Result RiskResult_rec_type
103 );
104
105
106
107
108 TYPE SettlementResult_rec_type IS RECORD (
109 Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,
110 Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
111 );
112
113
114 -- II.2 Table Types
115
116 TYPE SettlementResult_tbl_type IS TABLE OF SettlementResult_rec_type
117 INDEX BY BINARY_INTEGER;
118
119 ------------------------------------------------------------------------------
120 -- III. API Signatures
121 ------------------------------------------------------------------------------
122
123
124 -- 1. Create_Transaction_Extension
125 --
126 -- API name : Create_Transaction_Extension
127 -- Type : Public
128 -- Pre-reqs : None
129 -- Function : Creates a transaction extension entity
130 -- Current version : 1.0
131 -- Previous version: 1.0
132 -- Initial version : 1.0
133 --
134 PROCEDURE Create_Transaction_Extension
135 (
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_TRUE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
143 p_payer_equivalency IN VARCHAR2 :=
144 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
145 p_pmt_channel IN VARCHAR2,
146 p_instr_assignment IN NUMBER,
147 p_trxn_attribs IN TrxnExtension_rec_type,
148 x_entity_id OUT NOCOPY NUMBER,
149 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
150 );
151
152 -- 2. Update_Transaction_Extension
153 --
154 -- API name : Update_Transaction_Extension
155 -- Type : Public
156 -- Pre-reqs : None
157 -- Function : Update a transaction extension entity's attributes
158 -- Current version : 1.0
159 -- Previous version: 1.0
160 -- Initial version : 1.0
161 --
162 PROCEDURE Update_Transaction_Extension
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_equivalency IN VARCHAR2 :=
172 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
173 p_entity_id IN NUMBER,
174 p_pmt_channel IN VARCHAR2,
175 p_instr_assignment IN NUMBER,
176 p_trxn_attribs IN TrxnExtension_rec_type,
177 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
178 );
179
180 -- 3. Get_Transaction_Extension
181 --
182 -- API name : Get_Transaction_Extension
183 -- Type : Public
184 -- Pre-reqs : None
185 -- Function : Queries a transaction extension entity's attributes
186 -- Current version : 1.0
187 -- Previous version: 1.0
188 -- Initial version : 1.0
189 --
190 PROCEDURE Get_Transaction_Extension
191 (
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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_entity_id IN NUMBER,
199 x_trxn_attribs OUT NOCOPY TrxnExtension_rec_type,
200 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
201 );
202
203 -- 4. Copy_Transaction_Extension
204 --
205 -- API name : Copy_Transaction_Extension
206 -- Type : Public
207 -- Pre-reqs : None
208 -- Function : Copies a transaction extension, along with all the
209 -- associated operations done to it; merge version of
210 -- the API
211 -- Current version : 1.0
212 -- Previous version: 1.0
213 -- Initial version : 1.0
214 --
215 PROCEDURE Copy_Transaction_Extension
216 (
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219 p_commit IN VARCHAR2 := FND_API.G_TRUE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
224 p_payer_equivalency IN VARCHAR2 :=
225 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
226 p_entities IN IBY_FNDCPT_COMMON_PUB.Id_tbl_type,
227 p_trxn_attribs IN TrxnExtension_rec_type,
228 x_entity_id OUT NOCOPY NUMBER,
229 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
230 );
231
232 -- 5. Delete_Transaction_Extension
233 --
234 -- API name : Delete_Transaction_Extension
235 -- Type : Public
236 -- Pre-reqs : None
237 -- Function : Deletes/purges a transaction extension entity
238 -- Current version : 1.0
239 -- Previous version: 1.0
240 -- Initial version : 1.0
241 --
242 PROCEDURE Delete_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_entity_id IN NUMBER,
254 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
255 );
256
257 -- 6. Create_Authorization
258 --
259 -- API name : Create_Authorization
260 -- Type : Public
261 -- Pre-reqs : None
262 -- Function : Creates an authorization
263 -- Current version : 1.0
264 -- Previous version: 1.0
265 -- Initial version : 1.0
266 --
267 PROCEDURE Create_Authorization
268 (
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
275 p_payer_equivalency IN VARCHAR2 :=
276 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
277 p_payee IN PayeeContext_rec_type,
278 p_trxn_entity_id IN NUMBER,
279 p_auth_attribs IN AuthAttribs_rec_type,
280 p_amount IN Amount_rec_type,
281 x_auth_result OUT NOCOPY AuthResult_rec_type,
282 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
283 );
284
285 -- 7. Get_Authorization
286 --
287 -- API name : Get_Authorization
288 -- Type : Public
289 -- Pre-reqs : None
290 -- Function : Queries an authorization
291 -- Current version : 1.0
292 -- Previous version: 1.0
293 -- Initial version : 1.0
294 --
295 PROCEDURE Get_Authorization
296 (
297 p_api_version IN NUMBER,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
303 p_trxn_entity_id IN NUMBER,
304 x_auth_result OUT NOCOPY AuthResult_rec_type,
305 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
306 );
307
308 -- 8. Cancel_Authorization
309 --
310 -- API name : Cancel_Authorization
311 -- Type : Public
312 -- Pre-reqs : None
313 -- Function : Cancels an authorization
314 -- Current version : 1.0
315 -- Previous version: 1.0
316 -- Initial version : 1.0
317 --
318 PROCEDURE Cancel_Authorization
319 (
320 p_api_version IN NUMBER,
321 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_count OUT NOCOPY NUMBER,
324 x_msg_data OUT NOCOPY VARCHAR2,
325 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
326 p_auth_id IN NUMBER,
327 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
328 );
329
330
331 -- 9. Create_Settlement
332 --
333 -- API name : Create_Settlement
334 -- Type : Public
335 -- Pre-reqs : None
336 -- Function : Creates a settlement
337 -- Current version : 1.0
338 -- Previous version: 1.0
339 -- Initial version : 1.0
340 --
341 PROCEDURE Create_Settlement
342 (
343 p_api_version IN NUMBER,
344 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
349 p_payer_equivalency IN VARCHAR2 :=
350 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
351 p_trxn_entity_id IN NUMBER,
352 p_amount IN Amount_rec_type,
353 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
354 );
355
356
357 -- 9.5 Create_Settlement (Overloaded)
358 -- Accepts ReceiptAttribs_rec_type as an additional
359 -- IN parameter
360 --
361 -- API name : Create_Settlement
362 -- Type : Public
363 -- Pre-reqs : None
364 -- Function : Creates a settlement
365 -- Current version : 1.0
366 -- Previous version: 1.0
367 -- Initial version : 1.0
368 --
369 PROCEDURE Create_Settlement
370 (
371 p_api_version IN NUMBER,
372 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373 x_return_status OUT NOCOPY VARCHAR2,
374 x_msg_count OUT NOCOPY NUMBER,
375 x_msg_data OUT NOCOPY VARCHAR2,
376 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
377 p_payer_equivalency IN VARCHAR2 :=
378 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
379 p_trxn_entity_id IN NUMBER,
380 p_amount IN Amount_rec_type,
381 p_receipt_attribs IN ReceiptAttribs_rec_type,
382 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
383 );
384
385
386 -- 13. Create_Return
387 --
388 -- API name : Create_Return
389 -- Type : Public
390 -- Pre-reqs : None
391 -- Function : Creates a return
392 -- Current version : 1.0
393 -- Previous version: 1.0
394 -- Initial version : 1.0
395 --
396 PROCEDURE Create_Return
397 (
398 p_api_version IN NUMBER,
399 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400 x_return_status OUT NOCOPY VARCHAR2,
401 x_msg_count OUT NOCOPY NUMBER,
402 x_msg_data OUT NOCOPY VARCHAR2,
403 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
404 p_payer_equivalency IN VARCHAR2 :=
405 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
406 p_trxn_entity_id IN NUMBER,
407 p_amount IN Amount_rec_type,
408 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
409 );
410
411 -- 13.5 Create_Return (Overloaded)
412 -- Accepts ReceiptAttribs_rec_type as an additional
413 -- IN parameter
414 --
415 -- API name : Create_Return
416 -- Type : Public
417 -- Pre-reqs : None
418 -- Function : Creates a return
419 -- Current version : 1.0
420 -- Previous version: 1.0
421 -- Initial version : 1.0
422 --
423 PROCEDURE Create_Return
424 (
425 p_api_version IN NUMBER,
426 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
427 x_return_status OUT NOCOPY VARCHAR2,
428 x_msg_count OUT NOCOPY NUMBER,
429 x_msg_data OUT NOCOPY VARCHAR2,
430 p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
431 p_payer_equivalency IN VARCHAR2 :=
432 IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
433 p_trxn_entity_id IN NUMBER,
434 p_amount IN Amount_rec_type,
435 p_receipt_attribs IN ReceiptAttribs_rec_type,
436 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
437 );
438
439 -- 14. Create_Settlements
440 --
441 -- API name : create_settlements
442 -- Type : Public
443 -- Pre-reqs : None
444 -- Function : Pick up bulk settlment data from the the application
445 -- views to insert the settlement record in
446 -- IBY_TRXN_SUMMARIES_ALL
447 -- Current version : 1.0
448 -- Previous version: 1.0
449 -- Initial version : 1.0
450 --
451 PROCEDURE Create_Settlements (
452 p_api_version IN NUMBER,
453 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
454 p_calling_app_id IN NUMBER,
455 p_calling_app_request_code IN
456 IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
457 p_order_view_name IN VARCHAR2,
458 x_return_status OUT NOCOPY VARCHAR2,
459 x_msg_count OUT NOCOPY NUMBER,
460 x_msg_data OUT NOCOPY VARCHAR2,
461 x_responses OUT NOCOPY SettlementResult_tbl_type
462 );
463
464
465 -- 100. Encrypt_Extensions
466 --
467 -- Function : Encrypt_Extensions
468 -- Type : Private
469 -- Purpose : Encrypts transaction extensions
470 --
471 PROCEDURE Encrypt_Extensions
472 (p_commit IN VARCHAR2 := FND_API.G_TRUE,
473 p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
474 x_err_code OUT NOCOPY VARCHAR2
475 );
476
477 -- 100.5 Encrypt_Security_Code
478 --
479 -- Function : Encrypt_Security_Code
480 -- Type : Private
481 -- Purpose : Encrypts the security code passed
482 --
483 PROCEDURE Encrypt_Security_Code
484 (p_commit IN VARCHAR2 := FND_API.G_TRUE,
485 p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
486 p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
487 x_segment_id OUT NOCOPY NUMBER,
488 x_err_code OUT NOCOPY VARCHAR2
489 );
490
491 -- 101. Decrypt_Extensions
492 --
493 -- Function : Decrypt_Extensions
494 -- Type : Private
495 -- Purpose : Decrypts transaction extensions
496 --
497 PROCEDURE Decrypt_Extensions
498 (p_commit IN VARCHAR2 := FND_API.G_TRUE,
499 p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
500 x_err_code OUT NOCOPY VARCHAR2
501 );
502
503 -- 102.
504 --
505 -- Function : Get_Security_Code
506 -- Type : Private
507 -- Purpose : Gets the clear-text instrument security code
508 --
509 FUNCTION Get_Security_Code
510 (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
511 p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
512 )
513 RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
514
515 -- 102.5
516 -- Function : Get_Security_Code
517 -- Type : Private
518 -- Purpose : Gets the clear-text instrument security code
519 --
520 FUNCTION Get_Security_Code
521 (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
522 p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
523 p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
524 p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
525 )
526 RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
527
528 -- 103.
529 --
530 -- Function : Get_Tangible_Id
531 -- Type : Private
532 -- Purpose : Generates the tangible id
533 -- This function has been kept for backward
534 -- data compatibility. The overloaded API would
535 -- be used for new orders.
536 --
537 FUNCTION Get_Tangible_Id
538 (p_app_short_name IN fnd_application.application_short_name%TYPE,
539 p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
540 p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
541 p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
542 )
543 RETURN iby_trxn_summaries_all.tangibleid%TYPE;
544
545 -- 104.
546 --
547 -- Function : Get_Tangible_Id
548 -- Type : Private
549 -- Purpose : Generates the tangible id using the application
550 -- short name and the trxn_extension_id.
551 --
552 --Overloading this function for bug : 7628586
553 FUNCTION Get_Tangible_Id
554 (p_app_short_name IN fnd_application.application_short_name%TYPE,
555 p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
556 )
557 RETURN iby_trxn_summaries_all.tangibleid%TYPE;
558
559 /*--------------------------------------------------------------------
560 | NAME:
561 | print_debuginfo
562 |
563 | PURPOSE:
564 | This procedure prints the debug message to the concurrent manager
565 | log file.
566 |
567 | PARAMETERS:
568 | IN
569 | p_debug_text - The debug message to be printed
570 |
571 | OUT
572 |
573 |
574 | RETURNS:
575 |
576 | NOTES:
577 |
578 *---------------------------------------------------------------------*/
579 PROCEDURE print_debuginfo(
580 p_module IN VARCHAR2,
581 p_debug_text IN VARCHAR2
582 );
583
584 /*--------------------------------------------------------------------
585 | NAME:
586 | get_le_from_bankacct_id
587 |
588 |
589 | PURPOSE:
590 |
591 |
592 | PARAMETERS:
593 | IN
594 |
595 |
596 | OUT
597 |
598 |
599 | RETURNS:
600 |
601 | NOTES:
602 |
603 *---------------------------------------------------------------------*/
604 FUNCTION get_le_from_bankacct_id(
605 l_intbankacct_id IN IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE)
606 RETURN NUMBER;
607
608
609 END IBY_FNDCPT_TRXN_PUB;