APPS.MRP_MSC_EXP_WF dependencies on WF_ENGINE

Line 11: wf_engine.GetActivityAttrText( itemtype => itemtype,

7: funcmode in varchar2,
8: resultout out NOCOPY varchar2) is
9:
10: l_user_type varchar2(20) :=
11: wf_engine.GetActivityAttrText( itemtype => itemtype,
12: itemkey => itemkey,
13: actid => actid,
14: aname => 'USER_TYPE');
15: l_planner varchar2(50) :=

Line 16: wf_engine.GetItemAttrText( itemtype => itemtype,

12: itemkey => itemkey,
13: actid => actid,
14: aname => 'USER_TYPE');
15: l_planner varchar2(50) :=
16: wf_engine.GetItemAttrText( itemtype => itemtype,
17: itemkey => itemkey,
18: aname => 'PLANNER');
19:
20: -- skanta

Line 22: wf_engine.GetItemAttrText( itemtype => itemtype,

18: aname => 'PLANNER');
19:
20: -- skanta
21: l_salesrep varchar2(30) :=
22: wf_engine.GetItemAttrText( itemtype => itemtype,
23: itemkey => itemkey,
24: aname => 'SALESREP');
25: l_order_type number :=
26: wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 26: wf_engine.GetItemAttrNumber( itemtype => itemtype,

22: wf_engine.GetItemAttrText( itemtype => itemtype,
23: itemkey => itemkey,
24: aname => 'SALESREP');
25: l_order_type number :=
26: wf_engine.GetItemAttrNumber( itemtype => itemtype,
27: itemkey => itemkey,
28: aname => 'ORDER_TYPE_CODE');
29:
30: l_exception_type number :=

Line 31: wf_engine.GetItemAttrNumber( itemtype => itemtype,

27: itemkey => itemkey,
28: aname => 'ORDER_TYPE_CODE');
29:
30: l_exception_type number :=
31: wf_engine.GetItemAttrNumber( itemtype => itemtype,
32: itemkey => itemkey,
33: aname => 'EXCEPTION_TYPE_ID');
34:
35: l_salesrep_name varchar2(320);

Line 52: wf_engine.GetItemAttrText( itemtype => itemtype,

48: --
49: BEGIN
50: if (funcmode = 'RUN') then
51: l_user_name :=
52: wf_engine.GetItemAttrText( itemtype => itemtype,
53: itemkey => itemkey,
54: aname => l_user_type);
55:
56: if (l_user_name is null) then

Line 68: wf_engine.SetItemAttrText( itemtype => itemtype,

64: FETCH c_salesrep INTO l_salesrep_name;
65: CLOSE c_salesrep;
66:
67: IF l_salesrep_name is NOT NULL THEN
68: wf_engine.SetItemAttrText( itemtype => itemtype,
69: itemkey => itemkey,
70: aname => 'SALESREP',
71: avalue => l_salesrep_name);
72: END IF;

Line 78: wf_engine.SetItemAttrText( itemtype => itemtype,

74: END IF;
75: l_msg := GetMessageName(l_exception_type,
76: l_order_type,
77: l_user_type);
78: wf_engine.SetItemAttrText( itemtype => itemtype,
79: itemkey => itemkey,
80: aname => 'MESSAGE_NAME',
81: avalue => l_msg);
82:

Line 110: wf_engine.GetActivityAttrText( itemtype => itemtype,

106: funcmode in varchar2,
107: resultout out NOCOPY varchar2) is
108:
109: l_partner_type varchar2(20) :=
110: wf_engine.GetActivityAttrText( itemtype => itemtype,
111: itemkey => itemkey,
112: actid => actid,
113: aname => 'PARTNER_TYPE');
114:

Line 116: wf_engine.GetItemAttrNumber( itemtype => itemtype,

112: actid => actid,
113: aname => 'PARTNER_TYPE');
114:
115: l_order_type number :=
116: wf_engine.GetItemAttrNumber( itemtype => itemtype,
117: itemkey => itemkey,
118: aname => 'ORDER_TYPE_CODE');
119:
120: l_exception_type number :=

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

117: itemkey => itemkey,
118: aname => 'ORDER_TYPE_CODE');
119:
120: l_exception_type number :=
121: wf_engine.GetItemAttrNumber( itemtype => itemtype,
122: itemkey => itemkey,
123: aname => 'EXCEPTION_TYPE_ID');
124:
125: l_msg varchar2(30);

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

126: l_partner_name varchar2(50);
127: BEGIN
128: if (funcmode = 'RUN') then
129: l_partner_name :=
130: wf_engine.GetItemAttrText( itemtype => itemtype,
131: itemkey => itemkey,
132: aname => l_partner_type);
133:
134: if (l_partner_name is null) then

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

137: else
138: l_msg := GetMessageName(l_exception_type,
139: l_order_type,
140: l_partner_type);
141: wf_engine.SetItemAttrText( itemtype => itemtype,
142: itemkey => itemkey,
143: aname => 'MESSAGE_NAME',
144: avalue => l_msg);
145: resultout := 'COMPLETE:FOUND';

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

168: funcmode in varchar2,
169: resultout out NOCOPY varchar2) is
170:
171: l_exception_type number :=
172: wf_engine.GetItemAttrNumber( itemtype => itemtype,
173: itemkey => itemkey,
174: aname => 'EXCEPTION_TYPE_ID');
175:
176: BEGIN

Line 210: wf_engine.GetActivityAttrText( itemtype => itemtype,

206: funcmode in varchar2,
207: resultout out NOCOPY varchar2) is
208:
209: l_result varchar2(20) :=
210: wf_engine.GetActivityAttrText( itemtype => itemtype,
211: itemkey => itemkey,
212: actid => actid,
213: aname => 'SR_RESULT');
214:

Line 216: wf_engine.GetItemAttrText( itemtype => itemtype,

212: actid => actid,
213: aname => 'SR_RESULT');
214:
215: l_db_link varchar2(30) :=
216: wf_engine.GetItemAttrText( itemtype => itemtype,
217: itemkey => itemkey,
218: aname => 'APPS_PS_DBLINK');
219:
220: l_exception_type number :=

Line 221: wf_engine.GetItemAttrNumber( itemtype => itemtype,

217: itemkey => itemkey,
218: aname => 'APPS_PS_DBLINK');
219:
220: l_exception_type number :=
221: wf_engine.GetItemAttrNumber( itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'EXCEPTION_TYPE_ID');
224:
225: l_transaction_id number :=

Line 226: wf_engine.GetItemAttrNumber( itemtype => itemtype,

222: itemkey => itemkey,
223: aname => 'EXCEPTION_TYPE_ID');
224:
225: l_transaction_id number :=
226: wf_engine.GetItemAttrNumber( itemtype => itemtype,
227: itemkey => itemkey,
228: aname => 'TRANSACTION_ID');
229:
230: l_dest_item_type varchar2(50) := 'MSCEXPWF';

Line 255: sql_stmt := 'begin wf_engine.CreateProcess' || l_db_link ||

251: l_dest_process := 'EXCEPTION_PROCESS3';
252: elsif (l_exception_type in (17, 18, 19)) then
253: l_dest_process := 'EXCEPTION_PROCESS4';
254: end if;
255: sql_stmt := 'begin wf_engine.CreateProcess' || l_db_link ||
256: '( itemtype => :l_itemtype,' ||
257: 'itemkey => :l_itemkey, ' ||
258: 'process => :l_process);end;';
259: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type, l_dest_item_key,

Line 267: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

263: -- we could only copy those insterested attributes,
264: -- but we copy all for debug purpose.
265:
266: -- SR_RESULT.
267: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
268: '(itemtype => :item_type,' ||
269: ' itemkey => :item_key,' ||
270: ' aname => ''SR_RESULT'',' ||
271: ' avalue => :l_text);end;';

Line 275: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

271: ' avalue => :l_text);end;';
272: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_result;
273:
274: -- EXCEPTION_TYPE_ID.
275: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
276: '(itemtype => :item_type,' ||
277: ' itemkey => :item_key,' ||
278: ' aname => ''EXCEPTION_TYPE_ID'',' ||
279: ' avalue => :l_numb);end;';

Line 282: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

278: ' aname => ''EXCEPTION_TYPE_ID'',' ||
279: ' avalue => :l_numb);end;';
280: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_exception_type;
281:
282: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
283: '(itemtype => :item_type,' ||
284: ' itemkey => :item_key,' ||
285: ' aname => ''TRANSACTION_ID'',' ||
286: ' avalue => :l_numb);end;';

Line 290: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

286: ' avalue => :l_numb);end;';
287: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_transaction_id;
288:
289: -- APPS_PS_DBLINK
290: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
291: '(itemtype => :item_type,' ||
292: ' itemkey => :item_key,' ||
293: ' aname => ''APPS_PS_DBLINK'',' ||
294: ' avalue => :l_text);end;';

Line 298: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

294: ' avalue => :l_text);end;';
295: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_db_link;
296:
297: --BUYER. we don't need to set back BUYER, set it for debug
298: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
299: itemkey => itemkey,
300: aname => 'BUYER');
301: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
302: '(itemtype => :item_type,' ||

Line 301: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

297: --BUYER. we don't need to set back BUYER, set it for debug
298: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
299: itemkey => itemkey,
300: aname => 'BUYER');
301: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
302: '(itemtype => :item_type,' ||
303: ' itemkey => :item_key,' ||
304: ' aname => ''BUYER'',' ||
305: ' avalue => :l_text);end;';

