25: in_trans_req_id IN VARCHAR2,
26: out_insert_records OUT NOCOPY VARCHAR2) IS
27: BEGIN
28: IF PG_DEBUG in ('Y', 'C') THEN
29: arp_util.debug('arp_lockbox_hook.proc_before_validation()+');
30: END IF;
31: out_errorcode := 0;
32: out_errorbuf := NULL;
33: out_insert_records := 'Y';
31: out_errorcode := 0;
32: out_errorbuf := NULL;
33: out_insert_records := 'Y';
34: IF PG_DEBUG in ('Y', 'C') THEN
35: arp_util.debug('arp_lockbox_hook.proc_before_validation()-');
36: END IF;
37: END proc_before_validation;
38: --
39: /*----------------------------------------------------------------------------
64: out_insert_records OUT NOCOPY VARCHAR2) IS
65: --
66: BEGIN
67: IF PG_DEBUG in ('Y', 'C') THEN
68: arp_util.debug('arp_lockbox_hook.proc_after_validation()+');
69: END IF;
70: out_errorcode := 9;
71: out_errorbuf := NULL;
72: out_insert_records := 'N';
70: out_errorcode := 9;
71: out_errorbuf := NULL;
72: out_insert_records := 'N';
73: IF PG_DEBUG in ('Y', 'C') THEN
74: arp_util.debug('arp_lockbox_hook.proc_after_validation()-');
75: END IF;
76: END proc_after_validation;
77: --
78: /*----------------------------------------------------------------------------
92: out_errorcode OUT NOCOPY VARCHAR2,
93: in_trans_req_id IN VARCHAR2) IS
94: BEGIN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_util.debug('arp_lockbox_hook.proc_after_second_validation()+');
97: END IF;
98: out_errorcode := 0;
99: out_errorbuf := NULL;
100: IF PG_DEBUG in ('Y', 'C') THEN
97: END IF;
98: out_errorcode := 0;
99: out_errorbuf := NULL;
100: IF PG_DEBUG in ('Y', 'C') THEN
101: arp_util.debug('arp_lockbox_hook.proc_after_second_validation()-');
102: END IF;
103: END proc_after_second_validation;
104: --
105: /*----------------------------------------------------------------------------
199: PROCEDURE CURSOR_FOR_MATCHING_RULE(p_matching_option IN VARCHAR2,
200: p_cursor_string OUT NOCOPY VARCHAR2) IS
201: BEGIN
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
204: END IF;
205: p_cursor_string := 'select -9999, NULL, NULL from dual';
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
203: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
204: END IF;
205: p_cursor_string := 'select -9999, NULL, NULL from dual';
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
208: END IF;
209: RETURN;
210: END cursor_for_matching_rule;
211: --
344: ********************PSEUDO CODE***********************************************/
345:
346: BEGIN
347: IF PG_DEBUG in ('Y', 'C') THEN
348: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()+');
349: END IF;
350:
351: /***********************PSEUDO CODE*****************************************
352: Loop till last record in p_unresolved_inv_array
365:
366: End Loop.
367: ************************PSEUDO CODE****************************************/
368: IF PG_DEBUG in ('Y', 'C') THEN
369: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()-');
370: END IF;
371: RETURN;
372: END cursor_for_custom_llca;
373: --