DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on FND_CURRENCIES

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

1156: from dual;
1157:
1158: -- start addition by ssumaith -bug# 3127834
1159:
1160: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
1161: select precision
1162: from fnd_currencies
1163: where currency_code = cp_currency_code;
1164:

Line 1162: from fnd_currencies

1158: -- start addition by ssumaith -bug# 3127834
1159:
1160: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
1161: select precision
1162: from fnd_currencies
1163: where currency_code = cp_currency_code;
1164:
1165: -- ends here additions by ssumaith -bug# 3127834
1166: --Added by kunkumar for porting 4454499

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

1178: where invoice_id = p_inv_id;
1179:
1180: ln_source VARCHAR2(50);
1181:
1182: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
1183: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;
1184: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
1185: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
1186: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/

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

1961: tables. As a result the invoice was going into automatic hold because the invoice amount
1962: does not equal sum of distributions amount.
1963:
1964: This has been resolved in the bug by getting the currency precision for the invoice
1965: currency from FND_CURRENCIES table and using it in all the inserts and updates which
1966: involve the tax amounts.
1967:
1968: 40. 30/12/2004 Aparajita - Bug#4095234. Version#115.5
1969:

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

7488: from dual;
7489:
7490: -- start addition by ssumaith -bug# 3127834
7491:
7492: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
7493: select precision
7494: from fnd_currencies
7495: where currency_code = cp_currency_code;
7496:

Line 7494: from fnd_currencies

7490: -- start addition by ssumaith -bug# 3127834
7491:
7492: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
7493: select precision
7494: from fnd_currencies
7495: where currency_code = cp_currency_code;
7496:
7497: -- ends here additions by ssumaith -bug# 3127834
7498:

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

7495: where currency_code = cp_currency_code;
7496:
7497: -- ends here additions by ssumaith -bug# 3127834
7498:
7499: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
7500: v_statement_no VARCHAR2(6);
7501: v_dist_reversal_cnt NUMBER;
7502: v_batch_id NUMBER;
7503: c_tax_rec c_tax%ROWTYPE;

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

8058: tables. As a result the invoice was going into automatic hold because the invoice amount
8059: does not equal sum of distributions amount.
8060:
8061: This has been resolved in the bug by getting the currency precision for the invoice
8062: currency from FND_CURRENCIES table and using it in all the inserts and updates which
8063: involve the tax amounts.
8064:
8065: 38. 21/01/2005 Aparajita - Bug#4078546 Service Tax. Version#115.3
8066: