eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_TAXES_B

Line 161: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

157: p_return_status OUT NOCOPY VARCHAR2,
158: p_error_buffer OUT NOCOPY VARCHAR2);
159:
160: PROCEDURE get_rounding_info(
161: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
162: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
163: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE, --bug#6526550
164: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
165: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,

Line 168: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

164: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
165: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
166: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
167: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
168: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
169: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
170: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
171: p_return_status OUT NOCOPY VARCHAR2,
172: p_error_buffer OUT NOCOPY VARCHAR2

Line 169: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,

165: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
166: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
167: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
168: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
169: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
170: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
171: p_return_status OUT NOCOPY VARCHAR2,
172: p_error_buffer OUT NOCOPY VARCHAR2
173: );

Line 170: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,

166: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
167: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
168: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
169: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
170: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
171: p_return_status OUT NOCOPY VARCHAR2,
172: p_error_buffer OUT NOCOPY VARCHAR2
173: );
174:

Line 215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
218: p_return_status OUT NOCOPY VARCHAR2,
219: p_error_buffer OUT NOCOPY VARCHAR2,

Line 216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
218: p_return_status OUT NOCOPY VARCHAR2,
219: p_error_buffer OUT NOCOPY VARCHAR2,
220: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884

Line 217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
218: p_return_status OUT NOCOPY VARCHAR2,
219: p_error_buffer OUT NOCOPY VARCHAR2,
220: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
221:

Line 242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

Line 243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

Line 244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
248: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,

Line 268: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

264: p_error_buffer OUT NOCOPY VARCHAR2
265: );
266:
267: PROCEDURE do_rounding(
268: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,

Line 328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

324: );
325:
326: PROCEDURE update_header_rounding_info(
327: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,

Line 1223: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

1219: --
1220:
1221: FUNCTION round_tax(
1222: p_amount IN NUMBER,
1223: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
1224: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
1225: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
1226: p_return_status OUT NOCOPY VARCHAR2,
1227: p_error_buffer OUT NOCOPY VARCHAR2

Line 1224: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

1220:
1221: FUNCTION round_tax(
1222: p_amount IN NUMBER,
1223: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
1224: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
1225: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
1226: p_return_status OUT NOCOPY VARCHAR2,
1227: p_error_buffer OUT NOCOPY VARCHAR2
1228: )

Line 1225: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

1221: FUNCTION round_tax(
1222: p_amount IN NUMBER,
1223: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
1224: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
1225: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
1226: p_return_status OUT NOCOPY VARCHAR2,
1227: p_error_buffer OUT NOCOPY VARCHAR2
1228: )
1229: RETURN NUMBER IS

Line 3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3321: p_return_status OUT NOCOPY VARCHAR2,
3322: p_error_buffer OUT NOCOPY VARCHAR2,

Line 3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3321: p_return_status OUT NOCOPY VARCHAR2,
3322: p_error_buffer OUT NOCOPY VARCHAR2,
3323: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL)--Bug7183884

Line 3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3321: p_return_status OUT NOCOPY VARCHAR2,
3322: p_error_buffer OUT NOCOPY VARCHAR2,
3323: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL)--Bug7183884
3324: IS

Line 3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

Line 3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

Line 3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3494: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,

Line 3969: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

3965: -- This procedure gets rounding information for transaction currency
3966: -- and tax currency
3967:
3968: PROCEDURE get_rounding_info(
3969: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
3970: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,

Line 3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3978: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3979: p_return_status OUT NOCOPY VARCHAR2,
3980: p_error_buffer OUT NOCOPY VARCHAR2

Line 3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,

3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3978: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3979: p_return_status OUT NOCOPY VARCHAR2,
3980: p_error_buffer OUT NOCOPY VARCHAR2
3981: )

Line 3978: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,

3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3978: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3979: p_return_status OUT NOCOPY VARCHAR2,
3980: p_error_buffer OUT NOCOPY VARCHAR2
3981: )
3982: IS

Line 3983: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;

3979: p_return_status OUT NOCOPY VARCHAR2,
3980: p_error_buffer OUT NOCOPY VARCHAR2
3981: )
3982: IS
3983: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
3984: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
3985:
3986: BEGIN
3987:

Line 4256: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

4252: l_rnd_sum_unrnd_funcl_curr NUMBER;
4253: i BINARY_INTEGER;
4254: j BINARY_INTEGER;
4255: l_count NUMBER;
4256: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4257: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4258:
4259: l_tax_line_id_tbl TAX_LINE_ID_TBL;
4260: l_tax_amt_tbl TAX_AMT_TBL;

Line 4257: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

