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_AR_TRXS

Line 173: JAI_AR_TRXS jrct --bug#5194107

169: ra_customer_trx_all trx ,
170: ra_customer_trx_lines_all rctl ,
171: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175
172: -- ja_in_ra_customer_trx_lines jrctl
173: JAI_AR_TRXS jrct --bug#5194107
174: WHERE
175: trx.customer_trx_id = rctl.customer_trx_id
176: AND jrct.customer_trx_id = trx.customer_trx_id --5194107
177: AND rctl.line_type = 'LINE'

Line 196: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat

192: --added for bug#6685050,csahoo
193: CURSOR c_same_inv_no (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
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

Line 227: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_No%TYPE; --added for bug#6685050

223: ld_start_date DATE ;
224: ld_end_date DATE ;
225: --Commented below for bug#7621541
226: --ln_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%TYPE; --Added by Anujsax for bug#5636544
227: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_No%TYPE; --added for bug#6685050
228: lv_same_inv_no VARCHAR2(1); --added for bug#6685050
229: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
230:
231: --start additions for bug#5194107

Line 234: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;

230:
231: --start additions for bug#5194107
232: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;
233: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;
234: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;
235:
236: --add by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168#,begin
237: ----------------------------------------------------------------------------------------------------------------
238: lv_display_flag VARCHAR2(1);

Line 247: from jai_ar_trxs

243: ---------------------------------------------------------
244: cursor c_get_rec(cn_customer_trx_id number)
245: is
246: select *
247: from jai_ar_trxs
248: where customer_trx_id = cn_customer_trx_id;
249:
250: t_rec_new jai_ar_trxs%rowtype;
251: t_rec_old jai_ar_trxs%rowtype;

Line 250: t_rec_new jai_ar_trxs%rowtype;

246: select *
247: from jai_ar_trxs
248: where customer_trx_id = cn_customer_trx_id;
249:
250: t_rec_new jai_ar_trxs%rowtype;
251: t_rec_old jai_ar_trxs%rowtype;
252:
253: lv_action VARCHAR2(20);
254: lv_return_message VARCHAR2(2000);

Line 251: t_rec_old jai_ar_trxs%rowtype;

247: from jai_ar_trxs
248: where customer_trx_id = cn_customer_trx_id;
249:
250: t_rec_new jai_ar_trxs%rowtype;
251: t_rec_old jai_ar_trxs%rowtype;
252:
253: lv_action VARCHAR2(20);
254: lv_return_message VARCHAR2(2000);
255: lv_return_code VARCHAR2(100) ;

Line 341: UPDATE JAI_AR_TRXS

337:
338: ---------------------------------------------------------
339: --Added by Zhiwei for bug#14040855 JAI Trigger elimination end
340:
341: UPDATE JAI_AR_TRXS
342: SET vat_invoice_no = nvl( ln_vat_invoice_no ,vat_invoice_no ) ,
343: vat_invoice_date = nvl( ld_vat_invoice_date,vat_invoice_date ) ,
344: last_update_date = sysdate ,
345: last_updated_by = ln_last_updated_by ,

Line 361: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

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 ,
364: pv_action => lv_action ,
365: pv_return_code => lv_return_code ,

Line 699: FROM JAI_AR_TRXS

695:
696: -- get vat invoice number
697: CURSOR get_vat_invoice_cur IS
698: SELECT vat_invoice_no
699: FROM JAI_AR_TRXS
700: WHERE customer_trx_id = pn_customer_trx_id;
701: -- get excise invoice number
702: CURSOR get_exc_inv_no_cur IS
703: SELECT excise_invoice_no

Line 709: FROM JAI_AR_TRXS

705: WHERE customer_trx_id = pn_customer_trx_id;
706:
707: CURSOR get_st_invoice_cur IS
708: SELECT st_inv_number
709: FROM JAI_AR_TRXS
710: WHERE customer_trx_id = pn_customer_trx_id;
711: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
712:
713: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%Type;

Line 713: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%Type;

709: FROM JAI_AR_TRXS
710: WHERE customer_trx_id = pn_customer_trx_id;
711: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
712:
713: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%Type;
714: lv_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%type;
715: lv_st_invoice_num JAI_AR_TRXS.st_inv_number%Type;
716: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
717: lv_display_flag VARCHAR2(240);

Line 715: lv_st_invoice_num JAI_AR_TRXS.st_inv_number%Type;

711: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
712:
713: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%Type;
714: lv_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%type;
715: lv_st_invoice_num JAI_AR_TRXS.st_inv_number%Type;
716: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
717: lv_display_flag VARCHAR2(240);
718: lv_procedure_name VARCHAR2(40):='update_reference';
719: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;