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_PUB dependencies on RA_CUSTOMER_TRX

Line 189: customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

185: INDEX BY BINARY_INTEGER;
186: TYPE G_application_rec_type IS RECORD
187: ( cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
188: receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
189: customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

Line 190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,

186: TYPE G_application_rec_type IS RECORD
187: ( cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
188: receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
189: customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
194: line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

Line 194: line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
194: line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
195: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
196: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL
197: );
198: TYPE G_create_cash_rec_type IS RECORD

Line 215: (trx_number ra_customer_trx.trx_number%TYPE,

211: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
212: receipt_method_name ar_receipt_methods.name%TYPE
213: );
214: TYPE G_unapp_rec_type IS RECORD
215: (trx_number ra_customer_trx.trx_number%TYPE,
216: customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,

Line 366: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

362: x_msg_data OUT NOCOPY VARCHAR2,
363: -- Receipt application parameters.
364: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
365: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
366: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
367: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
370: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 367: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

363: -- Receipt application parameters.
364: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
365: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
366: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
367: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
370: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
371: -- this is the allocated receipt amount

Line 379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
380: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
381: p_called_from IN VARCHAR2 DEFAULT NULL,
382: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
383: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 412: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

408: x_msg_data OUT NOCOPY VARCHAR2,
409: -- Receipt application parameters.
410: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
411: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
412: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
413: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
414: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
415: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
416: -- LLCA Parameters

Line 413: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

409: -- Receipt application parameters.
410: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
411: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
412: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
413: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
414: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
415: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
416: -- LLCA Parameters
417: p_llca_type IN VARCHAR2 DEFAULT 'S',

Line 475: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

471: x_msg_data OUT NOCOPY VARCHAR2 ,
472: -- *** Receipt Info. parameters *****
473: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
474: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
475: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
478: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
479: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

Line 476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

472: -- *** Receipt Info. parameters *****
473: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
474: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
475: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
478: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
479: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
480: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

Line 552: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

548: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
549: -- ** OUT NOCOPY variables for Creating receipt
550: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
551: -- Receipt application parameters
552: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
553: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
554: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
555: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
556: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 553: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

549: -- ** OUT NOCOPY variables for Creating receipt
550: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
551: -- Receipt application parameters
552: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
553: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
554: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
555: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
556: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
557: -- this is the allocated receipt amount

Line 565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
566: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
567: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
568: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
569: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

Line 704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

700: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
701: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
702: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
707: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
708: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,