[Home] [Help]
165: rctl.customer_trx_line_id ,
166: rctl.interface_line_attribute3 ,
167: rctl.interface_line_attribute6
168: FROM
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
189: -----------------------------------------------------------------------------------------------
190: --Added and mofidied by Bo Li for bug#9710105 on 05-JUL-2010 End
191:
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'
417: errbuf := sqlerrm;
418: end update_excise_invoice_no;
419:
420: procedure validate_invoice ( p_customer_trx_id IN RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE ,
421: p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE , /* should not be used in a where clause as this is not unique */
422: p_error_flag OUT NOCOPY VARCHAR2 ,
423: p_error_message OUT NOCOPY VARCHAR2
424: )
425:
461: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;
462:
463: CURSOR ORG_CUR IS
464: SELECT ORG_ID
465: FROM RA_CUSTOMER_TRX_ALL
466: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
467: /*
468: || Modified by Ramananda for bug#4468353
469: || Check whether any other taxes other than localizations taxes exist.
520: SELECT
521: 1
522: FROM
523: ra_cust_trx_line_gl_dist_all gl_dist,
524: ra_customer_trx_all rctx
525: WHERE
526: rctx.customer_trx_id = gl_dist.customer_trx_id AND
527: rctx.invoicing_rule_id IS NOT NULL AND
528: gl_dist.account_class = p_acc_class AND