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_CREDIT_PUB dependencies on WF_ENGINE

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

86: IF p_del_type = 'Delinquency' THEN
87:
88: itemkey := 'DEL'||itemkey; --to_char(p_delinquency_id);
89:
90: wf_engine.createprocess ( itemtype => itemtype,
91: itemkey => itemkey,
92: process => 'CREDIT_HOLD');
93:
94: wf_engine.setitemattrtext( itemtype => itemtype,

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

90: wf_engine.createprocess ( itemtype => itemtype,
91: itemkey => itemkey,
92: process => 'CREDIT_HOLD');
93:
94: wf_engine.setitemattrtext( itemtype => itemtype,
95: itemkey => itemkey,
96: aname => 'DEL_TYPE',
97: avalue => 'Delinquency');
98:

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

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

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

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

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

116: exception
117: when others then null;
118: end;
119:
120: wf_engine.setitemattrtext( itemtype => itemtype,
121: itemkey => itemkey,
122: aname => 'PARTY_ID',
123: avalue => l_party_id);
124:

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

121: itemkey => itemkey,
122: aname => 'PARTY_ID',
123: avalue => l_party_id);
124:
125: wf_engine.setitemattrtext( itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'PARTY_NAME',
128: avalue => l_party_name);
129:

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

126: itemkey => itemkey,
127: aname => 'PARTY_NAME',
128: avalue => l_party_name);
129:
130: wf_engine.setitemattrtext( itemtype => itemtype,
131: itemkey => itemkey,
132: aname => 'ACCOUNT_NUMBER',
133: avalue => l_account_number);
134: -- bug 15935804 end...

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

136: ELSIF p_del_type = 'Repossession' THEN
137:
138: itemkey := 'REP'||itemkey; --to_char(p_repossession_id);
139:
140: wf_engine.createprocess ( itemtype => itemtype,
141: itemkey => itemkey,
142: process => 'CREDIT_HOLD');
143:
144: wf_engine.setitemattrtext( itemtype => itemtype,

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

140: wf_engine.createprocess ( itemtype => itemtype,
141: itemkey => itemkey,
142: process => 'CREDIT_HOLD');
143:
144: wf_engine.setitemattrtext( itemtype => itemtype,
145: itemkey => itemkey,
146: aname => 'DEL_TYPE',
147: avalue => 'Repossession');
148:

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

145: itemkey => itemkey,
146: aname => 'DEL_TYPE',
147: avalue => 'Repossession');
148:
149: wf_engine.setitemattrtext( itemtype => itemtype,
150: itemkey => itemkey,
151: aname => 'REPOSSESSION_ID',
152: avalue => p_repossession_id);
153:

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

150: itemkey => itemkey,
151: aname => 'REPOSSESSION_ID',
152: avalue => p_repossession_id);
153:
154: wf_engine.setitemattrtext( itemtype => itemtype,
155: itemkey => itemkey,
156: aname => 'UNIQUE_ID',
157: avalue => 'Reposession Id: '||p_repossession_id);
158:

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

166: exception
167: when others then null;
168: end;
169:
170: wf_engine.setitemattrtext( itemtype => itemtype,
171: itemkey => itemkey,
172: aname => 'PARTY_ID',
173: avalue => l_party_id);
174:

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

171: itemkey => itemkey,
172: aname => 'PARTY_ID',
173: avalue => l_party_id);
174:
175: wf_engine.setitemattrtext( itemtype => itemtype,
176: itemkey => itemkey,
177: aname => 'PARTY_NAME',
178: avalue => l_party_name);
179:

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

176: itemkey => itemkey,
177: aname => 'PARTY_NAME',
178: avalue => l_party_name);
179:
180: wf_engine.setitemattrtext( itemtype => itemtype,
181: itemkey => itemkey,
182: aname => 'ACCOUNT_NUMBER',
183: avalue => l_account_number);
184: -- bug 15935804 end...

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

