The following lines contain the word 'select', 'insert', 'update' or 'delete':
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'.
----------------------------------------------------------------------------*/
PROCEDURE proc_before_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
arp_util.debug('arp_lockbox_hook.proc_before_validation()+');
out_insert_records := 'N';
out_insert_records := 'N';
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
p_api_version NUMBER := 1;
out_insert_records := 'Y';
out_insert_records := 'Y';
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 ';
p_cursor_string := 'select -9999, NULL, NULL from dual';