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_MATCH_TAX_PKG dependencies on JAI_AR_TRX_PKG

Line 2285: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

2281:
2282:
2283:
2284: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2285: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2286: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2288:
2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

Line 2286: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

2282:
2283:
2284: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2285: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2286: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2288:
2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

Line 2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

2283:
2284: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2285: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2286: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2288:
2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

Line 2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

2285: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2286: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2288:
2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2292:
2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);

Line 2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

2286: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2288:
2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2292:
2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2294: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

Line 2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

2287: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2288:
2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2292:
2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2294: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2295: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

Line 2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);

2289: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2292:
2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2294: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2295: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
2296:
2297: if ln_tax_rate_id is null then

Line 2294: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

2290: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2292:
2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2294: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2295: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
2296:
2297: if ln_tax_rate_id is null then
2298: raise Localization_tax_not_defined;

Line 2295: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

2291: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2292:
2293: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2294: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2295: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
2296:
2297: if ln_tax_rate_id is null then
2298: raise Localization_tax_not_defined;
2299: end if;

Line 3919: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

3915: end if;
3916: */
3917:
3918: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
3919: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3920: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3922:
3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

Line 3920: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

3916: */
3917:
3918: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
3919: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3920: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3922:
3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

Line 3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

3917:
3918: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
3919: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3920: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3922:
3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

Line 3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

3919: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3920: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3922:
3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
3926:
3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);

Line 3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

3920: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3922:
3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
3926:
3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
3928: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

Line 3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

3921: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3922:
3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
3926:
3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
3928: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
3929: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

Line 3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);

3923: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
3926:
3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
3928: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
3929: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
3930:
3931: if ln_tax_rate_id is null then

Line 3928: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

3924: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
3926:
3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
3928: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
3929: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
3930:
3931: if ln_tax_rate_id is null then
3932: raise Localization_tax_not_defined;

Line 3929: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

3925: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
3926:
3927: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
3928: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
3929: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
3930:
3931: if ln_tax_rate_id is null then
3932: raise Localization_tax_not_defined;
3933: end if;