[Home] [Help]
106: rctl.customer_trx_line_id ,
107: rctl.interface_line_attribute3 ,
108: rctl.interface_line_attribute6
109: FROM
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
123: AND rctl.customer_trx_line_id = jrctl.customer_trx_line_id
124: AND ( jrctl.excise_invoice_no IS NULL OR jrct.vat_invoice_no IS NULL ) ;--bug#5194107
125:
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'
270: errbuf := sqlerrm;
271: end update_excise_invoice_no;
272:
273: procedure validate_invoice ( p_customer_trx_id IN RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE ,
274: p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE , /* should not be used in a where clause as this is not unique */
275: p_error_flag OUT NOCOPY VARCHAR2 ,
276: p_error_message OUT NOCOPY VARCHAR2
277: )
278:
314: lv_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE ;
315:
316: CURSOR ORG_CUR IS
317: SELECT ORG_ID
318: FROM RA_CUSTOMER_TRX_ALL
319: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
320: /*
321: || Modified by Ramananda for bug#4468353
322: || Check whether any other taxes other than localizations taxes exist.
373: SELECT
374: 1
375: FROM
376: ra_cust_trx_line_gl_dist_all gl_dist,
377: ra_customer_trx_all rctx
378: WHERE
379: rctx.customer_trx_id = gl_dist.customer_trx_id AND
380: rctx.invoicing_rule_id IS NOT NULL AND
381: gl_dist.account_class = p_acc_class AND