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 368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

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

Line 369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_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
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

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

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',
418: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,

Line 415: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_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',
418: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
419: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */

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

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,
481: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 478: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%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,
481: p_called_from IN VARCHAR2 DEFAULT NULL,
482: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',

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

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

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

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
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

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

699: -- Receipt application parameters.
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,

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

937: x_msg_data OUT NOCOPY VARCHAR2,
938: -- Receipt application parameters.
939: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
940: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,