Line 309: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

305: ' avalue => :l_text);end;';
306: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
307:
308: -- we don't need to set back CUSTCNT, for debug only
309: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
310: itemkey => itemkey,
311: aname => 'CUSTCNT');
312: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
313: '(itemtype => :item_type,' ||

Line 312: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

308: -- we don't need to set back CUSTCNT, for debug only
309: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
310: itemkey => itemkey,
311: aname => 'CUSTCNT');
312: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
313: '(itemtype => :item_type,' ||
314: ' itemkey => :item_key,' ||
315: ' aname => ''CUSTCNT'',' ||
316: ' avalue => :l_text);end;';

Line 320: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

316: ' avalue => :l_text);end;';
317: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
318:
319: -- customer_name
320: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'CUSTOMER_NAME');
323: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
324: '(itemtype => :item_type,' ||

Line 323: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

319: -- customer_name
320: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'CUSTOMER_NAME');
323: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
324: '(itemtype => :item_type,' ||
325: ' itemkey => :item_key,' ||
326: ' aname => ''CUSTOMER_NAME'',' ||
327: ' avalue => :l_text);end;';

Line 331: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

327: ' avalue => :l_text);end;';
328: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
329:
330: -- customer_ID.
331: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'CUSTOMER_ID');
334: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
335: '(itemtype => :item_type,' ||

Line 334: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

330: -- customer_ID.
331: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'CUSTOMER_ID');
334: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
335: '(itemtype => :item_type,' ||
336: ' itemkey => :item_key,' ||
337: ' aname => ''CUSTOMER_ID'',' ||
338: ' avalue => :l_numb);end;';

Line 342: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

338: ' avalue => :l_numb);end;';
339: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
340:
341: -- Days_compressed
342: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'DAYS_COMPRESSED');
345: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
346: '(itemtype => :item_type,' ||

Line 345: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

