APPS.IEX_WF_DEL_REQ_SERVICE_PUB dependencies on IEX_WRITEOFFS

Line 398: update IEX_WRITEOFFS

394: update IEX_LITIGATIONS
395: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
396: where litigation_id = l_litigation_id;
397: ELSIF l_del_type = 'Writeoff' THEN
398: update IEX_WRITEOFFS
399: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
400: where writeoff_id = l_writeoff_id;
401: ELSIF l_del_type = 'Bankruptcy' THEN
402: update IEX_BANKRUPTCIES

Line 492: update IEX_WRITEOFFS

488: itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'WRITEOFF_ID');
491:
492: update IEX_WRITEOFFS
493: set SERVICE_HOLD_APPROVED_FLAG = 'N'
494: where writeoff_id = l_writeoff_id;
495: ELSIF l_del_type = 'Bankruptcy' THEN
496: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

Line 554: update IEX_WRITEOFFS

550: update IEX_LITIGATIONS
551: set SERVICE_HOLD_APPROVED_FLAG = 'N'
552: where litigation_id = TO_NUMBER(substr(itemkey, 3));
553: ELSIF l_del_type = 'Writeoff' THEN
554: update IEX_WRITEOFFS
555: set SERVICE_HOLD_APPROVED_FLAG = 'N'
556: where writeoff_id = TO_NUMBER(substr(itemkey, 3));
557: ELSIF l_del_type = 'Bankruptcy' THEN
558: update IEX_BANKRUPTCIES