PACKAGE: APPS.IBY_IMPORT_PMT_ACK_DATA_PUB

Source

1 PACKAGE IBY_IMPORT_PMT_ACK_DATA_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibyacks.pls 120.3 2011/01/28 07:30:35 sgogula noship $*/
3 
4 
5 
6 ------------------------------------------------------------------------
7 -- I. Constant Declarations
8 ------------------------------------------------------------------------
9 
10 
11 
12 
13 
14 ------------------------------------------------------------------------
15 -- II. Record type(s)
16 ------------------------------------------------------------------------
17 
18 TYPE reject_dtls_rec IS RECORD (
19         BANK_ERROR_CODE          VARCHAR2(80),
20         BANK_ERROR_MESSAGE       VARCHAR2(1024),
21         BANK_ERROR_LOCATION      VARCHAR2(1024)
22         );
23 
24 
25 
26 ------------------------------------------------------------------------
27 -- III. Table type(s)
28 ------------------------------------------------------------------------
29 
30 TYPE Reject_dtls_tbl_type IS TABLE OF reject_dtls_rec INDEX BY BINARY_INTEGER;
31 
32 
33 
34 
35 
36 
37 ------------------------------------------------------------------------
38 -- IV. API Signatures
39 ------------------------------------------------------------------------
40 
41 
42 /*--------------------------------------------------------------------
43  | NAME:
44  |     Create_Acknowlegment
45  |
46  | PURPOSE:
47  |     Creates the acknowledgement record for a payment.
48  |
49  | PARAMETERS:
50  |     IN - Refer the following spec
51  |
52  |     OUT - Refer the following spec
53  | RETURNS: - Refer the following spec
54  |
55  | NOTES:
56  |
57  *---------------------------------------------------------------------*/
58 
59 
60 PROCEDURE Create_Acknowlegment
61 (
62 P_PAYMENT_REF_NUMBER		  IN	NUMBER,
63 P_PMT_INSTRUCTION_REF_NUMBER  IN	NUMBER,
64 P_BANK_STATUS_CODE		  IN	VARCHAR2,
65 P_ACKNOWLEDGEMENT_DATE		  IN	DATE,
66 P_BANK_ASSIGNED_REF_CODE1	  IN	VARCHAR2,
67 P_BANK_ASSIGNED_REF_CODE2	  IN	VARCHAR2,
68 P_PAYER_NAME			  IN	VARCHAR2,
69 P_PAYER_BANK_NAME		  IN	VARCHAR2,
70 P_PAYER_BANK_BRANCH_NAME	  IN	VARCHAR2,
71 P_PAYER_BANK_SWIFT_CODE		  IN	VARCHAR2,
72 P_PAYER_BANK_ACCOUNT_NUMBER	  IN	VARCHAR2,
73 P_PAYER_BANK_IBAN_NUMBER	  IN	VARCHAR2,
74 P_PAYEE_NAME			  IN	VARCHAR2,
75 P_PAYEE_BANK_NAME		  IN	VARCHAR2,
76 P_PAYEE_BANK_BRANCH_NAME	  IN	VARCHAR2,
77 P_PAYEE_BANK_SWIFT_CODE		  IN	VARCHAR2,
78 P_PAYEE_BANK_ACCOUNT_NUMBER	  IN	VARCHAR2,
79 P_PAYEE_BANK_IBAN_NUMBER	  IN	VARCHAR2,
80 P_PAYMENT_AMOUNT		  IN	NUMBER,
81 P_BANK_CHARGE_AMOUNT		  IN	NUMBER,
82 P_PAYMENT_CURRENCY_CODE		  IN	VARCHAR2,
83 P_EXCHANGE_RATE		          IN	NUMBER,
84 P_VALUE_DATE			  IN	DATE,
85 P_REQUESTED_EXECUTION_DATE	  IN	DATE,
86 P_P_REJECT_DTLS_TBL_TYPE	  IN	Reject_dtls_tbl_type,
87 x_return_status			  OUT NOCOPY VARCHAR2,
88 x_return_message		  OUT NOCOPY VARCHAR2,
89 x_msg_count			  OUT NOCOPY NUMBER
90 );
91 
92 END IBY_IMPORT_PMT_ACK_DATA_PUB;