687: OPEN ORG_CUR;
688: FETCH ORG_CUR INTO V_ORG_ID;
689: CLOSE ORG_CUR;
690:
691: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
692: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
694:
695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
688: FETCH ORG_CUR INTO V_ORG_ID;
689: CLOSE ORG_CUR;
690:
691: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
692: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
694:
695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
696: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
689: CLOSE ORG_CUR;
690:
691: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
692: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
694:
695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
696: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
697: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
691: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
692: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
694:
695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
696: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
697: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
698: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
699:
692: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
694:
695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
696: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
697: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
698: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
699:
700: IF v_books_id IS NULL THEN
693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
694:
695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
696: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
697: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
698: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
699:
700: IF v_books_id IS NULL THEN
701: /* Bug 5243532. Added by Lakshmi Gopalsami
1937: OPEN ORG_CUR;
1938: FETCH ORG_CUR INTO V_ORG_ID;
1939: CLOSE ORG_CUR;
1940:
1941: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1942: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1944:
1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1938: FETCH ORG_CUR INTO V_ORG_ID;
1939: CLOSE ORG_CUR;
1940:
1941: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1942: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1944:
1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1946: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1939: CLOSE ORG_CUR;
1940:
1941: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1942: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1944:
1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1946: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1947: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1941: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1942: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1944:
1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1946: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1947: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1948: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
1949:
1942: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1944:
1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1946: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1947: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1948: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
1949:
1950: OPEN SO_AR_HDR_INFO ;
1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1944:
1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1946: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1947: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1948: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
1949:
1950: OPEN SO_AR_HDR_INFO ;
1951: FETCH SO_AR_HDR_INFO INTO v_organization_id, v_location_id, v_batch_source_id;