1 PACKAGE IBY_CE_BATCH_RECON_PKG AUTHID CURRENT_USER as
2 /* $Header: ibycepis.pls 120.2.12010000.1 2008/07/28 05:39:56 appldev ship $ */
3
4
5 --==========================================================================
6 -- This API will be called by CE for reconciliation at the batch level with
7 -- R12 IBY payment instructions.
8 -- This API models the AP_RECONCILIATION_PKG.Recon_Payment_History() API for
9 -- batch clearing. The API will do proration as AP, then call product APIs
10 -- at transaction (payment) level so they can execute their business logic
11 -- and update their tables.
12 --==========================================================================
13 PROCEDURE Payment_Instruction_Clearing(
14 P_PAYMENT_INSTRUCTION_ID IN NUMBER,
15 P_ACCOUNTING_DATE IN DATE,
16 P_CLEARED_DATE IN DATE,
17 P_TRANSACTION_AMOUNT IN NUMBER, -- in bank curr.
18 P_ERROR_AMOUNT IN NUMBER, -- in bank curr.
19 P_CHARGE_AMOUNT IN NUMBER, -- in bank curr.
20 P_CURRENCY_CODE IN VARCHAR2, -- bank curr. code
21 P_EXCHANGE_RATE_TYPE IN VARCHAR2, -- between payment and functional
22 P_EXCHANGE_RATE_DATE IN DATE, -- between payment and functional
23 P_EXCHANGE_RATE IN NUMBER, -- between payment and functional
24 P_MATCHED_FLAG IN VARCHAR2,
25 P_ACTUAL_VALUE_DATE IN DATE,
26 P_PASSIN_MODE IN VARCHAR2, -- passed back to CE
27 P_STATEMENT_LINE_ID IN NUMBER, -- passed back to CE
28 P_STATEMENT_LINE_TYPE IN VARCHAR2, -- passed back to CE
29 P_LAST_UPDATE_DATE IN DATE,
30 P_LAST_UPDATED_BY IN NUMBER,
31 P_LAST_UPDATE_LOGIN IN NUMBER,
32 P_CREATED_BY IN NUMBER,
33 P_CREATION_DATE IN DATE,
34 P_PROGRAM_UPDATE_DATE IN DATE,
35 P_PROGRAM_APPLICATION_ID IN NUMBER,
36 P_PROGRAM_ID IN NUMBER,
37 P_REQUEST_ID IN NUMBER,
38 P_CALLING_SEQUENCE IN VARCHAR2,
39 P_LOGICAL_GROUP_REFERENCE IN VARCHAR2
40 ) ;
41
42 PROCEDURE Payment_Instruction_Unclearing(
43 P_PAYMENT_INSTRUCTION_ID IN NUMBER,
44 P_ACCOUNTING_DATE IN DATE,
45 P_MATCHED_FLAG IN VARCHAR2,
46 P_LAST_UPDATE_DATE IN DATE,
47 P_LAST_UPDATED_BY IN NUMBER,
48 P_LAST_UPDATE_LOGIN IN NUMBER,
49 P_CREATED_BY IN NUMBER,
50 P_CREATION_DATE IN DATE,
51 P_PROGRAM_UPDATE_DATE IN DATE,
52 P_PROGRAM_APPLICATION_ID IN NUMBER,
53 P_PROGRAM_ID IN NUMBER,
54 P_REQUEST_ID IN NUMBER,
55 P_CALLING_SEQUENCE IN VARCHAR2
56 ) ;
57
58 END IBY_CE_BATCH_RECON_PKG;