341: -- Days_compressed
342: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'DAYS_COMPRESSED');
345: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
346: '(itemtype => :item_type,' ||
347: ' itemkey => :item_key,' ||
348: ' aname => ''DAYS_COMPRESSED'',' ||
349: ' avalue => :l_numb);end;';

Line 353: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

349: ' avalue => :l_numb);end;';
350: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
351:
352: -- DB_LINK. we may not need.
353: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'DB_LINK');
356: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
357: '(itemtype => :item_type,' ||

Line 356: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

352: -- DB_LINK. we may not need.
353: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'DB_LINK');
356: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
357: '(itemtype => :item_type,' ||
358: ' itemkey => :item_key,' ||
359: ' aname => ''DB_LINK'',' ||
360: ' avalue => :l_text);end;';

Line 364: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

360: ' avalue => :l_text);end;';
361: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
362:
363: -- DEPARTMENT_LINE_CODE.
364: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
365: itemkey => itemkey,
366: aname => 'DEPARTMENT_LINE_CODE');
367: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
368: '(itemtype => :item_type,' ||

Line 367: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

363: -- DEPARTMENT_LINE_CODE.
364: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
365: itemkey => itemkey,
366: aname => 'DEPARTMENT_LINE_CODE');
367: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
368: '(itemtype => :item_type,' ||
369: ' itemkey => :item_key,' ||
370: ' aname => ''DEPARTMENT_LINE_CODE'',' ||
371: ' avalue => :l_text);end;';

Line 375: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,

371: ' avalue => :l_text);end;';
372: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
373:
374: -- due_date.
375: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'DUE_DATE');
378: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
379: '(itemtype => :item_type,' ||

Line 378: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||

374: -- due_date.
375: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'DUE_DATE');
378: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
379: '(itemtype => :item_type,' ||
380: ' itemkey => :item_key,' ||
381: ' aname => ''DUE_DATE'',' ||
382: ' avalue => :l_date);end;';

Line 386: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

382: ' avalue => :l_date);end;';
383: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_date;
384:
385: -- end_item_display_name.
386: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
387: itemkey => itemkey,
388: aname => 'END_ITEM_DISPLAY_NAME');
389: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
390: '(itemtype => :item_type,' ||

Line 389: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

385: -- end_item_display_name.
386: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
387: itemkey => itemkey,
388: aname => 'END_ITEM_DISPLAY_NAME');
389: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
390: '(itemtype => :item_type,' ||
391: ' itemkey => :item_key,' ||
392: ' aname => ''END_ITEM_DISPLAY_NAME'',' ||
393: ' avalue => :l_text);end;';

Line 398: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

394: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
395:
396: -- end_item_description
397:
398: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
399: itemkey => itemkey,
400: aname => 'END_ITEM_DESCRIPTION');
401: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
402: '(itemtype => :item_type,' ||

Line 401: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

397:
398: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
399: itemkey => itemkey,
400: aname => 'END_ITEM_DESCRIPTION');
401: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
402: '(itemtype => :item_type,' ||
403: ' itemkey => :item_key,' ||
404: ' aname => ''END_ITEM_DESCRIPTION'',' ||
405: ' avalue => :l_text);end;';

Line 410: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

406: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
407:
408:
409: --END_ORDER_NUMBER
410: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
411: itemkey => itemkey,
412: aname => 'END_ORDER_NUMBER');
413: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
414: '(itemtype => :item_type,' ||

Line 413: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

409: --END_ORDER_NUMBER
410: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
411: itemkey => itemkey,
412: aname => 'END_ORDER_NUMBER');
413: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
414: '(itemtype => :item_type,' ||
415: ' itemkey => :item_key,' ||
416: ' aname => ''END_ORDER_NUMBER'',' ||
417: ' avalue => :l_text);end;';

Line 421: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

417: ' avalue => :l_text);end;';
418: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
419:
420: -- EXCEPTION_DESCRIPTION
421: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
422: itemkey => itemkey,
423: aname => 'EXCEPTION_DESCRIPTION');
424: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
425: '(itemtype => :item_type,' ||

Line 424: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

420: -- EXCEPTION_DESCRIPTION
421: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
422: itemkey => itemkey,
423: aname => 'EXCEPTION_DESCRIPTION');
424: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
425: '(itemtype => :item_type,' ||
426: ' itemkey => :item_key,' ||
427: ' aname => ''EXCEPTION_DESCRIPTION'',' ||
428: ' avalue => :l_text);end;';

Line 432: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

428: ' avalue => :l_text);end;';
429: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
430:
431: --EXCEPTION_ID
432: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
433: itemkey => itemkey,
434: aname => 'EXCEPTION_ID');
435: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
436: '(itemtype => :item_type,' ||

Line 435: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

431: --EXCEPTION_ID
432: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
433: itemkey => itemkey,
434: aname => 'EXCEPTION_ID');
435: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
436: '(itemtype => :item_type,' ||
437: ' itemkey => :item_key,' ||
438: ' aname => ''EXCEPTION_ID'',' ||
439: ' avalue => :l_numb);end;';

Line 443: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,

439: ' avalue => :l_numb);end;';
440: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
441:
442: -- FROM_DATE
443: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'FROM_DATE');
446: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
447: '(itemtype => :item_type,' ||

Line 446: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||

442: -- FROM_DATE
443: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'FROM_DATE');
446: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
447: '(itemtype => :item_type,' ||
448: ' itemkey => :item_key,' ||
449: ' aname => ''FROM_DATE'',' ||
450: ' avalue => :l_date);end;';

Line 454: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

450: ' avalue => :l_date);end;';
451: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_date;
452:
453: -- FROM_PRJ_MGR
454: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
455: itemkey => itemkey,
456: aname => 'FROM_PRJ_MGR');
457: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
458: '(itemtype => :item_type,' ||

