1 PACKAGE OZF_AR_PAYMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvarps.pls 120.3.12020000.2 2012/07/02 08:43:21 arpchakr ship $ */
3
4 ------------------------------------------------------------------
5 -- PROCEDURE
6 -- Pay_Deduction
7 --
8 -- PURPOSE
9 -- An API to handle all kinds of payment for deduction.
10 --
11 -- PARAMETERS
12 -- p_claim_id: claim identifier.
13 --
14 -- NOTES
15 ------------------------------------------------------------------
16 PROCEDURE Create_AR_Payment(
17 p_api_version IN NUMBER
18 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
19 ,p_commit IN VARCHAR2 := FND_API.g_false
20 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
21
22 ,x_return_status OUT NOCOPY VARCHAR2
23 ,x_msg_data OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25
26 ,p_claim_id IN NUMBER
27 );
28
29
30
31
32 PROCEDURE Query_Claim(
33 p_claim_id IN NUMBER
34 ,x_claim_rec OUT NOCOPY OZF_Claim_PVT.claim_rec_type
35 ,x_return_status OUT NOCOPY VARCHAR2
36 );
37
38
39 PROCEDURE Unapply_Claim_Investigation(
40 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
41 ,p_reapply_amount IN NUMBER
42
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 );
47
48
49 PROCEDURE Apply_On_Account_Credit(
50 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
51 ,p_credit_amount IN NUMBER DEFAULT NULL
52
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 );
57
58 PROCEDURE Unapply_from_Receipt(
59 p_cash_receipt_id IN NUMBER
60 ,p_customer_trx_id IN NUMBER
61
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 );
66
67 PROCEDURE Apply_on_Receipt(
68 p_cash_receipt_id IN NUMBER
69 ,p_receipt_number IN VARCHAR2 DEFAULT NULL
70 ,p_customer_trx_id IN NUMBER
71 ,p_trx_number IN VARCHAR2 DEFAULT NULL
72 ,p_new_applied_amount IN NUMBER
73 ,p_new_applied_from_amount IN NUMBER DEFAULT NULL --Bug4684931
74 ,p_comments IN VARCHAR2 DEFAULT NULL
75 ,p_payment_set_id IN NUMBER DEFAULT NULL
76 ,p_application_ref_type IN VARCHAR2 DEFAULT NULL
77 ,p_application_ref_id IN NUMBER DEFAULT NULL
78 ,p_application_ref_num IN VARCHAR2 DEFAULT NULL
79 ,p_secondary_application_ref_id IN NUMBER DEFAULT NULL
80 ,p_application_ref_reason IN VARCHAR2 DEFAULT NULL
81 ,p_customer_reference IN VARCHAR2 DEFAULT NULL
82 ,p_apply_date IN DATE DEFAULT NULL -- Fix for Bug 3091401. TM passes old apply date
83 ,p_claim_id IN NUMBER -- Added For Rule Based Settlement
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 );
88
89 PROCEDURE Update_dispute_amount(
90 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
91 ,p_dispute_amount IN NUMBER
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_data OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 );
96
97 PROCEDURE Create_AR_Credit_Memo(
98 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
99 ,p_customer_trx_id IN NUMBER
100 ,p_deduction_type IN VARCHAR2
101 ,p_line_remaining IN NUMBER := 0
102 ,p_tax_remaining IN NUMBER := 0
103 ,p_freight_remaining IN NUMBER := 0
104 ,p_line_credit IN NUMBER := 0
105 ,p_tax_credit IN NUMBER := 0
106 ,p_freight_credit IN NUMBER := 0
107 ,p_total_credit IN NUMBER
108 ,p_cm_line_tbl IN AR_CREDIT_MEMO_API_PUB.cm_line_tbl_type_cover%TYPE
109 ,p_upd_dispute_flag IN VARCHAR2 := FND_API.g_false
110 ,x_cm_customer_trx_id OUT NOCOPY NUMBER
111 ,x_cm_amount OUT NOCOPY NUMBER
112 ,x_return_status OUT NOCOPY VARCHAR2
113 ,x_msg_data OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 );
116
117
118 PROCEDURE Create_AR_Write_Off(
119 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
120 ,p_deduction_type IN VARCHAR2
121 ,p_write_off_amount IN NUMBER
122 ,p_gl_date IN DATE := NULL
123 ,p_wo_rec_trx_id IN NUMBER := NULL
124 ,p_settlement_doc_id IN NUMBER := NULL -- Added for Bug 13948201
125 ,x_wo_adjust_id OUT NOCOPY NUMBER
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_data OUT NOCOPY VARCHAR2
128 ,x_msg_count OUT NOCOPY NUMBER
129 );
130
131 PROCEDURE Pay_by_Invoice_Credit(
132 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
133 ,p_deduction_type IN VARCHAR2
134
135 ,x_return_status OUT NOCOPY VARCHAR2
136 ,x_msg_data OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 );
139
140 PROCEDURE Pay_by_Credit_Memo(
141 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
142 ,p_deduction_type IN VARCHAR2
143 ,p_payment_reference_id IN NUMBER
144 ,p_credit_memo_amount IN NUMBER
145
146 ,x_return_status OUT NOCOPY VARCHAR2
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ,x_msg_count OUT NOCOPY NUMBER
149 );
150
151 PROCEDURE Pay_by_On_Account_Credit(
152 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
153 ,p_deduction_type IN VARCHAR2
154
155 ,x_return_status OUT NOCOPY VARCHAR2
156 ,x_msg_data OUT NOCOPY VARCHAR2
157 ,x_msg_count OUT NOCOPY NUMBER
158 );
159
160
161 PROCEDURE Pay_by_Chargeback(
162 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
163 ,p_deduction_type IN VARCHAR2
164
165 ,x_return_status OUT NOCOPY VARCHAR2
166 ,x_msg_data OUT NOCOPY VARCHAR2
167 ,x_msg_count OUT NOCOPY NUMBER
168 );
169
170 PROCEDURE Pay_by_Write_Off(
171 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
172 ,p_deduction_type IN VARCHAR2
173
174 ,x_return_status OUT NOCOPY VARCHAR2
175 ,x_msg_data OUT NOCOPY VARCHAR2
176 ,x_msg_count OUT NOCOPY NUMBER
177 );
178
179 PROCEDURE Pay_by_Debit_Memo(
180 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
181 ,p_deduction_type IN VARCHAR2
182 ,p_payment_reference_id IN NUMBER
183 ,p_debit_memo_amount IN NUMBER
184
185 ,x_return_status OUT NOCOPY VARCHAR2
186 ,x_msg_data OUT NOCOPY VARCHAR2
187 ,x_msg_count OUT NOCOPY NUMBER
188 );
189
190
191 PROCEDURE Pay_by_Contra_Charge(
192 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
193 ,p_deduction_type IN VARCHAR2
194
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_msg_data OUT NOCOPY VARCHAR2
197 ,x_msg_count OUT NOCOPY NUMBER
198 );
199
200
201 PROCEDURE Create_AR_Chargeback(
202 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
203 ,p_chargeback_amount IN NUMBER
204 ,p_gl_date IN DATE := NULL
205
206 ,x_cb_customer_trx_id OUT NOCOPY NUMBER
207 ,x_return_status OUT NOCOPY VARCHAR2
208 ,x_msg_data OUT NOCOPY VARCHAR2
209 ,x_msg_count OUT NOCOPY NUMBER
210 );
211
212
213 PROCEDURE Process_Settlement_WF(
214 p_claim_id IN NUMBER
215
216 ,x_return_status OUT NOCOPY VARCHAR2
217 ,x_msg_data OUT NOCOPY VARCHAR2
218 ,x_msg_count OUT NOCOPY NUMBER
219 );
220
221
222 PROCEDURE Pay_by_RMA_Inv_CM(
223 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
224 ,p_credit_memo_amount IN NUMBER
225
226 ,x_return_status OUT NOCOPY VARCHAR2
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 ,x_msg_count OUT NOCOPY NUMBER
229 );
230
231
232 END OZF_AR_PAYMENT_PVT;