DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on FND_CURRENCIES

Line 875: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is

871: from dual;
872:
873: -- start addition by ssumaith -bug# 3127834
874:
875: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
876: select precision
877: from fnd_currencies
878: where currency_code = cp_currency_code;
879:

Line 877: from fnd_currencies

873: -- start addition by ssumaith -bug# 3127834
874:
875: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
876: select precision
877: from fnd_currencies
878: where currency_code = cp_currency_code;
879:
880: -- ends here additions by ssumaith -bug# 3127834
881: --Added by kunkumar for porting 4454499

Line 887: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834

883: select NVL(rounding_factor,-1)
884: from jai_cmn_taxes_all
885: where tax_id = cp_tax_id ;
886:
887: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
888: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
889: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
890: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/
891: vPoUomCode mtl_units_of_measure.unit_of_measure%TYPE;

Line 1638: currency from FND_CURRENCIES table and using it in all the inserts and updates which

1634: tables. As a result the invoice was going into automatic hold because the invoice amount
1635: does not equal sum of distributions amount.
1636:
1637: This has been resolved in the bug by getting the currency precision for the invoice
1638: currency from FND_CURRENCIES table and using it in all the inserts and updates which
1639: involve the tax amounts.
1640:
1641: 40. 30/12/2004 Aparajita - Bug#4095234. Version#115.5
1642:

Line 5941: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is

5937: from dual;
5938:
5939: -- start addition by ssumaith -bug# 3127834
5940:
5941: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5942: select precision
5943: from fnd_currencies
5944: where currency_code = cp_currency_code;
5945:

Line 5943: from fnd_currencies

5939: -- start addition by ssumaith -bug# 3127834
5940:
5941: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5942: select precision
5943: from fnd_currencies
5944: where currency_code = cp_currency_code;
5945:
5946: -- ends here additions by ssumaith -bug# 3127834
5947:

Line 5948: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834

5944: where currency_code = cp_currency_code;
5945:
5946: -- ends here additions by ssumaith -bug# 3127834
5947:
5948: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
5949: v_statement_no VARCHAR2(6);
5950: v_dist_reversal_cnt NUMBER;
5951: v_batch_id NUMBER;
5952: c_tax_rec c_tax%ROWTYPE;

Line 6508: currency from FND_CURRENCIES table and using it in all the inserts and updates which

6504: tables. As a result the invoice was going into automatic hold because the invoice amount
6505: does not equal sum of distributions amount.
6506:
6507: This has been resolved in the bug by getting the currency precision for the invoice
6508: currency from FND_CURRENCIES table and using it in all the inserts and updates which
6509: involve the tax amounts.
6510:
6511: 38. 21/01/2005 Aparajita - Bug#4078546 Service Tax. Version#115.3
6512: