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 211: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

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

Line 212: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

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

Line 213: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

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

Line 238: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

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

Line 239: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

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

Line 240: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

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

Line 264: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

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

Line 320: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

316: );
317:
318: PROCEDURE update_header_rounding_info(
319: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
320: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
321: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
322: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
323: p_precision IN ZX_LINES.PRECISION%TYPE,
324: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,

Line 1215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

1211: --
1212:
1213: FUNCTION round_tax(
1214: p_amount IN NUMBER,
1215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
1216: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
1217: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_error_buffer OUT NOCOPY VARCHAR2

Line 1216: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

1212:
1213: FUNCTION round_tax(
1214: p_amount IN NUMBER,
1215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
1216: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
1217: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_error_buffer OUT NOCOPY VARCHAR2
1220: )

Line 1217: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

1213: FUNCTION round_tax(
1214: p_amount IN NUMBER,
1215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
1216: p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
1217: p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_error_buffer OUT NOCOPY VARCHAR2
1220: )
1221: RETURN NUMBER IS

Line 3310: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

3306: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3307: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3308: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3309: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3310: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3311: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3312: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3313: p_return_status OUT NOCOPY VARCHAR2,
3314: p_error_buffer OUT NOCOPY VARCHAR2,

Line 3311: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

3307: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3308: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3309: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3310: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3311: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3312: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3313: p_return_status OUT NOCOPY VARCHAR2,
3314: p_error_buffer OUT NOCOPY VARCHAR2,
3315: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL)--Bug7183884

Line 3312: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

3308: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3309: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3310: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3311: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3312: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3313: p_return_status OUT NOCOPY VARCHAR2,
3314: p_error_buffer OUT NOCOPY VARCHAR2,
3315: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL)--Bug7183884
3316: IS

Line 3480: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,

3476: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3477: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3478: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3479: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3480: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3481: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3482: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3483: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3484: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

Line 3481: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

3477: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3478: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3479: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3480: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3481: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3482: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3483: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3484: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3485: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

Line 3482: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,

3478: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3479: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3480: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3481: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3482: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3483: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3484: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3485: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3486: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,

Line 3900: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

3896: -- This procedure gets rounding information for transaction currency
3897: -- and tax currency
3898:
3899: PROCEDURE get_rounding_info(
3900: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
3901: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3902: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3903: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3904: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,

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

3903: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3904: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3905: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3906: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3907: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3908: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3909: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3910: p_return_status OUT NOCOPY VARCHAR2,
3911: p_error_buffer OUT NOCOPY VARCHAR2

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

3904: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3905: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3906: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3907: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3908: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3909: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3910: p_return_status OUT NOCOPY VARCHAR2,
3911: p_error_buffer OUT NOCOPY VARCHAR2
3912: )

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

3905: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3906: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3907: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3908: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3909: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3910: p_return_status OUT NOCOPY VARCHAR2,
3911: p_error_buffer OUT NOCOPY VARCHAR2
3912: )
3913: IS

Line 3914: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;

3910: p_return_status OUT NOCOPY VARCHAR2,
3911: p_error_buffer OUT NOCOPY VARCHAR2
3912: )
3913: IS
3914: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
3915: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
3916:
3917: BEGIN
3918:

Line 4187: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

4183: l_rnd_sum_unrnd_funcl_curr NUMBER;
4184: i BINARY_INTEGER;
4185: j BINARY_INTEGER;
4186: l_count NUMBER;
4187: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4188: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4189:
4190: l_tax_line_id_tbl TAX_LINE_ID_TBL;
4191: l_tax_amt_tbl TAX_AMT_TBL;

Line 4188: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

4184: i BINARY_INTEGER;
4185: j BINARY_INTEGER;
4186: l_count NUMBER;
4187: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4188: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4189:
4190: l_tax_line_id_tbl TAX_LINE_ID_TBL;
4191: l_tax_amt_tbl TAX_AMT_TBL;
4192: l_tax_amt_tax_curr_tbl TAX_AMT_TAX_CURR_TBL;

