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

Line 2641: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

2637: || Assigned the value of pr_new.org_id to v_org and instead removed the cursor org_cur which was picking org_id from ra_customer_trx_all
2638: || and causing mutation issue
2639: */
2640: v_org_id := pr_new.org_id;
2641: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2642: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2644:
2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

Line 2642: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

2638: || and causing mutation issue
2639: */
2640: v_org_id := pr_new.org_id;
2641: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2642: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2644:
2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
2646: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

Line 2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

2639: */
2640: v_org_id := pr_new.org_id;
2641: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2642: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2644:
2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
2646: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
2647: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

Line 2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

2641: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
2642: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2644:
2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
2646: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
2647: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
2648:
2649:

Line 2646: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

2642: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2644:
2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
2646: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
2647: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
2648:
2649:
2650: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,

Line 2647: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

2643: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
2644:
2645: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
2646: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
2647: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
2648:
2649:
2650: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,
2651: c_conversion_date ,c_conversion_type, c_conversion_rate);