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

Line 434: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

430: OPEN ORG_CUR;
431: FETCH ORG_CUR INTO V_ORG_ID;
432: CLOSE ORG_CUR;
433:
434: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
435: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
437:
438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

Line 435: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

431: FETCH ORG_CUR INTO V_ORG_ID;
432: CLOSE ORG_CUR;
433:
434: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
435: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
437:
438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
439: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

Line 436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

432: CLOSE ORG_CUR;
433:
434: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
435: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
437:
438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
439: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
440: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

Line 438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

434: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
435: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
437:
438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
439: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
440: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
441: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
442:

Line 439: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

435: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
437:
438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
439: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
440: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
441: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
442:
443: IF v_books_id IS NULL THEN

Line 440: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

436: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
437:
438: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
439: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
440: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
441: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
442:
443: IF v_books_id IS NULL THEN
444: /* Bug 5243532. Added by Lakshmi Gopalsami

Line 1232: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

1228: OPEN ORG_CUR;
1229: FETCH ORG_CUR INTO V_ORG_ID;
1230: CLOSE ORG_CUR;
1231:
1232: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1233: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1235:
1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

Line 1233: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

1229: FETCH ORG_CUR INTO V_ORG_ID;
1230: CLOSE ORG_CUR;
1231:
1232: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1233: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1235:
1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1237: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

Line 1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

1230: CLOSE ORG_CUR;
1231:
1232: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1233: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1235:
1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1237: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1238: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

Line 1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

1232: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
1233: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1235:
1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1237: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1238: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1239: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
1240:

Line 1237: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

1233: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1235:
1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1237: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1238: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1239: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
1240:
1241: OPEN SO_AR_HDR_INFO ;

Line 1238: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

1234: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
1235:
1236: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
1237: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
1238: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
1239: /* Added by Ramananda for bug# due to ebtax uptake by AR, end */
1240:
1241: OPEN SO_AR_HDR_INFO ;
1242: FETCH SO_AR_HDR_INFO INTO v_organization_id, v_location_id, v_batch_source_id;