183: set SUGGESTION_APPROVED_FLAG = 'Y',
184: WRITEOFF_DATE = sysdate
185: where WRITEOFF_ID = to_number(substr(itemkey, 2));
186: ELSIF to_number(substr(itemkey, 0, 2)) = 'REP' THEN
187: update IEX_REPOSSESSIONS
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
236: set SUGGESTION_APPROVED_FLAG = 'N',
237: WRITEOFF_DATE = sysdate
238: where WRITEOFF_ID = to_number(substr(itemkey, 2));
239: ELSIF to_number(substr(itemkey, 0, 2)) = 'REP' THEN
240: update IEX_REPOSSESSIONS
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