APPS.JAI_AR_TRX_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

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

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

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

367:
368: /*
369: ||Check whether the Revenue Recognition Program has been already run for an invoice with rules
370: */
371: CURSOR cur_revrec_run( p_acc_class ra_cust_trx_line_gl_dist_all.account_class%TYPE )
372: IS
373: SELECT
374: 1
375: FROM

Line 376: ra_cust_trx_line_gl_dist_all gl_dist,

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

Line 394: ra_cust_trx_line_gl_dist_all

390: IS
391: SELECT
392: 1
393: FROM
394: ra_cust_trx_line_gl_dist_all
395: WHERE
396: customer_trx_id = p_customer_trx_id AND
397: account_set_flag = 'N' AND
398: posting_control_id <> -3 AND