DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

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,
195: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

Line 192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_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,
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

Line 358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

354: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
355: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
356: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
357: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
360: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

Line 359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

355: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
356: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
357: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
360: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

Line 404: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

400: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
401: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
402: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
403: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
404: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
405: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
406: -- LLCA Parameters
407: p_llca_type IN VARCHAR2 DEFAULT 'S',
408: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,

Line 405: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

401: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
402: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
403: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
404: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
405: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
406: -- LLCA Parameters
407: p_llca_type IN VARCHAR2 DEFAULT 'S',
408: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
409: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */

Line 467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

463: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
464: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
465: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
466: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
468: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
469: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
470: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
471: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 468: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

464: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
465: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
466: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
468: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
469: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
470: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
471: p_called_from IN VARCHAR2 DEFAULT NULL,
472: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',

Line 544: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

540: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
541: -- Receipt application parameters
542: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
543: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
544: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
545: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
546: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

Line 545: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

541: -- Receipt application parameters
542: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
543: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
544: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
545: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
546: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

Line 693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default

689: -- Receipt application parameters.
690: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
691: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
692: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
697: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

925: x_msg_data OUT NOCOPY VARCHAR2,
926: -- Receipt application parameters.
927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,