eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_API_COVER dependencies on AR_RECEIVABLE_APPLICATIONS

Line 150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,

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 ,

Line 152: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%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 ,

Line 153: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%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 ,

Line 154: p_discount IN ar_receivable_applications.earned_discount_taken%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 ,

Line 155: p_apply_date IN ar_receivable_applications.apply_date%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 ,

Line 156: p_apply_gl_date IN ar_receivable_applications.gl_date%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 */

Line 157: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 */
161: p_called_from IN VARCHAR2 ,

Line 158: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%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 ,
162: p_move_deferred_tax IN VARCHAR2 ,

Line 163: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_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 ,
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 ,

Line 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 ,

Line 168: p_payment_set_id IN ar_receivable_applications.payment_set_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 ,
172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,

Line 169: p_application_ref_type IN ar_receivable_applications.application_ref_type%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 ,

Line 170: p_application_ref_id IN ar_receivable_applications.application_ref_id%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 ,

Line 171: p_application_ref_num IN ar_receivable_applications.application_ref_num%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

Line 172: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%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: )

Line 173: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%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: )
177: IS

Line 174: p_customer_reference IN ar_receivable_applications.customer_reference%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
178:

Line 175: p_customer_reason IN ar_receivable_applications.customer_reason%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:
179: BEGIN

Line 243: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,

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

Line 244: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%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: )
248: IS

Line 334: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,

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 ,

Line 336: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%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 ,

Line 337: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%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 ,

Line 338: p_discount IN ar_receivable_applications.earned_discount_taken%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 ,

Line 339: p_apply_date IN ar_receivable_applications.apply_date%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 ,

Line 340: p_apply_gl_date IN ar_receivable_applications.gl_date%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 */

Line 341: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 */
345: p_move_deferred_tax IN VARCHAR2 ,

Line 342: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%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 ,
346: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,

Line 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 ,

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

Line 507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,

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 ,

Line 508: p_apply_date IN ar_receivable_applications.apply_date%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 *******

Line 509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,

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 ,

Line 510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 ,

Line 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

Line 515: p_application_ref_num IN ar_receivable_applications.application_ref_num%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
519: )

Line 516: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%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: )
520: IS

Line 517: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,

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:

Line 564: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,

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:

Line 565: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE

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

Line 601: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,

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 ,

Line 604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default

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 ,

Line 605: p_apply_date IN ar_receivable_applications.apply_date%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 *******

Line 606: p_apply_gl_date IN ar_receivable_applications.gl_date%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 *******
610: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,

Line 607: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 ,

Line 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,

Line 613: ar_receivable_applications.application_ref_type%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,

Line 615: ar_receivable_applications.application_ref_id%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,

Line 617: ar_receivable_applications.application_ref_num%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,

Line 619: ar_receivable_applications.secondary_application_ref_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 ,

Line 620: p_payment_set_id IN ar_receivable_applications.payment_set_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 ,
624: p_called_from IN VARCHAR2

Line 621: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

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

Line 622: p_customer_reference IN ar_receivable_applications.customer_reference%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: )
626: IS

Line 678: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,

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

Line 679: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,

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:

Line 714: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

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 ,

Line 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 ,

Line 719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_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 ,
723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,

Line 720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%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 ,

Line 721: p_apply_date IN ar_receivable_applications.apply_date%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 ,

Line 722: p_apply_gl_date IN ar_receivable_applications.gl_date%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 ,

Line 723: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 ,

Line 724: p_application_ref_type IN ar_receivable_applications.application_ref_type%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 ,

Line 725: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_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 ,

Line 726: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%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 *******

Line 727: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%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 *******
731: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,

Line 728: p_payment_set_id IN ar_receivable_applications.payment_set_id%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 ,

Line 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

Line 733: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%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
737: )

Line 734: p_customer_reference IN ar_receivable_applications.customer_reference%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: )
738: IS

Line 735: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE ,

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:

Line 790: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

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

Line 791: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,

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

Line 928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,

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 ,

Line 929: p_amount_applied IN ar_receivable_applications.amount_applied%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 ,

Line 930: p_apply_date IN ar_receivable_applications.apply_date%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 ,
934: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,

Line 931: p_apply_gl_date IN ar_receivable_applications.gl_date%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 *******

Line 932: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 *******
936: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,

Line 937: p_comments IN ar_receivable_applications.comments%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: )

Line 938: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,

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

Line 939: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%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
943:

Line 940: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE

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;

Line 992: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

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:

Line 993: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,

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