1 PACKAGE OZF_AR_PAYMENT_PVT AS
2 /* $Header: ozfvarps.pls 120.2 2005/10/24 00:40:04 sshivali noship $ */
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 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_data OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 );
87
88 PROCEDURE Update_dispute_amount(
89 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
90 ,p_dispute_amount IN NUMBER
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 );
95
96 PROCEDURE Create_AR_Credit_Memo(
97 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
98 ,p_customer_trx_id IN NUMBER
99 ,p_deduction_type IN VARCHAR2
100 ,p_line_remaining IN NUMBER := 0
101 ,p_tax_remaining IN NUMBER := 0
102 ,p_freight_remaining IN NUMBER := 0
103 ,p_line_credit IN NUMBER := 0
104 ,p_tax_credit IN NUMBER := 0
105 ,p_freight_credit IN NUMBER := 0
106 ,p_total_credit IN NUMBER
107 ,p_cm_line_tbl IN AR_CREDIT_MEMO_API_PUB.cm_line_tbl_type_cover%TYPE
108 ,p_upd_dispute_flag IN VARCHAR2 := FND_API.g_false
109 ,x_cm_customer_trx_id OUT NOCOPY NUMBER
110 ,x_cm_amount OUT NOCOPY NUMBER
111 ,x_return_status OUT NOCOPY VARCHAR2
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 ,x_msg_count OUT NOCOPY NUMBER
114 );
115
116
117 PROCEDURE Create_AR_Write_Off(
118 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
119 ,p_deduction_type IN VARCHAR2
120 ,p_write_off_amount IN NUMBER
121 ,p_gl_date IN DATE := NULL
122 ,p_wo_rec_trx_id IN NUMBER := NULL
123
124 ,x_wo_adjust_id OUT NOCOPY NUMBER
125 ,x_return_status OUT NOCOPY VARCHAR2
126 ,x_msg_data OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 );
129
130 PROCEDURE Pay_by_Invoice_Credit(
131 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
132 ,p_deduction_type IN VARCHAR2
133
134 ,x_return_status OUT NOCOPY VARCHAR2
135 ,x_msg_data OUT NOCOPY VARCHAR2
136 ,x_msg_count OUT NOCOPY NUMBER
137 );
138
139 PROCEDURE Pay_by_Credit_Memo(
140 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
141 ,p_deduction_type IN VARCHAR2
142 ,p_payment_reference_id IN NUMBER
143 ,p_credit_memo_amount IN NUMBER
144
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_data OUT NOCOPY VARCHAR2
147 ,x_msg_count OUT NOCOPY NUMBER
148 );
149
150 PROCEDURE Pay_by_On_Account_Credit(
151 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
152 ,p_deduction_type IN VARCHAR2
153
154 ,x_return_status OUT NOCOPY VARCHAR2
155 ,x_msg_data OUT NOCOPY VARCHAR2
156 ,x_msg_count OUT NOCOPY NUMBER
157 );
158
159
160 PROCEDURE Pay_by_Chargeback(
161 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
162 ,p_deduction_type IN VARCHAR2
163
164 ,x_return_status OUT NOCOPY VARCHAR2
165 ,x_msg_data OUT NOCOPY VARCHAR2
166 ,x_msg_count OUT NOCOPY NUMBER
167 );
168
169 PROCEDURE Pay_by_Write_Off(
170 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
171 ,p_deduction_type IN VARCHAR2
172
173 ,x_return_status OUT NOCOPY VARCHAR2
174 ,x_msg_data OUT NOCOPY VARCHAR2
175 ,x_msg_count OUT NOCOPY NUMBER
176 );
177
178 PROCEDURE Pay_by_Debit_Memo(
179 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
180 ,p_deduction_type IN VARCHAR2
181 ,p_payment_reference_id IN NUMBER
182 ,p_debit_memo_amount IN NUMBER
183
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,x_msg_data OUT NOCOPY VARCHAR2
186 ,x_msg_count OUT NOCOPY NUMBER
187 );
188
189
190 PROCEDURE Pay_by_Contra_Charge(
191 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
192 ,p_deduction_type IN VARCHAR2
193
194 ,x_return_status OUT NOCOPY VARCHAR2
195 ,x_msg_data OUT NOCOPY VARCHAR2
196 ,x_msg_count OUT NOCOPY NUMBER
197 );
198
199
200 PROCEDURE Create_AR_Chargeback(
201 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
202 ,p_chargeback_amount IN NUMBER
203 ,p_gl_date IN DATE := NULL
204
205 ,x_cb_customer_trx_id OUT NOCOPY NUMBER
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_data OUT NOCOPY VARCHAR2
208 ,x_msg_count OUT NOCOPY NUMBER
209 );
210
211
212 PROCEDURE Process_Settlement_WF(
213 p_claim_id IN NUMBER
214
215 ,x_return_status OUT NOCOPY VARCHAR2
216 ,x_msg_data OUT NOCOPY VARCHAR2
217 ,x_msg_count OUT NOCOPY NUMBER
218 );
219
220
221 PROCEDURE Pay_by_RMA_Inv_CM(
222 p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
223 ,p_credit_memo_amount IN NUMBER
224
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_data OUT NOCOPY VARCHAR2
227 ,x_msg_count OUT NOCOPY NUMBER
228 );
229
230
231 END OZF_AR_PAYMENT_PVT;