DBA Data[Home] [Help]

APPS.AR_BILLS_MAINTAIN_PUB dependencies on AR_TRANSACTION_HISTORY

Line 181: l_trh_rec ar_transaction_history%ROWTYPE;

177: l_api_name CONSTANT VARCHAR2(20) := 'Complete_BR';
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 ;

Line 573: l_trh_rec ar_transaction_history%ROWTYPE;

569: l_api_name CONSTANT VARCHAR2(20) := 'UnComplete_BR';
570: l_api_version CONSTANT NUMBER := 1.0;
571:
572: l_trx_rec ra_customer_trx%ROWTYPE;
573: l_trh_rec ar_transaction_history%ROWTYPE;
574: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
575:
576: l_acceptance_flag VARCHAR2(1) ;
577:

Line 875: l_trh_rec ar_transaction_history%ROWTYPE;

871: l_api_name CONSTANT VARCHAR2(20) := 'Accept_BR';
872: l_api_version CONSTANT NUMBER := 1.0;
873:
874: l_trx_rec ra_customer_trx%ROWTYPE;
875: l_trh_rec ar_transaction_history%ROWTYPE;
876:
877: l_action VARCHAR2(30);
878:
879: l_trx_date DATE;

Line 1154: l_trh_rec ar_transaction_history%ROWTYPE;

1150:
1151: IS
1152: l_api_name CONSTANT VARCHAR2(20) := 'Hold_BR';
1153: l_api_version CONSTANT NUMBER := 1.0;
1154: l_trh_rec ar_transaction_history%ROWTYPE;
1155: l_trx_rec ra_customer_trx%ROWTYPE;
1156: l_ps_rec ar_payment_schedules%ROWTYPE;
1157:
1158: l_action VARCHAR2(30);

Line 1426: l_trh_rec ar_transaction_history%ROWTYPE;

1422: IS
1423: l_api_name CONSTANT VARCHAR2(20) := 'UnHold_BR';
1424: l_api_version CONSTANT NUMBER := 1.0;
1425:
1426: l_trh_rec ar_transaction_history%ROWTYPE;
1427: l_trx_rec ra_customer_trx%ROWTYPE;
1428: l_ps_rec ar_payment_schedules%ROWTYPE;
1429: l_action VARCHAR2(30);
1430:

Line 1682: l_trh_rec ar_transaction_history%ROWTYPE;

1678:
1679: IS
1680:
1681: l_batch_rec ar_batches%ROWTYPE;
1682: l_trh_rec ar_transaction_history%ROWTYPE;
1683: l_trx_rec ra_customer_trx%ROWTYPE;
1684: l_ps_rec ar_payment_schedules%ROWTYPE;
1685: l_action VARCHAR2(30);
1686:

Line 1852: l_trh_rec ar_transaction_history%ROWTYPE;

1848: -- ***** Output parameters *****
1849: p_status OUT NOCOPY VARCHAR2 )
1850: IS
1851:
1852: l_trh_rec ar_transaction_history%ROWTYPE;
1853: l_trx_rec ra_customer_trx%ROWTYPE;
1854: l_ps_rec ar_payment_schedules%ROWTYPE;
1855: l_action VARCHAR2(30);
1856:

Line 2011: l_trh_rec ar_transaction_history%ROWTYPE;

2007: -- ***** Input parameters *****
2008: p_ps_id IN NUMBER )
2009: IS
2010:
2011: l_trh_rec ar_transaction_history%ROWTYPE;
2012: l_trx_rec ra_customer_trx%ROWTYPE;
2013: l_ps_rec ar_payment_schedules%ROWTYPE;
2014: l_action VARCHAR2(30);
2015: l_trh_id ar_transaction_history.transaction_history_id%TYPE;

Line 2015: l_trh_id ar_transaction_history.transaction_history_id%TYPE;

2011: l_trh_rec ar_transaction_history%ROWTYPE;
2012: l_trx_rec ra_customer_trx%ROWTYPE;
2013: l_ps_rec ar_payment_schedules%ROWTYPE;
2014: l_action VARCHAR2(30);
2015: l_trh_id ar_transaction_history.transaction_history_id%TYPE;
2016:
2017: BEGIN
2018:
2019: IF PG_DEBUG in ('Y', 'C') THEN

Line 2172: l_trh_rec ar_transaction_history%ROWTYPE;

2168: p_status OUT NOCOPY VARCHAR2 )
2169:
2170: IS
2171: l_batch_rec ar_batches%ROWTYPE;
2172: l_trh_rec ar_transaction_history%ROWTYPE;
2173: l_ps_rec ar_payment_schedules%ROWTYPE;
2174: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
2175: l_action VARCHAR2(30);
2176:

Line 2453: l_trh_rec ar_transaction_history%ROWTYPE;