Line 457: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

453: -- FROM_PRJ_MGR
454: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
455: itemkey => itemkey,
456: aname => 'FROM_PRJ_MGR');
457: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
458: '(itemtype => :item_type,' ||
459: ' itemkey => :item_key,' ||
460: ' aname => ''FROM_PRJ_MGR'',' ||
461: ' avalue => :l_text);end;';

Line 465: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

461: ' avalue => :l_text);end;';
462: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
463:
464: --INSTANCE_ID
465: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'INSTANCE_ID');
468: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
469: '(itemtype => :item_type,' ||

Line 468: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

464: --INSTANCE_ID
465: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'INSTANCE_ID');
468: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
469: '(itemtype => :item_type,' ||
470: ' itemkey => :item_key,' ||
471: ' aname => ''INSTANCE_ID'',' ||
472: ' avalue => :l_numb);end;';

Line 476: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

472: ' avalue => :l_numb);end;';
473: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
474:
475: --INVENTORY_ITEM_ID
476: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
477: itemkey => itemkey,
478: aname => 'INVENTORY_ITEM_ID');
479: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
480: '(itemtype => :item_type,' ||

Line 479: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

475: --INVENTORY_ITEM_ID
476: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
477: itemkey => itemkey,
478: aname => 'INVENTORY_ITEM_ID');
479: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
480: '(itemtype => :item_type,' ||
481: ' itemkey => :item_key,' ||
482: ' aname => ''INVENTORY_ITEM_ID'',' ||
483: ' avalue => :l_numb);end;';

Line 487: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

483: ' avalue => :l_numb);end;';
484: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
485:
486: --IS_CALL_BACK
487: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
488: '(itemtype => :item_type,' ||
489: ' itemkey => :item_key,' ||
490: ' aname => ''IS_CALL_BACK'',' ||
491: ' avalue => ''Y'');end;';

Line 495: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

491: ' avalue => ''Y'');end;';
492: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key;
493:
494: -- ITEM_DISPLAY_NAME
495: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'ITEM_DISPLAY_NAME');
498: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
499: '(itemtype => :item_type,' ||

Line 498: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

494: -- ITEM_DISPLAY_NAME
495: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'ITEM_DISPLAY_NAME');
498: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
499: '(itemtype => :item_type,' ||
500: ' itemkey => :item_key,' ||
501: ' aname => ''ITEM_DISPLAY_NAME'',' ||
502: ' avalue => :l_text);end;';

Line 506: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

502: ' avalue => :l_text);end;';
503: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
504:
505: -- ITEM_DESCRIPTION
506: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
507: itemkey => itemkey,
508: aname => 'ITEM_DESCRIPTION');
509: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
510: '(itemtype => :item_type,' ||

Line 509: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

505: -- ITEM_DESCRIPTION
506: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
507: itemkey => itemkey,
508: aname => 'ITEM_DESCRIPTION');
509: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
510: '(itemtype => :item_type,' ||
511: ' itemkey => :item_key,' ||
512: ' aname => ''ITEM_DESCRIPTION'',' ||
513: ' avalue => :l_text);end;';

Line 517: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

513: ' avalue => :l_text);end;';
514: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
515:
516: -- LOT_NUMBER
517: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
518: itemkey => itemkey,
519: aname => 'LOT_NUMBER');
520: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
521: '(itemtype => :item_type,' ||

Line 520: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

516: -- LOT_NUMBER
517: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
518: itemkey => itemkey,
519: aname => 'LOT_NUMBER');
520: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
521: '(itemtype => :item_type,' ||
522: ' itemkey => :item_key,' ||
523: ' aname => ''LOT_NUMBER'',' ||
524: ' avalue => :l_text);end;';

Line 528: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

524: ' avalue => :l_text);end;';
525: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
526:
527: -- ORDER_NUMBER
528: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
529: itemkey => itemkey,
530: aname => 'ORDER_NUMBER');
531: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
532: '(itemtype => :item_type,' ||

Line 531: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

527: -- ORDER_NUMBER
528: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
529: itemkey => itemkey,
530: aname => 'ORDER_NUMBER');
531: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
532: '(itemtype => :item_type,' ||
533: ' itemkey => :item_key,' ||
534: ' aname => ''ORDER_NUMBER'',' ||
535: ' avalue => :l_text);end;';

Line 539: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

535: ' avalue => :l_text);end;';
536: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
537:
538: -- ORDER_TYPE_CODE
539: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
540: itemkey => itemkey,
541: aname => 'ORDER_TYPE_CODE');
542: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
543: '(itemtype => :item_type,' ||

Line 542: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

538: -- ORDER_TYPE_CODE
539: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
540: itemkey => itemkey,
541: aname => 'ORDER_TYPE_CODE');
542: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
543: '(itemtype => :item_type,' ||
544: ' itemkey => :item_key,' ||
545: ' aname => ''ORDER_TYPE_CODE'',' ||
546: ' avalue => :l_numb);end;';

Line 550: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

546: ' avalue => :l_numb);end;';
547: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
548:
549: -- ORGANIZATION_CODE
550: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'ORGANIZATION_CODE');
553: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
554: '(itemtype => :item_type,' ||

Line 553: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

549: -- ORGANIZATION_CODE
550: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'ORGANIZATION_CODE');
553: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
554: '(itemtype => :item_type,' ||
555: ' itemkey => :item_key,' ||
556: ' aname => ''ORGANIZATION_CODE'',' ||
557: ' avalue => :l_text);end;';

Line 561: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

557: ' avalue => :l_text);end;';
558: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
559:
560: --ORGANIZATION_ID
561: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'ORGANIZATION_ID');
564: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
565: '(itemtype => :item_type,' ||

Line 564: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

