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_TRX_PKG dependencies on JAI_CONSTANTS

Line 198: AND jror.attribute_type_code = jai_constants.regn_type_others

194: IS
195: SELECT jror.attribute_Value
196: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat
197: WHERE regime_code = 'VAT'
198: AND jror.attribute_type_code = jai_constants.regn_type_others
199: AND jror.attribute_code = jai_constants.attr_code_same_inv_no
200: AND jror.organization_id = jat.organization_id
201: AND jror.location_id = jat.location_id
202: AND jat.customer_trx_id = cp_customer_trx_id;

Line 199: AND jror.attribute_code = jai_constants.attr_code_same_inv_no

195: SELECT jror.attribute_Value
196: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat
197: WHERE regime_code = 'VAT'
198: AND jror.attribute_type_code = jai_constants.regn_type_others
199: AND jror.attribute_code = jai_constants.attr_code_same_inv_no
200: AND jror.organization_id = jat.organization_id
201: AND jror.location_id = jat.location_id
202: AND jat.customer_trx_id = cp_customer_trx_id;
203:

Line 359: lv_action := jai_constants.updating ;

355:
356:
357: if(t_rec_new.once_completed_flag = 'Y')then
358:
359: lv_action := jai_constants.updating ;
360:
361: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
362: pr_old => t_rec_old ,
363: pr_new => t_rec_new ,

Line 369: IF lv_return_code <> jai_constants.successful then

365: pv_return_code => lv_return_code ,
366: pv_return_message => lv_return_message
367: );
368:
369: IF lv_return_code <> jai_constants.successful then
370: RAISE le_error;
371: END IF;
372:
373: end if;