APPS.IEX_WF_DEL_REQ_SERVICE_PUB dependencies on IEX_LITIGATIONS

Line 394: update IEX_LITIGATIONS

390: update IEX_REPOSSESSIONS
391: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
392: where repossession_id = l_repossession_id;
393: ELSIF l_del_type = 'Litigation' THEN
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

Line 483: update IEX_LITIGATIONS

479: itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'LITIGATION_ID');
482:
483: update IEX_LITIGATIONS
484: set SERVICE_HOLD_APPROVED_FLAG = 'N'
485: where litigation_id = l_litigation_id;
486: ELSIF l_del_type = 'Writeoff' THEN
487: l_writeoff_id := wf_engine.GetItemAttrNumber(

Line 550: update IEX_LITIGATIONS

546: update IEX_REPOSSESSIONS
547: set SERVICE_HOLD_APPROVED_FLAG = 'N'
548: where repossession_id = TO_NUMBER(substr(itemkey, 3));
549: ELSIF l_del_type = 'Litigation' THEN
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