186: ELSIF p_del_type = 'Litigation' THEN
187:
188: itemkey := 'LIT'||itemkey; --to_char(p_litigation_id);
189:
190: wf_engine.createprocess ( itemtype => itemtype,
191: itemkey => itemkey,
192: process => 'CREDIT_HOLD');
193:
194: wf_engine.setitemattrtext( itemtype => itemtype,

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

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

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

195: itemkey => itemkey,
196: aname => 'DEL_TYPE',
197: avalue => 'Litigation');
198:
199: wf_engine.setitemattrtext( itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'LITIGATION_ID',
202: avalue => p_litigation_id);
203:

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

200: itemkey => itemkey,
201: aname => 'LITIGATION_ID',
202: avalue => p_litigation_id);
203:
204: wf_engine.setitemattrtext( itemtype => itemtype,
205: itemkey => itemkey,
206: aname => 'UNIQUE_ID',
207: avalue => 'Litigation Id: '||p_litigation_id);
208:

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

216: exception
217: when others then null;
218: end;
219:
220: wf_engine.setitemattrtext( itemtype => itemtype,
221: itemkey => itemkey,
222: aname => 'PARTY_ID',
223: avalue => l_party_id);
224:

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

221: itemkey => itemkey,
222: aname => 'PARTY_ID',
223: avalue => l_party_id);
224:
225: wf_engine.setitemattrtext( itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'PARTY_NAME',
228: avalue => l_party_name);
229:

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

226: itemkey => itemkey,
227: aname => 'PARTY_NAME',
228: avalue => l_party_name);
229:
230: wf_engine.setitemattrtext( itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'ACCOUNT_NUMBER',
233: avalue => l_account_number);
234: -- bug 15935804 end...

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

236: ELSIF p_del_type = 'Writeoff' THEN
237:
238: itemkey := 'WRI'||itemkey; --to_char(p_writeoff_id);
239:
240: wf_engine.createprocess ( itemtype => itemtype,
241: itemkey => itemkey,
242: process => 'CREDIT_HOLD');
243:
244: wf_engine.setitemattrtext( itemtype => itemtype,

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

240: wf_engine.createprocess ( itemtype => itemtype,
241: itemkey => itemkey,
242: process => 'CREDIT_HOLD');
243:
244: wf_engine.setitemattrtext( itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'DEL_TYPE',
247: avalue => 'Writeoff');
248:

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

245: itemkey => itemkey,
246: aname => 'DEL_TYPE',
247: avalue => 'Writeoff');
248:
249: wf_engine.setitemattrtext( itemtype => itemtype,
250: itemkey => itemkey,
251: aname => 'WRITEOFF_ID',
252: avalue => p_writeoff_id);
253:

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

250: itemkey => itemkey,
251: aname => 'WRITEOFF_ID',
252: avalue => p_writeoff_id);
253:
254: wf_engine.setitemattrtext( itemtype => itemtype,
255: itemkey => itemkey,
256: aname => 'UNIQUE_ID',
257: avalue => 'Writeoff Id: '||p_writeoff_id);
258:

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

266: exception
267: when others then null;
268: end;
269:
270: wf_engine.setitemattrtext( itemtype => itemtype,
271: itemkey => itemkey,
272: aname => 'PARTY_ID',
273: avalue => l_party_id);
274:

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

271: itemkey => itemkey,
272: aname => 'PARTY_ID',
273: avalue => l_party_id);
274:
275: wf_engine.setitemattrtext( itemtype => itemtype,
276: itemkey => itemkey,
277: aname => 'PARTY_NAME',
278: avalue => l_party_name);
279:

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

276: itemkey => itemkey,
277: aname => 'PARTY_NAME',
278: avalue => l_party_name);
279:
280: wf_engine.setitemattrtext( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'ACCOUNT_NUMBER',
283: avalue => l_account_number);
284: -- bug 15935804 end...

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

287:
288: itemkey := 'Ban'||itemkey; --to_char(p_bankruptcy_id);
289: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
290:
291: wf_engine.createprocess ( itemtype => itemtype,
292: itemkey => itemkey,
293: process => 'CREDIT_HOLD');
294:
295: wf_engine.setitemattrtext( itemtype => itemtype,

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

291: wf_engine.createprocess ( itemtype => itemtype,
292: itemkey => itemkey,
293: process => 'CREDIT_HOLD');
294:
295: wf_engine.setitemattrtext( itemtype => itemtype,
296: itemkey => itemkey,
297: aname => 'DEL_TYPE',
298: avalue => 'Bankrupt');
299:

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

296: itemkey => itemkey,
297: aname => 'DEL_TYPE',
298: avalue => 'Bankrupt');
299:
300: wf_engine.setitemattrtext( itemtype => itemtype,
301: itemkey => itemkey,
302: aname => 'BANKRUPTCY_ID',
303: avalue => p_bankruptcy_id);
304:

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

