188: set SUGGESTION_APPROVED_FLAG = 'Y',
189: REPOSSESSION_DATE = sysdate
190: where REPOSSESSION_ID = to_number(substr(itemkey, 2));
191: ELSIF to_number(substr(itemkey, 0, 2)) = 'LIT' THEN
192: update IEX_LITIGATIONS
193: set SUGGESTION_APPROVED_FLAG = 'Y'
194: where LITIGATION_ID = to_number(substr(itemkey, 2));
195: END IF;
196:
241: set SUGGESTION_APPROVED_FLAG = 'N',
242: REPOSSESSION_DATE = sysdate
243: where REPOSSESSION_ID = to_number(substr(itemkey, 2));
244: ELSIF to_number(substr(itemkey, 0, 2)) = 'LIT' THEN
245: update IEX_LITIGATIONS
246: set SUGGESTION_APPROVED_FLAG = 'N'
247: where LITIGATION_ID = to_number(substr(itemkey, 2));
248: END IF;
249: