[Home] [Help]
PACKAGE: APPS.IBY_BANKACCXFR_PUB
Source
1 PACKAGE IBY_BANKACCXFR_PUB AS
2 /*$Header: ibybareqs.pls 120.2 2005/09/15 01:30:23 rameshsh noship $ */
3
4 -------------------------------------------------------------------------
5 --**Defining all DataStructures required by the APIs**--
6 -- The following input and output PL/SQL record/table types are defined
7 -- to store the objects (entities) necessary for the EC-App PL/SQL APIs.
8 -------------------------------------------------------------------------
9
10 --INPUT DataStructures
11
12
13 TYPE BankAccXfrReq_Rec_Type IS RECORD (
14 PmtInstrType VARCHAR2(80),
15 Org_ID NUMBER,
16 EcappId VARCHAR2(80),
17 ECBatch_ID VARCHAR2(80),
18 Payee_Instr_ID VARCHAR2(80),
19 NLS_LANG VARCHAR2(80)
20 );
21
22 TYPE BankAccXfrTrxnReq_Rec_Type IS RECORD (
23 Payer_Instr_ID VARCHAR2(80),
24 Payer_Name VARCHAR2(80),
25 PmtInstrSubType VARCHAR2(80),
26 Tangible_ID VARCHAR2(80),
27 Tangible_Amount NUMBER,
28 Currency_Code VARCHAR2(80),
29 RefInfo VARCHAR2(80),
30 Memo VARCHAR2(80),
31 Settlement_Date DATE,
32 IssueDate DATE,
33 NLS_LANG VARCHAR2(80),
34 OrderMedium VARCHAR2(30),
35 EFTAuthMethod VARCHAR2(30),
36 customerRef VARCHAR2(240)
37 );
38
39 TYPE BankAccXfrTrxn_Tbl_Type IS TABLE of BankAccXfrTrxnReq_Rec_Type INDEX BY BINARY_INTEGER;
40
41 -- OUPUT DataStructures
42
43 TYPE BankAccXfrResp_Rec_Type IS RECORD (
44 Batch_ID VARCHAR2(80),
45 BatchStatus VARCHAR2(80),
46 ErrorCode VARCHAR2(80),
47 ErrorMsg VARCHAR2(80)
48 );
49
50 TYPE BankAccXfrRespDet_Rec_Type IS RECORD (
51 TrxnId VARCHAR2(80),
52 TangibleID VARCHAR2(80),
53 TrxnStatus VARCHAR2(80),
54 TrxnRef VARCHAR2(80),
55 ErrorCode VARCHAR2(80),
56 ErrorMsg VARCHAR2(80)
57 );
58
59 TYPE BankAccXfrRespDet_Tbl_Type IS TABLE of BankAccXfrRespDet_Rec_Type INDEX BY BINARY_INTEGER;
60
61
62 ---------------------------------------------------------------
63 -- API Signatures--
64 ---------------------------------------------------------------
65
66 /* ============================================================================
67 --1. OraPmtBankPayBatchReq
68 -- -----------------------
69 -- Start of comments
70 -- API name : OraPmtBatchReq
71 -- Type : Public
72 -- Pre-reqs : None
73 -- Function : Handles Batch Payment requests from Accounts Receivables
74 -- Parameters:
75 -- IN : p_api_version IN NUMBER,
76 -- p_init_msg_list IN VARCHAR2,
77 -- p_commit IN VARCHAR2,
78 -- p_validation_level IN NUMBER,
79 -- p_payee_id IN VARCHAR2,
80 -- p_ecapp_id IN NUMBER,
81 -- x_return_status OUT VARCHAR2,
82 -- x_msg_count OUT NUMBER,
83 -- x_msg_data OUT VARCHAR2,
84 -- p_pmt_batch_req_rec IN BankAccXfrReq_Rec_Type,
85 -- p_pmt_batch_trxn_tbl IN BankAccXfrTrxn_Tbl_Type,
86 -- x_batch_resp_rec OUT NOCOPY BankAccXfrResp_Rec_Type,
87 -- x_batch_respdet_tbl OUT NOCOPY BankAccXfrRespDet_Tbl_Type
88 -- Version :
89 -- Current version 1.0
90 -- Previous version 1.0
91 -- Initial version 1.0
92 -- End of comments
93 ============================================================================ */
94
95 PROCEDURE OraPmtBatchReq(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100 p_payee_id In VARCHAR2,
101 p_ecapp_id IN NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_batch_req_rec IN BankAccXfrReq_Rec_Type,
106 p_accxfr_trxn_tbl IN BankAccXfrTrxn_Tbl_Type,
107 x_batch_resp_rec OUT NOCOPY BankAccXfrResp_Rec_Type,
108 x_batch_respdet_tbl OUT NOCOPY BankAccXfrRespDet_Tbl_Type
109 ) ;
110
111
112 END IBY_BANKACCXFR_PUB;