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.ARP_PROCESS_DET_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 4: g_payschedule_trx ar_payment_schedules%ROWTYPE;

1: PACKAGE BODY arp_process_det_pkg AS
2: /* $Header: ARDLAPPB.pls 120.20.12010000.3 2008/11/18 13:28:11 dgaurab ship $*/
3: g_gt_id NUMBER := 0;
4: g_payschedule_trx ar_payment_schedules%ROWTYPE;
5: g_payschedule_rec ar_payment_schedules%ROWTYPE;
6: g_payschedule_clr ar_payment_schedules%ROWTYPE;
7: g_app_ra_id NUMBER;
8: g_bulk_fetch_rows NUMBER := 10000;

Line 5: g_payschedule_rec ar_payment_schedules%ROWTYPE;

1: PACKAGE BODY arp_process_det_pkg AS
2: /* $Header: ARDLAPPB.pls 120.20.12010000.3 2008/11/18 13:28:11 dgaurab ship $*/
3: g_gt_id NUMBER := 0;
4: g_payschedule_trx ar_payment_schedules%ROWTYPE;
5: g_payschedule_rec ar_payment_schedules%ROWTYPE;
6: g_payschedule_clr ar_payment_schedules%ROWTYPE;
7: g_app_ra_id NUMBER;
8: g_bulk_fetch_rows NUMBER := 10000;
9: g_customer_trx ra_customer_trx%ROWTYPE;

Line 6: g_payschedule_clr ar_payment_schedules%ROWTYPE;

2: /* $Header: ARDLAPPB.pls 120.20.12010000.3 2008/11/18 13:28:11 dgaurab ship $*/
3: g_gt_id NUMBER := 0;
4: g_payschedule_trx ar_payment_schedules%ROWTYPE;
5: g_payschedule_rec ar_payment_schedules%ROWTYPE;
6: g_payschedule_clr ar_payment_schedules%ROWTYPE;
7: g_app_ra_id NUMBER;
8: g_bulk_fetch_rows NUMBER := 10000;
9: g_customer_trx ra_customer_trx%ROWTYPE;
10: g_ae_sys_rec arp_acct_main.ae_sys_rec_type;

Line 101: p_ps_rec IN ar_payment_schedules%ROWTYPE,

97: p_line_uediscounted IN NUMBER,
98: p_tax_uediscounted IN NUMBER,
99: p_freight_uediscounted IN NUMBER,
100: p_charges_uediscounted IN NUMBER,
101: p_ps_rec IN ar_payment_schedules%ROWTYPE,
102: --
103: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE,
104: x_return_status IN OUT NOCOPY VARCHAR2);
105:

Line 262: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE);

258: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE)
259: RETURN VARCHAR2;
260:
261:
262: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE);
263:
264:
265:
266: --

Line 543: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE)

539:
540:
541: -- procedures and functions Body
542:
543: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE)
544: IS
545: BEGIN
546: arp_standard.debug('p_ps_rec.amount_applied :'||p_ps_rec.amount_applied);
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);

Line 581: FROM ar_payment_schedules

577: (x_return_status IN OUT NOCOPY VARCHAR2)
578: IS
579: CURSOR c_ps IS
580: SELECT *
581: FROM ar_payment_schedules
582: WHERE class in ('INV','DM') /* Bug 5189370 */
583: AND customer_trx_id = g_customer_trx.customer_trx_id
584: AND status = 'OP';
585: l_cpt NUMBER := 0;

Line 586: l_inv_ps ar_payment_schedules%ROWTYPE;

582: WHERE class in ('INV','DM') /* Bug 5189370 */
583: AND customer_trx_id = g_customer_trx.customer_trx_id
584: AND status = 'OP';
585: l_cpt NUMBER := 0;
586: l_inv_ps ar_payment_schedules%ROWTYPE;
587: no_installed_inv_allowed EXCEPTION;
588: no_op_trx_pay_schedule EXCEPTION;
589: no_customer_trx_cache EXCEPTION;
590: BEGIN

Line 660: FROM ar_payment_schedules

656: x_return_status IN OUT NOCOPY VARCHAR2)
657: IS
658: CURSOR c_ps IS
659: SELECT *
660: FROM ar_payment_schedules
661: WHERE class = 'PMT'
662: AND cash_receipt_id = p_cr_id
663: AND status = 'OP';
664: l_cpt NUMBER := 0;

Line 665: l_rec_ps ar_payment_schedules%ROWTYPE;

661: WHERE class = 'PMT'
662: AND cash_receipt_id = p_cr_id
663: AND status = 'OP';
664: l_cpt NUMBER := 0;
665: l_rec_ps ar_payment_schedules%ROWTYPE;
666: no_op_rec_pay_schedule EXCEPTION;
667: BEGIN
668: arp_standard.debug('get_rec_ps +');
669: arp_standard.debug(' p_cr_id :'||p_cr_id);

Line 753: p_ps_rec IN ar_payment_schedules%ROWTYPE,

749: p_line_uediscounted IN NUMBER,
750: p_tax_uediscounted IN NUMBER,
751: p_freight_uediscounted IN NUMBER,
752: p_charges_uediscounted IN NUMBER,
753: p_ps_rec IN ar_payment_schedules%ROWTYPE,
754: --
755: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE,
756: x_return_status IN OUT NOCOPY VARCHAR2)
757: IS

Line 790: l_ps_rec ar_payment_schedules%ROWTYPE;

786: l_earned_concern VARCHAR2(50);
787: l_uearned_concern VARCHAR2(50);
788: l_apps_rec ar_receivable_apps_gt%ROWTYPE;
789: l_gt_id VARCHAR2(30);
790: l_ps_rec ar_payment_schedules%ROWTYPE;
791: l_discount_taken_earned NUMBER := 0;
792: l_discount_taken_unearned NUMBER := 0;
793: neg_app_amt EXCEPTION;
794: neg_earned_amt EXCEPTION;

Line 803: p_bc_ps_rec IN ar_payment_schedules%ROWTYPE)

799: p_tax_applied IN NUMBER,
800: p_freight_applied IN NUMBER,
801: p_charges_applied IN NUMBER,
802: x_amount_applied OUT NOCOPY NUMBER,
803: p_bc_ps_rec IN ar_payment_schedules%ROWTYPE)
804: RETURN VARCHAR2
805: IS
806: l_line_applied NUMBER;
807: l_tax_applied NUMBER;

Line 1429: l_ps_rec ar_payment_schedules%ROWTYPE;

1425: PROCEDURE res_inv_ps
1426: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1427: x_return_status IN OUT NOCOPY VARCHAR2)
1428: IS
1429: l_ps_rec ar_payment_schedules%ROWTYPE;
1430: l_line_discounted NUMBER;
1431: l_tax_discounted NUMBER;
1432: l_charges_discounted NUMBER;
1433: l_discount_taken_total NUMBER;