DBA Data[Home] [Help]

APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_TAXES_B

Line 740: l_tax ZX_TAXES_B.tax%TYPE;

736: p_rnd_end_index OUT NOCOPY NUMBER,
737: p_return_status OUT NOCOPY VARCHAR2,
738: p_error_buffer OUT NOCOPY VARCHAR2) IS
739:
740: l_tax ZX_TAXES_B.tax%TYPE;
741: l_tax_id NUMBER;
742: l_index NUMBER;
743: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
744: l_rec_nrec_tax_dist_number NUMBER;

Line 747: c_tax_id zx_taxes_b.tax_id%TYPE) IS

743: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
744: l_rec_nrec_tax_dist_number NUMBER;
745:
746: CURSOR get_tax_recovery_info_cur(
747: c_tax_id zx_taxes_b.tax_id%TYPE) IS
748: SELECT allow_recoverability_flag,
749: primary_recovery_type_code,
750: primary_rec_type_rule_flag,
751: secondary_recovery_type_code,

Line 761: FROM ZX_TAXES_B

757: effective_from,
758: effective_to,
759: def_rec_settlement_option_code,
760: tax_account_source_tax
761: FROM ZX_TAXES_B
762: WHERE tax_id = c_tax_id;
763:
764: CURSOR get_maximum_tax_dist_num_csr is
765: SELECT max(rec_nrec_tax_dist_number)

Line 1469: l_tax ZX_TAXES_B.tax%TYPE;

1465: l_tax_id NUMBER;
1466: l_non_rec_index NUMBER;
1467: l_tax_determine_date DATE;
1468:
1469: l_tax ZX_TAXES_B.tax%TYPE;
1470: l_tax_date DATE;
1471: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1472: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1473: l_rec_rate NUMBER;

Line 1596: c_tax_id zx_taxes_b.tax_id%TYPE) IS

1592: -- AND rate.tax_jurisdiction_code(+) = c_tax_jurisdiction_code
1593: ***/
1594:
1595: CURSOR get_tax_rec_info_from_tax_csr(
1596: c_tax_id zx_taxes_b.tax_id%TYPE) IS
1597: SELECT allow_recoverability_flag,
1598: primary_recovery_type_code,
1599: primary_rec_type_rule_flag,
1600: secondary_recovery_type_code,

Line 1610: FROM ZX_TAXES_B

1606: effective_from,
1607: effective_to,
1608: def_rec_settlement_option_code,
1609: tax_account_source_tax
1610: FROM ZX_TAXES_B
1611: WHERE tax_id = c_tax_id;
1612:
1613: -- bug 5508356
1614: CURSOR get_tax_account_entity_id_csr(

Line 2460: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;

2456: p_tax_line_amt_funcl_curr IN NUMBER,
2457: p_return_status OUT NOCOPY VARCHAR2,
2458: p_error_buffer OUT NOCOPY VARCHAR2) IS
2459:
2460: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;

Line 2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;

2457: p_return_status OUT NOCOPY VARCHAR2,
2458: p_error_buffer OUT NOCOPY VARCHAR2) IS
2459:
2460: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;

Line 2462: l_precision zx_taxes_b.tax_precision%TYPE;

2458: p_error_buffer OUT NOCOPY VARCHAR2) IS
2459:
2460: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2461: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2462: l_precision zx_taxes_b.tax_precision%TYPE;
2463: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2464: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2465: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;

Line 2470: l_tax_id zx_taxes_b.tax_id%TYPE;

2466: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2467: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2468: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2469: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2470: l_tax_id zx_taxes_b.tax_id%TYPE;
2471:
2472: BEGIN
2473: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2474: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2638: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;

2634: l_rec_amt_largest NUMBER := 0;
2635: l_nrec_amt_largest NUMBER := 0;
2636:
2637: l_index NUMBER;
2638: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2639: l_precision zx_taxes_b.tax_precision%TYPE;
2640:
2641: BEGIN
2642:

Line 2639: l_precision zx_taxes_b.tax_precision%TYPE;

2635: l_nrec_amt_largest NUMBER := 0;
2636:
2637: l_index NUMBER;
2638: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2639: l_precision zx_taxes_b.tax_precision%TYPE;
2640:
2641: BEGIN
2642:
2643: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 3198: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;

3194:
3195: l_tax_line_rnd_diff_tax_curr NUMBER;
3196: l_tax_line_rnd_diff_funcl_curr NUMBER;
3197:
3198: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3199: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3200: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3201: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3202: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;

Line 3199: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;

3195: l_tax_line_rnd_diff_tax_curr NUMBER;
3196: l_tax_line_rnd_diff_funcl_curr NUMBER;
3197:
3198: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3199: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3200: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3201: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3202: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3203: l_funcl_currency_code fnd_currencies.currency_code%TYPE;

Line 3200: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;

3196: l_tax_line_rnd_diff_funcl_curr NUMBER;
3197:
3198: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3199: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3200: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3201: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3202: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3203: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3204: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;

Line 3201: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;

3197:
3198: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3199: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3200: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3201: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3202: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3203: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3204: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
3205:

Line 3202: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;

3198: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3199: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3200: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3201: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3202: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3203: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3204: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
3205:
3206: l_index NUMBER;

Line 3207: l_tax_id zx_taxes_b.tax_id%TYPE;

3203: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3204: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
3205:
3206: l_index NUMBER;
3207: l_tax_id zx_taxes_b.tax_id%TYPE;
3208:
3209:
3210:
3211: BEGIN

Line 5246: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;

5242: l_prd_tax_rnd_diff NUMBER;
5243: l_prd_tax_rnd_diff_tax_curr NUMBER;
5244: l_prd_tax_rnd_diff_funcl_curr NUMBER;
5245:
5246: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5247: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5248: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5249: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5250: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;

Line 5247: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;

5243: l_prd_tax_rnd_diff_tax_curr NUMBER;
5244: l_prd_tax_rnd_diff_funcl_curr NUMBER;
5245:
5246: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5247: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5248: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5249: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5250: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5251:

Line 5248: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;

5244: l_prd_tax_rnd_diff_funcl_curr NUMBER;
5245:
5246: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5247: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5248: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5249: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5250: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5251:
5252: l_error_buffer VARCHAR2(200);

Line 5249: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;

5245:
5246: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5247: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5248: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5249: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5250: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5251:
5252: l_error_buffer VARCHAR2(200);
5253: l_index NUMBER;

Line 5254: l_tax_id zx_taxes_b.tax_id%TYPE;

5250: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5251:
5252: l_error_buffer VARCHAR2(200);
5253: l_index NUMBER;
5254: l_tax_id zx_taxes_b.tax_id%TYPE;
5255:
5256: BEGIN
5257:
5258: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;