DBA Data[Home] [Help]

APPS.IEX_WF_DEL_STATUS_PUB dependencies on IEX_WRITEOFFS

Line 182: update IEX_WRITEOFFS

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

Line 235: update IEX_WRITEOFFS

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