APPS.JAI_AR_TRX_PKG dependencies on JAI_AR_TRXS

Line 114: JAI_AR_TRXS jrct --bug#5194107

110: ra_customer_trx_all trx ,
111: ra_customer_trx_lines_all rctl ,
112: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175
113: -- ja_in_ra_customer_trx_lines jrctl
114: JAI_AR_TRXS jrct --bug#5194107
115: WHERE
116: trx.customer_trx_id = rctl.customer_trx_id
117: AND jrct.customer_trx_id = trx.customer_trx_id --5194107
118: AND rctl.line_type = 'LINE'

Line 130: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat

126: --added for bug#6685050,csahoo
127: CURSOR c_same_inv_no (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
128: IS
129: SELECT jror.attribute_Value
130: FROM JAI_RGM_ORG_REGNS_V jror, jai_ar_trxs jat
131: WHERE regime_code = 'VAT'
132: AND jror.attribute_type_code = jai_constants.regn_type_others
133: AND jror.attribute_code = jai_constants.attr_code_same_inv_no
134: AND jror.organization_id = jat.organization_id

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

154: ld_start_date DATE ;
155: ld_end_date DATE ;
156: --Commented below for bug#7621541
157: --ln_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%TYPE; --Added by Anujsax for bug#5636544
158: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_No%TYPE; --added for bug#6685050
159: lv_same_inv_no VARCHAR2(1); --added for bug#6685050
160: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
161:
162: --start additions for bug#5194107

Line 165: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;

161:
162: --start additions for bug#5194107
163: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;
164: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;
165: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;
166:
167: BEGIN
168: /*
169: || start of 5369250

Line 227: UPDATE JAI_AR_TRXS

223: fnd_file.put_line(FND_FILE.LOG,' VAT invoice No -> '||ln_vat_invoice_no
224: || ', VAT inv date -> ' ||ld_vat_invoice_date
225: ||' for customer_trx_id -> '||delivery_rec.customer_trx_id );
226:
227: UPDATE JAI_AR_TRXS
228: SET vat_invoice_no = nvl( ln_vat_invoice_no ,vat_invoice_no ) ,
229: vat_invoice_date = nvl( ld_vat_invoice_date,vat_invoice_date ) ,
230: last_update_date = sysdate ,
231: last_updated_by = ln_last_updated_by ,