31: p_return_status OUT NOCOPY VARCHAR2,
32: p_error_buffer OUT NOCOPY VARCHAR2 );
33:
34: PROCEDURE get_currency_info_for_rounding(
35: p_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
36: p_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_error_buffer OUT NOCOPY VARCHAR2);
39:
32: p_error_buffer OUT NOCOPY VARCHAR2 );
33:
34: PROCEDURE get_currency_info_for_rounding(
35: p_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
36: p_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_error_buffer OUT NOCOPY VARCHAR2);
39:
40: FUNCTION get_other_rate (
69: p_conversion_type IN VARCHAR2)
70: RETURN BINARY_INTEGER ;
71:
72: PROCEDURE get_funcl_curr_info(
73: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
74: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
75: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
76: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
77:
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,
166: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
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,
166: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
167: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
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,
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,
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,
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,
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,
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,
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,
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:
175: PROCEDURE round_line_level(
176: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
177: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
173: );
174:
175: PROCEDURE round_line_level(
176: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
177: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
174:
175: PROCEDURE round_line_level(
176: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
177: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
182: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
175: PROCEDURE round_line_level(
176: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
177: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
182: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
183: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
176: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
177: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
182: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
183: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
184: p_return_status OUT NOCOPY VARCHAR2,
177: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
182: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
183: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
184: p_return_status OUT NOCOPY VARCHAR2,
185: p_error_buffer OUT NOCOPY VARCHAR2
178: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
182: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
183: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
184: p_return_status OUT NOCOPY VARCHAR2,
185: p_error_buffer OUT NOCOPY VARCHAR2
186: );
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
182: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
183: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
184: p_return_status OUT NOCOPY VARCHAR2,
185: p_error_buffer OUT NOCOPY VARCHAR2
186: );
187:
199: p_error_buffer OUT NOCOPY VARCHAR2
200: );
201:
202: PROCEDURE conv_rnd_tax_tax_curr(
203: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
204: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
207: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
200: );
201:
202: PROCEDURE conv_rnd_tax_tax_curr(
203: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
204: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
201:
202: PROCEDURE conv_rnd_tax_tax_curr(
203: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
204: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
202: PROCEDURE conv_rnd_tax_tax_curr(
203: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
204: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
203: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
204: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
204: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
205: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
206: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
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:
218:
219: PROCEDURE conv_rnd_tax_funcl_curr(
220: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
216: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
217:
218:
219: PROCEDURE conv_rnd_tax_funcl_curr(
220: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
221: p_amt IN ZX_LINES.TAX_AMT%TYPE,
222: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
223: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
224: p_return_status OUT NOCOPY VARCHAR2,
217:
218:
219: PROCEDURE conv_rnd_tax_funcl_curr(
220: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
221: p_amt IN ZX_LINES.TAX_AMT%TYPE,
222: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
223: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
224: p_return_status OUT NOCOPY VARCHAR2,
225: p_error_buffer OUT NOCOPY VARCHAR2
218:
219: PROCEDURE conv_rnd_tax_funcl_curr(
220: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
221: p_amt IN ZX_LINES.TAX_AMT%TYPE,
222: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
223: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
224: p_return_status OUT NOCOPY VARCHAR2,
225: p_error_buffer OUT NOCOPY VARCHAR2
226: );
219: PROCEDURE conv_rnd_tax_funcl_curr(
220: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
221: p_amt IN ZX_LINES.TAX_AMT%TYPE,
222: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
223: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
224: p_return_status OUT NOCOPY VARCHAR2,
225: p_error_buffer OUT NOCOPY VARCHAR2
226: );
227:
226: );
227:
228:
229: PROCEDURE conv_rnd_taxable_tax_curr(
230: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
231: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
234: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
227:
228:
229: PROCEDURE conv_rnd_taxable_tax_curr(
230: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
231: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
228:
229: PROCEDURE conv_rnd_taxable_tax_curr(
230: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
231: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
229: PROCEDURE conv_rnd_taxable_tax_curr(
230: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
231: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
230: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
231: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
231: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
232: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
233: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
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,
245: p_return_status OUT NOCOPY VARCHAR2,
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,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_error_buffer OUT NOCOPY VARCHAR2,
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,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_error_buffer OUT NOCOPY VARCHAR2,
247: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884
248:
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,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_error_buffer OUT NOCOPY VARCHAR2,
247: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884
248:
249:
250: PROCEDURE conv_rnd_taxable_funcl_curr(
251: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
247: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884
248:
249:
250: PROCEDURE conv_rnd_taxable_funcl_curr(
251: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
252: p_amt IN ZX_LINES.TAX_AMT%TYPE,
253: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
248:
249:
250: PROCEDURE conv_rnd_taxable_funcl_curr(
251: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
252: p_amt IN ZX_LINES.TAX_AMT%TYPE,
253: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
256: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
249:
250: PROCEDURE conv_rnd_taxable_funcl_curr(
251: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
252: p_amt IN ZX_LINES.TAX_AMT%TYPE,
253: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
256: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
257: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
250: PROCEDURE conv_rnd_taxable_funcl_curr(
251: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
252: p_amt IN ZX_LINES.TAX_AMT%TYPE,
253: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
256: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
257: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
258: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
251: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
252: p_amt IN ZX_LINES.TAX_AMT%TYPE,
253: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
256: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
257: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
258: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
259: p_return_status OUT NOCOPY VARCHAR2,
252: p_amt IN ZX_LINES.TAX_AMT%TYPE,
253: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
256: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
257: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
258: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
259: p_return_status OUT NOCOPY VARCHAR2,
260: p_error_buffer OUT NOCOPY VARCHAR2
254: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
255: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
256: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
257: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
258: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
259: p_return_status OUT NOCOPY VARCHAR2,
260: p_error_buffer OUT NOCOPY VARCHAR2
261: );
262:
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,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
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,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
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,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%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,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%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,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%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,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
268: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
270: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
271: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
272: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
273: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
274: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
275: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
276: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
277: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
278: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
279: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
280: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
281: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
282: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
283: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
284: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
285: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
286: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
287: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
288: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
289: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
290: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
298: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
291: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
298: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
299: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
292: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
298: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
299: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
300: p_return_status OUT NOCOPY VARCHAR2,
293: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
298: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
299: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
300: p_return_status OUT NOCOPY VARCHAR2,
301: p_error_buffer OUT NOCOPY VARCHAR2
294: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
298: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
299: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
300: p_return_status OUT NOCOPY VARCHAR2,
301: p_error_buffer OUT NOCOPY VARCHAR2
302: );
295: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
296: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
297: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
298: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
299: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
300: p_return_status OUT NOCOPY VARCHAR2,
301: p_error_buffer OUT NOCOPY VARCHAR2
302: );
303:
301: p_error_buffer OUT NOCOPY VARCHAR2
302: );
303:
304: PROCEDURE update_header_rounding_curr(
305: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
306: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
307: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
308: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
309: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
302: );
303:
304: PROCEDURE update_header_rounding_curr(
305: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
306: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
307: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
308: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
309: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
310: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
303:
304: PROCEDURE update_header_rounding_curr(
305: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
306: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
307: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
308: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
309: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
310: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
311: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
304: PROCEDURE update_header_rounding_curr(
305: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
306: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
307: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
308: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
309: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
310: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
311: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
312: p_same_tax IN VARCHAR2,
305: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
306: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
307: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
308: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
309: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
310: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
311: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
312: p_same_tax IN VARCHAR2,
313: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
309: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
310: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
311: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
312: p_same_tax IN VARCHAR2,
313: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
314: p_return_status OUT NOCOPY VARCHAR2,
315: p_error_buffer OUT NOCOPY VARCHAR2
316: );
317:
315: p_error_buffer OUT NOCOPY VARCHAR2
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,
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,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
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,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
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,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%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,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%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,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%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,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
323: p_precision IN ZX_LINES.PRECISION%TYPE,
324: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
331: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
324: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
331: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
332: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
325: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
331: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
332: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
333: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
326: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
331: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
332: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
333: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
334: p_same_tax IN VARCHAR2,
327: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
331: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
332: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
333: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
334: p_same_tax IN VARCHAR2,
335: p_sum_unrnd_tax_amt IN NUMBER,
335: p_sum_unrnd_tax_amt IN NUMBER,
336: p_sum_rnd_tax_amt IN NUMBER,
337: p_sum_rnd_tax_curr IN NUMBER,
338: p_sum_rnd_funcl_curr IN NUMBER,
339: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
340: p_return_status OUT NOCOPY VARCHAR2,
341: p_error_buffer OUT NOCOPY VARCHAR2
342: );
343:
361: p_error_buffer OUT NOCOPY VARCHAR2
362: );
363:
364: PROCEDURE handle_header_rounding_curr(
365: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
366: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
367: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
368: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
369: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
362: );
363:
364: PROCEDURE handle_header_rounding_curr(
365: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
366: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
367: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
368: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
369: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
370: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
363:
364: PROCEDURE handle_header_rounding_curr(
365: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
366: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
367: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
368: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
369: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
370: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
371: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
364: PROCEDURE handle_header_rounding_curr(
365: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
366: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
367: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
368: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
369: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
370: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
371: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
372: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
365: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
366: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
367: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
368: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
369: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
370: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
371: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
372: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
373: p_return_status OUT NOCOPY VARCHAR2,
368: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
369: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
370: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
371: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
372: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
373: p_return_status OUT NOCOPY VARCHAR2,
374: p_error_buffer OUT NOCOPY VARCHAR2
375: );
376:
384: p_error_buffer OUT NOCOPY VARCHAR2
385: );
386:
387: PROCEDURE chk_mandatory_col_after_round(
388: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
389: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
385: );
386:
387: PROCEDURE chk_mandatory_col_after_round(
388: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
389: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
386:
387: PROCEDURE chk_mandatory_col_after_round(
388: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
389: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
387: PROCEDURE chk_mandatory_col_after_round(
388: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
389: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
395: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
388: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
389: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
395: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
396: p_return_status OUT NOCOPY VARCHAR2,
389: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
395: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
396: p_return_status OUT NOCOPY VARCHAR2,
397: p_error_buffer OUT NOCOPY VARCHAR2
390: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
395: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
396: p_return_status OUT NOCOPY VARCHAR2,
397: p_error_buffer OUT NOCOPY VARCHAR2
398: );
418: p_return_status OUT NOCOPY VARCHAR2,
419: p_error_buffer OUT NOCOPY VARCHAR2
420: );
421:
422: PROCEDURE update_zx_lines(
423: p_conversion_rate IN NUMBER,
424: p_conversion_type IN VARCHAR2,
425: p_conversion_date IN DATE,
426: p_tax_amt_funcl_curr_tbl IN TAX_AMT_FUNCL_CURR_TBL,
431: p_error_buffer OUT NOCOPY VARCHAR2
432: );
433:
434: PROCEDURE convert_and_round_for_curr(
435: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
436: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
432: );
433:
434: PROCEDURE convert_and_round_for_curr(
435: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
436: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
433:
434: PROCEDURE convert_and_round_for_curr(
435: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
436: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
434: PROCEDURE convert_and_round_for_curr(
435: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
436: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
435: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
436: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
436: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
437: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
445: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
438: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
445: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
446: p_return_status OUT NOCOPY VARCHAR2,
439: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
445: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
446: p_return_status OUT NOCOPY VARCHAR2,
447: p_error_buffer OUT NOCOPY VARCHAR2
440: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
445: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
446: p_return_status OUT NOCOPY VARCHAR2,
447: p_error_buffer OUT NOCOPY VARCHAR2
448: );
927:
928: l_rate NUMBER;
929:
930: CURSOR get_rate_info_csr
931: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
932: c_to_currency ZX_LINES.tax_currency_code%TYPE,
933: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
934: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
935: IS
928: l_rate NUMBER;
929:
930: CURSOR get_rate_info_csr
931: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
932: c_to_currency ZX_LINES.tax_currency_code%TYPE,
933: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
934: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
935: IS
936: SELECT conversion_rate
929:
930: CURSOR get_rate_info_csr
931: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
932: c_to_currency ZX_LINES.tax_currency_code%TYPE,
933: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
934: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
935: IS
936: SELECT conversion_rate
937: FROM GL_DAILY_RATES
930: CURSOR get_rate_info_csr
931: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
932: c_to_currency ZX_LINES.tax_currency_code%TYPE,
933: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
934: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
935: IS
936: SELECT conversion_rate
937: FROM GL_DAILY_RATES
938: WHERE from_currency = c_from_currency
2127: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2128: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2129: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2130: p_rnd_lvl_party_tax_prof_id
2131: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2132: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
2133: p_return_status OUT NOCOPY VARCHAR2,
2134: p_error_buffer OUT NOCOPY VARCHAR2
2135: )
2128: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2129: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2130: p_rnd_lvl_party_tax_prof_id
2131: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2132: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
2133: p_return_status OUT NOCOPY VARCHAR2,
2134: p_error_buffer OUT NOCOPY VARCHAR2
2135: )
2136: IS
2181: provnl_tax_determination_date,
2182: adjusted_doc_date,
2183: trx_line_date,
2184: trx_date) tax_determine_date
2185: FROM ZX_LINES_DET_FACTORS
2186: WHERE application_id = p_event_class_rec.application_id
2187: AND entity_code = p_event_class_rec.entity_code
2188: AND event_class_code = p_event_class_rec.event_class_code
2189: AND trx_id = p_event_class_rec.trx_id
2996: -- to be used later for conversion and rounding
2997: --
2998:
2999: PROCEDURE get_currency_info_for_rounding(
3000: p_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3001: p_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3002: p_return_status OUT NOCOPY VARCHAR2,
3003: p_error_buffer OUT NOCOPY VARCHAR2
3004: )
2997: --
2998:
2999: PROCEDURE get_currency_info_for_rounding(
3000: p_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3001: p_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3002: p_return_status OUT NOCOPY VARCHAR2,
3003: p_error_buffer OUT NOCOPY VARCHAR2
3004: )
3005: IS
3086: -- This procedure converts amount from from_currency to to_currency
3087: --
3088:
3089: PROCEDURE convert_to_currency(
3090: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3091: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3087: --
3088:
3089: PROCEDURE convert_to_currency(
3090: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3091: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3088:
3089: PROCEDURE convert_to_currency(
3090: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3091: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3089: PROCEDURE convert_to_currency(
3090: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3091: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3090: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3091: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3098: p_return_status OUT NOCOPY VARCHAR2,
3091: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3098: p_return_status OUT NOCOPY VARCHAR2,
3099: p_error_buffer OUT NOCOPY VARCHAR2,
3092: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3098: p_return_status OUT NOCOPY VARCHAR2,
3099: p_error_buffer OUT NOCOPY VARCHAR2,
3100: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3093: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3094: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3098: p_return_status OUT NOCOPY VARCHAR2,
3099: p_error_buffer OUT NOCOPY VARCHAR2,
3100: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3101: IS
3096: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3098: p_return_status OUT NOCOPY VARCHAR2,
3099: p_error_buffer OUT NOCOPY VARCHAR2,
3100: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3101: IS
3102: l_rate_index BINARY_INTEGER;
3103: BEGIN
3104:
3201: -- a functional currency from fnd_currencies based on the ledger id,
3202: -- then rounds the tax amount in functional currency using ROUND function
3203:
3204: FUNCTION round_tax_funcl_curr(
3205: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
3206: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3207: p_return_status OUT NOCOPY VARCHAR2,
3208: p_error_buffer OUT NOCOPY VARCHAR2
3209: ) RETURN NUMBER
3202: -- then rounds the tax amount in functional currency using ROUND function
3203:
3204: FUNCTION round_tax_funcl_curr(
3205: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
3206: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3207: p_return_status OUT NOCOPY VARCHAR2,
3208: p_error_buffer OUT NOCOPY VARCHAR2
3209: ) RETURN NUMBER
3210: IS
3207: p_return_status OUT NOCOPY VARCHAR2,
3208: p_error_buffer OUT NOCOPY VARCHAR2
3209: ) RETURN NUMBER
3210: IS
3211: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3212: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3213: l_precision FND_CURRENCIES.PRECISION%TYPE;
3214: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3215:
3298: -- currency and then round the converted amount
3299: --
3300:
3301: PROCEDURE conv_rnd_tax_tax_curr(
3302: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3303: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3306: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3299: --
3300:
3301: PROCEDURE conv_rnd_tax_tax_curr(
3302: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3303: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3300:
3301: PROCEDURE conv_rnd_tax_tax_curr(
3302: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3303: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3301: PROCEDURE conv_rnd_tax_tax_curr(
3302: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3303: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3302: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3303: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3303: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3304: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3305: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
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
3317: l_amt_tax_curr NUMBER;
3318:
3319: BEGIN
3395: -- functional currency and then round the converted amount
3396: --
3397:
3398: PROCEDURE conv_rnd_tax_funcl_curr(
3399: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3400: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3401: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3402: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3403: p_return_status OUT NOCOPY VARCHAR2,
3396: --
3397:
3398: PROCEDURE conv_rnd_tax_funcl_curr(
3399: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3400: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3401: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3402: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3403: p_return_status OUT NOCOPY VARCHAR2,
3404: p_error_buffer OUT NOCOPY VARCHAR2
3397:
3398: PROCEDURE conv_rnd_tax_funcl_curr(
3399: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3400: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3401: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3402: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3403: p_return_status OUT NOCOPY VARCHAR2,
3404: p_error_buffer OUT NOCOPY VARCHAR2
3405: )
3398: PROCEDURE conv_rnd_tax_funcl_curr(
3399: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3400: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3401: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3402: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3403: p_return_status OUT NOCOPY VARCHAR2,
3404: p_error_buffer OUT NOCOPY VARCHAR2
3405: )
3406: IS
3468: -- tax currency and then round the converted amount
3469: --
3470:
3471: PROCEDURE conv_rnd_taxable_tax_curr(
3472: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3473: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3476: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3469: --
3470:
3471: PROCEDURE conv_rnd_taxable_tax_curr(
3472: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3473: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3470:
3471: PROCEDURE conv_rnd_taxable_tax_curr(
3472: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3473: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3471: PROCEDURE conv_rnd_taxable_tax_curr(
3472: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3473: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3472: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3473: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3473: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3474: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
3475: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%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,
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,
3487: p_return_status OUT NOCOPY VARCHAR2,
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,
3487: p_return_status OUT NOCOPY VARCHAR2,
3488: p_error_buffer OUT NOCOPY VARCHAR2,
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,
3487: p_return_status OUT NOCOPY VARCHAR2,
3488: p_error_buffer OUT NOCOPY VARCHAR2,
3489: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3490:
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,
3487: p_return_status OUT NOCOPY VARCHAR2,
3488: p_error_buffer OUT NOCOPY VARCHAR2,
3489: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3490:
3491: IS
3492: l_amt_tax_curr NUMBER;
3493: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
3587: -- functional currency and then round the converted amount
3588: --
3589:
3590: PROCEDURE conv_rnd_taxable_funcl_curr(
3591: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3592: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3588: --
3589:
3590: PROCEDURE conv_rnd_taxable_funcl_curr(
3591: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3592: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3589:
3590: PROCEDURE conv_rnd_taxable_funcl_curr(
3591: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3592: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3590: PROCEDURE conv_rnd_taxable_funcl_curr(
3591: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3592: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3598: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3591: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3592: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3598: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3599: p_return_status OUT NOCOPY VARCHAR2,
3592: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3598: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3599: p_return_status OUT NOCOPY VARCHAR2,
3600: p_error_buffer OUT NOCOPY VARCHAR2
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3598: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3599: p_return_status OUT NOCOPY VARCHAR2,
3600: p_error_buffer OUT NOCOPY VARCHAR2
3601: )
3602: IS
3693: -- This procedure is used to round tax lines at line level
3694: --
3695:
3696: PROCEDURE round_line_level(
3697: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3698: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3694: --
3695:
3696: PROCEDURE round_line_level(
3697: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3698: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3695:
3696: PROCEDURE round_line_level(
3697: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3698: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3703: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3696: PROCEDURE round_line_level(
3697: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3698: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3703: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3704: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3697: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3698: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3703: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3704: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3705: p_return_status OUT NOCOPY VARCHAR2,
3698: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3703: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3704: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3705: p_return_status OUT NOCOPY VARCHAR2,
3706: p_error_buffer OUT NOCOPY VARCHAR2
3699: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3703: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3704: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3705: p_return_status OUT NOCOPY VARCHAR2,
3706: p_error_buffer OUT NOCOPY VARCHAR2
3707: )
3700: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3701: p_trx_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3702: p_trx_precision IN ZX_LINES.PRECISION%TYPE,
3703: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3704: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3705: p_return_status OUT NOCOPY VARCHAR2,
3706: p_error_buffer OUT NOCOPY VARCHAR2
3707: )
3708: IS
3807: -- This procedure is incomplete due to handling of MRC is not clear now
3808:
3809:
3810: PROCEDURE handle_header_rounding_curr(
3811: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3812: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3813: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3814: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3815: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3808:
3809:
3810: PROCEDURE handle_header_rounding_curr(
3811: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3812: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3813: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3814: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3815: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3816: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3809:
3810: PROCEDURE handle_header_rounding_curr(
3811: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3812: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3813: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3814: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3815: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3816: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3817: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3810: PROCEDURE handle_header_rounding_curr(
3811: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3812: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3813: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3814: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3815: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3816: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3817: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3818: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3811: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3812: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3813: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3814: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3815: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3816: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3817: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3818: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3819: p_return_status OUT NOCOPY VARCHAR2,
3814: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3815: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3816: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3817: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3818: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3819: p_return_status OUT NOCOPY VARCHAR2,
3820: p_error_buffer OUT NOCOPY VARCHAR2
3821: )
3822: IS
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,
3905: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
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,
3905: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3906: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
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,
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,
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,
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,
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,
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,
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,
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,
4137: 'update the adjustments to the largest lines ....');
4138: END IF;
4139:
4140: FORALL i IN 1 .. l_count
4141: UPDATE ZX_LINES
4142: SET tax_amt_funcl_curr = l_tax_amt_curr_tbl(i),
4143: taxable_amt_funcl_curr = l_taxable_amt_curr_tbl(i)
4144: WHERE tax_line_id = l_tax_line_id_tbl(i);
4145:
4421: -- used later for rounding adjustments.
4422: -- This procedure is incomplete due to handling of MRC is not clear now
4423:
4424: PROCEDURE update_header_rounding_curr(
4425: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4426: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4427: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4428: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4429: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4422: -- This procedure is incomplete due to handling of MRC is not clear now
4423:
4424: PROCEDURE update_header_rounding_curr(
4425: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4426: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4427: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4428: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4429: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4430: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4423:
4424: PROCEDURE update_header_rounding_curr(
4425: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4426: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4427: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4428: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4429: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4430: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4431: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4424: PROCEDURE update_header_rounding_curr(
4425: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4426: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4427: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4428: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4429: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4430: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4431: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4432: p_same_tax IN VARCHAR2,
4425: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4426: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4427: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4428: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4429: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4430: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4431: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4432: p_same_tax IN VARCHAR2,
4433: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4429: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4430: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4431: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4432: p_same_tax IN VARCHAR2,
4433: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4434: p_return_status OUT NOCOPY VARCHAR2,
4435: p_error_buffer OUT NOCOPY VARCHAR2
4436: )
4437: IS
4520: -- This procedure stores header rounding info for each group which will be
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,
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,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
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,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
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,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%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,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%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,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%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,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4535: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4528: p_precision IN ZX_LINES.PRECISION%TYPE,
4529: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4535: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4536: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4529: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4535: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4536: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4537: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4530: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4535: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4536: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4537: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4538: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4531: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4535: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4536: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4537: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4538: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4539: p_same_tax IN VARCHAR2,
4532: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4533: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4534: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4535: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4536: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4537: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4538: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4539: p_same_tax IN VARCHAR2,
4540: p_sum_unrnd_tax_amt IN NUMBER,
4540: p_sum_unrnd_tax_amt IN NUMBER,
4541: p_sum_rnd_tax_amt IN NUMBER,
4542: p_sum_rnd_tax_curr IN NUMBER,
4543: p_sum_rnd_funcl_curr IN NUMBER,
4544: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4545: p_return_status OUT NOCOPY VARCHAR2,
4546: p_error_buffer OUT NOCOPY VARCHAR2
4547: )
4548: IS
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,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
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,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
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,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%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,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%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,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%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,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4682: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4684: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4685: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4686: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4687: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4688: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4689: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4690: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4691: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4692: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4693: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4694: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4695: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4696: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4697: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4698: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4699: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4700: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4701: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4702: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4703: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4704: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4712: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4705: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4712: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4713: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4706: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4712: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4713: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4714: p_return_status OUT NOCOPY VARCHAR2,
4707: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4712: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4713: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4714: p_return_status OUT NOCOPY VARCHAR2,
4715: p_error_buffer OUT NOCOPY VARCHAR2
4708: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4712: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4713: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4714: p_return_status OUT NOCOPY VARCHAR2,
4715: p_error_buffer OUT NOCOPY VARCHAR2
4716: )
4709: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4710: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4711: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4712: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4713: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4714: p_return_status OUT NOCOPY VARCHAR2,
4715: p_error_buffer OUT NOCOPY VARCHAR2
4716: )
4717: IS
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
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
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
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4726: l_funcl_precision FND_CURRENCIES.PRECISION%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
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4726: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4727: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%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
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4726: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4727: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4728:
5201: p_return_status OUT NOCOPY VARCHAR2,
5202: p_error_buffer OUT NOCOPY VARCHAR2
5203: )
5204: IS
5205: l_trx_id ZX_LINES.TRX_ID%TYPE;
5206: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5207: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5208: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5209:
5202: p_error_buffer OUT NOCOPY VARCHAR2
5203: )
5204: IS
5205: l_trx_id ZX_LINES.TRX_ID%TYPE;
5206: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5207: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5208: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5209:
5210: CURSOR get_existing_sum_amt_csr
5203: )
5204: IS
5205: l_trx_id ZX_LINES.TRX_ID%TYPE;
5206: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5207: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5208: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5209:
5210: CURSOR get_existing_sum_amt_csr
5211: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5204: IS
5205: l_trx_id ZX_LINES.TRX_ID%TYPE;
5206: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5207: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5208: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5209:
5210: CURSOR get_existing_sum_amt_csr
5211: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5212: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5207: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5208: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5209:
5210: CURSOR get_existing_sum_amt_csr
5211: (c_trx_id ZX_LINES.TRX_ID%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,
5208: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5209:
5210: CURSOR get_existing_sum_amt_csr
5211: (c_trx_id ZX_LINES.TRX_ID%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,
5209:
5210: CURSOR get_existing_sum_amt_csr
5211: (c_trx_id ZX_LINES.TRX_ID%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,
5210: CURSOR get_existing_sum_amt_csr
5211: (c_trx_id ZX_LINES.TRX_ID%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,
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,
5221: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_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,
5221: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%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,
5221: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5220: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5221: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5221: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5223: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5224: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5225: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5226: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5227: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5228: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5229: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5230: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5231: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5232: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5233: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5234: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5235: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5236: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5237: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5238: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5239: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5240: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5241: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5242: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5243: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5244: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5245: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5246: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5247: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5248: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5249: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5250: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5251: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5252: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5253: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5254: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5255: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5256: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5257: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5265: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5258: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5265: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5266: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5259: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5265: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5266: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5267: IS
5260: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5265: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5266: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5267: IS
5268: SELECT SUM(unrounded_tax_amt),
5261: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5265: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5266: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5267: IS
5268: SELECT SUM(unrounded_tax_amt),
5269: SUM(tax_amt),
5262: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5263: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5264: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5265: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5266: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5267: IS
5268: SELECT SUM(unrounded_tax_amt),
5269: SUM(tax_amt),
5270: SUM(tax_amt_tax_curr),
5268: SELECT SUM(unrounded_tax_amt),
5269: SUM(tax_amt),
5270: SUM(tax_amt_tax_curr),
5271: SUM(tax_amt_funcl_curr)
5272: FROM ZX_LINES L
5273: WHERE L.trx_id = c_trx_id AND
5274: L.application_id = c_application_id AND
5275: L.event_class_code = c_event_class_code AND
5276: L.entity_code = c_entity_code AND
5415: p_sum_rnd_tax_amt,
5416: p_sum_rnd_tax_curr,
5417: p_sum_rnd_funcl_curr;
5418: IF p_sum_unrnd_tax_amt IS NULL THEN
5419: -- this would be the case of those tax lines exist in zx_lines
5420: -- have been updated so these same tax lines would also exist
5421: -- in gt, causing no record returns
5422: p_sum_unrnd_tax_amt := 0;
5423: p_sum_rnd_tax_amt := 0;
5459: -- This procedure
5460: --
5461:
5462: PROCEDURE chk_mandatory_col_after_round(
5463: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5464: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5460: --
5461:
5462: PROCEDURE chk_mandatory_col_after_round(
5463: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5464: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5461:
5462: PROCEDURE chk_mandatory_col_after_round(
5463: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5464: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5469: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5462: PROCEDURE chk_mandatory_col_after_round(
5463: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5464: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5469: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5470: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5463: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5464: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5469: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5470: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5471: p_return_status OUT NOCOPY VARCHAR2,
5464: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5469: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5470: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5471: p_return_status OUT NOCOPY VARCHAR2,
5472: p_error_buffer OUT NOCOPY VARCHAR2
5465: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5469: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5470: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5471: p_return_status OUT NOCOPY VARCHAR2,
5472: p_error_buffer OUT NOCOPY VARCHAR2
5473: )
5648:
5649: END update_detail_tax_lines_gt;
5650: -----------------------------------------------------------------------
5651: -- PRIVATE PROCEDURE
5652: -- update_zx_lines
5653: --
5654: -- DESCRIPTION
5655: -- This procedure updates the values belonged to a group used by
5656: -- header level rounding
5655: -- This procedure updates the values belonged to a group used by
5656: -- header level rounding
5657: --
5658:
5659: PROCEDURE update_zx_lines(
5660: p_conversion_rate IN NUMBER,
5661: p_conversion_type IN VARCHAR2,
5662: p_conversion_date IN DATE,
5663: p_tax_amt_funcl_curr_tbl IN TAX_AMT_FUNCL_CURR_TBL,
5675: BEGIN
5676:
5677: IF (g_level_statement >= g_current_runtime_level ) THEN
5678: FND_LOG.STRING(g_level_statement,
5679: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.BEGIN',
5680: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(+)');
5681: END IF;
5682:
5683: p_return_status := FND_API.G_RET_STS_SUCCESS;
5676:
5677: IF (g_level_statement >= g_current_runtime_level ) THEN
5678: FND_LOG.STRING(g_level_statement,
5679: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.BEGIN',
5680: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(+)');
5681: END IF;
5682:
5683: p_return_status := FND_API.G_RET_STS_SUCCESS;
5684:
5683: p_return_status := FND_API.G_RET_STS_SUCCESS;
5684:
5685: l_count := p_tax_line_id_tbl.COUNT;
5686:
5687: -- update zx_lines
5688: --
5689: FORALL i IN 1 .. l_count
5690: UPDATE ZX_LINES
5691: SET currency_conversion_date = p_conversion_date,
5686:
5687: -- update zx_lines
5688: --
5689: FORALL i IN 1 .. l_count
5690: UPDATE ZX_LINES
5691: SET currency_conversion_date = p_conversion_date,
5692: currency_conversion_type = p_conversion_type,
5693: currency_conversion_rate = p_conversion_rate,
5694: tax_amt_funcl_curr = p_tax_amt_funcl_curr_tbl(i),
5698:
5699: IF (g_level_statement >= g_current_runtime_level ) THEN
5700:
5701: FND_LOG.STRING(g_level_statement,
5702: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.END',
5703: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(-)'||p_return_status);
5704: END IF;
5705:
5706: EXCEPTION
5699: IF (g_level_statement >= g_current_runtime_level ) THEN
5700:
5701: FND_LOG.STRING(g_level_statement,
5702: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.END',
5703: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(-)'||p_return_status);
5704: END IF;
5705:
5706: EXCEPTION
5707: WHEN OTHERS THEN
5709: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5710:
5711: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5712: FND_LOG.STRING(g_level_unexpected,
5713: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines',
5714: p_error_buffer);
5715: END IF;
5716: END update_zx_lines;
5717: ---------------------------------------------------------------------------
5712: FND_LOG.STRING(g_level_unexpected,
5713: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines',
5714: p_error_buffer);
5715: END IF;
5716: END update_zx_lines;
5717: ---------------------------------------------------------------------------
5718: -- PUBLIC PROCEDURE
5719: -- perform_rounding
5720: --
5830: l_entity_code_tbl ENTITY_CODE_TBL;
5831: l_trx_id_tbl TRX_ID_TBL;
5832: l_rounding_level_code_tbl ROUNDING_LEVEL_CODE_TBL;
5833:
5834: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
5835: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5836: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5837: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5838:
5831: l_trx_id_tbl TRX_ID_TBL;
5832: l_rounding_level_code_tbl ROUNDING_LEVEL_CODE_TBL;
5833:
5834: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
5835: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5836: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5837: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5838:
5839:
5832: l_rounding_level_code_tbl ROUNDING_LEVEL_CODE_TBL;
5833:
5834: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
5835: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5836: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5837: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5838:
5839:
5840: CURSOR get_trx_id_csr
5833:
5834: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
5835: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5836: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5837: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5838:
5839:
5840: CURSOR get_trx_id_csr
5841: IS
5847: FROM ZX_DETAIL_TAX_LINES_GT
5848: WHERE offset_link_to_tax_line_id IS NULL;
5849:
5850: CURSOR get_round_info_csr
5851: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
5852: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5853: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5854: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
5855: IS
5848: WHERE offset_link_to_tax_line_id IS NULL;
5849:
5850: CURSOR get_round_info_csr
5851: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
5852: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5853: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5854: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
5855: IS
5856: SELECT /*+ dynamic_sampling(1) */
5849:
5850: CURSOR get_round_info_csr
5851: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
5852: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5853: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5854: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
5855: IS
5856: SELECT /*+ dynamic_sampling(1) */
5857: tax_line_id,
5850: CURSOR get_round_info_csr
5851: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
5852: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5853: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5854: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
5855: IS
5856: SELECT /*+ dynamic_sampling(1) */
5857: tax_line_id,
5858: Manually_Entered_Flag,
6534: -- specified and then performs line level rounding
6535: --
6536:
6537: PROCEDURE convert_and_round_for_curr(
6538: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6539: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6535: --
6536:
6537: PROCEDURE convert_and_round_for_curr(
6538: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6539: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6536:
6537: PROCEDURE convert_and_round_for_curr(
6538: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6539: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6537: PROCEDURE convert_and_round_for_curr(
6538: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6539: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6538: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6539: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6539: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6547: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6540: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6547: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6548: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6541: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6547: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6548: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6549: p_return_status OUT NOCOPY VARCHAR2,
6542: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6547: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6548: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6549: p_return_status OUT NOCOPY VARCHAR2,
6550: p_error_buffer OUT NOCOPY VARCHAR2
6543: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6547: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6548: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6549: p_return_status OUT NOCOPY VARCHAR2,
6550: p_error_buffer OUT NOCOPY VARCHAR2
6551: )
6666: l_taxable_amt_funcl_curr_tbl TAXABLE_AMT_FUNCL_CURR_TBL;
6667: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
6668:
6669: CURSOR get_round_line_level_curr_csr
6670: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6671: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6672: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6673: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6674: IS
6667: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
6668:
6669: CURSOR get_round_line_level_curr_csr
6670: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6671: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6672: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6673: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6674: IS
6675: SELECT tax_line_id,
6668:
6669: CURSOR get_round_line_level_curr_csr
6670: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6671: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6672: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6673: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6674: IS
6675: SELECT tax_line_id,
6676: tax_rate,
6669: CURSOR get_round_line_level_curr_csr
6670: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6671: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6672: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6673: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6674: IS
6675: SELECT tax_line_id,
6676: tax_rate,
6677: tax_rate_id,
6687: unrounded_tax_amt,
6688: tax_amt_funcl_curr,
6689: taxable_amt_funcl_curr,
6690: cal_tax_amt_funcl_curr
6691: FROM ZX_LINES
6692: WHERE trx_id = c_trx_id AND
6693: application_id = c_application_id AND
6694: event_class_code = c_event_class_code AND
6695: entity_code = c_entity_code AND
6783: -- bulk update the current rows processed
6784: -- before fetch the next set of rows
6785: --
6786:
6787: -- update zx_lines
6788: --
6789: update_zx_lines(
6790: p_conversion_rate,
6791: p_conversion_type,
6785: --
6786:
6787: -- update zx_lines
6788: --
6789: update_zx_lines(
6790: p_conversion_rate,
6791: p_conversion_type,
6792: p_conversion_date,
6793: l_tax_amt_funcl_curr_tbl,
6927: l_taxable_amt_funcl_curr_tbl TAXABLE_AMT_FUNCL_CURR_TBL;
6928: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
6929:
6930: CURSOR get_round_head_level_curr_csr
6931: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6932: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6933: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6934: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6935: IS
6928: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
6929:
6930: CURSOR get_round_head_level_curr_csr
6931: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6932: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6933: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6934: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6935: IS
6936: SELECT tax_line_id,
6929:
6930: CURSOR get_round_head_level_curr_csr
6931: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6932: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6933: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6934: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6935: IS
6936: SELECT tax_line_id,
6937: tax_regime_code,
6930: CURSOR get_round_head_level_curr_csr
6931: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6932: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6933: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6934: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6935: IS
6936: SELECT tax_line_id,
6937: tax_regime_code,
6938: tax,
6995: unrounded_tax_amt,
6996: tax_amt_funcl_curr,
6997: taxable_amt_funcl_curr,
6998: cal_tax_amt_funcl_curr
6999: FROM ZX_LINES
7000: WHERE trx_id = c_trx_id AND
7001: application_id = c_application_id AND
7002: event_class_code = c_event_class_code AND
7003: entity_code = c_entity_code AND
7323: -- bulk update the current rows processed
7324: -- before fetch the next set of rows
7325: --
7326:
7327: -- update zx_lines
7328: --
7329: update_zx_lines(
7330: p_conversion_rate,
7331: p_conversion_type,
7325: --
7326:
7327: -- update zx_lines
7328: --
7329: update_zx_lines(
7330: p_conversion_rate,
7331: p_conversion_type,
7332: p_conversion_date,
7333: l_tax_amt_funcl_curr_tbl,
7426: p_return_status := FND_API.G_RET_STS_SUCCESS;
7427: p_error_buffer := NULL;
7428:
7429:
7430: -- ???????? where to get rounding level if not from zx_lines ????????
7431: -- ???????? for now, assume get it from event class rec ????????
7432: --
7433: IF p_event_class_rec.Default_Rounding_Level_Code = 'HEADER' THEN
7434: convert_and_round_hdr_lvl_curr(
7454: END IF;
7455:
7456: -- *****************
7457: -- need to do the same for offset tax lines
7458: -- select only the offset tax lines from zx_lines and
7459: -- do similar thing as set_amt_columns in offset tax determination pkg
7460: -- will have separate procedure to do this when handling of
7461: -- MRC is clear
7462: -- ******************
7491: -- by user on tax line or summary line.
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,
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,
7501: p_return_status OUT NOCOPY VARCHAR2,
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,
7501: p_return_status OUT NOCOPY VARCHAR2,
7502: p_error_buffer OUT NOCOPY VARCHAR2
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,
7501: p_return_status OUT NOCOPY VARCHAR2,
7502: p_error_buffer OUT NOCOPY VARCHAR2
7503: )
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,
7501: p_return_status OUT NOCOPY VARCHAR2,
7502: p_error_buffer OUT NOCOPY VARCHAR2
7503: )
7504: IS
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;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
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;
7514: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%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;
7516: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%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;
7516: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7517: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7518:
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;
7516: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7517: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7518:
7519:
7520:
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;
7516: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7517: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7518:
7519:
7520:
7521: CURSOR get_rnd_level_hier_csr
7518:
7519:
7520:
7521: CURSOR get_rnd_level_hier_csr
7522: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7523: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7524: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE)
7525: IS
7526: SELECT default_rounding_level_code,
7519:
7520:
7521: CURSOR get_rnd_level_hier_csr
7522: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7523: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7524: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE)
7525: IS
7526: SELECT default_rounding_level_code,
7527: rounding_level_hier_1_code,
7520:
7521: CURSOR get_rnd_level_hier_csr
7522: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7523: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7524: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE)
7525: IS
7526: SELECT default_rounding_level_code,
7527: rounding_level_hier_1_code,
7528: rounding_level_hier_2_code,
7534: EVENT_CLASS_CODE = c_event_class_code;
7535:
7536: -- bug#6798349
7537: -- add trx_currency_code, precision, minimum_accountable_unit
7538: -- to get trx currency info from zx_lines_det_factors
7539:
7540: CURSOR get_rnd_tx_prof_id_csr
7541: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7542: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7537: -- add trx_currency_code, precision, minimum_accountable_unit
7538: -- to get trx currency info from zx_lines_det_factors
7539:
7540: CURSOR get_rnd_tx_prof_id_csr
7541: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7542: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7543: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7544: c_trx_id ZX_LINES.TRX_ID%TYPE)
7545: IS
7538: -- to get trx currency info from zx_lines_det_factors
7539:
7540: CURSOR get_rnd_tx_prof_id_csr
7541: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7542: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7543: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7544: c_trx_id ZX_LINES.TRX_ID%TYPE)
7545: IS
7546: SELECT rdng_ship_to_pty_tx_prof_id,
7539:
7540: CURSOR get_rnd_tx_prof_id_csr
7541: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7542: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7543: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7544: c_trx_id ZX_LINES.TRX_ID%TYPE)
7545: IS
7546: SELECT rdng_ship_to_pty_tx_prof_id,
7547: rdng_ship_from_pty_tx_prof_id,
7540: CURSOR get_rnd_tx_prof_id_csr
7541: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7542: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7543: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7544: c_trx_id ZX_LINES.TRX_ID%TYPE)
7545: IS
7546: SELECT rdng_ship_to_pty_tx_prof_id,
7547: rdng_ship_from_pty_tx_prof_id,
7548: rdng_bill_to_pty_tx_prof_id,
7553: rdng_bill_from_pty_tx_p_st_id,
7554: trx_currency_code,
7555: precision,
7556: minimum_accountable_unit
7557: FROM ZX_LINES_DET_FACTORS
7558: WHERE APPLICATION_ID = c_application_id AND
7559: ENTITY_CODE = c_entity_code AND
7560: EVENT_CLASS_CODE = c_event_class_code AND
7561: TRX_ID = c_trx_id;
7560: EVENT_CLASS_CODE = c_event_class_code AND
7561: TRX_ID = c_trx_id;
7562:
7563: CURSOR get_rnd_info_from_tax_csr
7564: (c_tax_id ZX_LINES.TAX_ID%TYPE)
7565: IS
7566: SELECT rounding_rule_code,
7567: minimum_accountable_unit,
7568: tax_precision
7570: WHERE TAX_ID = c_tax_id;
7571:
7572: -- bug#6798349
7573: CURSOR get_precision_mau_csr
7574: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)
7575: IS
7576: SELECT minimum_accountable_unit,
7577: precision
7578: FROM FND_CURRENCIES
8324: -- accountable unit and precision of a functional currency from
8325: -- fnd_currencies based on the ledger id
8326:
8327: PROCEDURE get_funcl_curr_info(
8328: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8329: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8330: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8331: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8332: