APPS.JAI_AR_TRX_PKG dependencies on JAI_AR_TRX_PKG

Line 1: PACKAGE BODY jai_ar_trx_pkg

1: PACKAGE BODY jai_ar_trx_pkg
2: /* $Header: jai_ar_trx.plb 120.19.12020000.2 2013/03/18 07:45:49 qimeng ship $ */
3: AS
4: --+=======================================================================+
5: --| Copyright (c) 1998 Oracle Corporation |

Line 437: execution of the procedure jai_ar_trx_pkg.validate_invoice

433:
434: 07-Feb-2006 Aiyer for the bug 5021243, Version 120.5
435: Issue:-
436: Error plsql numeric or value error encontered while
437: execution of the procedure jai_ar_trx_pkg.validate_invoice
438:
439: Fix:-
440: The error was occuring as the variable lv_tax_regime_code was
441: declared as Number however the cursor

Line 442: jai_ar_trx_pkg.c_tax_regime_code_cur fetches a varchar value

438:
439: Fix:-
440: The error was occuring as the variable lv_tax_regime_code was
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

Line 569: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

565: OPEN ORG_CUR;
566: FETCH ORG_CUR INTO V_ORG_ID;
567: CLOSE ORG_CUR;
568:
569: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
570: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
571: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
572: /* Added by Ramananda for bug# due to ebtax uptake by AR, start */
573:

Line 570: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

566: FETCH ORG_CUR INTO V_ORG_ID;
567: CLOSE ORG_CUR;
568:
569: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
570: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
571: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
572: /* Added by Ramananda for bug# due to ebtax uptake by AR, start */
573:
574:

Line 571: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

567: CLOSE ORG_CUR;
568:
569: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
570: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
571: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
572: /* Added by Ramananda for bug# due to ebtax uptake by AR, start */
573:
574:
575: OPEN cur_chk_non_il_taxes('LOCALIZATION', 'TAX','FREIGHT',lv_tax_regime_code ); -- 'Localization' , Harshita for Bug 4907217

Line 789: END jai_ar_trx_pkg;

785: retcode := '2';
786: errbuf := SQLERRM;
787: END update_reference;
788:
789: END jai_ar_trx_pkg;