APPS.IEX_WF_DEL_REQ_SERVICE_PUB dependencies on IEX_REPOSSESSIONS

Line 390: update IEX_REPOSSESSIONS

386: update IEX_DELINQUENCIES_ALL
387: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
388: where delinquency_id = l_delinquency_id;
389: ELSIF l_del_type = 'Repossession' THEN
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

Line 474: update IEX_REPOSSESSIONS

470: itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'REPOSSESSION_ID');
473:
474: update IEX_REPOSSESSIONS
475: set SERVICE_HOLD_APPROVED_FLAG = 'N'
476: where repossession_id = l_repossession_id;
477: ELSIF l_del_type = 'Litigation' THEN
478: l_litigation_id := wf_engine.GetItemAttrNumber(

Line 546: update IEX_REPOSSESSIONS

542: update IEX_DELINQUENCIES_ALL
543: set SERVICE_HOLD_APPROVED_FLAG = 'N'
544: where delinquency_id = TO_NUMBER(substr(itemkey, 3));
545: ELSIF l_del_type = 'Repossession' THEN
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