4253: i BINARY_INTEGER;
4254: j BINARY_INTEGER;
4255: l_count NUMBER;
4256: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4257: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4258:
4259: l_tax_line_id_tbl TAX_LINE_ID_TBL;
4260: l_tax_amt_tbl TAX_AMT_TBL;
4261: l_tax_amt_tax_curr_tbl TAX_AMT_TAX_CURR_TBL;

Line 4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

4590: -- used later for rounding adjustments.
4591:
4592: PROCEDURE update_header_rounding_info(
4593: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,

Line 4747: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

4743: -- handled here
4744: --
4745:
4746: PROCEDURE do_rounding(
4747: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,

Line 4791: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

4787: p_return_status OUT NOCOPY VARCHAR2,
4788: p_error_buffer OUT NOCOPY VARCHAR2
4789: )
4790: IS
4791: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;

Line 4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

4788: p_error_buffer OUT NOCOPY VARCHAR2
4789: )
4790: IS
4791: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550

Line 4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;

4789: )
4790: IS
4791: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884

Line 4889: -- the exchange rate type from zx_taxes_b

4885: -- Bug#5506495- determine tax_currency_conversion_type
4886: -- if it is not available
4887: --
4888: -- if p_tax_currency_conversion_type is not available, get
4889: -- the exchange rate type from zx_taxes_b
4890: --
4891: l_tax_currency_conversion_type := NVL(p_tax_currency_conversion_type, l_tax_currency_conversion_type);
4892:
4893: get_funcl_curr_info(

Line 4920: -- set tax conversion type from zx_taxes_b which is

4916: l_currency_conversion_type := p_currency_conversion_type;
4917: p_tax_currency_conversion_rate := p_currency_conversion_rate;
4918: ELSE
4919: -- tax currency is not the same as functional currency
4920: -- set tax conversion type from zx_taxes_b which is
4921: -- NULL in this case
4922: l_currency_conversion_type := NULL;
4923: END IF;
4924: END IF;

Line 4927: -- from passed in or in zx_taxes_b

4923: END IF;
4924: END IF;
4925: ELSE
4926: -- tax currency conversion type is available either
4927: -- from passed in or in zx_taxes_b
4928: l_currency_conversion_type := l_tax_currency_conversion_type;
4929: END IF;
4930:
4931: -- bug 5636132 convert orig_tax_amt to orig_tax_amt_tax_curr

Line 5382: c_tax ZX_TAXES_B.tax%TYPE,

5378: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5379: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5380: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5385: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5386: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,

Line 5867: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;

5863: l_rate_ratio NUMBER;
5864: l_tax_amt_tax_curr NUMBER;
5865: l_taxable_amt_tax_curr NUMBER;
5866: l_cal_tax_amt_tax_curr NUMBER;
5867: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
5868: BEGIN
5869:
5870: IF (g_level_statement >= g_current_runtime_level ) THEN
5871: FND_LOG.STRING(g_level_statement,

Line 5895: from zx_lines zxl,zx_taxes_b tax

5891: l_tax_amt_tax_curr,
5892: l_taxable_amt_tax_curr,
5893: l_cal_tax_amt_tax_curr,
5894: l_rounding_rule_code
5895: from zx_lines zxl,zx_taxes_b tax
5896: where zxl.tax_line_id = p_tax_line_id_tbl(i)
5897: and zxl.tax_id = tax.tax_id;
5898:
5899: IF l_rate_ratio = 1 AND l_mau IS NOT NULL THEN

Line 7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

7751: --
7752:
7753: PROCEDURE round_tax_amt_entered(
7754: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7756: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7757: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7758: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7759: p_trx_id IN ZX_LINES.TRX_ID%TYPE,

Line 7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;

7761: p_error_buffer OUT NOCOPY VARCHAR2
7762: )
7763: IS
7764:
7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

Line 7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;

7762: )
7763: IS
7764:
7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

Line 7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

7764:
7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;

Line 7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;

Line 7828: FROM ZX_TAXES_B

7824: IS
7825: SELECT rounding_rule_code,
7826: minimum_accountable_unit,
7827: tax_precision
7828: FROM ZX_TAXES_B
7829: WHERE TAX_ID = c_tax_id;
7830:
7831: -- bug#6798349
7832: CURSOR get_precision_mau_csr

Line 7919: -- get rounding info from zx_taxes_b

7915: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7916: RETURN;
7917: END IF;
7918:
7919: -- get rounding info from zx_taxes_b
7920: OPEN get_rnd_info_from_tax_csr(p_tax_id);
7921: FETCH get_rnd_info_from_tax_csr INTO
7922: l_tax_rounding_rule_code,
7923: l_tax_min_acct_unit,