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.MSDWF dependencies on WF_ENGINE

Line 40: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,

36: SELECT ACTIVITY_NAME, PROCESS_NAME INTO ActEntry, Process FROM WF_PROCESS_ACTIVITIES
37: WHERE INSTANCE_ID=actid;
38: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
39: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
40: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,
41: Itemkey => ItemKey,
42: aname => 'EXPCONN');
43:
44: -- new to indicate if ODP Master is governing Cycle

Line 45: Master:=wf_engine.GetItemAttrText(Itemtype => ItemType,

41: Itemkey => ItemKey,
42: aname => 'EXPCONN');
43:
44: -- new to indicate if ODP Master is governing Cycle
45: Master:=wf_engine.GetItemAttrText(Itemtype => ItemType,
46: Itemkey => ItemKey,
47: aname => 'ISMASTER');
48:
49: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,

Line 49: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,

45: Master:=wf_engine.GetItemAttrText(Itemtype => ItemType,
46: Itemkey => ItemKey,
47: aname => 'ISMASTER');
48:
49: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,
50: Itemkey => ItemKey,
51: aname => 'DBNAME');
52: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
53: Itemkey => ItemKey,

Line 52: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,

48:
49: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,
50: Itemkey => ItemKey,
51: aname => 'DBNAME');
52: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
53: Itemkey => ItemKey,
54: aname => 'DPADMIN');
55: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
56: Itemkey => ItemKey,

Line 55: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,

51: aname => 'DBNAME');
52: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
53: Itemkey => ItemKey,
54: aname => 'DPADMIN');
55: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
56: Itemkey => ItemKey,
57: aname => 'SHAREDLOC');
58: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
59: Itemkey => ItemKey,

Line 58: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,

54: aname => 'DPADMIN');
55: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
56: Itemkey => ItemKey,
57: aname => 'SHAREDLOC');
58: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
59: Itemkey => ItemKey,
60: aname => 'CODELOC');
61: PlanID:=wf_engine.GetItemAttrText(Itemtype => ItemType,
62: Itemkey => ItemKey,

Line 61: PlanID:=wf_engine.GetItemAttrText(Itemtype => ItemType,

57: aname => 'SHAREDLOC');
58: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
59: Itemkey => ItemKey,
60: aname => 'CODELOC');
61: PlanID:=wf_engine.GetItemAttrText(Itemtype => ItemType,
62: Itemkey => ItemKey,
63: aname => 'ODPPLAN');
64: SELECT C0, C1, C2, C3
65: into ActRetCode, ActRetText, ActRetVal, ActRetErr

