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.

[Home] [Help]

APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on WF_ENGINE

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

83:
84: itemkey := 'DEL'||itemkey; --to_char(p_delinquency_id);
85: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
86:
87: wf_engine.createprocess ( itemtype => itemtype,
88: itemkey => itemkey,
89: process => 'CREDIT_HOLD');
90:
91: wf_engine.setitemattrtext( itemtype => itemtype,

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

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

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

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

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

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

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

107:
108: itemkey := 'REP'||itemkey; --to_char(p_repossession_id);
109: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
110:
111: wf_engine.createprocess ( itemtype => itemtype,
112: itemkey => itemkey,
113: process => 'CREDIT_HOLD');
114:
115: wf_engine.setitemattrtext( itemtype => itemtype,

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

111: wf_engine.createprocess ( itemtype => itemtype,
112: itemkey => itemkey,
113: process => 'CREDIT_HOLD');
114:
115: wf_engine.setitemattrtext( itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'DEL_TYPE',
118: avalue => 'Repossession');
119: --DBMS_OUTPUT.PUT_LINE('*');

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

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

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

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

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

133: ELSIF p_del_type = 'Litigation' THEN
134:
135: itemkey := 'LIT'||itemkey; --to_char(p_litigation_id);
136:
137: wf_engine.createprocess ( itemtype => itemtype,
138: itemkey => itemkey,
139: process => 'CREDIT_HOLD');
140:
141: wf_engine.setitemattrtext( itemtype => itemtype,

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

137: wf_engine.createprocess ( itemtype => itemtype,
138: itemkey => itemkey,
139: process => 'CREDIT_HOLD');
140:
141: wf_engine.setitemattrtext( itemtype => itemtype,
142: itemkey => itemkey,
143: aname => 'DEL_TYPE',
144: avalue => 'Litigation');
145:

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

142: itemkey => itemkey,
143: aname => 'DEL_TYPE',
144: avalue => 'Litigation');
145:
146: wf_engine.setitemattrtext( itemtype => itemtype,
147: itemkey => itemkey,
148: aname => 'LITIGATION_ID',
149: avalue => p_litigation_id);
150:

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

147: itemkey => itemkey,
148: aname => 'LITIGATION_ID',
149: avalue => p_litigation_id);
150:
151: wf_engine.setitemattrtext( itemtype => itemtype,
152: itemkey => itemkey,
153: aname => 'UNIQUE_ID',
154: avalue => 'Litigation Id: '||p_litigation_id);
155:

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

156: ELSIF p_del_type = 'Writeoff' THEN
157:
158: itemkey := 'WRI'||itemkey; --to_char(p_writeoff_id);
159:
160: wf_engine.createprocess ( itemtype => itemtype,
161: itemkey => itemkey,
162: process => 'CREDIT_HOLD');
163:
164: wf_engine.setitemattrtext( itemtype => itemtype,

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

160: wf_engine.createprocess ( itemtype => itemtype,
161: itemkey => itemkey,
162: process => 'CREDIT_HOLD');
163:
164: wf_engine.setitemattrtext( itemtype => itemtype,
165: itemkey => itemkey,
166: aname => 'DEL_TYPE',
167: avalue => 'Writeoff');
168:

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

165: itemkey => itemkey,
166: aname => 'DEL_TYPE',
167: avalue => 'Writeoff');
168:
169: wf_engine.setitemattrtext( itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'WRITEOFF_ID',
172: avalue => p_writeoff_id);
173:

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

170: itemkey => itemkey,
171: aname => 'WRITEOFF_ID',
172: avalue => p_writeoff_id);
173:
174: wf_engine.setitemattrtext( itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'UNIQUE_ID',
177: avalue => 'Writeoff Id: '||p_writeoff_id);
178:

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