560: --ORGANIZATION_ID
561: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'ORGANIZATION_ID');
564: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
565: '(itemtype => :item_type,' ||
566: ' itemkey => :item_key,' ||
567: ' aname => ''ORGANIZATION_ID'',' ||
568: ' avalue => :l_numb);end;';

Line 572: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

568: ' avalue => :l_numb);end;';
569: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
570:
571: --PLAN_ID
572: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'PLAN_ID');
575: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
576: '(itemtype => :item_type,' ||

Line 575: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

571: --PLAN_ID
572: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'PLAN_ID');
575: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
576: '(itemtype => :item_type,' ||
577: ' itemkey => :item_key,' ||
578: ' aname => ''PLAN_ID'',' ||
579: ' avalue => :l_numb);end;';

Line 583: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

579: ' avalue => :l_numb);end;';
580: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
581:
582: -- PLAN_NAME
583: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
584: itemkey => itemkey,
585: aname => 'PLAN_NAME');
586: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
587: '(itemtype => :item_type,' ||

Line 586: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

582: -- PLAN_NAME
583: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
584: itemkey => itemkey,
585: aname => 'PLAN_NAME');
586: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
587: '(itemtype => :item_type,' ||
588: ' itemkey => :item_key,' ||
589: ' aname => ''PLAN_NAME'',' ||
590: ' avalue => :l_text);end;';

Line 594: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

590: ' avalue => :l_text);end;';
591: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
592:
593: -- PLANNER
594: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
595: itemkey => itemkey,
596: aname => 'PLANNER');
597: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
598: '(itemtype => :item_type,' ||

Line 597: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

593: -- PLANNER
594: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
595: itemkey => itemkey,
596: aname => 'PLANNER');
597: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
598: '(itemtype => :item_type,' ||
599: ' itemkey => :item_key,' ||
600: ' aname => ''PLANNER'',' ||
601: ' avalue => :l_text);end;';

Line 605: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

601: ' avalue => :l_text);end;';
602: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
603:
604: -- PLANNING_GROUP
605: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
606: itemkey => itemkey,
607: aname => 'PLANNING_GROUP');
608: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
609: '(itemtype => :item_type,' ||

Line 608: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

604: -- PLANNING_GROUP
605: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
606: itemkey => itemkey,
607: aname => 'PLANNING_GROUP');
608: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
609: '(itemtype => :item_type,' ||
610: ' itemkey => :item_key,' ||
611: ' aname => ''PLANNING_GROUP'',' ||
612: ' avalue => :l_text);end;';

Line 616: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

612: ' avalue => :l_text);end;';
613: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
614:
615: -- PROJECT_NUMBER
616: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
617: itemkey => itemkey,
618: aname => 'PROJECT_NUMBER');
619: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
620: '(itemtype => :item_type,' ||

Line 619: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

615: -- PROJECT_NUMBER
616: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
617: itemkey => itemkey,
618: aname => 'PROJECT_NUMBER');
619: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
620: '(itemtype => :item_type,' ||
621: ' itemkey => :item_key,' ||
622: ' aname => ''PROJECT_NUMBER'',' ||
623: ' avalue => :l_text);end;';

Line 627: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

623: ' avalue => :l_text);end;';
624: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
625:
626: --PRE_PROCESSING_LEAD_TIME
627: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
628: itemkey => itemkey,
629: aname => 'PRE_PRSNG_LEAD_TIME');
630: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
631: '(itemtype => :item_type,' ||

Line 630: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

626: --PRE_PROCESSING_LEAD_TIME
627: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
628: itemkey => itemkey,
629: aname => 'PRE_PRSNG_LEAD_TIME');
630: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
631: '(itemtype => :item_type,' ||
632: ' itemkey => :item_key,' ||
633: ' aname => ''PRE_PRSNG_LEAD_TIME'',' ||
634: ' avalue => :l_text);end;';

Line 638: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

634: ' avalue => :l_text);end;';
635: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
636:
637: -- PROCESSING_LEAD_TIME
638: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'PRSNG_LEAD_TIME');
641: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
642: '(itemtype => :item_type,' ||

Line 641: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

637: -- PROCESSING_LEAD_TIME
638: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'PRSNG_LEAD_TIME');
641: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
642: '(itemtype => :item_type,' ||
643: ' itemkey => :item_key,' ||
644: ' aname => ''PRSNG_LEAD_TIME'',' ||
645: ' avalue => :l_text);end;';

Line 649: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

645: ' avalue => :l_text);end;';
646: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
647:
648: -- POST_PROCESSING_LEAD_TIME
649: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'POST_PRSNG_LEAD_TIME');
652: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
653: '(itemtype => :item_type,' ||

Line 652: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

648: -- POST_PROCESSING_LEAD_TIME
649: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'POST_PRSNG_LEAD_TIME');
652: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
653: '(itemtype => :item_type,' ||
654: ' itemkey => :item_key,' ||
655: ' aname => ''POST_PRSNG_LEAD_TIME'',' ||
656: ' avalue => :l_text);end;';

Line 661: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

657: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
658:
659:
660: -- QUANTITY
661: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
662: itemkey => itemkey,
663: aname => 'QUANTITY');
664: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
665: '(itemtype => :item_type,' ||

Line 664: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

660: -- QUANTITY
661: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
662: itemkey => itemkey,
663: aname => 'QUANTITY');
664: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
665: '(itemtype => :item_type,' ||
666: ' itemkey => :item_key,' ||
667: ' aname => ''QUANTITY'',' ||
668: ' avalue => :l_text);end;';

Line 672: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

668: ' avalue => :l_text);end;';
669: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
670:
671: -- RESOURCE_CODE
672: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'RESOURCE_CODE');
675: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
676: '(itemtype => :item_type,' ||

Line 675: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

