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

APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_TAXES_B

Line 795: l_tax ZX_TAXES_B.tax%TYPE;

791: p_rnd_end_index OUT NOCOPY NUMBER,
792: p_return_status OUT NOCOPY VARCHAR2,
793: p_error_buffer OUT NOCOPY VARCHAR2) IS
794:
795: l_tax ZX_TAXES_B.tax%TYPE;
796: l_tax_id NUMBER;
797: l_tax_apportionment_line_num NUMBER;
798: l_index NUMBER;
799: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

Line 803: c_tax_id zx_taxes_b.tax_id%TYPE) IS

799: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
800: l_rec_nrec_tax_dist_number NUMBER;
801:
802: CURSOR get_tax_recovery_info_cur(
803: c_tax_id zx_taxes_b.tax_id%TYPE) IS
804: SELECT allow_recoverability_flag,
805: primary_recovery_type_code,
806: primary_rec_type_rule_flag,
807: secondary_recovery_type_code,

Line 817: FROM ZX_TAXES_B

813: effective_from,
814: effective_to,
815: def_rec_settlement_option_code,
816: tax_account_source_tax
817: FROM ZX_TAXES_B
818: WHERE tax_id = c_tax_id;
819:
820: CURSOR get_maximum_tax_dist_num_csr is
821: SELECT max(rec_nrec_tax_dist_number)

Line 1567: l_tax ZX_TAXES_B.tax%TYPE;

1563: l_total_rec_rate NUMBER;
1564: l_tax_determine_date DATE;
1565: l_tax_date DATE;
1566: l_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE;
1567: l_tax ZX_TAXES_B.tax%TYPE;
1568: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;

Line 1681: c_tax_id ZX_TAXES_B.tax_id%TYPE) IS

1677: AND default_rate_flag = 'Y'
1678: ORDER BY rate.tax_class NULLS LAST, rate.subscription_level_code;
1679:
1680: CURSOR get_tax_rec_info_from_tax_csr(
1681: c_tax_id ZX_TAXES_B.tax_id%TYPE) IS
1682: SELECT allow_recoverability_flag,
1683: primary_recovery_type_code,
1684: primary_rec_type_rule_flag,
1685: secondary_recovery_type_code,

Line 1695: FROM ZX_TAXES_B

1691: effective_from,
1692: effective_to,
1693: def_rec_settlement_option_code,
1694: tax_account_source_tax
1695: FROM ZX_TAXES_B
1696: WHERE tax_id = c_tax_id;
1697:
1698: -- Added for Bug#5508356
1699: CURSOR get_tax_account_entity_id_csr(

Line 2729: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;

2725: p_tax_line_amt_funcl_curr IN NUMBER,
2726: p_return_status OUT NOCOPY VARCHAR2,
2727: p_error_buffer OUT NOCOPY VARCHAR2) IS
2728:
2729: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;

Line 2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;

2726: p_return_status OUT NOCOPY VARCHAR2,
2727: p_error_buffer OUT NOCOPY VARCHAR2) IS
2728:
2729: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;

Line 2731: l_precision zx_taxes_b.tax_precision%TYPE;

2727: p_error_buffer OUT NOCOPY VARCHAR2) IS
2728:
2729: l_rounding_rule_code zx_taxes_b.rounding_rule_code%TYPE;
2730: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2731: l_precision zx_taxes_b.tax_precision%TYPE;
2732: l_trx_currency_code zx_rec_nrec_dist.trx_currency_code%TYPE;
2733: l_tax_currency_code zx_rec_nrec_dist.tax_currency_code%TYPE;
2734: l_tax_currency_date zx_rec_nrec_dist.tax_currency_conversion_date%TYPE;
2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;

Line 2739: l_tax_id zx_taxes_b.tax_id%TYPE;

2735: l_tax_currency_type zx_rec_nrec_dist.tax_currency_conversion_type%TYPE;
2736: l_tax_currency_rate zx_rec_nrec_dist.tax_currency_conversion_rate%TYPE;
2737: l_tax_amt_tax_currency zx_rec_nrec_dist.rec_nrec_tax_amt_tax_curr%TYPE;
2738: l_taxable_amt_tax_currency zx_rec_nrec_dist.taxable_amt_tax_curr%TYPE;
2739: l_tax_id zx_taxes_b.tax_id%TYPE;
2740:
2741: BEGIN
2742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2743: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2907: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;

2903: l_rec_amt_largest NUMBER := 0;
2904: l_nrec_amt_largest NUMBER := 0;
2905:
2906: l_index NUMBER;
2907: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2908: l_precision zx_taxes_b.tax_precision%TYPE;
2909: l_round_nrec_flag VARCHAR2(1);
2910:
2911: BEGIN

Line 2908: l_precision zx_taxes_b.tax_precision%TYPE;

