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 3071: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

3067: || 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
3068: || and causing mutation issue
3069: */
3070: v_org_id := pr_new.org_id;
3071: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3072: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3074:
3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

Line 3072: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

3068: || and causing mutation issue
3069: */
3070: v_org_id := pr_new.org_id;
3071: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3072: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3074:
3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
3076: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

Line 3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;

3069: */
3070: v_org_id := pr_new.org_id;
3071: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3072: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3074:
3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
3076: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
3077: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

Line 3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

3071: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
3072: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3074:
3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
3076: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
3077: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
3078:
3079:

Line 3076: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;

3072: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3074:
3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
3076: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
3077: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
3078:
3079:
3080: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,

Line 3077: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;

3073: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur ;
3074:
3075: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
3076: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur INTO ln_tax_rate_id;
3077: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur ;
3078:
3079:
3080: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,
3081: c_conversion_date ,c_conversion_type, c_conversion_rate);