178:
179: l_writeoff_id := to_number(substr(itemkey, 2));
180:
181: IF to_number(substr(itemkey, 0, 2)) = 'WRI' THEN
182: update IEX_WRITEOFFS
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
231:
232: l_writeoff_id := to_number(substr(itemkey, 2));
233:
234: IF to_number(substr(itemkey, 0, 2)) = 'WRI' THEN
235: update IEX_WRITEOFFS
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