DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_AR_TRX_PKG

Line 394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

390: FETCH ORG_CUR
391: INTO V_ORG_ID;
392: CLOSE ORG_CUR;
393:
394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:

Line 395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur

391: INTO V_ORG_ID;
392: CLOSE ORG_CUR;
393:
394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

Line 397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;

393:
394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;

Line 399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
403:

Line 400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur

396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
403:
404: IF v_books_id IS NULL THEN

Line 402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;

398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
403:
404: IF v_books_id IS NULL THEN
405: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id);
406: v_books_id := l_func_curr_det.ledger_id;