1 PACKAGE AP_RECONCILIATION_PKG as
2 /* $Header: aprecons.pls 120.6 2006/12/20 20:13:43 lxzhang noship $ */
3
4 --===================================================================
5 -- Main API for reconciliation
6 --===================================================================
7 PROCEDURE Recon_Payment_History(
8 X_CHECKRUN_ID IN NUMBER,
9 X_CHECK_ID IN NUMBER,
10 X_ACCOUNTING_DATE IN DATE,
11 X_CLEARED_DATE IN DATE,
12 X_TRANSACTION_AMOUNT IN NUMBER,
13 X_TRANSACTION_TYPE IN VARCHAR2,
14 X_ERROR_AMOUNT IN NUMBER,
15 X_CHARGE_AMOUNT IN NUMBER,
16 X_CURRENCY_CODE IN VARCHAR2,
17 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
18 X_EXCHANGE_RATE_DATE IN DATE,
19 X_EXCHANGE_RATE IN NUMBER,
20 X_MATCHED_FLAG IN VARCHAR2,
21 X_ACTUAL_VALUE_DATE IN DATE,
22 X_LAST_UPDATE_DATE IN DATE,
23 X_LAST_UPDATED_BY IN NUMBER,
24 X_LAST_UPDATE_LOGIN IN NUMBER,
25 X_CREATED_BY IN NUMBER,
26 X_CREATION_DATE IN DATE,
27 X_PROGRAM_UPDATE_DATE IN DATE,
28 X_PROGRAM_APPLICATION_ID IN NUMBER,
29 X_PROGRAM_ID IN NUMBER,
30 X_REQUEST_ID IN NUMBER,
31 X_CALLING_SEQUENCE IN VARCHAR2
32 ) ;
33
34 PROCEDURE Recon_Payment_Maturity(
35 X_CHECK_ID IN NUMBER,
36 X_ACCOUNTING_DATE IN DATE,
37 X_TRANSACTION_TYPE IN VARCHAR2,
38 X_TRANSACTION_AMOUNT IN NUMBER,
39 X_CURRENCY_CODE IN VARCHAR2,
40 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
41 X_EXCHANGE_RATE_DATE IN DATE,
42 X_EXCHANGE_RATE IN NUMBER,
43 X_LAST_UPDATE_DATE IN DATE,
44 X_LAST_UPDATED_BY IN NUMBER,
45 X_LAST_UPDATE_LOGIN IN NUMBER,
46 X_CREATED_BY IN NUMBER,
47 X_CREATION_DATE IN DATE,
48 X_PROGRAM_UPDATE_DATE IN DATE,
49 X_PROGRAM_APPLICATION_ID IN NUMBER,
50 X_PROGRAM_ID IN NUMBER,
51 X_REQUEST_ID IN NUMBER,
52 X_CALLING_SEQUENCE IN VARCHAR2
53 ) ;
54
55
56 PROCEDURE Delete_Payment_Maturity (
57 X_CHECK_ID IN NUMBER,
58 X_CALLING_SEQUENCE IN VARCHAR2
59 ) ;
60
61
62 PROCEDURE Recon_Payment_Clearing(
63 X_CHECKRUN_ID IN NUMBER,
64 X_CHECK_ID IN NUMBER,
65 X_ACCOUNTING_DATE IN DATE,
66 X_CLEARED_DATE IN DATE,
67 X_TRANSACTION_TYPE IN VARCHAR2,
68 X_TRX_BANK_AMOUNT IN NUMBER,
69 X_ERRORS_BANK_AMOUNT IN NUMBER,
70 X_CHARGES_BANK_AMOUNT IN NUMBER,
71 X_BANK_CURRENCY_CODE IN VARCHAR2,
72 X_PMT_TO_BASE_XRATE_TYPE IN VARCHAR2,
73 X_PMT_TO_BASE_XRATE_DATE IN DATE,
74 X_PMT_TO_BASE_XRATE IN NUMBER,
75 X_MATCHED_FLAG IN VARCHAR2,
76 X_ACTUAL_VALUE_DATE IN DATE,
77 X_LAST_UPDATE_DATE IN DATE,
78 X_LAST_UPDATED_BY IN NUMBER,
79 X_LAST_UPDATE_LOGIN IN NUMBER,
80 X_CREATED_BY IN NUMBER,
81 X_CREATION_DATE IN DATE,
82 X_PROGRAM_UPDATE_DATE IN DATE,
83 X_PROGRAM_APPLICATION_ID IN NUMBER,
84 X_PROGRAM_ID IN NUMBER,
85 X_REQUEST_ID IN NUMBER,
86 X_CALLING_SEQUENCE IN VARCHAR2
87 ) ;
88
89
90 PROCEDURE Recon_Payment_Unclearing(
91 X_CHECKRUN_ID IN NUMBER,
92 X_CHECK_ID IN NUMBER,
93 X_ACCOUNTING_DATE IN DATE,
94 X_TRANSACTION_TYPE IN VARCHAR2,
95 X_MATCHED_FLAG IN VARCHAR2,
96 X_LAST_UPDATE_DATE IN DATE,
97 X_LAST_UPDATED_BY IN NUMBER,
98 X_LAST_UPDATE_LOGIN IN NUMBER,
99 X_CREATED_BY IN NUMBER,
100 X_CREATION_DATE IN DATE,
101 X_PROGRAM_UPDATE_DATE IN DATE,
102 X_PROGRAM_APPLICATION_ID IN NUMBER,
103 X_PROGRAM_ID IN NUMBER,
104 X_REQUEST_ID IN NUMBER,
105 X_CALLING_SEQUENCE IN VARCHAR2
106 ) ;
107
108 PROCEDURE Insert_Payment_History(
109 X_CHECK_ID IN NUMBER,
110 X_TRANSACTION_TYPE IN VARCHAR2,
111 X_ACCOUNTING_DATE IN DATE,
112 X_TRX_BANK_AMOUNT IN NUMBER,
113 X_ERRORS_BANK_AMOUNT IN NUMBER,
114 X_CHARGES_BANK_AMOUNT IN NUMBER,
115 X_BANK_CURRENCY_CODE IN VARCHAR2,
116 X_BANK_TO_BASE_XRATE_TYPE IN VARCHAR2,
117 X_BANK_TO_BASE_XRATE_DATE IN DATE,
118 X_BANK_TO_BASE_XRATE IN NUMBER,
119 X_TRX_PMT_AMOUNT IN NUMBER,
120 X_ERRORS_PMT_AMOUNT IN NUMBER,
121 X_CHARGES_PMT_AMOUNT IN NUMBER,
122 X_PMT_CURRENCY_CODE IN VARCHAR2,
123 X_PMT_TO_BASE_XRATE_TYPE IN VARCHAR2,
124 X_PMT_TO_BASE_XRATE_DATE IN DATE,
125 X_PMT_TO_BASE_XRATE IN NUMBER,
126 X_TRX_BASE_AMOUNT IN NUMBER,
127 X_ERRORS_BASE_AMOUNT IN NUMBER,
128 X_CHARGES_BASE_AMOUNT IN NUMBER,
129 X_MATCHED_FLAG IN VARCHAR2,
130 X_REV_PMT_HIST_ID IN NUMBER,
131 X_ORG_ID IN NUMBER,
132 X_CREATION_DATE IN DATE,
133 X_CREATED_BY IN NUMBER,
134 X_LAST_UPDATE_DATE IN DATE,
135 X_LAST_UPDATED_BY IN NUMBER,
136 X_LAST_UPDATE_LOGIN IN NUMBER,
137 X_PROGRAM_UPDATE_DATE IN DATE,
138 X_PROGRAM_APPLICATION_ID IN NUMBER,
139 X_PROGRAM_ID IN NUMBER,
140 X_REQUEST_ID IN NUMBER,
141 X_CALLING_SEQUENCE IN VARCHAR2,
142 -- Bug 3343314
143 X_ACCOUNTING_EVENT_ID IN NUMBER DEFAULT NULL,
144 -- Bug fix 5694577
145 x_invoice_adjustment_event_id IN NUMBER DEFAULT NULL
146 );
147
148 FUNCTION UnClear_Check(
149 CC_CHECKRUN_ID IN NUMBER,
150 CC_CHECK_ID IN NUMBER,
151 X_LAST_UPDATE_DATE IN DATE,
152 X_LAST_UPDATED_BY IN NUMBER,
153 X_LAST_UPDATE_LOGIN IN NUMBER
154 )RETURN BOOLEAN ;
155
156 FUNCTION Recon_Update_Check(
157 RU_CHECK_ID IN NUMBER,
158 RU_CLEARED_AMOUNT IN NUMBER,
159 RU_CLEARED_BASE_AMOUNT IN NUMBER,
160 RU_CLEARED_ERROR_AMOUNT IN NUMBER,
161 RU_CLEARED_ERROR_BASE_AMOUNT IN NUMBER,
162 RU_CLEARED_CHARGES_AMOUNT IN NUMBER,
163 RU_CLEARED_CHARGES_BASE_AMOUNT IN NUMBER,
164 RU_CLEARED_DATE IN DATE,
165 RU_CHECK_STATUS IN VARCHAR2,
166 RU_CLEARED_XRATE IN NUMBER,
167 RU_CLEARED_XRATE_TYPE IN VARCHAR2,
168 RU_CLEARED_XRATE_DATE IN DATE,
169 RU_ACTUAL_VALUE_DATE IN DATE,
170 RU_LAST_UPDATED_BY IN NUMBER,
171 RU_LAST_UPDATE_LOGIN IN NUMBER,
172 RU_REQUEST_ID IN NUMBER
173 ) RETURN BOOLEAN;
174
175 FUNCTION Case_Type(
176 X_BANK_CURRENCY IN VARCHAR2,
177 X_PAY_CURRENCY IN VARCHAR2,
178 X_FUNC_CURRENCY IN VARCHAR2
179 ) RETURN VARCHAR2;
180
181 END AP_RECONCILIATION_PKG;