[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
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
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
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
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:
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
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:
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
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
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