APPS.ARP_ETAX_UTIL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1439: l_app_rec ar_receivable_applications%ROWTYPE;

1435: l_msg VARCHAR2(2000);
1436: l_mode VARCHAR2(20);
1437: l_adj_rec ar_adjustments%ROWTYPE;
1438: l_trx_rec ra_customer_trx%ROWTYPE;
1439: l_app_rec ar_receivable_applications%ROWTYPE;
1440: l_rows_inserted NUMBER;
1441: l_acct_meth ar_system_parameters.accounting_method%TYPE;
1442: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1443: l_gt_passed BOOLEAN := FALSE;

Line 1735: l_app_rec ar_receivable_applications%ROWTYPE;

1731: l_msg_count NUMBER;
1732: l_msg_data VARCHAR2(4000);
1733: l_msg VARCHAR2(2000);
1734: l_trx_rec ra_customer_trx%ROWTYPE;
1735: l_app_rec ar_receivable_applications%ROWTYPE;
1736: l_acct_meth ar_system_parameters.accounting_method%TYPE;
1737: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1738:
1739: BEGIN

Line 1747: FROM ar_receivable_applications

1743: END IF;
1744:
1745: SELECT *
1746: INTO l_app_rec
1747: FROM ar_receivable_applications
1748: WHERE receivable_application_id = p_rec_app_id;
1749:
1750: SELECT *
1751: INTO l_trx_rec

Line 2260: SELECT ar_receivable_applications_s.nextval

2256: It may be zero coming from arcpau */
2257: IF NVL(p_ra_app_id,0) = 0
2258: THEN
2259: /* get it from sequence */
2260: SELECT ar_receivable_applications_s.nextval
2261: INTO p_ra_app_id
2262: FROM DUAL;
2263:
2264: IF PG_DEBUG IN ('Y','C')