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 32: to zx_rates_b.tax

28: 12-Jan-2006 rallamse bug#4931630, Version 120.4
29: Issue : Remove references to ar_vat_tax_all as it is obsoleted
30: Impacted code : cp_loc_tax_code ar_vat_tax_all.tax_code%TYPE
31: Fix: Changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
32: to zx_rates_b.tax
33:
34: 07-Feb-2006 Aiyer for the bug 5021243, Version 120.5
35: Issue:-
36: Error plsql numeric or value error encontered while execution of

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

294: declared as Number however the cursor
295: jai_ar_trx_pkg.c_tax_regime_code_cur fetches a varchar value
296: into this variable.
297: Changed the variable from number to
298: ZX_RATES_B.TAX_REGIME_CODE%TYPE.Also changed the parameter
299: cp_tax_regime_code of the cursor cur_chk_non_il_taxes from
300: number to ZX_RATES_B.TAX_REGIME_CODE%TYPE.
301:
302: Dependency due to this fix:-

Line 300: number to ZX_RATES_B.TAX_REGIME_CODE%TYPE.

296: into this variable.
297: Changed the variable from number to
298: ZX_RATES_B.TAX_REGIME_CODE%TYPE.Also changed the parameter
299: cp_tax_regime_code of the cursor cur_chk_non_il_taxes from
300: number to ZX_RATES_B.TAX_REGIME_CODE%TYPE.
301:
302: Dependency due to this fix:-
303: None
304: --------------------------------------------------------------------------------------------------

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

309:
310:
311: V_ORG_ID number ;
312: /*Changed the Variable lv_tax_regime_code datatype from NUMBER to
313: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
314: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;
315:
316: CURSOR ORG_CUR IS
317: SELECT ORG_ID

Line 314: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;

310:
311: V_ORG_ID number ;
312: /*Changed the Variable lv_tax_regime_code datatype from NUMBER to
313: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
314: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;
315:
316: CURSOR ORG_CUR IS
317: SELECT ORG_ID
318: FROM RA_CUSTOMER_TRX_ALL

Line 324: || to zx_rates_b.tax

320: /*
321: || Modified by Ramananda for bug#4468353
322: || Check whether any other taxes other than localizations taxes exist.
323: || rallamse bug#4931630 changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
324: || to zx_rates_b.tax
325: */
326: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,

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

322: || Check whether any other taxes other than localizations taxes exist.
323: || rallamse bug#4931630 changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
324: || to zx_rates_b.tax
325: */
326: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
329: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
330: /*Variable datatype changed from number to

Line 329: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE

325: */
326: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
329: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
330: /*Variable datatype changed from number to
331: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
332: ) --rchandan for bug#4428980
333: IS

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

327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
329: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
330: /*Variable datatype changed from number to
331: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
332: ) --rchandan for bug#4428980
333: IS
334: SELECT
335: 1

Line 337: zx_rates_b zrb,

333: IS
334: SELECT
335: 1
336: FROM ra_customer_trx_lines_all rctl,
337: zx_rates_b zrb,
338: zx_party_tax_profile zptp
339: WHERE
340: zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217
341: AND zrb.tax_regime_code = cp_tax_regime_code