DBA Data[Home] [Help]

APPS.AR_TRANSFER_DOCUMENT dependencies on RA_CUSTOMER_TRX

Line 6: select 'x' from ra_customer_trx where customer_trx_id = p_doc_rec.source_id;

2: /*$Header: ARTRSDCB.pls 115.7 2002/12/23 22:45:11 tkoshio noship $ */
3:
4: function validateSource(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is
5: cursor trx is
6: select 'x' from ra_customer_trx where customer_trx_id = p_doc_rec.source_id;
7: l_exists varchar2(1);
8: l_retcode boolean := false;
9: begin
10: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateSource(+)'); end if;

Line 11: if p_doc_rec.source_table = 'RA_CUSTOMER_TRX' then

7: l_exists varchar2(1);
8: l_retcode boolean := false;
9: begin
10: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateSource(+)'); end if;
11: if p_doc_rec.source_table = 'RA_CUSTOMER_TRX' then
12: open trx; fetch trx into l_exists; close trx;
13: if l_exists is null then l_retcode := false;
14: else l_retcode := true; end if;
15: else