146: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
147: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
148: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
149: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
151: -- this is the allocated receipt amount
152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
148: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
149: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
151: -- this is the allocated receipt amount
152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
149: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
151: -- this is the allocated receipt amount
152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
151: -- this is the allocated receipt amount
152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
158: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
151: -- this is the allocated receipt amount
152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
158: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
159: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
158: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
159: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
160: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
158: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
159: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
160: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
161: p_called_from IN VARCHAR2 ,
154: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
158: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
159: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
160: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
161: p_called_from IN VARCHAR2 ,
162: p_move_deferred_tax IN VARCHAR2 ,
159: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
160: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
161: p_called_from IN VARCHAR2 ,
162: p_move_deferred_tax IN VARCHAR2 ,
163: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
164: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
165: -- ******* Global Flexfield parameters *******
166: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
167: p_comments IN ar_receivable_applications.comments%TYPE ,
163: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
164: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
165: -- ******* Global Flexfield parameters *******
166: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
167: p_comments IN ar_receivable_applications.comments%TYPE ,
168: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
164: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
165: -- ******* Global Flexfield parameters *******
166: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
167: p_comments IN ar_receivable_applications.comments%TYPE ,
168: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
165: -- ******* Global Flexfield parameters *******
166: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
167: p_comments IN ar_receivable_applications.comments%TYPE ,
168: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
166: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
167: p_comments IN ar_receivable_applications.comments%TYPE ,
168: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
167: p_comments IN ar_receivable_applications.comments%TYPE ,
168: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
175: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
168: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
175: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
176: )
169: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
175: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
176: )
177: IS
170: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
175: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
176: )
177: IS
178:
171: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
175: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
176: )
177: IS
178:
179: BEGIN
239: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
240: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
241: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
242: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
243: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
244: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
245: p_called_from IN VARCHAR2 ,
246: p_cancel_claim_flag IN VARCHAR2
247: )
240: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
241: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
242: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
243: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
244: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
245: p_called_from IN VARCHAR2 ,
246: p_cancel_claim_flag IN VARCHAR2
247: )
248: IS
330: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
331: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
332: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
333: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
334: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
335: -- this is the allocated receipt amount
336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
332: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
333: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
334: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
335: -- this is the allocated receipt amount
336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
333: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
334: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
335: -- this is the allocated receipt amount
336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
334: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
335: -- this is the allocated receipt amount
336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
335: -- this is the allocated receipt amount
336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
343: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
343: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
344: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
343: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
344: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
345: p_move_deferred_tax IN VARCHAR2 ,
338: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
343: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
344: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
345: p_move_deferred_tax IN VARCHAR2 ,
346: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
343: p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
344: p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
345: p_move_deferred_tax IN VARCHAR2 ,
346: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
347: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
348: -- ******* Global Flexfield parameters *******
349: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
350: app_comments IN ar_receivable_applications.comments%TYPE ,
346: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
347: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
348: -- ******* Global Flexfield parameters *******
349: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
350: app_comments IN ar_receivable_applications.comments%TYPE ,
351: -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
352: -- processor such as iPayments
353: p_call_payment_processor IN VARCHAR2
354:
503: x_msg_data OUT NOCOPY VARCHAR2,
504: -- Receipt application parameters.
505: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
511: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
504: -- Receipt application parameters.
505: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
511: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
512: -- ******* Global Flexfield parameters *******
505: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
511: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
512: -- ******* Global Flexfield parameters *******
513: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
511: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
512: -- ******* Global Flexfield parameters *******
513: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
514: p_comments IN ar_receivable_applications.comments%TYPE ,
510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
511: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
512: -- ******* Global Flexfield parameters *******
513: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
514: p_comments IN ar_receivable_applications.comments%TYPE ,
515: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
516: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
517: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
518: p_called_from IN VARCHAR2
511: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
512: -- ******* Global Flexfield parameters *******
513: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
514: p_comments IN ar_receivable_applications.comments%TYPE ,
515: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
516: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
517: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
518: p_called_from IN VARCHAR2
519: )
512: -- ******* Global Flexfield parameters *******
513: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
514: p_comments IN ar_receivable_applications.comments%TYPE ,
515: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
516: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
517: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
518: p_called_from IN VARCHAR2
519: )
520: IS
513: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
514: p_comments IN ar_receivable_applications.comments%TYPE ,
515: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
516: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
517: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
518: p_called_from IN VARCHAR2
519: )
520: IS
521:
560: x_msg_data OUT NOCOPY VARCHAR2 ,
561: -- *** Receipt Info. parameters *****
562: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
563: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
564: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
565: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE
566: )
567: IS
568:
561: -- *** Receipt Info. parameters *****
562: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
563: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
564: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
565: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE
566: )
567: IS
568:
569: BEGIN
597: x_msg_data OUT NOCOPY VARCHAR2,
598: -- Receipt application parameters.
599: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
600: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
601: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
602: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
605: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
600: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
601: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
602: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
605: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
606: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
607: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
608: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
601: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
602: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
605: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
606: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
607: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
608: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
609: -- ******* Global Flexfield parameters *******
602: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
605: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
606: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
607: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
608: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
609: -- ******* Global Flexfield parameters *******
610: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
605: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
606: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
607: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
608: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
609: -- ******* Global Flexfield parameters *******
610: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
611: p_comments IN ar_receivable_applications.comments%TYPE ,
607: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
608: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
609: -- ******* Global Flexfield parameters *******
610: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
611: p_comments IN ar_receivable_applications.comments%TYPE ,
612: p_application_ref_type IN OUT NOCOPY
613: ar_receivable_applications.application_ref_type%TYPE,
614: p_application_ref_id IN OUT NOCOPY
615: ar_receivable_applications.application_ref_id%TYPE,
609: -- ******* Global Flexfield parameters *******
610: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
611: p_comments IN ar_receivable_applications.comments%TYPE ,
612: p_application_ref_type IN OUT NOCOPY
613: ar_receivable_applications.application_ref_type%TYPE,
614: p_application_ref_id IN OUT NOCOPY
615: ar_receivable_applications.application_ref_id%TYPE,
616: p_application_ref_num IN OUT NOCOPY
617: ar_receivable_applications.application_ref_num%TYPE,
611: p_comments IN ar_receivable_applications.comments%TYPE ,
612: p_application_ref_type IN OUT NOCOPY
613: ar_receivable_applications.application_ref_type%TYPE,
614: p_application_ref_id IN OUT NOCOPY
615: ar_receivable_applications.application_ref_id%TYPE,
616: p_application_ref_num IN OUT NOCOPY
617: ar_receivable_applications.application_ref_num%TYPE,
618: p_secondary_application_ref_id IN OUT NOCOPY
619: ar_receivable_applications.secondary_application_ref_id%TYPE,
613: ar_receivable_applications.application_ref_type%TYPE,
614: p_application_ref_id IN OUT NOCOPY
615: ar_receivable_applications.application_ref_id%TYPE,
616: p_application_ref_num IN OUT NOCOPY
617: ar_receivable_applications.application_ref_num%TYPE,
618: p_secondary_application_ref_id IN OUT NOCOPY
619: ar_receivable_applications.secondary_application_ref_id%TYPE,
620: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
621: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
615: ar_receivable_applications.application_ref_id%TYPE,
616: p_application_ref_num IN OUT NOCOPY
617: ar_receivable_applications.application_ref_num%TYPE,
618: p_secondary_application_ref_id IN OUT NOCOPY
619: ar_receivable_applications.secondary_application_ref_id%TYPE,
620: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
621: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
622: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
623: p_val_writeoff_limits_flag IN VARCHAR2 ,
616: p_application_ref_num IN OUT NOCOPY
617: ar_receivable_applications.application_ref_num%TYPE,
618: p_secondary_application_ref_id IN OUT NOCOPY
619: ar_receivable_applications.secondary_application_ref_id%TYPE,
620: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
621: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
622: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
623: p_val_writeoff_limits_flag IN VARCHAR2 ,
624: p_called_from IN VARCHAR2
617: ar_receivable_applications.application_ref_num%TYPE,
618: p_secondary_application_ref_id IN OUT NOCOPY
619: ar_receivable_applications.secondary_application_ref_id%TYPE,
620: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
621: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
622: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
623: p_val_writeoff_limits_flag IN VARCHAR2 ,
624: p_called_from IN VARCHAR2
625: )
618: p_secondary_application_ref_id IN OUT NOCOPY
619: ar_receivable_applications.secondary_application_ref_id%TYPE,
620: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
621: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
622: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
623: p_val_writeoff_limits_flag IN VARCHAR2 ,
624: p_called_from IN VARCHAR2
625: )
626: IS
674: x_msg_data OUT NOCOPY VARCHAR2 ,
675: -- *** Receipt Info. parameters *****
676: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
677: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
678: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
679: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
680: p_called_from IN VARCHAR2
681: )
682: IS
675: -- *** Receipt Info. parameters *****
676: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
677: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
678: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
679: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
680: p_called_from IN VARCHAR2
681: )
682: IS
683:
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,
714: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
715: -- Receipt application parameters.
716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
714: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
715: -- Receipt application parameters.
716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
715: -- Receipt application parameters.
716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
728: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
728: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
729: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
722: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
728: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
729: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
730: -- ******* Global Flexfield parameters *******
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
728: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
729: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
730: -- ******* Global Flexfield parameters *******
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
724: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
728: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
729: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
730: -- ******* Global Flexfield parameters *******
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
732: p_comments IN ar_receivable_applications.comments%TYPE ,
728: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
729: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
730: -- ******* Global Flexfield parameters *******
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
732: p_comments IN ar_receivable_applications.comments%TYPE ,
733: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
734: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
735: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE ,
736: p_called_from IN VARCHAR2
729: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
730: -- ******* Global Flexfield parameters *******
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
732: p_comments IN ar_receivable_applications.comments%TYPE ,
733: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
734: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
735: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE ,
736: p_called_from IN VARCHAR2
737: )
730: -- ******* Global Flexfield parameters *******
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
732: p_comments IN ar_receivable_applications.comments%TYPE ,
733: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
734: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
735: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE ,
736: p_called_from IN VARCHAR2
737: )
738: IS
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
732: p_comments IN ar_receivable_applications.comments%TYPE ,
733: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
734: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
735: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE ,
736: p_called_from IN VARCHAR2
737: )
738: IS
739:
786: x_msg_data OUT NOCOPY VARCHAR2 ,
787: -- *** Receipt Info. parameters *****
788: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
789: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
790: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
791: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
792: p_cancel_claim_flag IN VARCHAR2 ,
793: p_called_from IN VARCHAR2
794: )
787: -- *** Receipt Info. parameters *****
788: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
789: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
790: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
791: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
792: p_cancel_claim_flag IN VARCHAR2 ,
793: p_called_from IN VARCHAR2
794: )
795: IS
924: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
925: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
932: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
925: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
932: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
933: p_called_from IN VARCHAR2 ,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
932: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
933: p_called_from IN VARCHAR2 ,
934: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
932: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
933: p_called_from IN VARCHAR2 ,
934: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
935: -- ******* Global Flexfield parameters *******
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
932: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
933: p_called_from IN VARCHAR2 ,
934: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
935: -- ******* Global Flexfield parameters *******
936: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
933: p_called_from IN VARCHAR2 ,
934: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
935: -- ******* Global Flexfield parameters *******
936: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
937: p_comments IN ar_receivable_applications.comments%TYPE ,
938: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
939: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
940: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
941: )
934: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
935: -- ******* Global Flexfield parameters *******
936: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
937: p_comments IN ar_receivable_applications.comments%TYPE ,
938: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
939: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
940: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
941: )
942: IS
935: -- ******* Global Flexfield parameters *******
936: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
937: p_comments IN ar_receivable_applications.comments%TYPE ,
938: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
939: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
940: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
941: )
942: IS
943:
936: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
937: p_comments IN ar_receivable_applications.comments%TYPE ,
938: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
939: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
940: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
941: )
942: IS
943:
944: l_acctd_amount_applied_from NUMBER;
988: p_validation_level IN NUMBER ,
989: x_return_status OUT NOCOPY VARCHAR2 ,
990: x_msg_count OUT NOCOPY NUMBER ,
991: x_msg_data OUT NOCOPY VARCHAR2 ,
992: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
993: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
994: p_called_from IN VARCHAR2 )
995: IS
996:
989: x_return_status OUT NOCOPY VARCHAR2 ,
990: x_msg_count OUT NOCOPY NUMBER ,
991: x_msg_data OUT NOCOPY VARCHAR2 ,
992: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
993: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
994: p_called_from IN VARCHAR2 )
995: IS
996:
997: BEGIN