2904: l_nrec_amt_largest NUMBER := 0;
2905:
2906: l_index NUMBER;
2907: l_min_acct_unit zx_taxes_b.minimum_accountable_unit%TYPE;
2908: l_precision zx_taxes_b.tax_precision%TYPE;
2909: l_round_nrec_flag VARCHAR2(1);
2910:
2911: BEGIN
2912:

Line 3598: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;

3594:
3595: l_tax_line_rnd_diff_tax_curr NUMBER;
3596: l_tax_line_rnd_diff_funcl_curr NUMBER;
3597:
3598: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3599: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3600: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3601: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3602: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;

Line 3599: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;

3595: l_tax_line_rnd_diff_tax_curr NUMBER;
3596: l_tax_line_rnd_diff_funcl_curr NUMBER;
3597:
3598: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3599: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3600: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3601: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3602: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3603: l_funcl_currency_code fnd_currencies.currency_code%TYPE;

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

3596: l_tax_line_rnd_diff_funcl_curr NUMBER;
3597:
3598: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3599: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3600: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3601: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3602: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3603: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3604: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;

Line 3601: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;

3597:
3598: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3599: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3600: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3601: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3602: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3603: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3604: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
3605:

Line 3602: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;

3598: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3599: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
3600: -- l_rounding_rule_tax_curr zx_taxes_b.Rounding_Rule_Code%TYPE;
3601: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
3602: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
3603: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3604: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
3605:
3606: l_index NUMBER;

Line 3607: l_tax_id zx_taxes_b.tax_id%TYPE;

3603: l_funcl_currency_code fnd_currencies.currency_code%TYPE;
3604: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
3605:
3606: l_index NUMBER;
3607: l_tax_id zx_taxes_b.tax_id%TYPE;
3608:
3609:
3610:
3611: BEGIN

Line 5615: CURSOR get_tax_recovery_info_cur(c_tax_id ZX_TAXES_B.tax_id%TYPE) IS

5611: AND NVL(reverse_flag, 'N') <> 'Y'
5612: ORDER BY rec_nrec_tax_dist_id, recoverable_flag;
5613:
5614: -- Added the cursor for Bug#14038095 --
5615: CURSOR get_tax_recovery_info_cur(c_tax_id ZX_TAXES_B.tax_id%TYPE) IS
5616: SELECT allow_recoverability_flag,
5617: primary_recovery_type_code,
5618: primary_rec_type_rule_flag,
5619: secondary_recovery_type_code,

Line 5629: FROM ZX_TAXES_B

5625: effective_from,
5626: effective_to,
5627: def_rec_settlement_option_code,
5628: tax_account_source_tax
5629: FROM ZX_TAXES_B
5630: WHERE tax_id = c_tax_id;
5631:
5632: CURSOR get_maximum_tax_dist_num_csr is
5633: SELECT max(rec_nrec_tax_dist_number)

Line 5644: l_tax ZX_TAXES_B.tax%TYPE;

5640: l_rnd_begin_index NUMBER;
5641: l_max_tax_dist_number NUMBER;
5642:
5643: -- Added these variables for Bug#14038095 --
5644: l_tax ZX_TAXES_B.tax%TYPE;
5645: l_tax_id NUMBER;
5646: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
5647:
5648: BEGIN

Line 5968: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;

5964: l_prd_tax_rnd_diff NUMBER;
5965: l_prd_tax_rnd_diff_tax_curr NUMBER;
5966: l_prd_tax_rnd_diff_funcl_curr NUMBER;
5967:
5968: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5969: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5970: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5971: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5972: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;

Line 5969: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;

5965: l_prd_tax_rnd_diff_tax_curr NUMBER;
5966: l_prd_tax_rnd_diff_funcl_curr NUMBER;
5967:
5968: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5969: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5970: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5971: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5972: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5973:

Line 5970: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;

5966: l_prd_tax_rnd_diff_funcl_curr NUMBER;
5967:
5968: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5969: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5970: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5971: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5972: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5973:
5974: l_error_buffer VARCHAR2(200);

Line 5971: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;

5967:
5968: l_min_acct_unit_tax_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5969: l_precision_tax_curr zx_taxes_b.tax_precision%TYPE;
5970: l_min_acct_unit_funcl_curr zx_taxes_b.minimum_accountable_unit%TYPE;
5971: l_precision_funcl_curr zx_taxes_b.tax_precision%TYPE;
5972: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5973:
5974: l_error_buffer VARCHAR2(200);
5975: l_index NUMBER;

Line 5976: l_tax_id zx_taxes_b.tax_id%TYPE;

5972: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
5973:
5974: l_error_buffer VARCHAR2(200);
5975: l_index NUMBER;
5976: l_tax_id zx_taxes_b.tax_id%TYPE;
5977:
5978: BEGIN
5979:
5980: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;