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_BILLS_MAINTAIN_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 182: l_ps_rec ar_payment_schedules%ROWTYPE;

178: l_api_version CONSTANT NUMBER := 1.0;
179:
180: l_trx_rec ra_customer_trx%ROWTYPE;
181: l_trh_rec ar_transaction_history%ROWTYPE;
182: l_ps_rec ar_payment_schedules%ROWTYPE;
183:
184: l_doc_sequence_id NUMBER ;
185: l_doc_sequence_value NUMBER ;
186: l_trx_number VARCHAR2(20) ;

Line 585: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

581: l_api_version CONSTANT NUMBER := 1.0;
582:
583: l_trx_rec ra_customer_trx%ROWTYPE;
584: l_trh_rec ar_transaction_history%ROWTYPE;
585: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
586:
587: l_acceptance_flag VARCHAR2(1) ;
588:
589: l_action VARCHAR2(30) ;

Line 1167: l_ps_rec ar_payment_schedules%ROWTYPE;

1163: l_api_name CONSTANT VARCHAR2(20) := 'Hold_BR';
1164: l_api_version CONSTANT NUMBER := 1.0;
1165: l_trh_rec ar_transaction_history%ROWTYPE;
1166: l_trx_rec ra_customer_trx%ROWTYPE;
1167: l_ps_rec ar_payment_schedules%ROWTYPE;
1168:
1169: l_action VARCHAR2(30);
1170:
1171: BEGIN

Line 1439: l_ps_rec ar_payment_schedules%ROWTYPE;

1435: l_api_version CONSTANT NUMBER := 1.0;
1436:
1437: l_trh_rec ar_transaction_history%ROWTYPE;
1438: l_trx_rec ra_customer_trx%ROWTYPE;
1439: l_ps_rec ar_payment_schedules%ROWTYPE;
1440: l_action VARCHAR2(30);
1441:
1442: BEGIN
1443:

Line 1695: l_ps_rec ar_payment_schedules%ROWTYPE;

1691:
1692: l_batch_rec ar_batches%ROWTYPE;
1693: l_trh_rec ar_transaction_history%ROWTYPE;
1694: l_trx_rec ra_customer_trx%ROWTYPE;
1695: l_ps_rec ar_payment_schedules%ROWTYPE;
1696: l_action VARCHAR2(30);
1697:
1698: BEGIN
1699:

Line 1865: l_ps_rec ar_payment_schedules%ROWTYPE;

1861: IS
1862:
1863: l_trh_rec ar_transaction_history%ROWTYPE;
1864: l_trx_rec ra_customer_trx%ROWTYPE;
1865: l_ps_rec ar_payment_schedules%ROWTYPE;
1866: l_action VARCHAR2(30);
1867:
1868: BEGIN
1869:

Line 2024: l_ps_rec ar_payment_schedules%ROWTYPE;

2020: IS
2021:
2022: l_trh_rec ar_transaction_history%ROWTYPE;
2023: l_trx_rec ra_customer_trx%ROWTYPE;
2024: l_ps_rec ar_payment_schedules%ROWTYPE;
2025: l_action VARCHAR2(30);
2026: l_trh_id ar_transaction_history.transaction_history_id%TYPE;
2027:
2028: BEGIN

Line 2175: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ,

2171:
2172: -- ***** Input parameters *****
2173:
2174: p_batch_id IN ar_batches.batch_id%TYPE ,
2175: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
2176:
2177: -- ***** Output parameters *****
2178:
2179: p_status OUT NOCOPY VARCHAR2 )

Line 2184: l_ps_rec ar_payment_schedules%ROWTYPE;

2180:
2181: IS
2182: l_batch_rec ar_batches%ROWTYPE;
2183: l_trh_rec ar_transaction_history%ROWTYPE;
2184: l_ps_rec ar_payment_schedules%ROWTYPE;
2185: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
2186: l_action VARCHAR2(30);
2187:
2188: BEGIN

Line 2466: l_ps_rec ar_payment_schedules%ROWTYPE;

