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 1594: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

1590:
1591:
1592:
1593: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
1594: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1595: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1597:
1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

Line 1595: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

1591:
1592:
1593: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
1594: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1595: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1597:
1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

Line 1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

1592:
1593: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
1594: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1595: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1597:
1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

Line 1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

1594: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1595: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1597:
1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
1601:
1602: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);

Line 1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

1595: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1597:
1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
1601:
1602: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
1603: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

Line 1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

1596: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1597:
1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
1601:
1602: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
1603: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
1604: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

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

1598: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
1601:
1602: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
1603: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
1604: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
1605:
1606: if ln_tax_rate_id is null then

Line 1603: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

1599: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
1601:
1602: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
1603: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
1604: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
1605:
1606: if ln_tax_rate_id is null then
1607: raise Localization_tax_not_defined;

Line 1604: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

1600: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
1601:
1602: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
1603: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
1604: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
1605:
1606: if ln_tax_rate_id is null then
1607: raise Localization_tax_not_defined;
1608: end if;

Line 2858: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

2854: end if;
2855: */
2856:
2857: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2858: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2859: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2861:
2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

Line 2859: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

2855: */
2856:
2857: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2858: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2859: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2861:
2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

Line 2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

2856:
2857: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, start */
2858: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2859: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2861:
2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

Line 2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

2858: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2859: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2861:
2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2865:
2866: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);

Line 2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

2859: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2861:
2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2865:
2866: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2867: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

Line 2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;

2860: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2861:
2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2865:
2866: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2867: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2868: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

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

2862: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2865:
2866: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2867: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2868: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
2869:
2870: if ln_tax_rate_id is null then

Line 2867: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

2863: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2865:
2866: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2867: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2868: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
2869:
2870: if ln_tax_rate_id is null then
2871: raise Localization_tax_not_defined;

Line 2868: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;

2864: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur ;
2865:
2866: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code, ln_party_tax_profile_id);
2867: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
2868: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur ;
2869:
2870: if ln_tax_rate_id is null then
2871: raise Localization_tax_not_defined;
2872: end if;