265: v_req_id NUMBER;
266:
267: BEGIN
268:
269: IF (g_asn_debug = 'Y') THEN
270: asn_debug.put_line('Enter RCV_ROI_INTERFACE_PKG.RESUBMIT');
271: END IF;
272:
273: WHILE (l_index <= p_count) LOOP
266:
267: BEGIN
268:
269: IF (g_asn_debug = 'Y') THEN
270: asn_debug.put_line('Enter RCV_ROI_INTERFACE_PKG.RESUBMIT');
271: END IF;
272:
273: WHILE (l_index <= p_count) LOOP
274: ---update data record in same group and its parent if not processed
307: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
308: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
309: NULL, NULL, NULL, NULL, NULL, NULL, NULL);
310: ELSE
311: IF (g_asn_debug = 'Y') THEN
312: asn_debug.put_line('Unexpected exception in update rhi/rti : ' ||
313: SQLERRM);
314: END IF;
315: END IF;
308: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
309: NULL, NULL, NULL, NULL, NULL, NULL, NULL);
310: ELSE
311: IF (g_asn_debug = 'Y') THEN
312: asn_debug.put_line('Unexpected exception in update rhi/rti : ' ||
313: SQLERRM);
314: END IF;
315: END IF;
316: END IF;
319: END LOOP;
320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: IF (g_asn_debug = 'Y') THEN
324: asn_debug.put_line('Unexpected exception in RESUBMIT : ' ||
325: SQLERRM);
326: END IF;
327: END resubmit;
320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: IF (g_asn_debug = 'Y') THEN
324: asn_debug.put_line('Unexpected exception in RESUBMIT : ' ||
325: SQLERRM);
326: END IF;
327: END resubmit;
328: --ROI project end