671: -- RESOURCE_CODE
672: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'RESOURCE_CODE');
675: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
676: '(itemtype => :item_type,' ||
677: ' itemkey => :item_key,' ||
678: ' aname => ''RESOURCE_CODE'',' ||
679: ' avalue => :l_text);end;';

Line 683: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

679: ' avalue => :l_text);end;';
680: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
681:
682: -- SUPCNT
683: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'SUPCNT');
686: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
687: '(itemtype => :item_type,' ||

Line 686: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

682: -- SUPCNT
683: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'SUPCNT');
686: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
687: '(itemtype => :item_type,' ||
688: ' itemkey => :item_key,' ||
689: ' aname => ''SUPCNT'',' ||
690: ' avalue => :l_text);end;';

Line 694: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

690: ' avalue => :l_text);end;';
691: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
692:
693: --SUPPLIER_ID
694: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'SUPPLIER_ID');
697: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
698: '(itemtype => :item_type,' ||

Line 697: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

693: --SUPPLIER_ID
694: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'SUPPLIER_ID');
697: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
698: '(itemtype => :item_type,' ||
699: ' itemkey => :item_key,' ||
700: ' aname => ''SUPPLIER_ID'',' ||
701: ' avalue => :l_numb);end;';

Line 705: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

701: ' avalue => :l_numb);end;';
702: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
703:
704: -- SUPPLIER_NAME
705: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'SUPPLIER_NAME');
708: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
709: '(itemtype => :item_type,' ||

Line 708: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

704: -- SUPPLIER_NAME
705: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'SUPPLIER_NAME');
708: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
709: '(itemtype => :item_type,' ||
710: ' itemkey => :item_key,' ||
711: ' aname => ''SUPPLIER_NAME'',' ||
712: ' avalue => :l_text);end;';

Line 716: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

712: ' avalue => :l_text);end;';
713: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
714:
715: -- SUPPLIER_SITE_CODE
716: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
717: itemkey => itemkey,
718: aname => 'SUPPLIER_SITE_CODE');
719: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
720: '(itemtype => :item_type,' ||

Line 719: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

715: -- SUPPLIER_SITE_CODE
716: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
717: itemkey => itemkey,
718: aname => 'SUPPLIER_SITE_CODE');
719: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
720: '(itemtype => :item_type,' ||
721: ' itemkey => :item_key,' ||
722: ' aname => ''SUPPLIER_SITE_CODE'',' ||
723: ' avalue => :l_text);end;';

Line 727: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

723: ' avalue => :l_text);end;';
724: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
725:
726: --SUPPLIER_SITE_ID
727: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'SUPPLIER_SITE_ID');
730: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
731: '(itemtype => :item_type,' ||

Line 730: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

726: --SUPPLIER_SITE_ID
727: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'SUPPLIER_SITE_ID');
730: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
731: '(itemtype => :item_type,' ||
732: ' itemkey => :item_key,' ||
733: ' aname => ''SUPPLIER_SITE_ID'',' ||
734: ' avalue => :l_numb);end;';

Line 738: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

734: ' avalue => :l_numb);end;';
735: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
736:
737: -- SUPPLY_TYPE
738: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
739: itemkey => itemkey,
740: aname => 'SUPPLY_TYPE');
741: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
742: '(itemtype => :item_type,' ||

Line 741: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

737: -- SUPPLY_TYPE
738: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
739: itemkey => itemkey,
740: aname => 'SUPPLY_TYPE');
741: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
742: '(itemtype => :item_type,' ||
743: ' itemkey => :item_key,' ||
744: ' aname => ''SUPPLY_TYPE'',' ||
745: ' avalue => :l_text);end;';

Line 749: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

745: ' avalue => :l_text);end;';
746: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
747:
748: -- TASK_NUMBER
749: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
750: itemkey => itemkey,
751: aname => 'TASK_NUMBER');
752: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
753: '(itemtype => :item_type,' ||

Line 752: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

748: -- TASK_NUMBER
749: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
750: itemkey => itemkey,
751: aname => 'TASK_NUMBER');
752: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
753: '(itemtype => :item_type,' ||
754: ' itemkey => :item_key,' ||
755: ' aname => ''TASK_NUMBER'',' ||
756: ' avalue => :l_text);end;';

Line 760: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,

756: ' avalue => :l_text);end;';
757: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
758:
759: -- TO_DATE
760: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
761: itemkey => itemkey,
762: aname => 'TO_DATE');
763: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
764: '(itemtype => :item_type,' ||

Line 763: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||

759: -- TO_DATE
760: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
761: itemkey => itemkey,
762: aname => 'TO_DATE');
763: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
764: '(itemtype => :item_type,' ||
765: ' itemkey => :item_key,' ||
766: ' aname => ''TO_DATE'',' ||
767: ' avalue => :l_date);end;';

Line 771: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

767: ' avalue => :l_date);end;';
768: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_date;
769:
770: -- TO_PRJ_MGR
771: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'TO_PRJ_MGR');
774: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
775: '(itemtype => :item_type,' ||

Line 774: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

770: -- TO_PRJ_MGR
771: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'TO_PRJ_MGR');
774: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
775: '(itemtype => :item_type,' ||
776: ' itemkey => :item_key,' ||
777: ' aname => ''TO_PRJ_MGR'',' ||
778: ' avalue => :l_text);end;';

Line 782: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

778: ' avalue => :l_text);end;';
779: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
780:
781: -- TO_PROJECT_NUMBER
782: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
783: itemkey => itemkey,
784: aname => 'TO_PROJECT_NUMBER');
785: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
786: '(itemtype => :item_type,' ||

Line 785: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

