[Home] [Help]
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) ;
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:
578: l_action VARCHAR2(30) ;
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);
1159:
1160: BEGIN
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:
1431: BEGIN
1432:
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:
1687: BEGIN
1688:
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:
1857: BEGIN
1858:
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;
2016:
2017: BEGIN
2160:
2161: -- ***** Input parameters *****
2162:
2163: p_batch_id IN ar_batches.batch_id%TYPE ,
2164: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
2165:
2166: -- ***** Output parameters *****
2167:
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:
2177: BEGIN
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) ;
2458:
2459: l_action VARCHAR2(30) ;
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 ;
2790: l_gl_date DATE ;
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;
3089: l_move_deferred_tax VARCHAR2(1) := 'N';
3092: l_mesg VARCHAR2(2000);
3093: -- Added for bug # 2712726
3094: -- ORASHID
3095: --
3096: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
3097:
3098: BEGIN
3099:
3100: IF PG_DEBUG in ('Y', 'C') THEN
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) ;
4004: l_trx_date DATE ;
4005: l_gl_date DATE ;
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;
4327: l_move_deferred_tax VARCHAR2(1) := 'N';
4328: l_action VARCHAR2(30);
4332:
4333: -- Added for bug # 2712726
4334: -- ORASHID
4335: --
4336: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
4337:
4338: BEGIN
4339:
4340: IF PG_DEBUG in ('Y', 'C') THEN
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;
4665: l_move_deferred_tax VARCHAR2(1):= 'N';
4666: l_action VARCHAR2(30);
4672:
4673: -- Added for bug # 2712726
4674: -- ORASHID
4675: --
4676: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
4677:
4678: BEGIN
4679:
4680: IF PG_DEBUG in ('Y', 'C') THEN
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;
5030: l_msg_count NUMBER;
5035:
5036: -- Added for bug # 2712726
5037: -- ORASHID
5038: --
5039: l_nocopy_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
5040:
5041: BEGIN
5042:
5043: IF PG_DEBUG in ('Y', 'C') THEN