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.JAI_AR_TRX_PKG dependencies on ZX_RATES_B

Line 63: --| ar_vat_tax_all.tax_code%type to zx_rates_b.tax |

59: --| is obsoleted. |
60: --| Impacted code:cp_loc_tax_code |
61: --| ar_vat_tax_all.tax_code%TYPE |
62: --| Fix: Changed the cp_loc_tax_code from |
63: --| ar_vat_tax_all.tax_code%type to zx_rates_b.tax |
64: --| |
65: --| 05-Jul-2006 Aiyer for the bug 5369250, Version 120.7 |
66: --| Issue:- |
67: --| The concurrent failes with the following error :- |

Line 445: ZX_RATES_B.TAX_REGIME_CODE%TYPE.Also changed the parameter

441: declared as Number however the cursor
442: jai_ar_trx_pkg.c_tax_regime_code_cur fetches a varchar value
443: into this variable.
444: Changed the variable from number to
445: ZX_RATES_B.TAX_REGIME_CODE%TYPE.Also changed the parameter
446: cp_tax_regime_code of the cursor cur_chk_non_il_taxes from
447: number to ZX_RATES_B.TAX_REGIME_CODE%TYPE.
448:
449: Dependency due to this fix:-

Line 447: number to ZX_RATES_B.TAX_REGIME_CODE%TYPE.

443: into this variable.
444: Changed the variable from number to
445: ZX_RATES_B.TAX_REGIME_CODE%TYPE.Also changed the parameter
446: cp_tax_regime_code of the cursor cur_chk_non_il_taxes from
447: number to ZX_RATES_B.TAX_REGIME_CODE%TYPE.
448:
449: Dependency due to this fix:-
450: None
451: --------------------------------------------------------------------------------------------------

Line 460: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */

456:
457:
458: V_ORG_ID number ;
459: /*Changed the Variable lv_tax_regime_code datatype from NUMBER to
460: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
461: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;
462:
463: CURSOR ORG_CUR IS
464: SELECT ORG_ID

Line 461: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;

457:
458: V_ORG_ID number ;
459: /*Changed the Variable lv_tax_regime_code datatype from NUMBER to
460: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
461: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;
462:
463: CURSOR ORG_CUR IS
464: SELECT ORG_ID
465: FROM RA_CUSTOMER_TRX_ALL

Line 471: || to zx_rates_b.tax

467: /*
468: || Modified by Ramananda for bug#4468353
469: || Check whether any other taxes other than localizations taxes exist.
470: || rallamse bug#4931630 changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
471: || to zx_rates_b.tax
472: */
473: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,

Line 473: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,

469: || Check whether any other taxes other than localizations taxes exist.
470: || rallamse bug#4931630 changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
471: || to zx_rates_b.tax
472: */
473: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
476: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
477: /*Variable datatype changed from number to

Line 476: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE

472: */
473: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
476: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
477: /*Variable datatype changed from number to
478: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
479: ) --rchandan for bug#4428980
480: IS

Line 478: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */

474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
476: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
477: /*Variable datatype changed from number to
478: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
479: ) --rchandan for bug#4428980
480: IS
481: SELECT
482: 1

Line 484: zx_rates_b zrb,

480: IS
481: SELECT
482: 1
483: FROM ra_customer_trx_lines_all rctl,
484: zx_rates_b zrb,
485: zx_party_tax_profile zptp
486: WHERE
487: zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217
488: AND zrb.tax_regime_code = cp_tax_regime_code