781: -- TO_PROJECT_NUMBER
782: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
783: itemkey => itemkey,
784: aname => 'TO_PROJECT_NUMBER');
785: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
786: '(itemtype => :item_type,' ||
787: ' itemkey => :item_key,' ||
788: ' aname => ''TO_PROJECT_NUMBER'',' ||
789: ' avalue => :l_text);end;';

Line 793: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

789: ' avalue => :l_text);end;';
790: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
791:
792: -- TO_TASK_NUMBER
793: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
794: itemkey => itemkey,
795: aname => 'TO_TASK_NUMBER');
796: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
797: '(itemtype => :item_type,' ||

Line 796: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

792: -- TO_TASK_NUMBER
793: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
794: itemkey => itemkey,
795: aname => 'TO_TASK_NUMBER');
796: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
797: '(itemtype => :item_type,' ||
798: ' itemkey => :item_key,' ||
799: ' aname => ''TO_TASK_NUMBER'',' ||
800: ' avalue => :l_text);end;';

Line 804: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,

800: ' avalue => :l_text);end;';
801: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
802:
803: -- URL1
804: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'URL1');
807: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
808: '(itemtype => :item_type,' ||

Line 807: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||

803: -- URL1
804: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'URL1');
807: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
808: '(itemtype => :item_type,' ||
809: ' itemkey => :item_key,' ||
810: ' aname => ''URL1'',' ||
811: ' avalue => :l_text);end;';

Line 815: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

811: ' avalue => :l_text);end;';
812: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_text;
813:
814: -- UTILIZATION_RATE
815: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
816: itemkey => itemkey,
817: aname => 'UTILIZATION_RATE');
818: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
819: '(itemtype => :item_type,' ||

Line 818: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

814: -- UTILIZATION_RATE
815: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
816: itemkey => itemkey,
817: aname => 'UTILIZATION_RATE');
818: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
819: '(itemtype => :item_type,' ||
820: ' itemkey => :item_key,' ||
821: ' aname => ''UTILIZATION_RATE'',' ||
822: ' avalue => :l_numb);end;';

Line 826: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

822: ' avalue => :l_numb);end;';
823: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
824:
825: -- CAPACITY_REQUIREMENT
826: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
827: itemkey => itemkey,
828: aname => 'CAPACITY_REQUIREMENT');
829: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
830: '(itemtype => :item_type,' ||

Line 829: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

825: -- CAPACITY_REQUIREMENT
826: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
827: itemkey => itemkey,
828: aname => 'CAPACITY_REQUIREMENT');
829: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
830: '(itemtype => :item_type,' ||
831: ' itemkey => :item_key,' ||
832: ' aname => ''CAPACITY_REQUIREMENT'',' ||
833: ' avalue => :l_numb);end;';

Line 837: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

833: ' avalue => :l_numb);end;';
834: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
835:
836: -- REQUIRED_QUANTITY
837: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'REQUIRED_QUANTITY');
840: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
841: '(itemtype => :item_type,' ||

Line 840: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

836: -- REQUIRED_QUANTITY
837: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'REQUIRED_QUANTITY');
840: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
841: '(itemtype => :item_type,' ||
842: ' itemkey => :item_key,' ||
843: ' aname => ''REQUIRED_QUANTITY'',' ||
844: ' avalue => :l_numb);end;';

Line 848: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

844: ' avalue => :l_numb);end;';
845: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
846:
847: -- PROJECTED_AVAILABLE_BALANCE
848: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
849: itemkey => itemkey,
850: aname => 'PROJECTED_AVAILABLE_BALANCE');
851: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
852: '(itemtype => :item_type,' ||

Line 851: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

847: -- PROJECTED_AVAILABLE_BALANCE
848: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
849: itemkey => itemkey,
850: aname => 'PROJECTED_AVAILABLE_BALANCE');
851: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
852: '(itemtype => :item_type,' ||
853: ' itemkey => :item_key,' ||
854: ' aname => ''PROJECTED_AVAILABLE_BALANCE'',' ||
855: ' avalue => :l_numb);end;';

Line 859: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

855: ' avalue => :l_numb);end;';
856: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
857:
858: -- AVAILABLE_QUANTITY
859: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
860: itemkey => itemkey,
861: aname => 'AVAILABLE_QUANTITY');
862: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
863: '(itemtype => :item_type,' ||

Line 862: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

858: -- AVAILABLE_QUANTITY
859: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
860: itemkey => itemkey,
861: aname => 'AVAILABLE_QUANTITY');
862: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
863: '(itemtype => :item_type,' ||
864: ' itemkey => :item_key,' ||
865: ' aname => ''AVAILABLE_QUANTITY'',' ||
866: ' avalue => :l_numb);end;';

Line 870: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,

866: ' avalue => :l_numb);end;';
867: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
868:
869: -- QTY_RELATED_VALUES
870: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'QTY_RELATED_VALUES');
873: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
874: '(itemtype => :item_type,' ||

Line 873: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||

869: -- QTY_RELATED_VALUES
870: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'QTY_RELATED_VALUES');
873: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
874: '(itemtype => :item_type,' ||
875: ' itemkey => :item_key,' ||
876: ' aname => ''QTY_RELATED_VALUES'',' ||
877: ' avalue => :l_numb);end;';

