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 584: l_trh_rec ar_transaction_history%ROWTYPE;

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

Line 886: l_trh_rec ar_transaction_history%ROWTYPE;

882: l_api_name CONSTANT VARCHAR2(20) := 'Accept_BR';
883: l_api_version CONSTANT NUMBER := 1.0;
884:
885: l_trx_rec ra_customer_trx%ROWTYPE;
886: l_trh_rec ar_transaction_history%ROWTYPE;
887:
888: l_action VARCHAR2(30);
889:
890: l_trx_date DATE;

Line 1165: l_trh_rec ar_transaction_history%ROWTYPE;

1161:
1162: IS
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);

Line 1437: l_trh_rec ar_transaction_history%ROWTYPE;

1433: IS
1434: l_api_name CONSTANT VARCHAR2(20) := 'UnHold_BR';
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:

Line 1693: l_trh_rec ar_transaction_history%ROWTYPE;

1689:
1690: IS
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:

Line 1863: l_trh_rec ar_transaction_history%ROWTYPE;

1859: -- ***** Output parameters *****
1860: p_status OUT NOCOPY VARCHAR2 )
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:

Line 2022: l_trh_rec ar_transaction_history%ROWTYPE;

2018: -- ***** Input parameters *****
2019: p_ps_id IN NUMBER )
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;

Line 2026: l_trh_id ar_transaction_history.transaction_history_id%TYPE;

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
2029:
2030: IF PG_DEBUG in ('Y', 'C') THEN

Line 2183: l_trh_rec ar_transaction_history%ROWTYPE;

2179: p_status OUT NOCOPY VARCHAR2 )
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:

Line 2464: l_trh_rec ar_transaction_history%ROWTYPE;

2460: IS
2461: l_api_name CONSTANT VARCHAR2(20) := 'Cancel_BR';
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) ;

Line 2796: l_trh_rec ar_transaction_history%ROWTYPE;

2792: IS
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 ;

Line 3095: l_trh_rec ar_transaction_history%ROWTYPE;

3091: p_status OUT NOCOPY VARCHAR2) IS
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;

Line 3474: l_trh_rec ar_transaction_history%ROWTYPE;

3470: IS
3471: l_api_name CONSTANT VARCHAR2(20) := 'Protest_BR';
3472: l_api_version CONSTANT NUMBER := 1.0;
3473:
3474: l_trh_rec ar_transaction_history%ROWTYPE;
3475: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
3476: l_action VARCHAR2(30);
3477: l_trx_date DATE;
3478: l_mesg VARCHAR2(2000);

Line 3736: l_trh_rec ar_transaction_history%ROWTYPE ;

3732: IS
3733: l_api_name CONSTANT VARCHAR2(20) := 'Restate_BR';
3734: l_api_version CONSTANT NUMBER := 1.0;
3735:
3736: l_trh_rec ar_transaction_history%ROWTYPE ;
3737: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;
3738: l_action VARCHAR2(30) ;
3739: l_trx_date DATE ;
3740: l_gl_date DATE ;

Line 4010: l_trh_rec ar_transaction_history%ROWTYPE ;

4006: IS
4007: l_api_name CONSTANT VARCHAR2(20) := 'Recall_BR';
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) ;

Line 4333: l_trh_rec ar_transaction_history%ROWTYPE;

4329: p_status OUT NOCOPY VARCHAR2) IS
4330:
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;

Line 4670: l_trh_rec ar_transaction_history%ROWTYPE;

4666:
4667: l_api_name CONSTANT VARCHAR2(20) := 'UnEliminate_Risk_BR';
4668: l_api_version CONSTANT NUMBER := 1.0 ;
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;

Line 4671: l_trh_prev_rec ar_transaction_history%ROWTYPE;

4667: l_api_name CONSTANT VARCHAR2(20) := 'UnEliminate_Risk_BR';
4668: l_api_version CONSTANT NUMBER := 1.0 ;
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;

Line 5036: l_trh_rec ar_transaction_history%ROWTYPE;

5032:
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;