eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_WF_DEL_REQ_SERVICE_PUB dependencies on WF_ENGINE

Line 93: wf_engine.createprocess ( itemtype => itemtype,

89:
90: itemkey := 'DEL'||to_char(p_delinquency_id)||to_char(l_sequence);
91: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
92:
93: wf_engine.createprocess ( itemtype => itemtype,
94: itemkey => itemkey,
95: process => 'SERVICE_HOLD');
96:
97: wf_engine.setitemattrtext( itemtype => itemtype,

Line 97: wf_engine.setitemattrtext( itemtype => itemtype,

93: wf_engine.createprocess ( itemtype => itemtype,
94: itemkey => itemkey,
95: process => 'SERVICE_HOLD');
96:
97: wf_engine.setitemattrtext( itemtype => itemtype,
98: itemkey => itemkey,
99: aname => 'DEL_TYPE',
100: avalue => 'Delinquency');
101:

Line 102: wf_engine.setitemattrtext( itemtype => itemtype,

98: itemkey => itemkey,
99: aname => 'DEL_TYPE',
100: avalue => 'Delinquency');
101:
102: wf_engine.setitemattrtext( itemtype => itemtype,
103: itemkey => itemkey,
104: aname => 'DELINQUENCY_ID',
105: avalue => p_delinquency_id);
106:

Line 107: wf_engine.setitemattrtext( itemtype => itemtype,

103: itemkey => itemkey,
104: aname => 'DELINQUENCY_ID',
105: avalue => p_delinquency_id);
106:
107: wf_engine.setitemattrtext( itemtype => itemtype,
108: itemkey => itemkey,
109: aname => 'UNIQUE_ID',
110: avalue => 'Delinquency Id: '||p_delinquency_id);
111:

Line 117: wf_engine.createprocess ( itemtype => itemtype,

113:
114: itemkey := 'REP'||to_char(p_repossession_id)||to_char(l_sequence);
115: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
116:
117: wf_engine.createprocess ( itemtype => itemtype,
118: itemkey => itemkey,
119: process => 'SERVICE_HOLD');
120:
121: wf_engine.setitemattrtext( itemtype => itemtype,

Line 121: wf_engine.setitemattrtext( itemtype => itemtype,

117: wf_engine.createprocess ( itemtype => itemtype,
118: itemkey => itemkey,
119: process => 'SERVICE_HOLD');
120:
121: wf_engine.setitemattrtext( itemtype => itemtype,
122: itemkey => itemkey,
123: aname => 'DEL_TYPE',
124: avalue => 'Repossession');
125: --DBMS_OUTPUT.PUT_LINE('*');

Line 127: wf_engine.setitemattrtext( itemtype => itemtype,

123: aname => 'DEL_TYPE',
124: avalue => 'Repossession');
125: --DBMS_OUTPUT.PUT_LINE('*');
126:
127: wf_engine.setitemattrtext( itemtype => itemtype,
128: itemkey => itemkey,
129: aname => 'REPOSSESSION_ID',
130: avalue => p_repossession_id);
131: --DBMS_OUTPUT.PUT_LINE('**');

Line 133: wf_engine.setitemattrtext( itemtype => itemtype,

129: aname => 'REPOSSESSION_ID',
130: avalue => p_repossession_id);
131: --DBMS_OUTPUT.PUT_LINE('**');
132:
133: wf_engine.setitemattrtext( itemtype => itemtype,
134: itemkey => itemkey,
135: aname => 'UNIQUE_ID',
136: avalue => 'Reposession Id: '||p_repossession_id);
137: --DBMS_OUTPUT.PUT_LINE('***');

Line 144: wf_engine.createprocess ( itemtype => itemtype,

140:
141: itemkey := 'LIT'||to_char(p_litigation_id)||to_char(l_sequence);
142: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
143:
144: wf_engine.createprocess ( itemtype => itemtype,
145: itemkey => itemkey,
146: process => 'SERVICE_HOLD');
147:
148: wf_engine.setitemattrtext( itemtype => itemtype,

Line 148: wf_engine.setitemattrtext( itemtype => itemtype,

144: wf_engine.createprocess ( itemtype => itemtype,
145: itemkey => itemkey,
146: process => 'SERVICE_HOLD');
147:
148: wf_engine.setitemattrtext( itemtype => itemtype,
149: itemkey => itemkey,
150: aname => 'DEL_TYPE',
151: avalue => 'Litigation');
152:

Line 153: wf_engine.setitemattrtext( itemtype => itemtype,

149: itemkey => itemkey,
150: aname => 'DEL_TYPE',
151: avalue => 'Litigation');
152:
153: wf_engine.setitemattrtext( itemtype => itemtype,
154: itemkey => itemkey,
155: aname => 'LITIGATION_ID',
156: avalue => p_litigation_id);
157:

Line 158: wf_engine.setitemattrtext( itemtype => itemtype,

154: itemkey => itemkey,
155: aname => 'LITIGATION_ID',
156: avalue => p_litigation_id);
157:
158: wf_engine.setitemattrtext( itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'UNIQUE_ID',
161: avalue => 'Litigation Id: '||p_litigation_id);
162:

Line 168: wf_engine.createprocess ( itemtype => itemtype,

164:
165: itemkey := 'WRI'||to_char(p_writeoff_id)||to_char(l_sequence);
166: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
167:
168: wf_engine.createprocess ( itemtype => itemtype,
169: itemkey => itemkey,
170: process => 'SERVICE_HOLD');
171:
172: wf_engine.setitemattrtext( itemtype => itemtype,

Line 172: wf_engine.setitemattrtext( itemtype => itemtype,

168: wf_engine.createprocess ( itemtype => itemtype,
169: itemkey => itemkey,
170: process => 'SERVICE_HOLD');
171:
172: wf_engine.setitemattrtext( itemtype => itemtype,
173: itemkey => itemkey,
174: aname => 'DEL_TYPE',
175: avalue => 'Writeoff');
176:

Line 177: wf_engine.setitemattrtext( itemtype => itemtype,

173: itemkey => itemkey,
174: aname => 'DEL_TYPE',
175: avalue => 'Writeoff');
176:
177: wf_engine.setitemattrtext( itemtype => itemtype,
178: itemkey => itemkey,
179: aname => 'WRITEOFF_ID',
180: avalue => p_writeoff_id);
181:

Line 182: wf_engine.setitemattrtext( itemtype => itemtype,

178: itemkey => itemkey,
179: aname => 'WRITEOFF_ID',
180: avalue => p_writeoff_id);
181:
182: wf_engine.setitemattrtext( itemtype => itemtype,
183: itemkey => itemkey,
184: aname => 'UNIQUE_ID',
185: avalue => 'Writeoff Id: '||p_writeoff_id);
186:

Line 191: wf_engine.createprocess ( itemtype => itemtype,

187: ELSIF p_del_type = 'Bankruptcy' THEN
188:
189: itemkey := 'Ban'||to_char(p_writeoff_id)||to_char(l_sequence);
190:
191: wf_engine.createprocess ( itemtype => itemtype,
192: itemkey => itemkey,
193: process => 'SERVICE_HOLD');
194:
195: wf_engine.setitemattrtext( itemtype => itemtype,

Line 195: wf_engine.setitemattrtext( itemtype => itemtype,

191: wf_engine.createprocess ( itemtype => itemtype,
192: itemkey => itemkey,
193: process => 'SERVICE_HOLD');
194:
195: wf_engine.setitemattrtext( itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'DEL_TYPE',
198: avalue => 'Bankrupt');
199:

Line 200: wf_engine.setitemattrtext( itemtype => itemtype,

196: itemkey => itemkey,
197: aname => 'DEL_TYPE',
198: avalue => 'Bankrupt');
199:
200: wf_engine.setitemattrtext( itemtype => itemtype,
201: itemkey => itemkey,
202: aname => 'BANKRUPTCY_ID',
203: avalue => p_bankruptcy_id);
204:

Line 205: wf_engine.setitemattrtext( itemtype => itemtype,

201: itemkey => itemkey,
202: aname => 'BANKRUPTCY_ID',
203: avalue => p_bankruptcy_id);
204:
205: wf_engine.setitemattrtext( itemtype => itemtype,
206: itemkey => itemkey,
207: aname => 'UNIQUE_ID',
208: avalue => 'Bankruptcy Id: '||p_writeoff_id);
209:

Line 236: wf_engine.setitemattrnumber( itemtype => itemtype,

232: IEX_DEBUG_PUB.LogMessage('start_workflow: ' || 'Get manager for Request Service Workflow =>'||
233: l_manager_id);
234: END IF;
235:
236: wf_engine.setitemattrnumber( itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'DELINQUENCY_ID',
239: avalue => p_delinquency_id);
240:

Line 241: wf_engine.setitemattrnumber( itemtype => itemtype,

237: itemkey => itemkey,
238: aname => 'DELINQUENCY_ID',
239: avalue => p_delinquency_id);
240:
241: wf_engine.setitemattrnumber( itemtype => itemtype,
242: itemkey => itemkey,
243: aname => 'MANAGER_ID',
244: avalue => l_manager_id);
245:

Line 246: wf_engine.setitemattrtext( itemtype => itemtype,

242: itemkey => itemkey,
243: aname => 'MANAGER_ID',
244: avalue => l_manager_id);
245:
246: wf_engine.setitemattrtext( itemtype => itemtype,
247: itemkey => itemkey,
248: aname => 'MANAGER_NAME',
249: avalue => l_manager_name);
250:

Line 251: wf_engine.setitemattrtext( itemtype => itemtype,

247: itemkey => itemkey,
248: aname => 'MANAGER_NAME',
249: avalue => l_manager_name);
250:
251: wf_engine.setitemattrtext( itemtype => itemtype,
252: itemkey => itemkey,
253: aname => 'REQUESTER_NAME',
254: avalue => l_user_name);
255:

Line 256: wf_engine.setitemattrtext( itemtype => itemtype,

252: itemkey => itemkey,
253: aname => 'REQUESTER_NAME',
254: avalue => l_user_name);
255:
256: wf_engine.setitemattrtext( itemtype => itemtype,
257: itemkey => itemkey,
258: aname => 'REQUESTER_ID',
259: avalue => p_user_id);
260:

Line 261: wf_engine.startprocess( itemtype => itemtype,

257: itemkey => itemkey,
258: aname => 'REQUESTER_ID',
259: avalue => p_user_id);
260:
261: wf_engine.startprocess( itemtype => itemtype,
262: itemkey => itemkey);
263:
264: wf_engine.ItemStatus( itemtype => ItemType,
265: itemkey => ItemKey,

Line 264: wf_engine.ItemStatus( itemtype => ItemType,

260:
261: wf_engine.startprocess( itemtype => itemtype,
262: itemkey => itemkey);
263:
264: wf_engine.ItemStatus( itemtype => ItemType,
265: itemkey => ItemKey,
266: status => l_return_status,
267: result => l_result);
268:

Line 345: result := wf_engine.eng_null;

341:
342: BEGIN
343:
344: if funcmode <> 'RUN' then
345: result := wf_engine.eng_null;
346: return;
347: end if;
348:
349: l_manager_name := wf_engine.GetItemAttrText(

Line 349: l_manager_name := wf_engine.GetItemAttrText(

345: result := wf_engine.eng_null;
346: return;
347: end if;
348:
349: l_manager_name := wf_engine.GetItemAttrText(
350: itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'MANAGER_NAME');
353:

Line 354: l_delinquency_id := wf_engine.GetItemAttrNumber(

350: itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'MANAGER_NAME');
353:
354: l_delinquency_id := wf_engine.GetItemAttrNumber(
355: itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'DELINQUENCY_ID');
358:

Line 359: l_del_type := wf_engine.GetItemAttrText(

355: itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'DELINQUENCY_ID');
358:
359: l_del_type := wf_engine.GetItemAttrText(
360: itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'DEL_TYPE');
363:

Line 364: l_repossession_id := wf_engine.GetItemAttrNumber(

360: itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'DEL_TYPE');
363:
364: l_repossession_id := wf_engine.GetItemAttrNumber(
365: itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'REPOSSESSION_ID');
368:

Line 369: l_litigation_id := wf_engine.GetItemAttrNumber(

365: itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'REPOSSESSION_ID');
368:
369: l_litigation_id := wf_engine.GetItemAttrNumber(
370: itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'LITIGATION_ID');
373:

Line 374: l_writeoff_id := wf_engine.GetItemAttrNumber(

370: itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'LITIGATION_ID');
373:
374: l_writeoff_id := wf_engine.GetItemAttrNumber(
375: itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'WRITEOFF_ID');
378:

Line 379: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

375: itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'WRITEOFF_ID');
378:
379: l_bankruptcy_id := wf_engine.GetItemAttrNumber(
380: itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'BANKRUPTCY_ID');
383:

Line 445: result := wf_engine.eng_null;

441:
442: BEGIN
443:
444: if funcmode <> 'RUN' then
445: result := wf_engine.eng_null;
446: return;
447: end if;
448:
449: l_manager_name := wf_engine.GetItemAttrText(

Line 449: l_manager_name := wf_engine.GetItemAttrText(

445: result := wf_engine.eng_null;
446: return;
447: end if;
448:
449: l_manager_name := wf_engine.GetItemAttrText(
450: itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'MANAGER_NAME');
453:

Line 454: l_del_type := wf_engine.GetItemAttrText(

450: itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'MANAGER_NAME');
453:
454: l_del_type := wf_engine.GetItemAttrText(
455: itemtype => itemtype,
456: itemkey => itemkey,
457: aname => 'DEL_TYPE');
458:

Line 460: l_delinquency_id := wf_engine.GetItemAttrNumber(

456: itemkey => itemkey,
457: aname => 'DEL_TYPE');
458:
459: IF l_del_type = 'Delinquency' THEN
460: l_delinquency_id := wf_engine.GetItemAttrNumber(
461: itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'DELINQUENCY_ID');
464:

Line 469: l_repossession_id := wf_engine.GetItemAttrNumber(

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(
470: itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'REPOSSESSION_ID');
473:

Line 478: l_litigation_id := wf_engine.GetItemAttrNumber(

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(
479: itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'LITIGATION_ID');
482:

Line 487: l_writeoff_id := wf_engine.GetItemAttrNumber(

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(
488: itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'WRITEOFF_ID');
491:

Line 496: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

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(
497: itemtype => itemtype,
498: itemkey => itemkey,
499: aname => 'BANKRUPTCY_ID');
500: