APPS.ARP_ETAX_UTIL dependencies on AR_ADJUSTMENTS

Line 1501: l_adj_rec ar_adjustments%ROWTYPE;

1497: l_msg_count NUMBER;
1498: l_msg_data VARCHAR2(4000);
1499: l_msg VARCHAR2(2000);
1500: l_mode VARCHAR2(20);
1501: l_adj_rec ar_adjustments%ROWTYPE;
1502: l_trx_rec ra_customer_trx%ROWTYPE;
1503: l_app_rec ar_receivable_applications%ROWTYPE;
1504: l_rows_inserted NUMBER;
1505: l_acct_meth ar_system_parameters.accounting_method%TYPE;

Line 1721: FROM ar_adjustments

1717: IF l_mode = 'ADJUST'
1718: THEN
1719: SELECT *
1720: INTO l_adj_rec
1721: FROM ar_adjustments
1722: WHERE adjustment_id = p_transaction_rec.trx_id;
1723:
1724: SELECT *
1725: INTO l_trx_rec

Line 1884: l_adj_rec ar_adjustments%ROWTYPE;

1880: p_adj_id IN NUMBER,
1881: p_prorated_line IN NUMBER,
1882: p_prorated_tax IN NUMBER)
1883: IS
1884: l_adj_rec ar_adjustments%ROWTYPE;
1885: l_ps_rec ar_payment_schedules%ROWTYPE;
1886: l_orig_line_adj NUMBER := 0;
1887: l_orig_tax_adj NUMBER := 0;
1888: l_ps_update_needed BOOLEAN := TRUE;

Line 1904: FROM ar_adjustments

1900: SELECT nvl(line_adjusted,0),
1901: nvl(tax_adjusted,0)
1902: INTO l_orig_line_adj,
1903: l_orig_tax_adj
1904: FROM ar_adjustments
1905: WHERE adjustment_id = p_adj_id;
1906:
1907: /* if the original and new amounts are
1908: different, update adjustment here */

Line 1914: UPDATE ar_adjustments

1910: l_orig_tax_adj <> p_prorated_tax
1911: THEN
1912:
1913: /* update adjustment manually */
1914: UPDATE ar_adjustments
1915: SET line_adjusted = p_prorated_line,
1916: tax_adjusted = p_prorated_tax
1917: WHERE adjustment_id = p_adj_id;
1918: ELSE

Line 1941: FROM ar_adjustments

1937: NOTE: This includes update line and tax
1938: from above */
1939: SELECT *
1940: INTO l_adj_rec
1941: FROM ar_adjustments
1942: WHERE adjustment_id = p_adj_id;
1943:
1944: arp_util.debug('from adj record ');
1945: arp_util.debug(' line adjusted = ' || l_adj_rec.line_adjusted);

Line 2306: FROM ar_adjustments a,

2302: SELECT a.adjustment_number, r.tax_recoverable_flag,a.tax_adjusted
2303: INTO l_adj_number,
2304: l_recov_flag,
2305: l_tax_adjusted /* Bug 8512053 */
2306: FROM ar_adjustments a,
2307: ar_receivables_trx r
2308: WHERE a.adjustment_id = p_adj_id
2309: AND a.receivables_trx_id = r.receivables_trx_id
2310: AND a.org_id = r.org_id;