APPS.ARP_ETAX_UTIL dependencies on AR_ADJUSTMENTS

Line 1437: l_adj_rec ar_adjustments%ROWTYPE;

1433: l_msg_count NUMBER;
1434: l_msg_data VARCHAR2(4000);
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;

Line 1657: FROM ar_adjustments

1653: IF l_mode = 'ADJUST'
1654: THEN
1655: SELECT *
1656: INTO l_adj_rec
1657: FROM ar_adjustments
1658: WHERE adjustment_id = p_transaction_rec.trx_id;
1659:
1660: SELECT *
1661: INTO l_trx_rec

Line 1820: l_adj_rec ar_adjustments%ROWTYPE;

1816: p_adj_id IN NUMBER,
1817: p_prorated_line IN NUMBER,
1818: p_prorated_tax IN NUMBER)
1819: IS
1820: l_adj_rec ar_adjustments%ROWTYPE;
1821: l_ps_rec ar_payment_schedules%ROWTYPE;
1822: l_orig_line_adj NUMBER := 0;
1823: l_orig_tax_adj NUMBER := 0;
1824: l_ps_update_needed BOOLEAN := TRUE;

Line 1840: FROM ar_adjustments

1836: SELECT nvl(line_adjusted,0),
1837: nvl(tax_adjusted,0)
1838: INTO l_orig_line_adj,
1839: l_orig_tax_adj
1840: FROM ar_adjustments
1841: WHERE adjustment_id = p_adj_id;
1842:
1843: /* if the original and new amounts are
1844: different, update adjustment here */

Line 1850: UPDATE ar_adjustments

1846: l_orig_tax_adj <> p_prorated_tax
1847: THEN
1848:
1849: /* update adjustment manually */
1850: UPDATE ar_adjustments
1851: SET line_adjusted = p_prorated_line,
1852: tax_adjusted = p_prorated_tax
1853: WHERE adjustment_id = p_adj_id;
1854: ELSE

Line 1877: FROM ar_adjustments

1873: NOTE: This includes update line and tax
1874: from above */
1875: SELECT *
1876: INTO l_adj_rec
1877: FROM ar_adjustments
1878: WHERE adjustment_id = p_adj_id;
1879:
1880: arp_util.debug('from adj record ');
1881: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);

Line 2235: FROM ar_adjustments a,

2231: /* Get adj number */
2232: SELECT a.adjustment_number, r.tax_recoverable_flag
2233: INTO l_adj_number,
2234: l_recov_flag
2235: FROM ar_adjustments a,
2236: ar_receivables_trx r
2237: WHERE a.adjustment_id = p_adj_id
2238: AND a.receivables_trx_id = r.receivables_trx_id
2239: AND a.org_id = r.org_id;