[Home] [Help]
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 OUT NOCOPY 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 OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY 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 OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%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 OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%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 OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%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 OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%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 OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
179: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
180: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
187: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
180: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
187: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
188: p_return_status OUT NOCOPY VARCHAR2,
181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
187: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
188: p_return_status OUT NOCOPY VARCHAR2,
189: p_error_buffer OUT NOCOPY VARCHAR2
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
187: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
188: p_return_status OUT NOCOPY VARCHAR2,
189: p_error_buffer OUT NOCOPY VARCHAR2
190: );
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
187: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
188: p_return_status OUT NOCOPY VARCHAR2,
189: p_error_buffer OUT NOCOPY VARCHAR2
190: );
191:
203: p_error_buffer OUT NOCOPY VARCHAR2
204: );
205:
206: PROCEDURE conv_rnd_tax_tax_curr(
207: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
208: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
204: );
205:
206: PROCEDURE conv_rnd_tax_tax_curr(
207: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
208: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
205:
206: PROCEDURE conv_rnd_tax_tax_curr(
207: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
208: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
206: PROCEDURE conv_rnd_tax_tax_curr(
207: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
208: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
207: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
208: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
208: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
209: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
210: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
211: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
212: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
213: p_amt IN ZX_LINES.TAX_AMT%TYPE,
214: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
215: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
218: p_return_status OUT NOCOPY VARCHAR2,
216: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
217: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
218: p_return_status OUT NOCOPY VARCHAR2,
219: p_error_buffer OUT NOCOPY VARCHAR2,
220: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
221:
222:
223: PROCEDURE conv_rnd_tax_funcl_curr(
224: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
220: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
221:
222:
223: PROCEDURE conv_rnd_tax_funcl_curr(
224: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
225: p_amt IN ZX_LINES.TAX_AMT%TYPE,
226: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
227: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
228: p_return_status OUT NOCOPY VARCHAR2,
221:
222:
223: PROCEDURE conv_rnd_tax_funcl_curr(
224: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
225: p_amt IN ZX_LINES.TAX_AMT%TYPE,
226: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
227: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_error_buffer OUT NOCOPY VARCHAR2
222:
223: PROCEDURE conv_rnd_tax_funcl_curr(
224: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
225: p_amt IN ZX_LINES.TAX_AMT%TYPE,
226: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
227: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_error_buffer OUT NOCOPY VARCHAR2
230: );
223: PROCEDURE conv_rnd_tax_funcl_curr(
224: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
225: p_amt IN ZX_LINES.TAX_AMT%TYPE,
226: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
227: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_error_buffer OUT NOCOPY VARCHAR2
230: );
231:
230: );
231:
232:
233: PROCEDURE conv_rnd_taxable_tax_curr(
234: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
235: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
231:
232:
233: PROCEDURE conv_rnd_taxable_tax_curr(
234: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
235: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
232:
233: PROCEDURE conv_rnd_taxable_tax_curr(
234: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
235: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
233: PROCEDURE conv_rnd_taxable_tax_curr(
234: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
235: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
234: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
235: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
235: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
236: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
237: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
238: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
239: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
240: p_amt IN ZX_LINES.TAX_AMT%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
241: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
248: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
249: p_return_status OUT NOCOPY VARCHAR2,
242: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
248: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_error_buffer OUT NOCOPY VARCHAR2,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
248: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_error_buffer OUT NOCOPY VARCHAR2,
251: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884
252:
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
248: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_error_buffer OUT NOCOPY VARCHAR2,
251: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884
252:
253:
254: PROCEDURE conv_rnd_taxable_funcl_curr(
255: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
251: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884
252:
253:
254: PROCEDURE conv_rnd_taxable_funcl_curr(
255: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
256: p_amt IN ZX_LINES.TAX_AMT%TYPE,
257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
252:
253:
254: PROCEDURE conv_rnd_taxable_funcl_curr(
255: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
256: p_amt IN ZX_LINES.TAX_AMT%TYPE,
257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
253:
254: PROCEDURE conv_rnd_taxable_funcl_curr(
255: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
256: p_amt IN ZX_LINES.TAX_AMT%TYPE,
257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
254: PROCEDURE conv_rnd_taxable_funcl_curr(
255: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
256: p_amt IN ZX_LINES.TAX_AMT%TYPE,
257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
262: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
255: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
256: p_amt IN ZX_LINES.TAX_AMT%TYPE,
257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
262: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
263: p_return_status OUT NOCOPY VARCHAR2,
256: p_amt IN ZX_LINES.TAX_AMT%TYPE,
257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
262: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_error_buffer OUT NOCOPY VARCHAR2
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
262: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_error_buffer OUT NOCOPY VARCHAR2
265: );
266:
266:
267: PROCEDURE do_rounding(
268: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
267: PROCEDURE do_rounding(
268: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
268: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
274: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
275: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
276: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
277: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
278: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
279: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
280: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
281: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
282: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
283: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
284: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
285: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
286: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
287: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
288: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
289: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
290: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
291: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
292: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
305: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
305: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
306: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
305: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
306: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
307: --p_quote_flag IN VARCHAR2,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
305: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
306: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
307: --p_quote_flag IN VARCHAR2,
308: p_return_status OUT NOCOPY VARCHAR2,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
305: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
306: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
307: --p_quote_flag IN VARCHAR2,
308: p_return_status OUT NOCOPY VARCHAR2,
309: p_error_buffer OUT NOCOPY VARCHAR2
302: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_FUNCL_CURR%TYPE,
303: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
304: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
305: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
306: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
307: --p_quote_flag IN VARCHAR2,
308: p_return_status OUT NOCOPY VARCHAR2,
309: p_error_buffer OUT NOCOPY VARCHAR2
310: );
309: p_error_buffer OUT NOCOPY VARCHAR2
310: );
311:
312: PROCEDURE update_header_rounding_curr(
313: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
314: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
315: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
316: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
317: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
310: );
311:
312: PROCEDURE update_header_rounding_curr(
313: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
314: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
315: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
316: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
317: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
318: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
311:
312: PROCEDURE update_header_rounding_curr(
313: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
314: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
315: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
316: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
317: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
318: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
319: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
312: PROCEDURE update_header_rounding_curr(
313: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
314: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
315: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
316: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
317: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
318: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
319: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
320: p_same_tax IN VARCHAR2,
313: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
314: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
315: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
316: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
317: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
318: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
319: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
320: p_same_tax IN VARCHAR2,
321: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
317: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
318: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
319: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
320: p_same_tax IN VARCHAR2,
321: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
322: p_return_status OUT NOCOPY VARCHAR2,
323: p_error_buffer OUT NOCOPY VARCHAR2
324: );
325:
323: p_error_buffer OUT NOCOPY VARCHAR2
324: );
325:
326: PROCEDURE update_header_rounding_info(
327: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
325:
326: PROCEDURE update_header_rounding_info(
327: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
326: PROCEDURE update_header_rounding_info(
327: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
327: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
328: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
329: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
330: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
338: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
331: p_precision IN ZX_LINES.PRECISION%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
338: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
339: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
332: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
338: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
339: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
340: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
333: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
338: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
339: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
340: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
341: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
334: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
338: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
339: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
340: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
341: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
342: p_same_tax IN VARCHAR2,
335: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
336: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
337: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
338: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
339: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
340: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
341: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
342: p_same_tax IN VARCHAR2,
343: p_sum_unrnd_tax_amt IN NUMBER,
343: p_sum_unrnd_tax_amt IN NUMBER,
344: p_sum_rnd_tax_amt IN NUMBER,
345: p_sum_rnd_tax_curr IN NUMBER,
346: p_sum_rnd_funcl_curr IN NUMBER,
347: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
348: p_return_status OUT NOCOPY VARCHAR2,
349: p_error_buffer OUT NOCOPY VARCHAR2
350: );
351:
369: p_error_buffer OUT NOCOPY VARCHAR2
370: );
371:
372: PROCEDURE handle_header_rounding_curr(
373: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
374: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
375: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
376: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
377: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
370: );
371:
372: PROCEDURE handle_header_rounding_curr(
373: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
374: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
375: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
376: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
377: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
378: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
371:
372: PROCEDURE handle_header_rounding_curr(
373: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
374: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
375: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
376: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
377: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
378: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
379: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
372: PROCEDURE handle_header_rounding_curr(
373: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
374: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
375: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
376: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
377: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
378: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
379: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
380: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
373: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
374: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
375: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
376: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
377: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
378: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
379: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
380: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
381: p_return_status OUT NOCOPY VARCHAR2,
376: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
377: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
378: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
379: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
380: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
381: p_return_status OUT NOCOPY VARCHAR2,
382: p_error_buffer OUT NOCOPY VARCHAR2
383: );
384:
392: p_error_buffer OUT NOCOPY VARCHAR2
393: );
394:
395: PROCEDURE chk_mandatory_col_after_round(
396: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
397: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: );
394:
395: PROCEDURE chk_mandatory_col_after_round(
396: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
397: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394:
395: PROCEDURE chk_mandatory_col_after_round(
396: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
397: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
402: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
395: PROCEDURE chk_mandatory_col_after_round(
396: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
397: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
402: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
403: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
396: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
397: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
402: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
403: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
404: p_return_status OUT NOCOPY VARCHAR2,
397: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
402: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
403: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
404: p_return_status OUT NOCOPY VARCHAR2,
405: p_error_buffer OUT NOCOPY VARCHAR2
398: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
402: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
403: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
404: p_return_status OUT NOCOPY VARCHAR2,
405: p_error_buffer OUT NOCOPY VARCHAR2
406: );
426: p_return_status OUT NOCOPY VARCHAR2,
427: p_error_buffer OUT NOCOPY VARCHAR2
428: );
429:
430: PROCEDURE update_zx_lines(
431: p_conversion_rate IN NUMBER,
432: p_conversion_type IN VARCHAR2,
433: p_conversion_date IN DATE,
434: p_tax_amt_funcl_curr_tbl IN TAX_AMT_FUNCL_CURR_TBL,
439: p_error_buffer OUT NOCOPY VARCHAR2
440: );
441:
442: PROCEDURE convert_and_round_for_curr(
443: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
444: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
440: );
441:
442: PROCEDURE convert_and_round_for_curr(
443: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
444: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
441:
442: PROCEDURE convert_and_round_for_curr(
443: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
444: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: PROCEDURE convert_and_round_for_curr(
443: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
444: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
444: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
452: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
445: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
452: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
453: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
446: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
452: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
453: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
454: p_return_status OUT NOCOPY VARCHAR2,
447: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
452: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
453: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
454: p_return_status OUT NOCOPY VARCHAR2,
455: p_error_buffer OUT NOCOPY VARCHAR2
448: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
452: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
453: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
454: p_return_status OUT NOCOPY VARCHAR2,
455: p_error_buffer OUT NOCOPY VARCHAR2
456: );
935:
936: l_rate NUMBER;
937:
938: CURSOR get_rate_info_csr
939: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
940: c_to_currency ZX_LINES.tax_currency_code%TYPE,
941: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
942: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
943: IS
936: l_rate NUMBER;
937:
938: CURSOR get_rate_info_csr
939: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
940: c_to_currency ZX_LINES.tax_currency_code%TYPE,
941: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
942: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
943: IS
944: SELECT conversion_rate
937:
938: CURSOR get_rate_info_csr
939: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
940: c_to_currency ZX_LINES.tax_currency_code%TYPE,
941: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
942: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
943: IS
944: SELECT conversion_rate
945: FROM GL_DAILY_RATES
938: CURSOR get_rate_info_csr
939: (c_from_currency ZX_LINES.trx_currency_code%TYPE,
940: c_to_currency ZX_LINES.tax_currency_code%TYPE,
941: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
942: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
943: IS
944: SELECT conversion_rate
945: FROM GL_DAILY_RATES
946: WHERE from_currency = c_from_currency
2135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2136: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2137: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2138: p_rnd_lvl_party_tax_prof_id
2139: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2140: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
2141: p_return_status OUT NOCOPY VARCHAR2,
2142: p_error_buffer OUT NOCOPY VARCHAR2
2143: )
2136: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2137: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2138: p_rnd_lvl_party_tax_prof_id
2139: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2140: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
2141: p_return_status OUT NOCOPY VARCHAR2,
2142: p_error_buffer OUT NOCOPY VARCHAR2
2143: )
2144: IS
2189: provnl_tax_determination_date,
2190: adjusted_doc_date,
2191: trx_line_date,
2192: trx_date) tax_determine_date
2193: FROM ZX_LINES_DET_FACTORS
2194: WHERE application_id = p_event_class_rec.application_id
2195: AND entity_code = p_event_class_rec.entity_code
2196: AND event_class_code = p_event_class_rec.event_class_code
2197: AND trx_id = p_event_class_rec.trx_id
3004: -- to be used later for conversion and rounding
3005: --
3006:
3007: PROCEDURE get_currency_info_for_rounding(
3008: p_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3009: p_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3010: p_return_status OUT NOCOPY VARCHAR2,
3011: p_error_buffer OUT NOCOPY VARCHAR2
3012: )
3005: --
3006:
3007: PROCEDURE get_currency_info_for_rounding(
3008: p_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3009: p_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3010: p_return_status OUT NOCOPY VARCHAR2,
3011: p_error_buffer OUT NOCOPY VARCHAR2
3012: )
3013: IS
3094: -- This procedure converts amount from from_currency to to_currency
3095: --
3096:
3097: PROCEDURE convert_to_currency(
3098: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3099: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3095: --
3096:
3097: PROCEDURE convert_to_currency(
3098: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3099: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3096:
3097: PROCEDURE convert_to_currency(
3098: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3099: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3097: PROCEDURE convert_to_currency(
3098: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3099: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3105: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3098: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3099: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3105: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3106: p_return_status OUT NOCOPY VARCHAR2,
3099: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3105: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3106: p_return_status OUT NOCOPY VARCHAR2,
3107: p_error_buffer OUT NOCOPY VARCHAR2,
3100: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3105: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3106: p_return_status OUT NOCOPY VARCHAR2,
3107: p_error_buffer OUT NOCOPY VARCHAR2,
3108: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3101: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3102: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3103: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3105: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3106: p_return_status OUT NOCOPY VARCHAR2,
3107: p_error_buffer OUT NOCOPY VARCHAR2,
3108: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3109: IS
3104: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
3105: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3106: p_return_status OUT NOCOPY VARCHAR2,
3107: p_error_buffer OUT NOCOPY VARCHAR2,
3108: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3109: IS
3110: l_rate_index BINARY_INTEGER;
3111: BEGIN
3112:
3209: -- a functional currency from fnd_currencies based on the ledger id,
3210: -- then rounds the tax amount in functional currency using ROUND function
3211:
3212: FUNCTION round_tax_funcl_curr(
3213: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
3214: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3215: p_return_status OUT NOCOPY VARCHAR2,
3216: p_error_buffer OUT NOCOPY VARCHAR2
3217: ) RETURN NUMBER
3210: -- then rounds the tax amount in functional currency using ROUND function
3211:
3212: FUNCTION round_tax_funcl_curr(
3213: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
3214: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3215: p_return_status OUT NOCOPY VARCHAR2,
3216: p_error_buffer OUT NOCOPY VARCHAR2
3217: ) RETURN NUMBER
3218: IS
3215: p_return_status OUT NOCOPY VARCHAR2,
3216: p_error_buffer OUT NOCOPY VARCHAR2
3217: ) RETURN NUMBER
3218: IS
3219: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3220: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3221: l_precision FND_CURRENCIES.PRECISION%TYPE;
3222: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3223:
3306: -- currency and then round the converted amount
3307: --
3308:
3309: PROCEDURE conv_rnd_tax_tax_curr(
3310: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3311: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3307: --
3308:
3309: PROCEDURE conv_rnd_tax_tax_curr(
3310: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3311: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3308:
3309: PROCEDURE conv_rnd_tax_tax_curr(
3310: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3311: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3309: PROCEDURE conv_rnd_tax_tax_curr(
3310: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3311: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3310: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3311: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3311: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3312: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3313: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3314: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3315: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3316: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3317: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3318: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3321: p_return_status OUT NOCOPY VARCHAR2,
3319: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3320: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3321: p_return_status OUT NOCOPY VARCHAR2,
3322: p_error_buffer OUT NOCOPY VARCHAR2,
3323: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL)--Bug7183884
3324: IS
3325: l_amt_tax_curr NUMBER;
3326:
3327: BEGIN
3403: -- functional currency and then round the converted amount
3404: --
3405:
3406: PROCEDURE conv_rnd_tax_funcl_curr(
3407: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3408: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3409: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3410: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3411: p_return_status OUT NOCOPY VARCHAR2,
3404: --
3405:
3406: PROCEDURE conv_rnd_tax_funcl_curr(
3407: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3408: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3409: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3410: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3411: p_return_status OUT NOCOPY VARCHAR2,
3412: p_error_buffer OUT NOCOPY VARCHAR2
3405:
3406: PROCEDURE conv_rnd_tax_funcl_curr(
3407: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3408: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3409: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3410: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3411: p_return_status OUT NOCOPY VARCHAR2,
3412: p_error_buffer OUT NOCOPY VARCHAR2
3413: )
3406: PROCEDURE conv_rnd_tax_funcl_curr(
3407: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3408: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3409: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3410: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3411: p_return_status OUT NOCOPY VARCHAR2,
3412: p_error_buffer OUT NOCOPY VARCHAR2
3413: )
3414: IS
3476: -- tax currency and then round the converted amount
3477: --
3478:
3479: PROCEDURE conv_rnd_taxable_tax_curr(
3480: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3481: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3477: --
3478:
3479: PROCEDURE conv_rnd_taxable_tax_curr(
3480: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3481: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3478:
3479: PROCEDURE conv_rnd_taxable_tax_curr(
3480: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3481: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3479: PROCEDURE conv_rnd_taxable_tax_curr(
3480: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3481: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3480: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3481: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3481: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3482: p_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3483: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
3484: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
3485: p_tax_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
3486: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3487: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3494: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3495: p_return_status OUT NOCOPY VARCHAR2,
3488: p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3494: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3495: p_return_status OUT NOCOPY VARCHAR2,
3496: p_error_buffer OUT NOCOPY VARCHAR2,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3494: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3495: p_return_status OUT NOCOPY VARCHAR2,
3496: p_error_buffer OUT NOCOPY VARCHAR2,
3497: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3498:
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3494: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3495: p_return_status OUT NOCOPY VARCHAR2,
3496: p_error_buffer OUT NOCOPY VARCHAR2,
3497: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3498:
3499: IS
3500: l_amt_tax_curr NUMBER;
3501: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
3594: -- functional currency and then round the converted amount
3595: --
3596:
3597: PROCEDURE conv_rnd_taxable_funcl_curr(
3598: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3599: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3595: --
3596:
3597: PROCEDURE conv_rnd_taxable_funcl_curr(
3598: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3599: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3596:
3597: PROCEDURE conv_rnd_taxable_funcl_curr(
3598: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3599: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3597: PROCEDURE conv_rnd_taxable_funcl_curr(
3598: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3599: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3605: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3598: p_funcl_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3599: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3605: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3606: p_return_status OUT NOCOPY VARCHAR2,
3599: p_amt IN ZX_LINES.TAX_AMT%TYPE,
3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3605: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3606: p_return_status OUT NOCOPY VARCHAR2,
3607: p_error_buffer OUT NOCOPY VARCHAR2
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3605: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3606: p_return_status OUT NOCOPY VARCHAR2,
3607: p_error_buffer OUT NOCOPY VARCHAR2
3608: )
3609: IS
3700: -- This procedure is used to round tax lines at line level
3701: --
3702:
3703: PROCEDURE round_line_level(
3704: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3705: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3701: --
3702:
3703: PROCEDURE round_line_level(
3704: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3705: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3702:
3703: PROCEDURE round_line_level(
3704: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3705: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3703: PROCEDURE round_line_level(
3704: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3705: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3704: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
3705: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3705: p_taxable_amt OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3706: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3707: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3715: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3708: p_trx_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3715: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3716: p_return_status OUT NOCOPY VARCHAR2,
3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3715: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3716: p_return_status OUT NOCOPY VARCHAR2,
3717: p_error_buffer OUT NOCOPY VARCHAR2
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3715: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3716: p_return_status OUT NOCOPY VARCHAR2,
3717: p_error_buffer OUT NOCOPY VARCHAR2
3718: )
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3715: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3716: p_return_status OUT NOCOPY VARCHAR2,
3717: p_error_buffer OUT NOCOPY VARCHAR2
3718: )
3719: IS
3718: )
3719: IS
3720:
3721: l_zx_proudct_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
3722: l_min_acct_unit ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3723: l_precision ZX_LINES.PRECISION%TYPE;
3724:
3725: BEGIN
3726:
3719: IS
3720:
3721: l_zx_proudct_options_rec ZX_GLOBAL_STRUCTURES_PKG.zx_product_options_rec_type;
3722: l_min_acct_unit ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3723: l_precision ZX_LINES.PRECISION%TYPE;
3724:
3725: BEGIN
3726:
3727: IF (g_level_statement >= g_current_runtime_level ) THEN
3876: -- This procedure is incomplete due to handling of MRC is not clear now
3877:
3878:
3879: PROCEDURE handle_header_rounding_curr(
3880: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3881: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3882: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3883: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3884: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3877:
3878:
3879: PROCEDURE handle_header_rounding_curr(
3880: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3881: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3882: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3883: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3884: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3885: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3878:
3879: PROCEDURE handle_header_rounding_curr(
3880: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3881: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3882: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3883: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3884: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3885: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3886: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3879: PROCEDURE handle_header_rounding_curr(
3880: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3881: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3882: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3883: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3884: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3885: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3886: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3887: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3880: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
3881: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3882: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3883: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3884: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3885: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3886: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3887: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3888: p_return_status OUT NOCOPY VARCHAR2,
3883: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
3884: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
3885: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
3886: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
3887: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3888: p_return_status OUT NOCOPY VARCHAR2,
3889: p_error_buffer OUT NOCOPY VARCHAR2
3890: )
3891: IS
3966: -- and tax currency
3967:
3968: PROCEDURE get_rounding_info(
3969: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
3970: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3967:
3968: PROCEDURE get_rounding_info(
3969: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
3970: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3968: PROCEDURE get_rounding_info(
3969: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
3970: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3969: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
3970: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3970: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3978: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3971: p_tax_currency_conversion_date IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
3972: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3973: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
3974: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3975: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3976: p_tax_min_acct_unit OUT NOCOPY ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3977: p_tax_precision OUT NOCOPY ZX_TAXES_B.TAX_PRECISION%TYPE,
3978: p_tax_currency_conversion_type OUT NOCOPY ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE,
3979: p_return_status OUT NOCOPY VARCHAR2,
4206: 'update the adjustments to the largest lines ....');
4207: END IF;
4208:
4209: FORALL i IN 1 .. l_count
4210: UPDATE ZX_LINES
4211: SET tax_amt_funcl_curr = l_tax_amt_curr_tbl(i),
4212: taxable_amt_funcl_curr = l_taxable_amt_curr_tbl(i)
4213: WHERE tax_line_id = l_tax_line_id_tbl(i);
4214:
4490: -- used later for rounding adjustments.
4491: -- This procedure is incomplete due to handling of MRC is not clear now
4492:
4493: PROCEDURE update_header_rounding_curr(
4494: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4495: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4496: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4497: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4498: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4491: -- This procedure is incomplete due to handling of MRC is not clear now
4492:
4493: PROCEDURE update_header_rounding_curr(
4494: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4495: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4496: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4497: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4498: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4499: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4492:
4493: PROCEDURE update_header_rounding_curr(
4494: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4495: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4496: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4497: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4498: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4499: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4500: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4493: PROCEDURE update_header_rounding_curr(
4494: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4495: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4496: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4497: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4498: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4499: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4500: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4501: p_same_tax IN VARCHAR2,
4494: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4495: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4496: p_tax_amt_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4497: p_taxable_amt_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4498: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4499: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4500: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4501: p_same_tax IN VARCHAR2,
4502: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4498: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4499: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4500: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4501: p_same_tax IN VARCHAR2,
4502: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4503: p_return_status OUT NOCOPY VARCHAR2,
4504: p_error_buffer OUT NOCOPY VARCHAR2
4505: )
4506: IS
4589: -- This procedure stores header rounding info for each group which will be
4590: -- used later for rounding adjustments.
4591:
4592: PROCEDURE update_header_rounding_info(
4593: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4591:
4592: PROCEDURE update_header_rounding_info(
4593: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4592: PROCEDURE update_header_rounding_info(
4593: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4593: p_tax_line_id IN ZX_LINES.TAX_LINE_ID%TYPE,
4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4594: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4595: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4596: p_min_acct_unit IN ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4604: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4597: p_precision IN ZX_LINES.PRECISION%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4604: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4605: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4598: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4604: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4605: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4606: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4599: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4604: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4605: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4606: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4607: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4600: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4604: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4605: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4606: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4607: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4608: p_same_tax IN VARCHAR2,
4601: p_tax_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4602: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4603: p_taxable_amt_funcl_curr IN ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4604: p_tax_curr_conv_rate IN ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4605: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4606: p_prev_hdr_grp_rec IN OUT NOCOPY HDR_GRP_REC_TYPE,
4607: p_curr_hdr_grp_rec IN HDR_GRP_REC_TYPE,
4608: p_same_tax IN VARCHAR2,
4609: p_sum_unrnd_tax_amt IN NUMBER,
4609: p_sum_unrnd_tax_amt IN NUMBER,
4610: p_sum_rnd_tax_amt IN NUMBER,
4611: p_sum_rnd_tax_curr IN NUMBER,
4612: p_sum_rnd_funcl_curr IN NUMBER,
4613: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4614: p_return_status OUT NOCOPY VARCHAR2,
4615: p_error_buffer OUT NOCOPY VARCHAR2
4616: )
4617: IS
4745:
4746: PROCEDURE do_rounding(
4747: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4746: PROCEDURE do_rounding(
4747: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4747: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4753: p_orig_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4754: p_orig_taxable_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4755: p_cal_tax_amt IN OUT NOCOPY ZX_LINES.CAL_TAX_AMT%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4756: p_tax_amt_tax_curr IN OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4757: p_taxable_amt_tax_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4758: p_cal_tax_amt_tax_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_TAX_CURR%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4759: p_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4760: p_taxable_amt_funcl_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_FUNCL_CURR%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4761: p_cal_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.CAL_TAX_AMT_FUNCL_CURR%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4762: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4763: p_tax_currency_code OUT NOCOPY ZX_LINES.TAX_CURRENCY_CODE%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4764: p_tax_currency_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4765: p_tax_currency_conversion_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4766: p_tax_currency_conversion_date IN ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4767: p_currency_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4768: p_currency_conversion_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4769: p_currency_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4770: p_Rounding_Rule_Code IN ZX_LINES.Rounding_Rule_Code%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4771: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4784: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4784: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4785: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4784: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4785: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4786: --p_quote_flag IN VARCHAR2,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4784: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4785: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4786: --p_quote_flag IN VARCHAR2,
4787: p_return_status OUT NOCOPY VARCHAR2,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4784: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4785: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4786: --p_quote_flag IN VARCHAR2,
4787: p_return_status OUT NOCOPY VARCHAR2,
4788: p_error_buffer OUT NOCOPY VARCHAR2
4781: p_prd_total_tax_amt_funcl_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE,
4782: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
4783: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
4784: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
4785: p_tax_provider_id IN zx_lines.tax_provider_id%TYPE,
4786: --p_quote_flag IN VARCHAR2,
4787: p_return_status OUT NOCOPY VARCHAR2,
4788: p_error_buffer OUT NOCOPY VARCHAR2
4789: )
4790: IS
4791: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4791: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4792: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4800: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4793: l_tax_currency_conversion_type ZX_TAXES_B.EXCHANGE_RATE_TYPE%TYPE;
4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4800: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4801:
5367: p_return_status OUT NOCOPY VARCHAR2,
5368: p_error_buffer OUT NOCOPY VARCHAR2
5369: )
5370: IS
5371: l_trx_id ZX_LINES.TRX_ID%TYPE;
5372: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5373: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5374: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5375:
5368: p_error_buffer OUT NOCOPY VARCHAR2
5369: )
5370: IS
5371: l_trx_id ZX_LINES.TRX_ID%TYPE;
5372: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5373: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5374: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5375:
5376: CURSOR get_existing_sum_amt_csr
5369: )
5370: IS
5371: l_trx_id ZX_LINES.TRX_ID%TYPE;
5372: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5373: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5374: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5375:
5376: CURSOR get_existing_sum_amt_csr
5377: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5370: IS
5371: l_trx_id ZX_LINES.TRX_ID%TYPE;
5372: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
5373: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5374: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5375:
5376: CURSOR get_existing_sum_amt_csr
5377: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5378: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5373: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
5374: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5375:
5376: CURSOR get_existing_sum_amt_csr
5377: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5378: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5379: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5380: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5374: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
5375:
5376: CURSOR get_existing_sum_amt_csr
5377: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5378: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5379: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5380: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5375:
5376: CURSOR get_existing_sum_amt_csr
5377: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5378: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5379: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5380: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5376: CURSOR get_existing_sum_amt_csr
5377: (c_trx_id ZX_LINES.TRX_ID%TYPE,
5378: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
5379: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
5380: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5385: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5386: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5387: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5385: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5386: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5387: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5385: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5386: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5387: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5386: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5387: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5387: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5389: c_tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5390: c_tax_amt_included_flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5391: c_compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5392: c_historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5393: c_self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5394: c_overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5395: c_manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5396: c_Copied_From_Other_Doc_Flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5397: c_associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5398: c_tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5399: c_mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5400: c_reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5401: c_applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5402: c_applied_from_evnt_cls_cd ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5403: c_applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5404: c_applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5405: c_applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5406: c_adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5407: c_adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5408: c_adjusted_doc_evnt_cls_cd ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5409: c_adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5410: --c_applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5411: --c_applied_to_evnt_cls_cd ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5412: --c_applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5413: --c_applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5414: --c_applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5415: c_tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5416: c_tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5417: c_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5418: c_exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5419: c_exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5420: c_exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5421: c_exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5422: c_tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5423: c_tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5431: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5424: c_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5431: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5432: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5425: c_exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5431: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5432: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5433: IS
5426: c_ledger_id ZX_LINES.LEDGER_ID%TYPE,
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5431: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5432: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5433: IS
5434: SELECT SUM(unrounded_tax_amt),
5427: c_legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5431: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5432: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5433: IS
5434: SELECT SUM(unrounded_tax_amt),
5435: SUM(tax_amt),
5428: c_establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
5429: c_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_date%TYPE,
5430: c_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_type%TYPE,
5431: c_currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_rate%TYPE,
5432: c_record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE)
5433: IS
5434: SELECT SUM(unrounded_tax_amt),
5435: SUM(tax_amt),
5436: SUM(tax_amt_tax_curr),
5434: SELECT SUM(unrounded_tax_amt),
5435: SUM(tax_amt),
5436: SUM(tax_amt_tax_curr),
5437: SUM(tax_amt_funcl_curr)
5438: FROM ZX_LINES L
5439: WHERE L.trx_id = c_trx_id AND
5440: L.application_id = c_application_id AND
5441: L.event_class_code = c_event_class_code AND
5442: L.entity_code = c_entity_code AND
5581: p_sum_rnd_tax_amt,
5582: p_sum_rnd_tax_curr,
5583: p_sum_rnd_funcl_curr;
5584: IF p_sum_unrnd_tax_amt IS NULL THEN
5585: -- this would be the case of those tax lines exist in zx_lines
5586: -- have been updated so these same tax lines would also exist
5587: -- in gt, causing no record returns
5588: p_sum_unrnd_tax_amt := 0;
5589: p_sum_rnd_tax_amt := 0;
5625: -- This procedure
5626: --
5627:
5628: PROCEDURE chk_mandatory_col_after_round(
5629: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5630: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5626: --
5627:
5628: PROCEDURE chk_mandatory_col_after_round(
5629: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5630: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5627:
5628: PROCEDURE chk_mandatory_col_after_round(
5629: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5630: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5635: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5628: PROCEDURE chk_mandatory_col_after_round(
5629: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5630: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5635: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5636: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5629: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
5630: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5635: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5636: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5637: p_return_status OUT NOCOPY VARCHAR2,
5630: p_tax_currency_code IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5635: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5636: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5637: p_return_status OUT NOCOPY VARCHAR2,
5638: p_error_buffer OUT NOCOPY VARCHAR2
5631: p_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5635: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5636: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5637: p_return_status OUT NOCOPY VARCHAR2,
5638: p_error_buffer OUT NOCOPY VARCHAR2
5639: )
5836:
5837: END update_detail_tax_lines_gt;
5838: -----------------------------------------------------------------------
5839: -- PRIVATE PROCEDURE
5840: -- update_zx_lines
5841: --
5842: -- DESCRIPTION
5843: -- This procedure updates the values belonged to a group used by
5844: -- header level rounding
5843: -- This procedure updates the values belonged to a group used by
5844: -- header level rounding
5845: --
5846:
5847: PROCEDURE update_zx_lines(
5848: p_conversion_rate IN NUMBER,
5849: p_conversion_type IN VARCHAR2,
5850: p_conversion_date IN DATE,
5851: p_tax_amt_funcl_curr_tbl IN TAX_AMT_FUNCL_CURR_TBL,
5868: BEGIN
5869:
5870: IF (g_level_statement >= g_current_runtime_level ) THEN
5871: FND_LOG.STRING(g_level_statement,
5872: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.BEGIN',
5873: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(+)');
5874: END IF;
5875:
5876: p_return_status := FND_API.G_RET_STS_SUCCESS;
5869:
5870: IF (g_level_statement >= g_current_runtime_level ) THEN
5871: FND_LOG.STRING(g_level_statement,
5872: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.BEGIN',
5873: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(+)');
5874: END IF;
5875:
5876: p_return_status := FND_API.G_RET_STS_SUCCESS;
5877:
5876: p_return_status := FND_API.G_RET_STS_SUCCESS;
5877:
5878: l_count := p_tax_line_id_tbl.COUNT;
5879:
5880: -- update zx_lines
5881: --
5882: FOR i IN 1 .. l_count LOOP
5883: select Decode(tax_currency_conversion_rate,0,2,currency_conversion_rate/tax_currency_conversion_rate),
5884: NVL(tax.minimum_accountable_unit, power(10, (-1 * tax.tax_precision))),
5891: l_tax_amt_tax_curr,
5892: l_taxable_amt_tax_curr,
5893: l_cal_tax_amt_tax_curr,
5894: l_rounding_rule_code
5895: from zx_lines zxl,zx_taxes_b tax
5896: where zxl.tax_line_id = p_tax_line_id_tbl(i)
5897: and zxl.tax_id = tax.tax_id;
5898:
5899: IF l_rate_ratio = 1 AND l_mau IS NOT NULL THEN
5920: l_taxable_amt_tax_curr := p_taxable_amt_funcl_curr_tbl(i);
5921: l_cal_tax_amt_tax_curr := p_cal_tax_amt_funcl_curr_tbl(i);
5922: END IF;
5923:
5924: UPDATE ZX_LINES
5925: SET currency_conversion_date = p_conversion_date,
5926: currency_conversion_type = p_conversion_type,
5927: currency_conversion_rate = p_conversion_rate,
5928: tax_amt_funcl_curr = p_tax_amt_funcl_curr_tbl(i),
5941: END LOOP;
5942: IF (g_level_statement >= g_current_runtime_level ) THEN
5943:
5944: FND_LOG.STRING(g_level_statement,
5945: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.END',
5946: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(-)'||p_return_status);
5947: END IF;
5948:
5949: EXCEPTION
5942: IF (g_level_statement >= g_current_runtime_level ) THEN
5943:
5944: FND_LOG.STRING(g_level_statement,
5945: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines.END',
5946: 'ZX_TDS_TAX_ROUNDING_PKG: update_zx_lines(-)'||p_return_status);
5947: END IF;
5948:
5949: EXCEPTION
5950: WHEN OTHERS THEN
5952: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5953:
5954: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5955: FND_LOG.STRING(g_level_unexpected,
5956: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines',
5957: p_error_buffer);
5958: END IF;
5959: END update_zx_lines;
5960: ---------------------------------------------------------------------------
5955: FND_LOG.STRING(g_level_unexpected,
5956: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.update_zx_lines',
5957: p_error_buffer);
5958: END IF;
5959: END update_zx_lines;
5960: ---------------------------------------------------------------------------
5961: -- PUBLIC PROCEDURE
5962: -- perform_rounding
5963: --
6074: l_entity_code_tbl ENTITY_CODE_TBL;
6075: l_trx_id_tbl TRX_ID_TBL;
6076: l_rounding_level_code_tbl ROUNDING_LEVEL_CODE_TBL;
6077:
6078: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
6079: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
6080: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
6081: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
6082:
6075: l_trx_id_tbl TRX_ID_TBL;
6076: l_rounding_level_code_tbl ROUNDING_LEVEL_CODE_TBL;
6077:
6078: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
6079: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
6080: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
6081: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
6082:
6083:
6076: l_rounding_level_code_tbl ROUNDING_LEVEL_CODE_TBL;
6077:
6078: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
6079: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
6080: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
6081: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
6082:
6083:
6084: CURSOR get_trx_id_csr
6077:
6078: l_trx_id ZX_LINES.TRX_ID%TYPE; --code changes
6079: l_application_id ZX_LINES.APPLICATION_ID%TYPE;
6080: l_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE;
6081: l_entity_code ZX_LINES.ENTITY_CODE%TYPE;
6082:
6083:
6084: CURSOR get_trx_id_csr
6085: IS
6091: FROM ZX_DETAIL_TAX_LINES_GT
6092: WHERE offset_link_to_tax_line_id IS NULL;
6093:
6094: CURSOR get_round_info_csr
6095: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
6096: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6097: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6098: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6099: IS
6092: WHERE offset_link_to_tax_line_id IS NULL;
6093:
6094: CURSOR get_round_info_csr
6095: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
6096: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6097: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6098: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6099: IS
6100: SELECT /*+ dynamic_sampling(1) */
6093:
6094: CURSOR get_round_info_csr
6095: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
6096: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6097: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6098: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6099: IS
6100: SELECT /*+ dynamic_sampling(1) */
6101: tax_line_id,
6094: CURSOR get_round_info_csr
6095: ( c_trx_id ZX_LINES.TRX_ID%TYPE,
6096: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6097: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6098: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6099: IS
6100: SELECT /*+ dynamic_sampling(1) */
6101: tax_line_id,
6102: Manually_Entered_Flag,
6793: -- specified and then performs line level rounding
6794: --
6795:
6796: PROCEDURE convert_and_round_for_curr(
6797: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6798: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6794: --
6795:
6796: PROCEDURE convert_and_round_for_curr(
6797: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6798: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6795:
6796: PROCEDURE convert_and_round_for_curr(
6797: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6798: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6796: PROCEDURE convert_and_round_for_curr(
6797: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6798: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6797: p_curr_conv_rate IN ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
6798: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6798: p_rounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6806: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6799: p_rounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6806: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6807: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6800: p_unrounded_tax_amt IN ZX_LINES.TAX_AMT%TYPE,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6806: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6807: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6808: p_return_status OUT NOCOPY VARCHAR2,
6801: p_unrounded_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6806: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6807: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6808: p_return_status OUT NOCOPY VARCHAR2,
6809: p_error_buffer OUT NOCOPY VARCHAR2
6802: p_conv_rnd_tax_amt_curr OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6806: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6807: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6808: p_return_status OUT NOCOPY VARCHAR2,
6809: p_error_buffer OUT NOCOPY VARCHAR2
6810: )
6925: l_taxable_amt_funcl_curr_tbl TAXABLE_AMT_FUNCL_CURR_TBL;
6926: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
6927:
6928: CURSOR get_round_line_level_curr_csr
6929: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6930: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6931: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6932: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6933: IS
6926: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
6927:
6928: CURSOR get_round_line_level_curr_csr
6929: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6930: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6931: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6932: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6933: IS
6934: SELECT tax_line_id,
6927:
6928: CURSOR get_round_line_level_curr_csr
6929: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6930: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6931: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6932: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6933: IS
6934: SELECT tax_line_id,
6935: tax_rate,
6928: CURSOR get_round_line_level_curr_csr
6929: (c_trx_id ZX_LINES.TRX_ID%TYPE,
6930: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
6931: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
6932: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
6933: IS
6934: SELECT tax_line_id,
6935: tax_rate,
6936: tax_rate_id,
6946: unrounded_tax_amt,
6947: tax_amt_funcl_curr,
6948: taxable_amt_funcl_curr,
6949: cal_tax_amt_funcl_curr
6950: FROM ZX_LINES
6951: WHERE trx_id = c_trx_id AND
6952: application_id = c_application_id AND
6953: event_class_code = c_event_class_code AND
6954: entity_code = c_entity_code AND
7042: -- bulk update the current rows processed
7043: -- before fetch the next set of rows
7044: --
7045:
7046: -- update zx_lines
7047: --
7048: update_zx_lines(
7049: p_conversion_rate,
7050: p_conversion_type,
7044: --
7045:
7046: -- update zx_lines
7047: --
7048: update_zx_lines(
7049: p_conversion_rate,
7050: p_conversion_type,
7051: p_conversion_date,
7052: l_tax_amt_funcl_curr_tbl,
7186: l_taxable_amt_funcl_curr_tbl TAXABLE_AMT_FUNCL_CURR_TBL;
7187: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
7188:
7189: CURSOR get_round_head_level_curr_csr
7190: (c_trx_id ZX_LINES.TRX_ID%TYPE,
7191: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7192: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7193: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
7194: IS
7187: l_cal_tax_amt_funcl_curr_tbl CAL_TAX_AMT_FUNCL_CURR_TBL;
7188:
7189: CURSOR get_round_head_level_curr_csr
7190: (c_trx_id ZX_LINES.TRX_ID%TYPE,
7191: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7192: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7193: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
7194: IS
7195: SELECT tax_line_id,
7188:
7189: CURSOR get_round_head_level_curr_csr
7190: (c_trx_id ZX_LINES.TRX_ID%TYPE,
7191: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7192: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7193: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
7194: IS
7195: SELECT tax_line_id,
7196: tax_regime_code,
7189: CURSOR get_round_head_level_curr_csr
7190: (c_trx_id ZX_LINES.TRX_ID%TYPE,
7191: c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7192: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7193: c_entity_code ZX_LINES.ENTITY_CODE%TYPE)
7194: IS
7195: SELECT tax_line_id,
7196: tax_regime_code,
7197: tax,
7254: unrounded_tax_amt,
7255: tax_amt_funcl_curr,
7256: taxable_amt_funcl_curr,
7257: cal_tax_amt_funcl_curr
7258: FROM ZX_LINES
7259: WHERE trx_id = c_trx_id AND
7260: application_id = c_application_id AND
7261: event_class_code = c_event_class_code AND
7262: entity_code = c_entity_code AND
7582: -- bulk update the current rows processed
7583: -- before fetch the next set of rows
7584: --
7585:
7586: -- update zx_lines
7587: --
7588: update_zx_lines(
7589: p_conversion_rate,
7590: p_conversion_type,
7584: --
7585:
7586: -- update zx_lines
7587: --
7588: update_zx_lines(
7589: p_conversion_rate,
7590: p_conversion_type,
7591: p_conversion_date,
7592: l_tax_amt_funcl_curr_tbl,
7685: p_return_status := FND_API.G_RET_STS_SUCCESS;
7686: p_error_buffer := NULL;
7687:
7688:
7689: -- ???????? where to get rounding level if not from zx_lines ????????
7690: -- ???????? for now, assume get it from event class rec ????????
7691: --
7692: IF p_event_class_rec.Default_Rounding_Level_Code = 'HEADER' THEN
7693: convert_and_round_hdr_lvl_curr(
7713: END IF;
7714:
7715: -- *****************
7716: -- need to do the same for offset tax lines
7717: -- select only the offset tax lines from zx_lines and
7718: -- do similar thing as set_amt_columns in offset tax determination pkg
7719: -- will have separate procedure to do this when handling of
7720: -- MRC is clear
7721: -- ******************
7750: -- by user on tax line or summary line.
7751: --
7752:
7753: PROCEDURE round_tax_amt_entered(
7754: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7756: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7757: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7758: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7752:
7753: PROCEDURE round_tax_amt_entered(
7754: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7756: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7757: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7758: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7759: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
7760: p_return_status OUT NOCOPY VARCHAR2,
7753: PROCEDURE round_tax_amt_entered(
7754: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7756: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7757: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7758: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7759: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
7760: p_return_status OUT NOCOPY VARCHAR2,
7761: p_error_buffer OUT NOCOPY VARCHAR2
7754: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7756: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7757: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7758: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7759: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
7760: p_return_status OUT NOCOPY VARCHAR2,
7761: p_error_buffer OUT NOCOPY VARCHAR2
7762: )
7755: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
7756: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
7757: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
7758: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
7759: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
7760: p_return_status OUT NOCOPY VARCHAR2,
7761: p_error_buffer OUT NOCOPY VARCHAR2
7762: )
7763: IS
7763: IS
7764:
7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7776: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7777:
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7776: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7777:
7778:
7779:
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7776: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7777:
7778:
7779:
7780: CURSOR get_rnd_level_hier_csr
7777:
7778:
7779:
7780: CURSOR get_rnd_level_hier_csr
7781: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7782: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7783: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE)
7784: IS
7785: SELECT default_rounding_level_code,
7778:
7779:
7780: CURSOR get_rnd_level_hier_csr
7781: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7782: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7783: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE)
7784: IS
7785: SELECT default_rounding_level_code,
7786: rounding_level_hier_1_code,
7779:
7780: CURSOR get_rnd_level_hier_csr
7781: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7782: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7783: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE)
7784: IS
7785: SELECT default_rounding_level_code,
7786: rounding_level_hier_1_code,
7787: rounding_level_hier_2_code,
7793: EVENT_CLASS_CODE = c_event_class_code;
7794:
7795: -- bug#6798349
7796: -- add trx_currency_code, precision, minimum_accountable_unit
7797: -- to get trx currency info from zx_lines_det_factors
7798:
7799: CURSOR get_rnd_tx_prof_id_csr
7800: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7801: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7796: -- add trx_currency_code, precision, minimum_accountable_unit
7797: -- to get trx currency info from zx_lines_det_factors
7798:
7799: CURSOR get_rnd_tx_prof_id_csr
7800: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7801: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7802: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7803: c_trx_id ZX_LINES.TRX_ID%TYPE)
7804: IS
7797: -- to get trx currency info from zx_lines_det_factors
7798:
7799: CURSOR get_rnd_tx_prof_id_csr
7800: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7801: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7802: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7803: c_trx_id ZX_LINES.TRX_ID%TYPE)
7804: IS
7805: SELECT rdng_ship_to_pty_tx_prof_id,
7798:
7799: CURSOR get_rnd_tx_prof_id_csr
7800: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7801: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7802: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7803: c_trx_id ZX_LINES.TRX_ID%TYPE)
7804: IS
7805: SELECT rdng_ship_to_pty_tx_prof_id,
7806: rdng_ship_from_pty_tx_prof_id,
7799: CURSOR get_rnd_tx_prof_id_csr
7800: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7801: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
7802: c_event_class_code ZX_LINES.EVENT_CLASS_CODE%TYPE,
7803: c_trx_id ZX_LINES.TRX_ID%TYPE)
7804: IS
7805: SELECT rdng_ship_to_pty_tx_prof_id,
7806: rdng_ship_from_pty_tx_prof_id,
7807: rdng_bill_to_pty_tx_prof_id,
7812: rdng_bill_from_pty_tx_p_st_id,
7813: trx_currency_code,
7814: precision,
7815: minimum_accountable_unit
7816: FROM ZX_LINES_DET_FACTORS
7817: WHERE APPLICATION_ID = c_application_id AND
7818: ENTITY_CODE = c_entity_code AND
7819: EVENT_CLASS_CODE = c_event_class_code AND
7820: TRX_ID = c_trx_id;
7819: EVENT_CLASS_CODE = c_event_class_code AND
7820: TRX_ID = c_trx_id;
7821:
7822: CURSOR get_rnd_info_from_tax_csr
7823: (c_tax_id ZX_LINES.TAX_ID%TYPE)
7824: IS
7825: SELECT rounding_rule_code,
7826: minimum_accountable_unit,
7827: tax_precision
7829: WHERE TAX_ID = c_tax_id;
7830:
7831: -- bug#6798349
7832: CURSOR get_precision_mau_csr
7833: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)
7834: IS
7835: SELECT minimum_accountable_unit,
7836: precision
7837: FROM FND_CURRENCIES
8591: -- accountable unit and precision of a functional currency from
8592: -- fnd_currencies based on the ledger id
8593:
8594: PROCEDURE get_funcl_curr_info(
8595: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8596: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8597: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8598: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8599: