DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on AR_PAYMENT_SCHEDULES

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

1127: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

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

1128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

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

1877: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1878: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1881: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1882: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1883: -- LLCA Parameters
1884: p_llca_type IN VARCHAR2 DEFAULT 'S',
1885: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,

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

1878: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1881: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1882: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1883: -- LLCA Parameters
1884: p_llca_type IN VARCHAR2 DEFAULT 'S',
1885: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1886: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */

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

2880: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2881: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2886: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2887: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2888: p_called_from IN VARCHAR2 DEFAULT NULL,

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

2881: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2886: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2887: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2888: p_called_from IN VARCHAR2 DEFAULT NULL,
2889: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',

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

4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4644: -- Receipt application parameters
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

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

4644: -- Receipt application parameters
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

Line 5305: l_ps_rec ar_payment_schedules%ROWTYPE;

5301: ) IS
5302: l_rev_crh_id NUMBER;
5303: l_crh_rec ar_cash_receipt_history%ROWTYPE;
5304: l_cr_rec ar_cash_receipts%ROWTYPE;
5305: l_ps_rec ar_payment_schedules%ROWTYPE;
5306: BEGIN
5307: p_return_status := FND_API.G_RET_STS_SUCCESS;
5308: /*-------------------------------------------------+
5309: | Initialize SOB/org dependent variables |

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

7059: -- Receipt application parameters.
7060: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7061: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7067: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 7693: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

7689: l_org_return_status VARCHAR2(1);
7690: l_org_id NUMBER;
7691: l_cr_unapp_amt NUMBER; /* Bug fix 3569640 */
7692: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7693: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
7694: l_refund_return_status VARCHAR2(1);
7695: BEGIN
7696: /*------------------------------------+
7697: | Standard start of API savepoint |

Line 9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

9306: x_msg_data OUT NOCOPY VARCHAR2,
9307: -- Receipt application parameters.
9308: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9309: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

Line 9336: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

9332: l_cash_receipt_id NUMBER;
9333: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9334: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9335: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9336: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9337: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9338: l_cr_gl_date DATE;
9339: l_open_cr_gl_date DATE;
9340: l_cr_date DATE;