APPS.ARP_LOCKBOX_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

   If out_insert_records is returned as 'Y', the first validation will
     insert the records into ar_interim_cash_receipt and receipt_line.
     In non-custom mode, this parameter returns 'Y', because we do not call
     validation second time. However, if you are planning to call the second
     validation, for customising lockbox,  assign this variable as 'N'.

 ----------------------------------------------------------------------------*/
PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line: 26

                                 out_insert_records OUT NOCOPY VARCHAR2) IS
BEGIN
  IF PG_DEBUG in ('Y', 'C') THEN
     arp_util.debug('arp_lockbox_hook.proc_before_validation()+');

Line: 33

  out_insert_records := 'Y';

Line: 52

   If out_insert_records is returned as 'Y', the second validation will
     insert the records into ar_interim_cash_receipt and receipt_line.
     In non-custom mode, this parameter returns 'N', because we do not call
     validation second time. However, if you are planning to call the second
     validation and you have returned out_insert_records as 'N' in the
     proc_before_validation, you should return 'Y' here. This parameter is
     considered only if the out_errorcode was returned as 0.

 ----------------------------------------------------------------------------*/
PROCEDURE proc_after_validation(out_errorbuf OUT NOCOPY VARCHAR2,
                                 out_errorcode OUT NOCOPY VARCHAR2,
                                 in_trans_req_id IN VARCHAR2,
                                 out_insert_records OUT NOCOPY VARCHAR2) IS
--
BEGIN
  IF PG_DEBUG in ('Y', 'C') THEN
     arp_util.debug('arp_lockbox_hook.proc_after_validation()+');

Line: 72

  out_insert_records := 'N';

Line: 178

p_cursor_string := 'select ct.customer_id, ct.trx_number, ct.trx_date ' ||
                   'from custom_table ct ' ||
                   'where ct.matching_number = :b_current_matching_number ' ||
                   ' and  ct.matching_date = :b_current_matching_date ';

Line: 205

    p_cursor_string := 'select -9999, NULL, NULL from dual';