301: itemkey => itemkey,
302: aname => 'BANKRUPTCY_ID',
303: avalue => p_bankruptcy_id);
304:
305: wf_engine.setitemattrtext( itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'UNIQUE_ID',
308: avalue => 'Bankruptcy Id: '||p_bankruptcy_id);
309:

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

318: exception
319: when others then null;
320: end;
321:
322: wf_engine.setitemattrtext( itemtype => itemtype,
323: itemkey => itemkey,
324: aname => 'PARTY_ID',
325: avalue => l_party_id);
326:

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

323: itemkey => itemkey,
324: aname => 'PARTY_ID',
325: avalue => l_party_id);
326:
327: wf_engine.setitemattrtext( itemtype => itemtype,
328: itemkey => itemkey,
329: aname => 'PARTY_NAME',
330: avalue => l_party_name);
331:

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

328: itemkey => itemkey,
329: aname => 'PARTY_NAME',
330: avalue => l_party_name);
331:
332: wf_engine.setitemattrtext( itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'ACCOUNT_NUMBER',
335: avalue => l_account_number);
336: -- bug 15935804 end...

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

351: l_manager_name := l_user_name;
352: END IF;
353: CLOSE C_MANAGER;
354: --DBMS_OUTPUT.PUT_LINE('**');
355: wf_engine.setitemattrnumber( itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'DELINQUENCY_ID',
358: avalue => p_delinquency_id);
359:

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

356: itemkey => itemkey,
357: aname => 'DELINQUENCY_ID',
358: avalue => p_delinquency_id);
359:
360: wf_engine.setitemattrnumber( itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'MANAGER_ID',
363: avalue => l_manager_id);
364:

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

361: itemkey => itemkey,
362: aname => 'MANAGER_ID',
363: avalue => l_manager_id);
364:
365: wf_engine.setitemattrtext( itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'MANAGER_NAME',
368: avalue => l_manager_name);
369:

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

366: itemkey => itemkey,
367: aname => 'MANAGER_NAME',
368: avalue => l_manager_name);
369:
370: wf_engine.setitemattrtext( itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'REQUESTER_NAME',
373: avalue => l_user_name);
374:

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

371: itemkey => itemkey,
372: aname => 'REQUESTER_NAME',
373: avalue => l_user_name);
374:
375: wf_engine.setitemattrtext( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'REQUESTER_ID',
378: avalue => p_user_id);
379:

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