Line 4525: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

4521: -- used later for rounding adjustments.
4522:
4523: PROCEDURE update_header_rounding_info(
4524: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4525: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4526: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4527: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4528: p_precision IN ZX_LINES.PRECISION%TYPE,
4529: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,

Line 4678: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

4674: -- handled here
4675: --
4676:
4677: PROCEDURE do_rounding(
4678: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4679: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4680: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4681: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4682: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,

Line 4718: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

4714: p_return_status OUT NOCOPY VARCHAR2,
4715: p_error_buffer OUT NOCOPY VARCHAR2
4716: )
4717: IS
4718: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4719: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4720: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4721: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4722: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;

Line 4719: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

4715: p_error_buffer OUT NOCOPY VARCHAR2
4716: )
4717: IS
4718: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4719: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4720: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4721: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4722: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4723: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550

Line 4720: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;

4716: )
4717: IS
4718: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4719: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4720: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4721: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4722: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4723: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4724: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884

Line 4812: -- the exchange rate type from zx_taxes_b

4808: -- Bug#5506495- determine tax_currency_conversion_type
4809: -- if it is not available
4810: --
4811: -- if p_tax_currency_conversion_type is not available, get
4812: -- the exchange rate type from zx_taxes_b
4813: --
4814: l_tax_currency_conversion_type := NVL(p_tax_currency_conversion_type, l_tax_currency_conversion_type);
4815:
4816: IF l_tax_currency_conversion_type IS NULL THEN

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

4839: l_currency_conversion_type := p_currency_conversion_type;
4840: p_tax_currency_conversion_rate := p_currency_conversion_rate;
4841: ELSE
4842: -- tax currency is not the same as functional currency
4843: -- set tax conversion type from zx_taxes_b which is
4844: -- NULL in this case
4845: l_currency_conversion_type := NULL;
4846: END IF;
4847: END IF;

Line 4850: -- from passed in or in zx_taxes_b

4846: END IF;
4847: END IF;
4848: ELSE
4849: -- tax currency conversion type is available either
4850: -- from passed in or in zx_taxes_b
4851: l_currency_conversion_type := l_tax_currency_conversion_type;
4852: END IF;
4853:
4854: -- bug 5636132 convert orig_tax_amt to orig_tax_amt_tax_curr

Line 5216: c_tax ZX_TAXES_B.tax%TYPE,

5212: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5213: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5214: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5215: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5216: c_tax ZX_TAXES_B.tax%TYPE,
5217: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5218: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5219: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5220: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,

Line 7496: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,

7492: --
7493:
7494: PROCEDURE round_tax_amt_entered(
7495: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
7496: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7497: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7498: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7499: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7500: p_trx_id IN ZX_LINES.TRX_ID%TYPE,

Line 7506: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;

7502: p_error_buffer OUT NOCOPY VARCHAR2
7503: )
7504: IS
7505:
7506: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

Line 7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;

7503: )
7504: IS
7505:
7506: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

Line 7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

7505:
7506: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7513: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;

Line 7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7513: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7514: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7515: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;

Line 7569: FROM ZX_TAXES_B

7565: IS
7566: SELECT rounding_rule_code,
7567: minimum_accountable_unit,
7568: tax_precision
7569: FROM ZX_TAXES_B
7570: WHERE TAX_ID = c_tax_id;
7571:
7572: -- bug#6798349
7573: CURSOR get_precision_mau_csr

Line 7660: -- get rounding info from zx_taxes_b

7656: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7657: RETURN;
7658: END IF;
7659:
7660: -- get rounding info from zx_taxes_b
7661: OPEN get_rnd_info_from_tax_csr(p_tax_id);
7662: FETCH get_rnd_info_from_tax_csr INTO
7663: l_tax_rounding_rule_code,
7664: l_tax_min_acct_unit,