APPS.JAI_AR_TRX_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 420: procedure validate_invoice ( p_customer_trx_id IN RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE ,

416: retcode :='2';
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: )

Line 518: CURSOR cur_revrec_run( p_acc_class ra_cust_trx_line_gl_dist_all.account_class%TYPE )

514:
515: /*
516: ||Check whether the Revenue Recognition Program has been already run for an invoice with rules
517: */
518: CURSOR cur_revrec_run( p_acc_class ra_cust_trx_line_gl_dist_all.account_class%TYPE )
519: IS
520: SELECT
521: 1
522: FROM

Line 523: ra_cust_trx_line_gl_dist_all gl_dist,

519: IS
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

Line 541: ra_cust_trx_line_gl_dist_all

537: IS
538: SELECT
539: 1
540: FROM
541: ra_cust_trx_line_gl_dist_all
542: WHERE
543: customer_trx_id = p_customer_trx_id AND
544: account_set_flag = 'N' AND
545: posting_control_id <> -3 AND