Line 100: wf_engine.SetItemAttrDate(Itemtype => ItemType,

96: then
97: TxtDate := to_char(sysdate, 'YY MM DD');
98: TempDate := to_date(TxtDate, 'YY MM DD');
99: -- obsolete agb 6/14/00 TempDate := sysdate;
100: wf_engine.SetItemAttrDate(Itemtype => ItemType,
101: Itemkey => ItemKey,
102: aname => 'VALUE1',
103: avalue => TempDate);
104: end if;

Line 115: wf_engine.SetItemAttrDate(Itemtype => ItemType,

111: then
112: TxtDate := to_char(sysdate, 'YY MM DD');
113: TempDate := to_date(TxtDate, 'YY MM DD');
114: -- obsolete agb 6/14/00 TempDate := sysdate;
115: wf_engine.SetItemAttrDate(Itemtype => ItemType,
116: Itemkey => ItemKey,
117: aname => 'VALUE1',
118: avalue => TempDate);
119: end if;

Line 135: wf_engine.SetItemAttrText(Itemtype => ItemType,

131: end if;
132: if ActRetCode = 'Y' then
133: if ActEntry = 'ODPDIST'
134: then
135: wf_engine.SetItemAttrText(Itemtype => ItemType,
136: Itemkey => ItemKey,
137: aname => 'ASSIGNID',
138: avalue => ActRetVal);
139: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 139: wf_engine.SetItemAttrText(Itemtype => ItemType,

135: wf_engine.SetItemAttrText(Itemtype => ItemType,
136: Itemkey => ItemKey,
137: aname => 'ASSIGNID',
138: avalue => ActRetVal);
139: wf_engine.SetItemAttrText(Itemtype => ItemType,
140: Itemkey => ItemKey,
141: aname => 'ASSIGNNAME',
142: avalue => ActRetText);
143: end if;

Line 147: wf_engine.SetItemAttrText(Itemtype => ItemType,

143: end if;
144:
145: end if;
146: if ActRetCode = 'N' then
147: wf_engine.SetItemAttrText(Itemtype => ItemType,
148: Itemkey => ItemKey,
149: aname => 'DPPROBLEM',
150: avalue => ActRetErr);
151: end if;

Line 179: wf_engine.CreateProcess(ItemType => ItemType,

175: shared_db_location, express_connect_string INTO PlName,
176: CodeLoc, DBName, SharedLoc, express_server
177: from msd_demand_plans_v
178: where demand_plan_id=to_number(inPlan);
179: wf_engine.CreateProcess(ItemType => ItemType,
180: itemKey => ItemKey,
181: process => WorkflowProcess);
182: -- The sysinfo(user that launched the process or the Owner of the process.
183: -- This would be the demand planning administrator.

Line 184: wf_engine.SetItemOwner(ItemType => ItemType,

180: itemKey => ItemKey,
181: process => WorkflowProcess);
182: -- The sysinfo(user that launched the process or the Owner of the process.
183: -- This would be the demand planning administrator.
184: wf_engine.SetItemOwner(ItemType => ItemType,
185: ItemKey => ItemKey,
186: owner => owner);
187: wf_engine.SetItemAttrText(Itemtype => ItemType,
188: Itemkey => ItemKey,

Line 187: wf_engine.SetItemAttrText(Itemtype => ItemType,

183: -- This would be the demand planning administrator.
184: wf_engine.SetItemOwner(ItemType => ItemType,
185: ItemKey => ItemKey,
186: owner => owner);
187: wf_engine.SetItemAttrText(Itemtype => ItemType,
188: Itemkey => ItemKey,
189: aname => 'DPADMIN',
190: avalue => owner);
191: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 191: wf_engine.SetItemAttrText(Itemtype => ItemType,

187: wf_engine.SetItemAttrText(Itemtype => ItemType,
188: Itemkey => ItemKey,
189: aname => 'DPADMIN',
190: avalue => owner);
191: wf_engine.SetItemAttrText(Itemtype => ItemType,
192: Itemkey => ItemKey,
193: aname => 'ODPROLE',
194: avalue => inrole);
195: -- Plan ID!

Line 196: wf_engine.SetItemAttrText(Itemtype => ItemType,

192: Itemkey => ItemKey,
193: aname => 'ODPROLE',
194: avalue => inrole);
195: -- Plan ID!
196: wf_engine.SetItemAttrText(Itemtype => ItemType,
197: Itemkey => ItemKey,
198: aname => 'ODPPLAN',
199: avalue => inplan);
200: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 200: wf_engine.SetItemAttrText(Itemtype => ItemType,

196: wf_engine.SetItemAttrText(Itemtype => ItemType,
197: Itemkey => ItemKey,
198: aname => 'ODPPLAN',
199: avalue => inplan);
200: wf_engine.SetItemAttrText(Itemtype => ItemType,
201: Itemkey => ItemKey,
202: aname => 'PLNAME',
203: avalue => PlName);
204: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 204: wf_engine.SetItemAttrText(Itemtype => ItemType,

200: wf_engine.SetItemAttrText(Itemtype => ItemType,
201: Itemkey => ItemKey,
202: aname => 'PLNAME',
203: avalue => PlName);
204: wf_engine.SetItemAttrText(Itemtype => ItemType,
205: Itemkey => ItemKey,
206: aname => 'CODELOC',
207: avalue => CodeLoc);
208: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 208: wf_engine.SetItemAttrText(Itemtype => ItemType,

204: wf_engine.SetItemAttrText(Itemtype => ItemType,
205: Itemkey => ItemKey,
206: aname => 'CODELOC',
207: avalue => CodeLoc);
208: wf_engine.SetItemAttrText(Itemtype => ItemType,
209: Itemkey => ItemKey,
210: aname => 'DBNAME',
211: avalue => DBName);
212: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 212: wf_engine.SetItemAttrText(Itemtype => ItemType,

208: wf_engine.SetItemAttrText(Itemtype => ItemType,
209: Itemkey => ItemKey,
210: aname => 'DBNAME',
211: avalue => DBName);
212: wf_engine.SetItemAttrText(Itemtype => ItemType,
213: Itemkey => ItemKey,
214: aname => 'SHAREDLOC',
215: avalue => SharedLoc);
216: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 216: wf_engine.SetItemAttrText(Itemtype => ItemType,

212: wf_engine.SetItemAttrText(Itemtype => ItemType,
213: Itemkey => ItemKey,
214: aname => 'SHAREDLOC',
215: avalue => SharedLoc);
216: wf_engine.SetItemAttrText(Itemtype => ItemType,
217: Itemkey => ItemKey,
218: aname => 'EXPCONN',
219: avalue => express_server);
220: if WorkflowProcess = 'ODPSTDCOL'

Line 223: wf_engine.SetItemAttrDate(Itemtype => ItemType,

219: avalue => express_server);
220: if WorkflowProcess = 'ODPSTDCOL'
221: then
222: CompDate:= to_date(inCDate, 'YY MM DD');
223: wf_engine.SetItemAttrDate(Itemtype => ItemType,
224: Itemkey => ItemKey,
225: aname => 'VALUE2',
226: avalue => CompDate);
227: end if;

Line 236: wf_engine.SetItemAttrNumber(Itemtype => ItemType,

232: select count(value) into FixedDate from v$parameter
233: where name like '%fixed_date%' AND length(VALUE) > 0;
234: if FixedDate > 0
235: then
236: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
237: Itemkey => ItemKey,
238: aname => 'WAIT_RELATIVE_TIME',
239: avalue => NULL);
240: end if;

Line 243: wf_engine.StartProcess(ItemType => ItemType,

239: avalue => NULL);
240: end if;
241: end if;
242:
243: wf_engine.StartProcess(ItemType => ItemType,
244: ItemKey => ItemKey);
245: return;
246: exception
247: when others then

Line 278: LaunchMgr:=wf_engine.GetItemAttrText(Itemtype => ItemType,

274: -- DONE means all DB Assignments are complete.
275: -- CYCLE means keep processing.
276: -- This is set upon the start of the process.
277: -- This is set by MSDWF.GOVERNOR.
278: LaunchMgr:=wf_engine.GetItemAttrText(Itemtype => ItemType,
279: Itemkey => ItemKey,
280: aname => 'LAUNCHMGR');
281: PlanID:=wf_engine.GetItemAttrText(Itemtype => ItemType,
282: Itemkey => ItemKey,

Line 281: PlanID:=wf_engine.GetItemAttrText(Itemtype => ItemType,

277: -- This is set by MSDWF.GOVERNOR.
278: LaunchMgr:=wf_engine.GetItemAttrText(Itemtype => ItemType,
279: Itemkey => ItemKey,
280: aname => 'LAUNCHMGR');
281: PlanID:=wf_engine.GetItemAttrText(Itemtype => ItemType,
282: Itemkey => ItemKey,
283: aname => 'ODPPLAN');
284: if LaunchMgr = 'CYCLE' or LaunchMgr = 'DONE'
285: then

Line 292: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,

288: end if;
289: -- Call to Launch a process.
290: if LaunchMgr = 'LAUNCH'
291: then
292: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,
293: Itemkey => ItemKey,
294: aname => 'EXPCONN');
295: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
296: Itemkey => ItemKey,

Line 295: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,

291: then
292: express_server:=wf_engine.GetItemAttrText(Itemtype => ItemType,
293: Itemkey => ItemKey,
294: aname => 'EXPCONN');
295: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
296: Itemkey => ItemKey,
297: aname => 'DPADMIN');
298: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,
299: Itemkey => ItemKey,

Line 298: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,

294: aname => 'EXPCONN');
295: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
296: Itemkey => ItemKey,
297: aname => 'DPADMIN');
298: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,
299: Itemkey => ItemKey,
300: aname => 'DBNAME');
301: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
302: Itemkey => ItemKey,

Line 301: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,

297: aname => 'DPADMIN');
298: DBName:=wf_engine.GetItemAttrText(Itemtype => ItemType,
299: Itemkey => ItemKey,
300: aname => 'DBNAME');
301: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
302: Itemkey => ItemKey,
303: aname => 'SHAREDLOC');
304: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
305: Itemkey => ItemKey,

Line 304: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,

300: aname => 'DBNAME');
301: SharedLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
302: Itemkey => ItemKey,
303: aname => 'SHAREDLOC');
304: CodeLoc:=wf_engine.GetItemAttrText(Itemtype => ItemType,
305: Itemkey => ItemKey,
306: aname => 'CODELOC');
307: SELECT C0, C1, C2
308: into ActRetCode, ActRetText, ActRetErr

Line 335: -- wf_engine.SetItemAttrText(Itemtype => ItemType,

331: if ActRetCode = 'Y' then
332: resultout :='COMPLETE:Y';
333: end if;
334: -- if ActRetCode = 'Y' then
335: -- wf_engine.SetItemAttrText(Itemtype => ItemType,
336: -- Itemkey => ItemKey,
337: -- aname => 'ODPBODY',
338: -- avalue => ActRetText);
339: -- end if;

Line 341: wf_engine.SetItemAttrText(Itemtype => ItemType,

337: -- aname => 'ODPBODY',
338: -- avalue => ActRetText);
339: -- end if;
340: if ActRetCode = 'N' then
341: wf_engine.SetItemAttrText(Itemtype => ItemType,
342: Itemkey => ItemKey,
343: aname => 'DPPROBLEM',
344: avalue => ActRetErr);
345: end if;

Line 376: express_server := wf_engine.GetItemAttrText(Itemtype => ItemType,

372: SELECT ACTIVITY_NAME INTO ActEntry FROM WF_PROCESS_ACTIVITIES
373: WHERE INSTANCE_ID=actid;
374: SELECT TEXT_VALUE INTO thisrole FROM WF_ITEM_ATTRIBUTE_VALUES
375: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
376: express_server := wf_engine.GetItemAttrText(Itemtype => ItemType,
377: Itemkey => ItemKey,
378: aname => 'EXPCONN');
379: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
380: Itemkey => ItemKey,

Line 379: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,

375: WHERE ITEM_KEY=itemkey AND ITEM_TYPE=itemtype AND NAME='ODPROLE';
376: express_server := wf_engine.GetItemAttrText(Itemtype => ItemType,
377: Itemkey => ItemKey,
378: aname => 'EXPCONN');
379: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
380: Itemkey => ItemKey,
381: aname => 'DPADMIN');
382: DBName := wf_engine.GetItemAttrText(Itemtype => ItemType,
383: Itemkey => ItemKey,

Line 382: DBName := wf_engine.GetItemAttrText(Itemtype => ItemType,

378: aname => 'EXPCONN');
379: DPAdmin:=wf_engine.GetItemAttrText(Itemtype => ItemType,
380: Itemkey => ItemKey,
381: aname => 'DPADMIN');
382: DBName := wf_engine.GetItemAttrText(Itemtype => ItemType,
383: Itemkey => ItemKey,
384: aname => 'DBNAME');
385: SharedLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,
386: Itemkey => ItemKey,

Line 385: SharedLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,

381: aname => 'DPADMIN');
382: DBName := wf_engine.GetItemAttrText(Itemtype => ItemType,
383: Itemkey => ItemKey,
384: aname => 'DBNAME');
385: SharedLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,
386: Itemkey => ItemKey,
387: aname => 'SHAREDLOC');
388: CodeLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,
389: Itemkey => ItemKey,

Line 388: CodeLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,

384: aname => 'DBNAME');
385: SharedLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,
386: Itemkey => ItemKey,
387: aname => 'SHAREDLOC');
388: CodeLoc := wf_engine.GetItemAttrText(Itemtype => ItemType,
389: Itemkey => ItemKey,
390: aname => 'CODELOC');
391: SELECT C0, C1, C2, C3
392: into ActRetCode, ActRetText, ActRetVal, ActRetErr

Line 425: wf_engine.setItemAttrText(Itemtype => ItemType,

421: end if;
422: -- its time to launch another or contiue
423: -- ActRetVal should be either LAUNCH or CYCLE.
424: if ActRetCode = 'Y' then
425: wf_engine.setItemAttrText(Itemtype => ItemType,
426: Itemkey => ItemKey,
427: aname => 'LAUNCHMGR',
428: avalue => ActRetVal);
429: resultout :='COMPLETE:CYCLE';

Line 432: wf_engine.SetItemAttrText(Itemtype => ItemType,

428: avalue => ActRetVal);
429: resultout :='COMPLETE:CYCLE';
430: end if;
431: if ActRetCode = 'N' then
432: wf_engine.SetItemAttrText(Itemtype => ItemType,
433: Itemkey => ItemKey,
434: aname => 'DPPROBLEM',
435: avalue => ActRetErr);
436: end if;

Line 476: wf_engine.CreateProcess(ItemType => ItemType,

472: BEGIN
473:
474: g_owner := owner;
475:
476: wf_engine.CreateProcess(ItemType => ItemType,
477: itemKey => ItemKey,
478: process => WFProcess);
479:
480: wf_engine.SetItemOwner(ItemType => ItemType,

Line 480: wf_engine.SetItemOwner(ItemType => ItemType,

476: wf_engine.CreateProcess(ItemType => ItemType,
477: itemKey => ItemKey,
478: process => WFProcess);
479:
480: wf_engine.SetItemOwner(ItemType => ItemType,
481: ItemKey => ItemKey,
482: owner => owner);
483:
484: -- Plan ID!

Line 485: wf_engine.SetItemAttrText(Itemtype => ItemType,

481: ItemKey => ItemKey,
482: owner => owner);
483:
484: -- Plan ID!
485: wf_engine.SetItemAttrText(Itemtype => ItemType,
486: Itemkey => ItemKey,
487: aname => 'ODPPLAN',
488: avalue => inplan);
489:

Line 490: wf_engine.SetItemAttrText(Itemtype => ItemType,

486: Itemkey => ItemKey,
487: aname => 'ODPPLAN',
488: avalue => inplan);
489:
490: wf_engine.SetItemAttrText(Itemtype => ItemType,
491: Itemkey => itemKey ,
492: aname => 'ARG2',
493: avalue => cost_itemKey );
494:

Line 495: wf_engine.SetItemAttrText(Itemtype => ItemType,

491: Itemkey => itemKey ,
492: aname => 'ARG2',
493: avalue => cost_itemKey );
494:
495: wf_engine.SetItemAttrText(Itemtype => ItemType,
496: Itemkey => itemKey ,
497: aname => 'ARG1',
498: avalue => ItemType);
499:

Line 500: wf_engine.StartProcess(ItemType => ItemType,

496: Itemkey => itemKey ,
497: aname => 'ARG1',
498: avalue => ItemType);
499:
500: wf_engine.StartProcess(ItemType => ItemType,
501: ItemKey => ItemKey);
502:
503:
504: return;

Line 560: wf_engine.ItemStatus(itemType, itemkey, status_code, result);

556: -- Activity until the Process with Deferred Activities is not completed.
557:
558: Loop
559:
560: wf_engine.ItemStatus(itemType, itemkey, status_code, result);
561:
562: if RTRIM(status_code) = 'COMPLETE' then
563: exit;
564: end if;

Line 574: wf_engine.Background(itemtype);

570: and ACTIVITY_STATUS_CODE = 'DEFERRED';
571:
572: if status_code = 'DEFERRED' then
573: deferred_found := 'YES';
574: wf_engine.Background(itemtype);
575: dbms_lock.sleep(seconds);
576: end if;
577: end loop;
578:

Line 780: -- IN Standard parameters supplied by WF engine:

776: -- SetColDate
777: --
778: -- WF proc to set the number of days to run the Standard Collection.
779: --
780: -- IN Standard parameters supplied by WF engine:
781: -- itemtype , itemkey, actid, funcmode
782: --
783: -- OUT
784: -- resultout 'COMPLETE:N' for failure, 'COMPLETE:Y' for success

Line 802: NumDays:=wf_engine.GetItemAttrNumber(Itemtype => ItemType,

798: IF (funcmode = 'RUN') THEN
799: resultout :='COMPLETE:N';
800:
801:
802: NumDays:=wf_engine.GetItemAttrNumber(Itemtype => ItemType,
803: Itemkey => ItemKey,
804: aname => 'NUMDAYS');
805:
806: TempDate := sysdate + NumDays;

Line 809: wf_engine.SetItemAttrDate(Itemtype => ItemType,

805:
806: TempDate := sysdate + NumDays;
807: TxtDate := to_char(TempDate, 'YY MM DD');
808: TempDate := to_date(TxtDate, 'YY MM DD');
809: wf_engine.SetItemAttrDate(Itemtype => ItemType,
810: Itemkey => ItemKey,
811: aname => 'VALUE2',
812: avalue => TempDate);
813:

Line 879: wf_engine.CreateProcess(ItemType => ItemType,

875: org := orgcode || ':' || instcode;
876: itemkey := org || '-' || PlanName || '-' || to_char( sysdate, 'MM/DD/YYYY-HH24:MI:SS') || '-' || workflowprocess;
877:
878: -- Create WF Automate process instance
879: wf_engine.CreateProcess(ItemType => ItemType,
880: itemKey => ItemKey,
881: process => WorkflowProcess);
882: -- This should be the demand planning administrator.
883: wf_engine.SetItemOwner(ItemType => ItemType,

Line 883: wf_engine.SetItemOwner(ItemType => ItemType,

879: wf_engine.CreateProcess(ItemType => ItemType,
880: itemKey => ItemKey,
881: process => WorkflowProcess);
882: -- This should be the demand planning administrator.
883: wf_engine.SetItemOwner(ItemType => ItemType,
884: ItemKey => ItemKey,
885: owner => owner);
886: -- Sets new attribute Is OPD Master running.
887: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 887: wf_engine.SetItemAttrText(Itemtype => ItemType,

883: wf_engine.SetItemOwner(ItemType => ItemType,
884: ItemKey => ItemKey,
885: owner => owner);
886: -- Sets new attribute Is OPD Master running.
887: wf_engine.SetItemAttrText(Itemtype => ItemType,
888: Itemkey => ItemKey,
889: aname => 'ISMASTER',
890: avalue => 'Y');
891: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 891: wf_engine.SetItemAttrText(Itemtype => ItemType,

887: wf_engine.SetItemAttrText(Itemtype => ItemType,
888: Itemkey => ItemKey,
889: aname => 'ISMASTER',
890: avalue => 'Y');
891: wf_engine.SetItemAttrText(Itemtype => ItemType,
892: Itemkey => ItemKey,
893: aname => 'DPADMIN',
894: avalue => owner);
895: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 895: wf_engine.SetItemAttrText(Itemtype => ItemType,

891: wf_engine.SetItemAttrText(Itemtype => ItemType,
892: Itemkey => ItemKey,
893: aname => 'DPADMIN',
894: avalue => owner);
895: wf_engine.SetItemAttrText(Itemtype => ItemType,
896: Itemkey => ItemKey,
897: aname => 'ODPROLE',
898: avalue => owner);
899: -- Plan ID!

Line 900: wf_engine.SetItemAttrText(Itemtype => ItemType,

896: Itemkey => ItemKey,
897: aname => 'ODPROLE',
898: avalue => owner);
899: -- Plan ID!
900: wf_engine.SetItemAttrText(Itemtype => ItemType,
901: Itemkey => ItemKey,
902: aname => 'ODPPLAN',
903: avalue => PlanID);
904: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 904: wf_engine.SetItemAttrText(Itemtype => ItemType,

900: wf_engine.SetItemAttrText(Itemtype => ItemType,
901: Itemkey => ItemKey,
902: aname => 'ODPPLAN',
903: avalue => PlanID);
904: wf_engine.SetItemAttrText(Itemtype => ItemType,
905: Itemkey => ItemKey,
906: aname => 'PLNAME',
907: avalue => PlanName);
908: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 908: wf_engine.SetItemAttrText(Itemtype => ItemType,

904: wf_engine.SetItemAttrText(Itemtype => ItemType,
905: Itemkey => ItemKey,
906: aname => 'PLNAME',
907: avalue => PlanName);
908: wf_engine.SetItemAttrText(Itemtype => ItemType,
909: Itemkey => ItemKey,
910: aname => 'CODELOC',
911: avalue => CodeLoc);
912: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 912: wf_engine.SetItemAttrText(Itemtype => ItemType,

908: wf_engine.SetItemAttrText(Itemtype => ItemType,
909: Itemkey => ItemKey,
910: aname => 'CODELOC',
911: avalue => CodeLoc);
912: wf_engine.SetItemAttrText(Itemtype => ItemType,
913: Itemkey => ItemKey,
914: aname => 'DBNAME',
915: avalue => DBName);
916: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 916: wf_engine.SetItemAttrText(Itemtype => ItemType,

912: wf_engine.SetItemAttrText(Itemtype => ItemType,
913: Itemkey => ItemKey,
914: aname => 'DBNAME',
915: avalue => DBName);
916: wf_engine.SetItemAttrText(Itemtype => ItemType,
917: Itemkey => ItemKey,
918: aname => 'SHAREDLOC',
919: avalue => SharedLoc);
920: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 920: wf_engine.SetItemAttrText(Itemtype => ItemType,

916: wf_engine.SetItemAttrText(Itemtype => ItemType,
917: Itemkey => ItemKey,
918: aname => 'SHAREDLOC',
919: avalue => SharedLoc);
920: wf_engine.SetItemAttrText(Itemtype => ItemType,
921: Itemkey => ItemKey,
922: aname => 'EXPCONN',
923: avalue => express_server);
924: -- set NumDays to collect

Line 925: wf_engine.SetItemAttrNumber(Itemtype => ItemType,

921: Itemkey => ItemKey,
922: aname => 'EXPCONN',
923: avalue => express_server);
924: -- set NumDays to collect
925: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
926: Itemkey => ItemKey,
927: aname => 'NUMDAYS',
928: avalue => NumDaysToCol);
929:

Line 931: wf_engine.StartProcess(ItemType => ItemType,

927: aname => 'NUMDAYS',
928: avalue => NumDaysToCol);
929:
930: -- Now that all is created and set START the PROCESS!
931: wf_engine.StartProcess(ItemType => ItemType,
932: ItemKey => ItemKey);
933: commit;
934:
935: -- Start background engine for this process.