Line 880: wf_engine.SetItemAttrNumber( itemtype => itemtype,

876: ' aname => ''QTY_RELATED_VALUES'',' ||
877: ' avalue => :l_numb);end;';
878: EXECUTE IMMEDIATE sql_stmt USING l_dest_item_type,l_dest_item_key,l_numb;
879:
880: wf_engine.SetItemAttrNumber( itemtype => itemtype,
881: itemkey => itemkey,
882: aname => 'REQUEST_ID',
883: avalue => p_request_id);
884:

Line 1113: wf_engine.StartProcess( itemtype => p_item_type,

1109:
1110: FND_FILE.PUT_LINE(FND_FILE.LOG,
1111: 'key='||p_item_key);
1112:
1113: wf_engine.StartProcess( itemtype => p_item_type,
1114: itemkey => p_item_key);
1115:
1116: FND_FILE.PUT_LINE(FND_FILE.LOG,
1117: 'done for'||p_item_type);

Line 1139: wf_engine.CreateProcess( itemtype => item_type,

1135: select to_char(mrp_form_query_s.nextval)
1136: into item_key
1137: from dual;
1138:
1139: wf_engine.CreateProcess( itemtype => item_type,
1140: itemkey => item_key,
1141: process => l_process);
1142:
1143: wf_engine.SetItemAttrNumber( itemtype => item_type,

Line 1143: wf_engine.SetItemAttrNumber( itemtype => item_type,

1139: wf_engine.CreateProcess( itemtype => item_type,
1140: itemkey => item_key,
1141: process => l_process);
1142:
1143: wf_engine.SetItemAttrNumber( itemtype => item_type,
1144: itemkey => item_key,
1145: aname => 'EXCEPTION_TYPE_ID',
1146: avalue => 49);
1147:

Line 1148: wf_engine.SetItemAttrText( itemtype => item_type,

1144: itemkey => item_key,
1145: aname => 'EXCEPTION_TYPE_ID',
1146: avalue => 49);
1147:
1148: wf_engine.SetItemAttrText( itemtype => item_type,
1149: itemkey => item_key,
1150: aname => 'ORGANIZATION_CODE',
1151: avalue => org_code);
1152: wf_engine.SetItemAttrText( itemtype => item_type,

Line 1152: wf_engine.SetItemAttrText( itemtype => item_type,

1148: wf_engine.SetItemAttrText( itemtype => item_type,
1149: itemkey => item_key,
1150: aname => 'ORGANIZATION_CODE',
1151: avalue => org_code);
1152: wf_engine.SetItemAttrText( itemtype => item_type,
1153: itemkey => item_key,
1154: aname => 'ITEM_DISPLAY_NAME',
1155: avalue => from_item);
1156: wf_engine.SetItemAttrText( itemtype => item_type,

Line 1156: wf_engine.SetItemAttrText( itemtype => item_type,

1152: wf_engine.SetItemAttrText( itemtype => item_type,
1153: itemkey => item_key,
1154: aname => 'ITEM_DISPLAY_NAME',
1155: avalue => from_item);
1156: wf_engine.SetItemAttrText( itemtype => item_type,
1157: itemkey => item_key,
1158: aname => 'EXCEPTION_DESCRIPTION',
1159: avalue => p_text);
1160:

Line 1161: wf_engine.SetItemAttrText( itemtype => item_type,

1157: itemkey => item_key,
1158: aname => 'EXCEPTION_DESCRIPTION',
1159: avalue => p_text);
1160:
1161: wf_engine.SetItemAttrText( itemtype => item_type,
1162: itemkey => item_key,
1163: aname => 'QUANTITY',
1164: avalue => quantity);
1165:

Line 1166: wf_engine.SetItemAttrText( itemtype => item_type,

1162: itemkey => item_key,
1163: aname => 'QUANTITY',
1164: avalue => quantity);
1165:
1166: wf_engine.SetItemAttrText( itemtype => item_type,
1167: itemkey => item_key,
1168: aname => 'END_ITEM_DISPLAY_NAME',
1169: avalue => substitute_item);
1170:

Line 1171: wf_engine.SetItemAttrText( itemtype => item_type,

1167: itemkey => item_key,
1168: aname => 'END_ITEM_DISPLAY_NAME',
1169: avalue => substitute_item);
1170:
1171: wf_engine.SetItemAttrText( itemtype => item_type,
1172: itemkey => item_key,
1173: aname => 'END_ORDER_NUMBER',
1174: avalue => order_number);
1175:

Line 1176: wf_engine.SetItemAttrText( itemtype => item_type,

1172: itemkey => item_key,
1173: aname => 'END_ORDER_NUMBER',
1174: avalue => order_number);
1175:
1176: wf_engine.SetItemAttrText( itemtype => item_type,
1177: itemkey => item_key,
1178: aname => 'RESOURCE_CODE',
1179: avalue => substitute_org);
1180:

Line 1181: wf_engine.SetItemAttrNumber( itemtype => item_type,

1177: itemkey => item_key,
1178: aname => 'RESOURCE_CODE',
1179: avalue => substitute_org);
1180:
1181: wf_engine.SetItemAttrNumber( itemtype => item_type,
1182: itemkey => item_key,
1183: aname => 'UTILIZATION_RATE',
1184: avalue => substitute_qty);
1185:

Line 1186: wf_engine.setItemAttrText( itemtype => item_type,

1182: itemkey => item_key,
1183: aname => 'UTILIZATION_RATE',
1184: avalue => substitute_qty);
1185:
1186: wf_engine.setItemAttrText( itemtype => item_type,
1187: itemkey => item_key,
1188: aname => 'CUSTCNT',
1189: avalue => customer_contact);
1190:

Line 1191: wf_engine.setItemAttrText( itemtype => item_type,

1187: itemkey => item_key,
1188: aname => 'CUSTCNT',
1189: avalue => customer_contact);
1190:
1191: wf_engine.setItemAttrText( itemtype => item_type,
1192: itemkey => item_key,
1193: aname => 'SALESREP',
1194: avalue => sales_rep);
1195:

Line 1196: wf_engine.StartProcess( itemtype => item_type,

1192: itemkey => item_key,
1193: aname => 'SALESREP',
1194: avalue => sales_rep);
1195:
1196: wf_engine.StartProcess( itemtype => item_type,
1197: itemkey => item_key);
1198:
1199:
1200: END start_substitute_workflow;