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_LIB_PVT dependencies on RA_CUSTOMER_TRX

Line 88: p_trx_rec IN OUT NOCOPY RA_CUSTOMER_TRX%ROWTYPE,

84:
85: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
86:
87: PROCEDURE Get_Doc_Seq ( p_appid IN NUMBER ,
88: p_trx_rec IN OUT NOCOPY RA_CUSTOMER_TRX%ROWTYPE,
89: p_sob_id IN NUMBER ,
90: p_met_code IN VARCHAR2) IS
91:
92: l_cat_code VARCHAR2(20) ;

Line 433: -- Get the remittance batch id in ra_customer_trx_id

429: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()+');
430: END IF;
431:
432:
433: -- Get the remittance batch id in ra_customer_trx_id
434:
435: IF PG_DEBUG in ('Y', 'C') THEN
436: arp_util.debug ( 'Customer_Trx_Id : ' || p_customer_trx_id);
437: END IF;

Line 441: FROM ra_customer_trx

437: END IF;
438:
439: SELECT remittance_batch_id
440: INTO p_batch_rec.batch_id
441: FROM ra_customer_trx
442: WHERE customer_trx_id = p_customer_trx_id;
443:
444: -- Modified for bug # 2712726
445: -- ORASHID

Line 608: FROM ra_customer_trx_lines

604:
605: CURSOR assignment_cur IS
606: SELECT br_ref_customer_trx_id, br_ref_payment_schedule_id, extended_amount,
607: customer_trx_line_id, extended_acctd_amount
608: FROM ra_customer_trx_lines
609: WHERE customer_trx_id = p_trh_rec.customer_trx_id;
610:
611: assignment_rec assignment_cur%ROWTYPE ;
612:

Line 615: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;

611: assignment_rec assignment_cur%ROWTYPE ;
612:
613: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;
614: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE ;
615: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;
616: l_new_adjust_id NUMBER ;
617: l_move_deferred_tax VARCHAR2(1) := 'N' ;
618:
619: BEGIN

Line 656: UPDATE ra_customer_trx_lines

652: +-----------------------------------------------*/
653:
654: arp_ctl_pkg.lock_p (assignment_rec.customer_trx_line_id);
655:
656: UPDATE ra_customer_trx_lines
657: SET br_adjustment_id = l_new_adjust_id
658: WHERE customer_trx_line_id = assignment_rec.customer_trx_line_id;
659:
660:

Line 734: PROCEDURE Complete_Acc_Required (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)

730: | |
731: +==============================================================================*/
732:
733:
734: PROCEDURE Complete_Acc_Required (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)
735: IS
736:
737:
738: CURSOR assignment_cur IS

Line 740: FROM ra_customer_trx_lines

736:
737:
738: CURSOR assignment_cur IS
739: SELECT br_ref_payment_schedule_id
740: FROM ra_customer_trx_lines
741: WHERE customer_trx_id = p_customer_trx_id;
742:
743: assignment_rec assignment_cur%ROWTYPE ;
744:

Line 793: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

789: +==============================================================================*/
790:
791:
792: PROCEDURE Create_Adjustment ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
793: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
794: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
795: p_amount IN NUMBER ,
796: p_receivables_trx_id IN ar_receivables_trx.receivables_trx_id%TYPE ,
797: p_status IN VARCHAR2 ,

Line 932: PROCEDURE Find_Last_Adjustment (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

928: | |
929: +==============================================================================*/
930:
931:
932: PROCEDURE Find_Last_Adjustment (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
933: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE )
934:
935: IS
936:

Line 1204: l_customer_trx ra_customer_trx%ROWTYPE;

1200:
1201: l_org_return_status VARCHAR2(1);
1202: l_org_id NUMBER;
1203:
1204: l_customer_trx ra_customer_trx%ROWTYPE;
1205:
1206:
1207: BEGIN
1208:

Line 1277: from ar_adjustments adj,ra_customer_trx ra

1273: begin
1274:
1275: select adj.customer_trx_id,ra.upgrade_method
1276: into l_customer_trx.customer_trx_id, l_customer_trx.upgrade_method
1277: from ar_adjustments adj,ra_customer_trx ra
1278: where adj.adjustment_id = l_new_adjust_id
1279: and ra.customer_trx_id = adj.customer_trx_id;
1280:
1281: exception

Line 1279: and ra.customer_trx_id = adj.customer_trx_id;

1275: select adj.customer_trx_id,ra.upgrade_method
1276: into l_customer_trx.customer_trx_id, l_customer_trx.upgrade_method
1277: from ar_adjustments adj,ra_customer_trx ra
1278: where adj.adjustment_id = l_new_adjust_id
1279: and ra.customer_trx_id = adj.customer_trx_id;
1280:
1281: exception
1282: when others then
1283: arp_util.debug( '>>>>>>>>>> Problems during balance stamping select query');

Line 1348: FROM ra_customer_trx_lines

1344: IS
1345:
1346: CURSOR assignment_cur IS
1347: SELECT br_adjustment_id, br_ref_payment_schedule_id, customer_trx_line_id, br_ref_customer_trx_id
1348: FROM ra_customer_trx_lines
1349: WHERE customer_trx_id = p_trh_rec.customer_trx_id;
1350:
1351: assignment_rec assignment_cur%ROWTYPE ;
1352:

Line 1358: l_trx_rec ra_customer_trx%ROWTYPE ;

1354: l_msg VARCHAR2(240) ;
1355: l_msg_count NUMBER ;
1356: l_return_status VARCHAR2(1) ;
1357: l_ps_rec ar_payment_schedules%ROWTYPE ;
1358: l_trx_rec ra_customer_trx%ROWTYPE ;
1359: l_trh_rec ar_transaction_history%ROWTYPE ;
1360:
1361: BEGIN
1362:

Line 1387: UPDATE ra_customer_trx_lines

1383:
1384:
1385: arp_ctl_pkg.lock_p (assignment_rec.customer_trx_line_id);
1386:
1387: UPDATE ra_customer_trx_lines
1388: SET br_adjustment_id = NULL
1389: WHERE customer_trx_line_id = assignment_rec.customer_trx_line_id;
1390:
1391:

Line 1466: PROCEDURE Find_Last_Receipt ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

1462: | |
1463: +==============================================================================*/
1464:
1465:
1466: PROCEDURE Find_Last_Receipt ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
1467: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE )
1468:
1469: IS
1470:

Line 1517: PROCEDURE Find_Last_STD ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

1513: | |
1514: +==============================================================================*/
1515:
1516:
1517: PROCEDURE Find_Last_STD ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
1518: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE ,
1519: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE)
1520:
1521: IS

Line 1823: PROCEDURE Apply_STD ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

1819: | |
1820: +==============================================================================*/
1821:
1822:
1823: PROCEDURE Apply_STD ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
1824: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
1825: p_apply_date IN DATE ,
1826: p_apply_gl_date IN DATE )
1827:

Line 2085: p_remittance_batch_id IN ra_customer_trx.remittance_batch_id%TYPE,

2081: +==============================================================================*/
2082:
2083: PROCEDURE Unpaid ( p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE ,
2084: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2085: p_remittance_batch_id IN ra_customer_trx.remittance_batch_id%TYPE,
2086: p_unpaid_reason IN VARCHAR2 )
2087: IS
2088:
2089: l_adj_id ar_adjustments.adjustment_id%TYPE ;