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 AR_PAYMENT_SCHEDULES

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

1138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1139: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

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

1139: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

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

1910: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1911: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1912: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1913: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1914: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1915: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1916: -- LLCA Parameters
1917: p_llca_type IN VARCHAR2 DEFAULT 'S',
1918: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,

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

1911: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1912: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1913: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1914: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1915: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1916: -- LLCA Parameters
1917: p_llca_type IN VARCHAR2 DEFAULT 'S',
1918: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1919: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */

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

2926: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2933: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2934: p_called_from IN VARCHAR2 DEFAULT NULL,

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

2927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2933: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2934: p_called_from IN VARCHAR2 DEFAULT NULL,
2935: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',

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

4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4817: -- Receipt application parameters
4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4819: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

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

4817: -- Receipt application parameters
4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4819: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

Line 5478: l_ps_rec ar_payment_schedules%ROWTYPE;

5474: ) IS
5475: l_rev_crh_id NUMBER;
5476: l_crh_rec ar_cash_receipt_history%ROWTYPE;
5477: l_cr_rec ar_cash_receipts%ROWTYPE;
5478: l_ps_rec ar_payment_schedules%ROWTYPE;
5479: BEGIN
5480: p_return_status := FND_API.G_RET_STS_SUCCESS;
5481: /*-------------------------------------------------+
5482: | Initialize SOB/org dependent variables |

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

7350: -- Receipt application parameters.
7351: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7352: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 8053: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

8049: l_org_return_status VARCHAR2(1);
8050: l_org_id NUMBER;
8051: l_cr_unapp_amt NUMBER; /* Bug fix 3569640 */
8052: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8053: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
8054: l_refund_return_status VARCHAR2(1);
8055: BEGIN
8056: /*------------------------------------+
8057: | Standard start of API savepoint |

Line 9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,

9667: x_msg_data OUT NOCOPY VARCHAR2,
9668: -- Receipt application parameters.
9669: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9670: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

Line 9697: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

9693: l_cash_receipt_id NUMBER;
9694: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9695: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9696: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9697: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9698: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9699: l_cr_gl_date DATE;
9700: l_open_cr_gl_date DATE;
9701: l_cr_date DATE;

Line 11361: update AR_payment_schedules SET

11357: IF PG_DEBUG in ('Y','C') THEN
11358: arp_standard.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));
11359: END IF;
11360:
11361: update AR_payment_schedules SET
11362: last_update_date = sysdate,
11363: request_id = p_request_id
11364: WHERE cash_receipt_id in
11365: ( select cash_receipt_id