1 PACKAGE cn_pmt_trans_pvt AS
2 -- $Header: cnvpmtrs.pls 120.11 2006/01/20 18:52:06 fmburu ship $
3 G_HOLD_ALL CONSTANT VARCHAR2 (20) := 'HOLD_ALL' ;
4 G_RELEASE_ALL CONSTANT VARCHAR2 (20) := 'RELEASE_ALL' ;
5 G_RESET_TO_UNPAID CONSTANT VARCHAR2 (20) := 'RESET_TO_UNPAID' ;
6
7 TYPE pmt_tran_rec IS RECORD (
8 payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
9 amount cn_payment_transactions.amount%TYPE,
10 payment_amount cn_payment_transactions.payment_amount%TYPE,
11 payment_diff cn_payment_transactions.payment_amount%TYPE,
12 quota_id cn_payment_transactions.quota_id%TYPE,
13 quota_name cn_quotas.NAME%TYPE,
14 incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,
15 incentive_type cn_lookups.meaning%TYPE,
16 hold_flag cn_payment_transactions.hold_flag%TYPE,
17 hold_flag_desc cn_lookups.meaning%TYPE,
18 waive_flag cn_payment_transactions.waive_flag%TYPE,
19 waive_flag_desc cn_lookups.meaning%TYPE,
20 pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
21 pay_element_name pay_element_types_f.element_name%TYPE,
22 recoverable_flag cn_payment_transactions.recoverable_flag%TYPE,
23 recoverable_flag_desc cn_lookups.meaning%TYPE
24 );
25
26 TYPE pmt_tran_tbl IS TABLE OF pmt_tran_rec
27 INDEX BY BINARY_INTEGER;
28
29 TYPE pmt_process_rec IS RECORD (
30 p_action VARCHAR2(250),
31 payrun_id cn_payment_transactions.payrun_id%TYPE,
32 salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,
33 worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
34 quota_id cn_quotas.quota_id%TYPE,
35 revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
36 invoice_number VARCHAR2(4000),
37 order_number NUMBER,
38 customer VARCHAR2(4000),
39 hold_flag cn_payment_transactions.hold_flag%TYPE,
40 request_id NUMBER,
41 org_id NUMBER,
42 object_version_number NUMBER,
43 is_processing VARCHAR2(30) := 'NO'
44 ) ;
45
46 TYPE pmt_process_tbl IS TABLE OF pmt_process_rec
47 INDEX BY BINARY_INTEGER;
48
49 --============================================================================
50 -- Start of Comments
51 --
52 -- API name : Update_Pmt_Transactons
53 -- Type : Private.
54 -- Pre-reqs : None.
55 -- Usage : To update the Payment Transaction and Worksheets
56 -- Parameters :
57 -- IN : p_api_version IN NUMBER Require
58 -- p_init_msg_list IN VARCHAR2 Optional
59 -- Default = FND_API.G_FALSE
60 -- p_commit IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_validation_level IN NUMBER Optional
63 -- Default = FND_API.G_VALID_LEVEL_FULL
64 -- OUT : x_return_status OUT VARCHAR2(1)
65 -- x_msg_count OUT NUMBER
66 -- x_msg_data OUT VARCHAR2(2000)
67 -- IN : p_payment_transaction_id IN NUMBER
68 -- IN : p_hold_flag IN VARCHAR2(01)
69 -- IN : P_payment_amount IN NUMBER
70 -- IN : P_recoverable_flag IN Varchar2(01)
71 -- IN : p_waive_flag IN Varchar2(01)
72 -- IN : p_incentive_type_code IN Varchar2
73 -- OUT : x_loading_status OUT
74 -- Detailed Error Message
75 -- Version : Current version 1.0
76 -- Initial version 1.0
77 --
78 -- End of comments
79 --============================================================================
80 PROCEDURE update_pmt_transactions (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2,
83 p_commit IN VARCHAR2,
84 p_validation_level IN NUMBER,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
89 p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90 p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91 p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92 p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93 p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94 p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
95 p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
96 x_status OUT NOCOPY VARCHAR2,
97 x_loading_status OUT NOCOPY VARCHAR2,
98 --R12
99 p_org_id IN cn_payment_transactions.org_id%TYPE,
100 p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE
101 );
102
103 --============================================================================
104 -- Start of Comments
105 --
106 -- API name : Create_Pmt_Transactons
107 -- Type : Private.
108 -- Pre-reqs : None.
109 -- Usage : To create new records in cn_payment_transactions
110 -- Parameters :
111 -- IN : p_api_version IN NUMBER Require
112 -- p_init_msg_list IN VARCHAR2 Optional
113 -- Default = FND_API.G_FALSE
114 -- p_commit IN VARCHAR2 Optional
115 -- Default = FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Optional
117 -- Default = FND_API.G_VALID_LEVEL_FULL
118 -- OUT : x_return_status OUT VARCHAR2(1)
119 -- x_msg_count OUT NUMBER
120 -- x_msg_data OUT VARCHAR2(2000)
121 -- IN : p_salesrep_id IN NUMBER
122 -- IN : p_payrun_id IN NUMBER
123 -- IN : P_payment_amount IN NUMBER
124 -- IN : p_recoverable_flag IN VARCHAR2,
125 -- OUT : x_status OUT VARCHAR2,
126 -- OUT : x_loading_status OUT
127 -- Detailed Error Message
128 -- Version : Current version 1.0
129 -- Initial version 1.0
130 --
131 -- End of comments
132 --============================================================================
133 PROCEDURE create_pmt_transactions (
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2,
136 p_commit IN VARCHAR2,
137 p_validation_level IN NUMBER,
138 p_payrun_id IN NUMBER,
139 p_salesrep_id IN NUMBER,
140 p_incentive_type_code IN VARCHAR2,
141 p_recoverable_flag IN VARCHAR2,
142 p_payment_amount IN NUMBER,
143 p_quota_id IN NUMBER,
144 p_org_id IN cn_payment_transactions.org_id%TYPE,
145 p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,
146 x_pmt_transaction_id OUT NOCOPY NUMBER,
147 x_status OUT NOCOPY VARCHAR2,
148 x_loading_status OUT NOCOPY VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2) ;
152
153 --=====================================================================
154 -- Start of Comments
155 --
156 -- API name : Delete_Pmt_Transactons
157 -- Type : Private.
158 -- Pre-reqs : None.
159 -- Usage : To delete the cn_payment_transactions only manual pmt
160 -- Parameters :
161 -- IN : p_api_version IN NUMBER Require
162 -- p_init_msg_list IN VARCHAR2 Optional
163 -- Default = FND_API.G_FALSE
164 -- p_commit IN VARCHAR2 Optional
165 -- Default = FND_API.G_FALSE
166 -- p_validation_level IN NUMBER Optional
167 -- Default = FND_API.G_VALID_LEVEL_FULL
168 -- OUT : x_return_status OUT VARCHAR2(1)
169 -- x_msg_count OUT NUMBER
170 -- x_msg_data OUT VARCHAR2(2000)
171 -- IN : p_payment_transaction_id IN NUMBER
172 -- OUT : x_status OUT VARCHAR2,
173 -- OUT : x_loading_status OUT
174 -- Detailed Error Message
175 -- Version : Current version 1.0
176 -- Initial version 1.0
177 --
178 -- End of comments
179 --============================================================================
180 PROCEDURE delete_pmt_transactions (
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2,
183 p_commit IN VARCHAR2,
184 p_validation_level IN NUMBER,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_payment_transaction_id IN NUMBER,
189 p_validation_only IN VARCHAR2,
190 x_status OUT NOCOPY VARCHAR2,
191 x_loading_status OUT NOCOPY VARCHAR2,
192 p_ovn IN NUMBER
193 );
194
195 --=====================================================================
196 -- Start of Comments
197 --
198 -- API name : release_wksht_hold
199 -- Type : Public.
200 -- Pre-reqs : None.
201 -- Usage : To release the payment holds at worksheet level.
202 -- Parameters :
203 -- IN : p_api_version IN NUMBER Require
204 -- p_init_msg_list IN VARCHAR2 Optional
205 -- Default = FND_API.G_FALSE
206 -- p_commit IN VARCHAR2 Optional
207 -- Default = FND_API.G_FALSE
208 -- p_validation_level IN NUMBER Optional
209 -- Default = FND_API.G_VALID_LEVEL_FULL
210 -- OUT : x_return_status OUT VARCHAR2(1)
211 -- x_msg_count OUT NUMBER
212 -- x_msg_data OUT VARCHAR2(2000)
213 -- IN : p_payment_worksheet_id IN NUMBER
214 -- OUT : x_status OUT VARCHAR2,
215 -- OUT : x_loading_status OUT
216 -- Detailed Error Message
217 -- Version : Current version 1.0
218 -- Initial version 1.0
219 --11.5.10
220 -- End of comments
221 --============================================================================
222 PROCEDURE release_wksht_hold (
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2,
225 p_commit IN VARCHAR2,
226 p_validation_level IN NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_payment_worksheet_id IN NUMBER
231 );
232
233 --============================================================================
234 -- Start of Comments
235 --
236 -- API name : process_pmt_transactions
237 -- Type : Private.
238 -- Pre-reqs : None.
239 -- Usage : submits the hold all concurrent program.
240 -- Parameters :
241 -- IN : p_api_version IN NUMBER Require
242 -- p_init_msg_list IN VARCHAR2 Optional
243 -- Default = FND_API.G_FALSE
244 -- p_commit IN VARCHAR2 Optional
245 -- Default = FND_API.G_FALSE
246 -- p_validation_level IN NUMBER Optional
247 -- Default = FND_API.G_VALID_LEVEL_FULL
248 -- IN : p_payrun_id IN NUMBER
249 -- IN : p_salesrep_id IN VARCHAR2(01)
250 -- IN : p_quota_id IN NUMBER
251 -- IN : p_revenue_class_id IN Varchar2(01)
252 -- IN : p_invoice_number IN Varchar2(01)
253 -- IN : p_customer IN Varchar2
254 -- IN : p_hold_flag IN Varchar2
255 -- IN : p_action IN Varchar2
256 -- Detailed Error Message
257 -- Version : Current version 1.0
258 -- Initial version 1.0
259 --
260 -- End of comments
261 --============================================================================
262 PROCEDURE process_pmt_transactions (
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
265 p_commit IN VARCHAR2 := fnd_api.g_false,
266 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
267 p_rec IN OUT NOCOPY pmt_process_rec,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2
271 ) ;
272
273 --============================================================================
274 -- Start of Comments
275 --
276 -- API name : hold_multiple_trans_conc
277 -- Type : Private.
278 -- Pre-reqs : None.
279 -- Usage : Procedure which will be used as the executable for the
280 -- concurrent program.
281 -- Parameters :
282 -- IN : p_api_version IN NUMBER Require
283 -- OUT : errbuf OUT VARCHAR2(1)
284 -- retcode OUT NUMBER
285 -- IN : p_payrun_id IN NUMBER
286 -- IN : p_salesrep_id IN VARCHAR2(01)
287 -- IN : p_quota_id IN NUMBER
288 -- IN : p_revenue_class_id IN Varchar2(01)
289 -- IN : p_invoice_number IN Varchar2(01)
290 -- IN : p_incentive_type_code IN Varchar2
291 -- Detailed Error Message
292 -- Version : Current version 1.0
293 -- Initial version 1.0
294 --
295 -- End of comments
296 --============================================================================
297 PROCEDURE hold_multiple_trans_conc (
298 errbuf OUT NOCOPY VARCHAR2,
299 retcode OUT NOCOPY NUMBER,
300 p_payrun_id IN NUMBER,
301 p_salesrep_id IN NUMBER,
302 p_quota_id IN NUMBER,
303 p_revenue_class_id IN NUMBER,
304 p_invoice_number IN VARCHAR2,
308 p_action IN VARCHAR2
305 p_order_number IN NUMBER,
306 p_customer IN VARCHAR2,
307 p_hold_flag IN VARCHAR2,
309 );
310
311 END cn_pmt_trans_pvt;