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 RA_CUSTOMER_TRX

Line 144: | with data model definition in RA_CUSTOMER_TRX|

140: | |
141: | HISTORY |
142: | 01-OCT-02 V Crisostomo Bug 2533917 : p_old_trx_number datatype was |
143: | changed from NUMBER to VARCHAR2 to comply |
144: | with data model definition in RA_CUSTOMER_TRX|
145: | 25-MAY-05 V Crisostomo SSA-R12: pass org_id |
146: +===========================================================================*/
147:
148:

Line 180: l_trx_rec ra_customer_trx%ROWTYPE;

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

Line 195: l_drawee_id ra_customer_trx.drawee_id%type;

191: l_action VARCHAR2(30) ;
192: l_action_rec action_rec_type ;
193:
194: --Bug5051673
195: l_drawee_id ra_customer_trx.drawee_id%type;
196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;
197: l_org_id ra_customer_trx.org_id%type;
198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;
199: l_created_from ra_customer_trx.created_from%type;

Line 196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;

192: l_action_rec action_rec_type ;
193:
194: --Bug5051673
195: l_drawee_id ra_customer_trx.drawee_id%type;
196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;
197: l_org_id ra_customer_trx.org_id%type;
198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;
199: l_created_from ra_customer_trx.created_from%type;
200: l_instr_id iby_trxn_extensions_v.instr_assignment_id%type;

Line 197: l_org_id ra_customer_trx.org_id%type;

193:
194: --Bug5051673
195: l_drawee_id ra_customer_trx.drawee_id%type;
196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;
197: l_org_id ra_customer_trx.org_id%type;
198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;
199: l_created_from ra_customer_trx.created_from%type;
200: l_instr_id iby_trxn_extensions_v.instr_assignment_id%type;
201:

Line 198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;

194: --Bug5051673
195: l_drawee_id ra_customer_trx.drawee_id%type;
196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;
197: l_org_id ra_customer_trx.org_id%type;
198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;
199: l_created_from ra_customer_trx.created_from%type;
200: l_instr_id iby_trxn_extensions_v.instr_assignment_id%type;
201:
202:

Line 199: l_created_from ra_customer_trx.created_from%type;

195: l_drawee_id ra_customer_trx.drawee_id%type;
196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;
197: l_org_id ra_customer_trx.org_id%type;
198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;
199: l_created_from ra_customer_trx.created_from%type;
200: l_instr_id iby_trxn_extensions_v.instr_assignment_id%type;
201:
202:
203: BEGIN

Line 257: from ra_customer_trx

253: select trx_number,drawee_id,drawee_site_use_id,org_id,payment_trxn_extension_id,
254: substr(created_from ,1,8)
255: into l_trx_number,l_drawee_id,l_drawee_site_use_id,l_org_id,l_payment_trxn_extension_id,
256: l_created_from
257: from ra_customer_trx
258: where customer_trx_id = p_customer_trx_id;
259:
260: if l_payment_trxn_extension_id is null then
261: If substr(l_created_from,1,8) = 'ARBRCBAT' then

Line 272: from ra_customer_Trx_lines brlines,

268:
269: Begin
270: Select instr_assignment_id
271: Into l_instr_id
272: from ra_customer_Trx_lines brlines,
273: ra_customer_trx ct,
274: iby_trxn_extensions_v iby
275: where ct.customer_trx_id = brlines.br_ref_customer_trx_id
276: and ct.payment_trxn_extension_id = iby.trxn_extension_id

Line 273: ra_customer_trx ct,

269: Begin
270: Select instr_assignment_id
271: Into l_instr_id
272: from ra_customer_Trx_lines brlines,
273: ra_customer_trx ct,
274: iby_trxn_extensions_v iby
275: where ct.customer_trx_id = brlines.br_ref_customer_trx_id
276: and ct.payment_trxn_extension_id = iby.trxn_extension_id
277: and brlines.customer_trx_id = p_customer_trx_id

Line 324: update ra_customer_trx

320: arp_standard.debug('Call to AR_BILLS_CREATION_PUB.create_br_trxn_extension Errored');
321: app_exception.raise_exception;
322: END IF;
323:
324: update ra_customer_trx
325: set payment_trxn_extension_id = l_payment_trxn_extension_id
326: where customer_trx_id = p_customer_trx_id;
327:
328: end if;

Line 583: l_trx_rec ra_customer_trx%ROWTYPE;

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

Line 885: l_trx_rec ra_customer_trx%ROWTYPE;

881: IS
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:

Line 1166: l_trx_rec ra_customer_trx%ROWTYPE;

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);
1170:

Line 1438: l_trx_rec ra_customer_trx%ROWTYPE;

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:
1442: BEGIN

Line 1694: l_trx_rec ra_customer_trx%ROWTYPE;

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:
1698: BEGIN

Line 1864: l_trx_rec ra_customer_trx%ROWTYPE;

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:
1868: BEGIN

Line 2023: l_trx_rec ra_customer_trx%ROWTYPE;

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

Line 2185: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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
2189:

Line 2465: l_trx_rec ra_customer_trx%ROWTYPE;

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) ;
2469:

Line 2798: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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 ;
2802: l_action VARCHAR2(30);

Line 3097: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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';
3101: l_trx_date DATE;

Line 3475: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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);
3479:

Line 3737: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;

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 ;
3741: l_mesg VARCHAR2(2000);

Line 4011: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;

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) ;
4015: l_trx_date DATE ;

Line 4334: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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;
4338: l_move_deferred_tax VARCHAR2(1) := 'N';

Line 4672: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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;
4676: l_move_deferred_tax VARCHAR2(1):= 'N';

Line 5035: l_trx_rec ra_customer_trx%ROWTYPE;

5031:
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);

Line 5040: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

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;
5042: l_msg_data VARCHAR2(2000);
5043: l_return_status VARCHAR2(1);
5044: