DBA Data[Home] [Help]

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_AR_TRX_PKG

Line 691: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

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);

Line 692: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO 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;

Line 693: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

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 ;

Line 695: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

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:

Line 696: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_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:
700: IF v_books_id IS NULL THEN

Line 697: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

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

Line 1941: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

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);

Line 1942: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO 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;

Line 1943: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

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 ;

Line 1945: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

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:

Line 1946: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_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:
1950: OPEN SO_AR_HDR_INFO ;

Line 1947: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

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;