376: itemkey => itemkey,
377: aname => 'REQUESTER_ID',
378: avalue => p_user_id);
379:
380: wf_engine.startprocess( itemtype => itemtype,
381: itemkey => itemkey);
382:
383: wf_engine.ItemStatus( itemtype => ItemType,
384: itemkey => ItemKey,

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

379:
380: wf_engine.startprocess( itemtype => itemtype,
381: itemkey => itemkey);
382:
383: wf_engine.ItemStatus( itemtype => ItemType,
384: itemkey => ItemKey,
385: status => l_return_status,
386: result => l_result);
387: --DBMS_OUTPUT.PUT_LINE('***'||l_return_status);

Line 483: result := wf_engine.eng_null;

479:
480: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Starting update_approval_status......= ');
481:
482: if funcmode <> 'RUN' then
483: result := wf_engine.eng_null;
484: return;
485: end if;
486:
487: l_manager_name := wf_engine.GetItemAttrText(

Line 487: l_manager_name := wf_engine.GetItemAttrText(

483: result := wf_engine.eng_null;
484: return;
485: end if;
486:
487: l_manager_name := wf_engine.GetItemAttrText(
488: itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'MANAGER_NAME');
491:

Line 492: l_delinquency_id := wf_engine.GetItemAttrNumber(

488: itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'MANAGER_NAME');
491:
492: l_delinquency_id := wf_engine.GetItemAttrNumber(
493: itemtype => itemtype,
494: itemkey => itemkey,
495: aname => 'DELINQUENCY_ID');
496:

Line 497: l_del_type := wf_engine.GetItemAttrText(

493: itemtype => itemtype,
494: itemkey => itemkey,
495: aname => 'DELINQUENCY_ID');
496:
497: l_del_type := wf_engine.GetItemAttrText(
498: itemtype => itemtype,
499: itemkey => itemkey,
500: aname => 'DEL_TYPE');
501:

Line 502: l_repossession_id := wf_engine.GetItemAttrNumber(

498: itemtype => itemtype,
499: itemkey => itemkey,
500: aname => 'DEL_TYPE');
501:
502: l_repossession_id := wf_engine.GetItemAttrNumber(
503: itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'REPOSSESSION_ID');
506:

Line 507: l_litigation_id := wf_engine.GetItemAttrNumber(

503: itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'REPOSSESSION_ID');
506:
507: l_litigation_id := wf_engine.GetItemAttrNumber(
508: itemtype => itemtype,
509: itemkey => itemkey,
510: aname => 'LITIGATION_ID');
511:

Line 512: l_writeoff_id := wf_engine.GetItemAttrNumber(

508: itemtype => itemtype,
509: itemkey => itemkey,
510: aname => 'LITIGATION_ID');
511:
512: l_writeoff_id := wf_engine.GetItemAttrNumber(
513: itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'WRITEOFF_ID');
516:

Line 517: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

513: itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'WRITEOFF_ID');
516:
517: l_bankruptcy_id := wf_engine.GetItemAttrNumber(
518: itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'BANKRUPTCY_ID');
521:

Line 633: l_manager_name := wf_engine.GetItemAttrText(

629: l_errmsg_name VARCHAR2(30);
630: L_API_ERROR EXCEPTION;
631:
632: BEGIN
633: l_manager_name := wf_engine.GetItemAttrText(
634: itemtype => itemtype,
635: itemkey => itemkey,
636: aname => 'MANAGER_NAME');
637:

Line 638: l_delinquency_id := wf_engine.GetItemAttrNumber(

634: itemtype => itemtype,
635: itemkey => itemkey,
636: aname => 'MANAGER_NAME');
637:
638: l_delinquency_id := wf_engine.GetItemAttrNumber(
639: itemtype => itemtype,
640: itemkey => itemkey,
641: aname => 'DELINQUENCY_ID');
642:

Line 643: l_del_type := wf_engine.GetItemAttrText(

639: itemtype => itemtype,
640: itemkey => itemkey,
641: aname => 'DELINQUENCY_ID');
642:
643: l_del_type := wf_engine.GetItemAttrText(
644: itemtype => itemtype,
645: itemkey => itemkey,
646: aname => 'DEL_TYPE');
647:

Line 648: l_repossession_id := wf_engine.GetItemAttrNumber(

644: itemtype => itemtype,
645: itemkey => itemkey,
646: aname => 'DEL_TYPE');
647:
648: l_repossession_id := wf_engine.GetItemAttrNumber(
649: itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'REPOSSESSION_ID');
652:

Line 653: l_litigation_id := wf_engine.GetItemAttrNumber(

649: itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'REPOSSESSION_ID');
652:
653: l_litigation_id := wf_engine.GetItemAttrNumber(
654: itemtype => itemtype,
655: itemkey => itemkey,
656: aname => 'LITIGATION_ID');
657:

Line 658: l_writeoff_id := wf_engine.GetItemAttrNumber(

654: itemtype => itemtype,
655: itemkey => itemkey,
656: aname => 'LITIGATION_ID');
657:
658: l_writeoff_id := wf_engine.GetItemAttrNumber(
659: itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'WRITEOFF_ID');
662:

Line 663: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

659: itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'WRITEOFF_ID');
662:
663: l_bankruptcy_id := wf_engine.GetItemAttrNumber(
664: itemtype => itemtype,
665: itemkey => itemkey,
666: aname => 'BANKRUPTCY_ID');
667: