APPS.ARP_TRX_UTIL dependencies on RA_CUSTOMER_TRX

Line 368: ra_customer_trx.customer_trx_id%type )

364: +===========================================================================*/
365:
366:
367: FUNCTION detect_freight_only_rules_case( p_customer_trx_id IN
368: ra_customer_trx.customer_trx_id%type )
369: RETURN BOOLEAN IS
370:
371: l_result varchar2(2);
372:

Line 381: FROM ra_customer_trx t,

377: SELECT DECODE( MAX(t.customer_trx_id),
378: NULL, 'N',
379: 'Y')
380: INTO l_result
381: FROM ra_customer_trx t,
382: ra_customer_trx_lines l,
383: ra_customeR_trx_lines frt
384: WHERE t.customer_trx_id = p_customer_trx_id
385: AND t.customer_trx_id = frt.customer_trx_id

Line 382: ra_customer_trx_lines l,

378: NULL, 'N',
379: 'Y')
380: INTO l_result
381: FROM ra_customer_trx t,
382: ra_customer_trx_lines l,
383: ra_customeR_trx_lines frt
384: WHERE t.customer_trx_id = p_customer_trx_id
385: AND t.customer_trx_id = frt.customer_trx_id
386: AND frt.line_type = 'FREIGHT'

Line 383: ra_customeR_trx_lines frt

379: 'Y')
380: INTO l_result
381: FROM ra_customer_trx t,
382: ra_customer_trx_lines l,
383: ra_customeR_trx_lines frt
384: WHERE t.customer_trx_id = p_customer_trx_id
385: AND t.customer_trx_id = frt.customer_trx_id
386: AND frt.line_type = 'FREIGHT'
387: AND frt.link_to_cust_trx_line_id IS NULL

Line 453: ra_customer_trx.customer_trx_id%type,

449:
450:
451: PROCEDURE transaction_balances(
452: p_customer_trx_id IN
453: ra_customer_trx.customer_trx_id%type,
454: p_open_receivables_flag IN
455: ra_cust_trx_types.accounting_affect_flag%type,
456: p_exchange_rate IN
457: ra_customer_trx.exchange_rate%type,

Line 457: ra_customer_trx.exchange_rate%type,

453: ra_customer_trx.customer_trx_id%type,
454: p_open_receivables_flag IN
455: ra_cust_trx_types.accounting_affect_flag%type,
456: p_exchange_rate IN
457: ra_customer_trx.exchange_rate%type,
458: p_mode IN VARCHAR2,
459: p_currency_mode IN VARCHAR2,
460: p_line_original OUT NOCOPY NUMBER,
461: p_line_remaining OUT NOCOPY NUMBER,

Line 660: ra_customer_trx.customer_trx_id%type,

656: +===========================================================================*/
657:
658:
659: PROCEDURE get_summary_trx_balances( p_customer_trx_id IN
660: ra_customer_trx.customer_trx_id%type,
661: p_open_receivables_flag IN
662: ra_cust_trx_types.accounting_affect_flag%type,
663: p_line_original OUT NOCOPY NUMBER,
664: p_line_remaining OUT NOCOPY NUMBER,