APPS.IEX_WF_DEL_REQ_SERVICE_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 386: update IEX_DELINQUENCIES_ALL

382: aname => 'BANKRUPTCY_ID');
383:
384:
385: IF l_del_type = 'Delinquency' THEN
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

Line 465: update IEX_DELINQUENCIES_ALL

461: itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'DELINQUENCY_ID');
464:
465: update IEX_DELINQUENCIES_ALL
466: set SERVICE_HOLD_APPROVED_FLAG = 'N'
467: where delinquency_id = l_delinquency_id;
468: ELSIF l_del_type = 'Repossession' THEN
469: l_repossession_id := wf_engine.GetItemAttrNumber(

Line 542: update IEX_DELINQUENCIES_ALL

538:
539: BEGIN
540:
541: IF l_del_type = 'Delinquency' THEN
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