2462: l_api_version CONSTANT NUMBER := 1.0;
2463:
2464: l_trh_rec ar_transaction_history%ROWTYPE;
2465: l_trx_rec ra_customer_trx%ROWTYPE;
2466: l_ps_rec ar_payment_schedules%ROWTYPE;
2467:
2468: l_acceptance_flag VARCHAR2(1) ;
2469:
2470: l_action VARCHAR2(30) ;

Line 2797: l_ps_rec ar_payment_schedules%ROWTYPE;

2793: l_api_name CONSTANT VARCHAR2(20) := 'Unpaid_BR';
2794: l_api_version CONSTANT NUMBER := 1.0;
2795:
2796: l_trh_rec ar_transaction_history%ROWTYPE;
2797: l_ps_rec ar_payment_schedules%ROWTYPE;
2798: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
2799:
2800: l_trx_date DATE ;
2801: l_gl_date DATE ;

Line 3096: l_ps_rec ar_payment_schedules%ROWTYPE;

3092:
3093: l_api_name CONSTANT VARCHAR2(20) := 'Endorse_BR';
3094: l_api_version CONSTANT NUMBER := 1.0;
3095: l_trh_rec ar_transaction_history%ROWTYPE;
3096: l_ps_rec ar_payment_schedules%ROWTYPE;
3097: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
3098: l_action VARCHAR2(30);
3099: new_adj_id ar_adjustments.adjustment_id%type;
3100: l_move_deferred_tax VARCHAR2(1) := 'N';

Line 3107: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

3103: l_mesg VARCHAR2(2000);
3104: -- Added for bug # 2712726
3105: -- ORASHID
3106: --
3107: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
3108:
3109: BEGIN
3110:
3111: IF PG_DEBUG in ('Y', 'C') THEN

Line 4012: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE ;

4008: l_api_version CONSTANT NUMBER := 1.0;
4009:
4010: l_trh_rec ar_transaction_history%ROWTYPE ;
4011: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;
4012: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE ;
4013: l_adj_id AR_ADJUSTMENTS.adjustment_id%TYPE ;
4014: l_action VARCHAR2(30) ;
4015: l_trx_date DATE ;
4016: l_gl_date DATE ;

Line 4335: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;

4331: l_api_name CONSTANT VARCHAR2(20) := 'Eliminate_Risk_BR';
4332: l_api_version CONSTANT NUMBER := 1.0;
4333: l_trh_rec ar_transaction_history%ROWTYPE;
4334: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
4335: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
4336: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4337: l_adj_id AR_ADJUSTMENTS.adjustment_id%TYPE;
4338: l_move_deferred_tax VARCHAR2(1) := 'N';
4339: l_action VARCHAR2(30);

Line 4347: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

4343:
4344: -- Added for bug # 2712726
4345: -- ORASHID
4346: --
4347: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
4348:
4349: BEGIN
4350:
4351: IF PG_DEBUG in ('Y', 'C') THEN

Line 4673: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;

4669:
4670: l_trh_rec ar_transaction_history%ROWTYPE;
4671: l_trh_prev_rec ar_transaction_history%ROWTYPE;
4672: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
4673: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
4674: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4675: l_adj_id AR_ADJUSTMENTS.adjustment_id%TYPE;
4676: l_move_deferred_tax VARCHAR2(1):= 'N';
4677: l_action VARCHAR2(30);

Line 4687: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

4683:
4684: -- Added for bug # 2712726
4685: -- ORASHID
4686: --
4687: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
4688:
4689: BEGIN
4690:
4691: IF PG_DEBUG in ('Y', 'C') THEN

Line 5037: l_ps_rec ar_payment_schedules%ROWTYPE;

5033: l_api_name CONSTANT VARCHAR2(20) := 'Exchange_BR';
5034: l_api_version CONSTANT NUMBER := 1.0;
5035: l_trx_rec ra_customer_trx%ROWTYPE;
5036: l_trh_rec ar_transaction_history%ROWTYPE;
5037: l_ps_rec ar_payment_schedules%ROWTYPE;
5038: l_action_rec action_rec_type;
5039: l_status VARCHAR2(30);
5040: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
5041: l_msg_count NUMBER;

Line 5050: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

5046:
5047: -- Added for bug # 2712726
5048: -- ORASHID
5049: --
5050: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
5051:
5052: BEGIN
5053:
5054: IF PG_DEBUG in ('Y', 'C') THEN