2449: IS
2450: l_api_name CONSTANT VARCHAR2(20) := 'Cancel_BR';
2451: l_api_version CONSTANT NUMBER := 1.0;
2452:
2453: l_trh_rec ar_transaction_history%ROWTYPE;
2454: l_trx_rec ra_customer_trx%ROWTYPE;
2455: l_ps_rec ar_payment_schedules%ROWTYPE;
2456:
2457: l_acceptance_flag VARCHAR2(1) ;

Line 2785: l_trh_rec ar_transaction_history%ROWTYPE;

2781: IS
2782: l_api_name CONSTANT VARCHAR2(20) := 'Unpaid_BR';
2783: l_api_version CONSTANT NUMBER := 1.0;
2784:
2785: l_trh_rec ar_transaction_history%ROWTYPE;
2786: l_ps_rec ar_payment_schedules%ROWTYPE;
2787: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
2788:
2789: l_trx_date DATE ;

Line 3084: l_trh_rec ar_transaction_history%ROWTYPE;

3080: p_status OUT NOCOPY VARCHAR2) IS
3081:
3082: l_api_name CONSTANT VARCHAR2(20) := 'Endorse_BR';
3083: l_api_version CONSTANT NUMBER := 1.0;
3084: l_trh_rec ar_transaction_history%ROWTYPE;
3085: l_ps_rec ar_payment_schedules%ROWTYPE;
3086: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
3087: l_action VARCHAR2(30);
3088: new_adj_id ar_adjustments.adjustment_id%type;

Line 3463: l_trh_rec ar_transaction_history%ROWTYPE;

3459: IS
3460: l_api_name CONSTANT VARCHAR2(20) := 'Protest_BR';
3461: l_api_version CONSTANT NUMBER := 1.0;
3462:
3463: l_trh_rec ar_transaction_history%ROWTYPE;
3464: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
3465: l_action VARCHAR2(30);
3466: l_trx_date DATE;
3467: l_mesg VARCHAR2(2000);

Line 3725: l_trh_rec ar_transaction_history%ROWTYPE ;

3721: IS
3722: l_api_name CONSTANT VARCHAR2(20) := 'Restate_BR';
3723: l_api_version CONSTANT NUMBER := 1.0;
3724:
3725: l_trh_rec ar_transaction_history%ROWTYPE ;
3726: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;
3727: l_action VARCHAR2(30) ;
3728: l_trx_date DATE ;
3729: l_gl_date DATE ;

Line 3999: l_trh_rec ar_transaction_history%ROWTYPE ;

3995: IS
3996: l_api_name CONSTANT VARCHAR2(20) := 'Recall_BR';
3997: l_api_version CONSTANT NUMBER := 1.0;
3998:
3999: l_trh_rec ar_transaction_history%ROWTYPE ;
4000: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;
4001: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE ;
4002: l_adj_id AR_ADJUSTMENTS.adjustment_id%TYPE ;
4003: l_action VARCHAR2(30) ;

Line 4322: l_trh_rec ar_transaction_history%ROWTYPE;

4318: p_status OUT NOCOPY VARCHAR2) IS
4319:
4320: l_api_name CONSTANT VARCHAR2(20) := 'Eliminate_Risk_BR';
4321: l_api_version CONSTANT NUMBER := 1.0;
4322: l_trh_rec ar_transaction_history%ROWTYPE;
4323: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
4324: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
4325: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4326: l_adj_id AR_ADJUSTMENTS.adjustment_id%TYPE;

Line 4659: l_trh_rec ar_transaction_history%ROWTYPE;

4655:
4656: l_api_name CONSTANT VARCHAR2(20) := 'UnEliminate_Risk_BR';
4657: l_api_version CONSTANT NUMBER := 1.0 ;
4658:
4659: l_trh_rec ar_transaction_history%ROWTYPE;
4660: l_trh_prev_rec ar_transaction_history%ROWTYPE;
4661: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
4662: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
4663: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;

Line 4660: l_trh_prev_rec ar_transaction_history%ROWTYPE;

4656: l_api_name CONSTANT VARCHAR2(20) := 'UnEliminate_Risk_BR';
4657: l_api_version CONSTANT NUMBER := 1.0 ;
4658:
4659: l_trh_rec ar_transaction_history%ROWTYPE;
4660: l_trh_prev_rec ar_transaction_history%ROWTYPE;
4661: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
4662: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
4663: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4664: l_adj_id AR_ADJUSTMENTS.adjustment_id%TYPE;

Line 5025: l_trh_rec ar_transaction_history%ROWTYPE;

5021:
5022: l_api_name CONSTANT VARCHAR2(20) := 'Exchange_BR';
5023: l_api_version CONSTANT NUMBER := 1.0;
5024: l_trx_rec ra_customer_trx%ROWTYPE;
5025: l_trh_rec ar_transaction_history%ROWTYPE;
5026: l_ps_rec ar_payment_schedules%ROWTYPE;
5027: l_action_rec action_rec_type;
5028: l_status VARCHAR2(30);
5029: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;