101: | claim processing
102: | 27-MAR-2003 cthangai Added OUT parameter x_return_status
103: *=======================================================================*/
104: PROCEDURE CLAIM_CREATION
105: (p_request_id IN ar_receivable_applications.request_id%TYPE DEFAULT NULL
106: ,p_matched_claim_creation_flag IN ar_system_parameters.matched_claim_creation_flag%TYPE
107: ,p_matched_claim_excl_cm_flag IN ar_system_parameters.matched_claim_excl_cm_flag%TYPE
108: ,x_return_status OUT NOCOPY VARCHAR2
109: );
219: | 05-FEB-03 CTHANGAI Removed application_ref_reason paramter |
220: | 13-FEB-03 CTHANGAI Removed paramter applied_payment_schedule_id |
221: +===========================================================================*/
222: PROCEDURE create_claims_rapp_dist
223: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
224: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
220: | 13-FEB-03 CTHANGAI Removed paramter applied_payment_schedule_id |
221: +===========================================================================*/
222: PROCEDURE create_claims_rapp_dist
223: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
224: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
221: +===========================================================================*/
222: PROCEDURE create_claims_rapp_dist
223: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
224: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
222: PROCEDURE create_claims_rapp_dist
223: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
224: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
223: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
224: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
224: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
225: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
226: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
227: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
228: ,p_status IN ar_receivable_applications.status%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
229: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
230: ,p_created_by IN ar_receivable_applications.created_by%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
231: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
232: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
233: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
234: ,p_program_id IN ar_receivable_applications.program_id%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
235: ,p_request_id IN ar_receivable_applications.request_id%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
236: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
237: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
238: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
239: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
240: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
241: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
242: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
243: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
244: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
245: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
246: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
247: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
248: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
249: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
250: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
251: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
252: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
253: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
261: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
254: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
261: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
262: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
255: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
261: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
262: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
263: ,x_return_status OUT NOCOPY VARCHAR2
256: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
261: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
262: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
263: ,x_return_status OUT NOCOPY VARCHAR2
264: );
257: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
261: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
262: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
263: ,x_return_status OUT NOCOPY VARCHAR2
264: );
265:
258: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
259: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
260: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
261: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
262: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
263: ,x_return_status OUT NOCOPY VARCHAR2
264: );
265:
266:
297: | 17-JAN-2003 cthangai Created
298: | 05-MAR-2003 cthangai Removed In parameter - payment_schedule_id
299: *=======================================================================*/
300: PROCEDURE claim_create_fail_recover
301: (p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
302: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
303: );
304:
305:
298: | 05-MAR-2003 cthangai Removed In parameter - payment_schedule_id
299: *=======================================================================*/
300: PROCEDURE claim_create_fail_recover
301: (p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
302: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
303: );
304:
305:
306: /*========================================================================
529: | 23-JAN-2003 CTHANGAI Created
530: |
531: *=======================================================================*/
532: FUNCTION CHECK_APP_VIOLATE
533: (p_amount IN ar_receivable_applications.amount_applied%TYPE
534: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL
535: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
536: ) RETURN VARCHAR2;
537:
530: |
531: *=======================================================================*/
532: FUNCTION CHECK_APP_VIOLATE
533: (p_amount IN ar_receivable_applications.amount_applied%TYPE
534: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL
535: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
536: ) RETURN VARCHAR2;
537:
538:
531: *=======================================================================*/
532: FUNCTION CHECK_APP_VIOLATE
533: (p_amount IN ar_receivable_applications.amount_applied%TYPE
534: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL
535: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
536: ) RETURN VARCHAR2;
537:
538:
539: /*========================================================================
563: | DD-MON-YYYY Name Bug #####, modified amount ..
564: |
565: *=======================================================================*/
566: FUNCTION GET_TM_ORACLE_REASON
567: (p_claim_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
568: ) RETURN VARCHAR2;
569:
570: /*========================================================================
571: | PUBLIC PROCEDURE apply_open_receipt_cover
595: *=======================================================================*/
596: PROCEDURE apply_open_receipt_cover
597: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
598: ,p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
599: ,p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE
600: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
596: PROCEDURE apply_open_receipt_cover
597: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
598: ,p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
599: ,p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE
600: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
597: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
598: ,p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
599: ,p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE
600: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
598: ,p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
599: ,p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE
600: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
599: ,p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE
600: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
600: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
601: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
602: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
603: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
604: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
605: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
606: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
607: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
615: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
608: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
615: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
616: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
609: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
615: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
616: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
617: ,x_return_status OUT NOCOPY VARCHAR2
610: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
615: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
616: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
617: ,x_return_status OUT NOCOPY VARCHAR2
618: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
611: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
615: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
616: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
617: ,x_return_status OUT NOCOPY VARCHAR2
618: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
619: ,x_apply_type OUT NOCOPY VARCHAR2
612: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
613: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
614: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
615: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
616: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
617: ,x_return_status OUT NOCOPY VARCHAR2
618: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
619: ,x_apply_type OUT NOCOPY VARCHAR2
620: );