[Home] [Help]
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:
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
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
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
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
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
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:
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
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:
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
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
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