180:
181: itemkey := 'Ban'||itemkey; --to_char(p_bankruptcy_id);
182: --DBMS_OUTPUT.PUT_LINE('itemkey = ' || itemkey);
183:
184: wf_engine.createprocess ( itemtype => itemtype,
185: itemkey => itemkey,
186: process => 'CREDIT_HOLD');
187:
188: wf_engine.setitemattrtext( itemtype => itemtype,

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

184: wf_engine.createprocess ( itemtype => itemtype,
185: itemkey => itemkey,
186: process => 'CREDIT_HOLD');
187:
188: wf_engine.setitemattrtext( itemtype => itemtype,
189: itemkey => itemkey,
190: aname => 'DEL_TYPE',
191: avalue => 'Bankrupt');
192:

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

189: itemkey => itemkey,
190: aname => 'DEL_TYPE',
191: avalue => 'Bankrupt');
192:
193: wf_engine.setitemattrtext( itemtype => itemtype,
194: itemkey => itemkey,
195: aname => 'BANKRUPTCY_ID',
196: avalue => p_bankruptcy_id);
197:

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

194: itemkey => itemkey,
195: aname => 'BANKRUPTCY_ID',
196: avalue => p_bankruptcy_id);
197:
198: wf_engine.setitemattrtext( itemtype => itemtype,
199: itemkey => itemkey,
200: aname => 'UNIQUE_ID',
201: avalue => 'Bankruptcy Id: '||p_bankruptcy_id);
202:

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

216: l_manager_name := l_user_name;
217: END IF;
218: CLOSE C_MANAGER;
219: --DBMS_OUTPUT.PUT_LINE('**');
220: wf_engine.setitemattrnumber( itemtype => itemtype,
221: itemkey => itemkey,
222: aname => 'DELINQUENCY_ID',
223: avalue => p_delinquency_id);
224:

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

221: itemkey => itemkey,
222: aname => 'DELINQUENCY_ID',
223: avalue => p_delinquency_id);
224:
225: wf_engine.setitemattrnumber( itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'MANAGER_ID',
228: avalue => l_manager_id);
229:

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

226: itemkey => itemkey,
227: aname => 'MANAGER_ID',
228: avalue => l_manager_id);
229:
230: wf_engine.setitemattrtext( itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'MANAGER_NAME',
233: avalue => l_manager_name);
234:

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

231: itemkey => itemkey,
232: aname => 'MANAGER_NAME',
233: avalue => l_manager_name);
234:
235: wf_engine.setitemattrtext( itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'REQUESTER_NAME',
238: avalue => l_user_name);
239:

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

236: itemkey => itemkey,
237: aname => 'REQUESTER_NAME',
238: avalue => l_user_name);
239:
240: wf_engine.setitemattrtext( itemtype => itemtype,
241: itemkey => itemkey,
242: aname => 'REQUESTER_ID',
243: avalue => p_user_id);
244:

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

241: itemkey => itemkey,
242: aname => 'REQUESTER_ID',
243: avalue => p_user_id);
244:
245: wf_engine.startprocess( itemtype => itemtype,
246: itemkey => itemkey);
247:
248: wf_engine.ItemStatus( itemtype => ItemType,
249: itemkey => ItemKey,

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

244:
245: wf_engine.startprocess( itemtype => itemtype,
246: itemkey => itemkey);
247:
248: wf_engine.ItemStatus( itemtype => ItemType,
249: itemkey => ItemKey,
250: status => l_return_status,
251: result => l_result);
252: --DBMS_OUTPUT.PUT_LINE('***'||l_return_status);

Line 327: result := wf_engine.eng_null;

323:
324: BEGIN
325:
326: if funcmode <> 'RUN' then
327: result := wf_engine.eng_null;
328: return;
329: end if;
330:
331: l_manager_name := wf_engine.GetItemAttrText(

Line 331: l_manager_name := wf_engine.GetItemAttrText(

327: result := wf_engine.eng_null;
328: return;
329: end if;
330:
331: l_manager_name := wf_engine.GetItemAttrText(
332: itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'MANAGER_NAME');
335:

Line 336: l_delinquency_id := wf_engine.GetItemAttrNumber(

332: itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'MANAGER_NAME');
335:
336: l_delinquency_id := wf_engine.GetItemAttrNumber(
337: itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'DELINQUENCY_ID');
340:

Line 341: l_del_type := wf_engine.GetItemAttrText(

337: itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'DELINQUENCY_ID');
340:
341: l_del_type := wf_engine.GetItemAttrText(
342: itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'DEL_TYPE');
345:

Line 346: l_repossession_id := wf_engine.GetItemAttrNumber(

342: itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'DEL_TYPE');
345:
346: l_repossession_id := wf_engine.GetItemAttrNumber(
347: itemtype => itemtype,
348: itemkey => itemkey,
349: aname => 'REPOSSESSION_ID');
350:

Line 351: l_litigation_id := wf_engine.GetItemAttrNumber(

347: itemtype => itemtype,
348: itemkey => itemkey,
349: aname => 'REPOSSESSION_ID');
350:
351: l_litigation_id := wf_engine.GetItemAttrNumber(
352: itemtype => itemtype,
353: itemkey => itemkey,
354: aname => 'LITIGATION_ID');
355:

Line 356: l_writeoff_id := wf_engine.GetItemAttrNumber(

352: itemtype => itemtype,
353: itemkey => itemkey,
354: aname => 'LITIGATION_ID');
355:
356: l_writeoff_id := wf_engine.GetItemAttrNumber(
357: itemtype => itemtype,
358: itemkey => itemkey,
359: aname => 'WRITEOFF_ID');
360:

Line 361: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

357: itemtype => itemtype,
358: itemkey => itemkey,
359: aname => 'WRITEOFF_ID');
360:
361: l_bankruptcy_id := wf_engine.GetItemAttrNumber(
362: itemtype => itemtype,
363: itemkey => itemkey,
364: aname => 'BANKRUPTCY_ID');
365:

Line 425: l_manager_name := wf_engine.GetItemAttrText(

421: l_errmsg_name VARCHAR2(30);
422: L_API_ERROR EXCEPTION;
423:
424: BEGIN
425: l_manager_name := wf_engine.GetItemAttrText(
426: itemtype => itemtype,
427: itemkey => itemkey,
428: aname => 'MANAGER_NAME');
429:

Line 430: l_delinquency_id := wf_engine.GetItemAttrNumber(

426: itemtype => itemtype,
427: itemkey => itemkey,
428: aname => 'MANAGER_NAME');
429:
430: l_delinquency_id := wf_engine.GetItemAttrNumber(
431: itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'DELINQUENCY_ID');
434:

Line 435: l_del_type := wf_engine.GetItemAttrText(

431: itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'DELINQUENCY_ID');
434:
435: l_del_type := wf_engine.GetItemAttrText(
436: itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'DEL_TYPE');
439:

Line 440: l_repossession_id := wf_engine.GetItemAttrNumber(

436: itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'DEL_TYPE');
439:
440: l_repossession_id := wf_engine.GetItemAttrNumber(
441: itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'REPOSSESSION_ID');
444:

Line 445: l_litigation_id := wf_engine.GetItemAttrNumber(

441: itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'REPOSSESSION_ID');
444:
445: l_litigation_id := wf_engine.GetItemAttrNumber(
446: itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'LITIGATION_ID');
449:

Line 450: l_writeoff_id := wf_engine.GetItemAttrNumber(

446: itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'LITIGATION_ID');
449:
450: l_writeoff_id := wf_engine.GetItemAttrNumber(
451: itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'WRITEOFF_ID');
454:

Line 455: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

451: itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'WRITEOFF_ID');
454:
455: l_bankruptcy_id := wf_engine.GetItemAttrNumber(
456: itemtype => itemtype,
457: itemkey => itemkey,
458: aname => 'BANKRUPTCY_ID');
459: