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

Line 170: wf_engine.CreateProcess( itemtype => g_item_type,

166: end if;
167:
168: p_process := 'RES_PO';
169:
170: wf_engine.CreateProcess( itemtype => g_item_type,
171: itemkey => p_item_key,
172: process => p_process);
173: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
174: itemkey => p_item_key,

Line 173: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

169:
170: wf_engine.CreateProcess( itemtype => g_item_type,
171: itemkey => p_item_key,
172: process => p_process);
173: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
174: itemkey => p_item_key,
175: aname => 'PLAN_ID',
176: avalue => p_plan_id);
177: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 177: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

173: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
174: itemkey => p_item_key,
175: aname => 'PLAN_ID',
176: avalue => p_plan_id);
177: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
178: itemkey => p_item_key,
179: aname => 'TRANSACTION_ID',
180: avalue => p_transaction_id);
181: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 181: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

177: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
178: itemkey => p_item_key,
179: aname => 'TRANSACTION_ID',
180: avalue => p_transaction_id);
181: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
182: itemkey => p_item_key,
183: aname => 'SR_INSTANCE_ID',
184: avalue => p_instance_id);
185: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 185: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

181: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
182: itemkey => p_item_key,
183: aname => 'SR_INSTANCE_ID',
184: avalue => p_instance_id);
185: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
186: itemkey => p_item_key,
187: aname => 'LOAD_TYPE',
188: avalue => p_load_type);
189: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 189: wf_engine.SetItemAttrText( itemtype => g_item_type,

185: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
186: itemkey => p_item_key,
187: aname => 'LOAD_TYPE',
188: avalue => p_load_type);
189: wf_engine.SetItemAttrText( itemtype => g_item_type,
190: itemkey => p_item_key,
191: aname => 'DBLINK',
192: avalue => p_dblink);
193: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 193: wf_engine.SetItemAttrText( itemtype => g_item_type,

189: wf_engine.SetItemAttrText( itemtype => g_item_type,
190: itemkey => p_item_key,
191: aname => 'DBLINK',
192: avalue => p_dblink);
193: wf_engine.SetItemAttrText( itemtype => g_item_type,
194: itemkey => p_item_key,
195: aname => 'INSTANCE_CODE',
196: avalue => p_instance_code);
197:

Line 198: wf_engine.StartProcess( itemtype => g_item_type,

194: itemkey => p_item_key,
195: aname => 'INSTANCE_CODE',
196: avalue => p_instance_code);
197:
198: wf_engine.StartProcess( itemtype => g_item_type,
199: itemkey => p_item_key);
200:
201: reset_load_type(p_plan_id, p_transaction_id);
202: exception when others then

Line 291: wf_engine.CreateProcess( itemtype => g_item_type,

287: l_old_date,
288: l_new_date,
289: l_qty,
290: l_buyer;
291: wf_engine.CreateProcess( itemtype => g_item_type,
292: itemkey => p_item_key,
293: process => p_process);
294:
295: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 295: wf_engine.SetItemAttrText( itemtype => g_item_type,

291: wf_engine.CreateProcess( itemtype => g_item_type,
292: itemkey => p_item_key,
293: process => p_process);
294:
295: wf_engine.SetItemAttrText( itemtype => g_item_type,
296: itemkey => p_item_key,
297: aname => 'PLANNER',
298: avalue => p_planner);
299:

Line 300: wf_engine.SetItemAttrText( itemtype => g_item_type,

296: itemkey => p_item_key,
297: aname => 'PLANNER',
298: avalue => p_planner);
299:
300: wf_engine.SetItemAttrText( itemtype => g_item_type,
301: itemkey => p_item_key,
302: aname => 'BUYER',
303: avalue => l_buyer);
304:

Line 305: wf_engine.SetItemAttrText( itemtype => g_item_type,

301: itemkey => p_item_key,
302: aname => 'BUYER',
303: avalue => l_buyer);
304:
305: wf_engine.SetItemAttrText( itemtype => g_item_type,
306: itemkey => p_item_key,
307: aname => 'PLAN_NAME',
308: avalue => l_plan_name);
309:

Line 310: wf_engine.SetItemAttrText( itemtype => g_item_type,

306: itemkey => p_item_key,
307: aname => 'PLAN_NAME',
308: avalue => l_plan_name);
309:
310: wf_engine.SetItemAttrText( itemtype => g_item_type,
311: itemkey => p_item_key,
312: aname => 'ITEM_NAME',
313: avalue => l_item_name);
314: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 314: wf_engine.SetItemAttrText( itemtype => g_item_type,

310: wf_engine.SetItemAttrText( itemtype => g_item_type,
311: itemkey => p_item_key,
312: aname => 'ITEM_NAME',
313: avalue => l_item_name);
314: wf_engine.SetItemAttrText( itemtype => g_item_type,
315: itemkey => p_item_key,
316: aname => 'ORG_CODE',
317: avalue => l_org_code);
318: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 318: wf_engine.SetItemAttrText( itemtype => g_item_type,

314: wf_engine.SetItemAttrText( itemtype => g_item_type,
315: itemkey => p_item_key,
316: aname => 'ORG_CODE',
317: avalue => l_org_code);
318: wf_engine.SetItemAttrText( itemtype => g_item_type,
319: itemkey => p_item_key,
320: aname => 'SUPPLIER',
321: avalue => l_supplier);
322:

Line 323: wf_engine.SetItemAttrText( itemtype => g_item_type,

319: itemkey => p_item_key,
320: aname => 'SUPPLIER',
321: avalue => l_supplier);
322:
323: wf_engine.SetItemAttrText( itemtype => g_item_type,
324: itemkey => p_item_key,
325: aname => 'ORDER_NAME',
326: avalue => l_order);
327: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 327: wf_engine.SetItemAttrText( itemtype => g_item_type,

323: wf_engine.SetItemAttrText( itemtype => g_item_type,
324: itemkey => p_item_key,
325: aname => 'ORDER_NAME',
326: avalue => l_order);
327: wf_engine.SetItemAttrText( itemtype => g_item_type,
328: itemkey => p_item_key,
329: aname => 'ORDER_TYPE',
330: avalue => l_order_type);
331: wf_engine.SetItemAttrDate( itemtype => g_item_type,

Line 331: wf_engine.SetItemAttrDate( itemtype => g_item_type,

327: wf_engine.SetItemAttrText( itemtype => g_item_type,
328: itemkey => p_item_key,
329: aname => 'ORDER_TYPE',
330: avalue => l_order_type);
331: wf_engine.SetItemAttrDate( itemtype => g_item_type,
332: itemkey => p_item_key,
333: aname => 'ORDER_DATE',
334: avalue => l_old_date);
335: wf_engine.SetItemAttrDate( itemtype => g_item_type,

Line 335: wf_engine.SetItemAttrDate( itemtype => g_item_type,

331: wf_engine.SetItemAttrDate( itemtype => g_item_type,
332: itemkey => p_item_key,
333: aname => 'ORDER_DATE',
334: avalue => l_old_date);
335: wf_engine.SetItemAttrDate( itemtype => g_item_type,
336: itemkey => p_item_key,
337: aname => 'NEW_ORDER_DATE',
338: avalue => l_new_date);
339: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 339: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

335: wf_engine.SetItemAttrDate( itemtype => g_item_type,
336: itemkey => p_item_key,
337: aname => 'NEW_ORDER_DATE',
338: avalue => l_new_date);
339: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
340: itemkey => p_item_key,
341: aname => 'ORDER_QTY',
342: avalue => l_qty);
343:

Line 344: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

340: itemkey => p_item_key,
341: aname => 'ORDER_QTY',
342: avalue => l_qty);
343:
344: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
345: itemkey => p_item_key,
346: aname => 'PLAN_ID',
347: avalue => p_plan_id);
348:

Line 349: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

345: itemkey => p_item_key,
346: aname => 'PLAN_ID',
347: avalue => p_plan_id);
348:
349: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
350: itemkey => p_item_key,
351: aname => 'TRANSACTION_ID',
352: avalue => p_transaction_id);
353:

Line 354: wf_engine.StartProcess( itemtype => g_item_type,

350: itemkey => p_item_key,
351: aname => 'TRANSACTION_ID',
352: avalue => p_transaction_id);
353:
354: wf_engine.StartProcess( itemtype => g_item_type,
355: itemkey => p_item_key);
356: exception when others then
357: wf_core.context('MSC_REL_WF', 'notify planner', p_item_key,g_item_type);
358: raise;

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

432: BEGIN
433:
434: if (funcmode = 'RUN') then
435: p_plan_id :=
436: wf_engine.GetItemAttrNumber( itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'PLAN_ID');
439:
440: p_transaction_id :=

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

437: itemkey => itemkey,
438: aname => 'PLAN_ID');
439:
440: p_transaction_id :=
441: wf_engine.GetItemAttrNumber( itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'TRANSACTION_ID');
444:
445: p_load_type :=

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

442: itemkey => itemkey,
443: aname => 'TRANSACTION_ID');
444:
445: p_load_type :=
446: wf_engine.GetItemAttrNumber( itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'LOAD_TYPE');
449:
450: p_dblink :=

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

447: itemkey => itemkey,
448: aname => 'LOAD_TYPE');
449:
450: p_dblink :=
451: wf_engine.GetItemAttrText( itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'DBLINK');
454:
455: p_instance_code :=

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

452: itemkey => itemkey,
453: aname => 'DBLINK');
454:
455: p_instance_code :=
456: wf_engine.GetItemAttrText( itemtype => itemtype,
457: itemkey => itemkey,
458: aname => 'INSTANCE_CODE');
459:
460: OPEN buyer_c;

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

537: l_qty;
538: CLOSE detail_attri;
539:
540: msc_util.msc_debug('notify planner no buyer/supplier found');
541: wf_engine.SetItemAttrText( itemtype => itemtype,
542: itemkey => itemkey,
543: aname => 'PLAN_NAME',
544: avalue => l_plan_name);
545:

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

542: itemkey => itemkey,
543: aname => 'PLAN_NAME',
544: avalue => l_plan_name);
545:
546: wf_engine.SetItemAttrText( itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'ITEM_NAME',
549: avalue => l_item_name);
550: wf_engine.SetItemAttrText( itemtype => itemtype,

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

546: wf_engine.SetItemAttrText( itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'ITEM_NAME',
549: avalue => l_item_name);
550: wf_engine.SetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'PLANNER',
553: avalue => l_planner);
554: wf_engine.SetItemAttrText( itemtype => itemtype,

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

550: wf_engine.SetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'PLANNER',
553: avalue => l_planner);
554: wf_engine.SetItemAttrText( itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'ORG_CODE',
557: avalue => l_org_code);
558:

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

555: itemkey => itemkey,
556: aname => 'ORG_CODE',
557: avalue => l_org_code);
558:
559: wf_engine.SetItemAttrText( itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'ORDER_NAME',
562: avalue => l_order);
563:

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

560: itemkey => itemkey,
561: aname => 'ORDER_NAME',
562: avalue => l_order);
563:
564: wf_engine.SetItemAttrText( itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'ORDER_TYPE',
567: avalue => l_order_type);
568:

Line 569: wf_engine.SetItemAttrDate( itemtype => itemtype,

565: itemkey => itemkey,
566: aname => 'ORDER_TYPE',
567: avalue => l_order_type);
568:
569: wf_engine.SetItemAttrDate( itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'ORDER_DATE',
572: avalue => l_old_date);
573:

Line 574: wf_engine.SetItemAttrDate( itemtype => itemtype,

570: itemkey => itemkey,
571: aname => 'ORDER_DATE',
572: avalue => l_old_date);
573:
574: wf_engine.SetItemAttrDate( itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'NEW_ORDER_DATE',
577: avalue => l_new_date);
578:

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

575: itemkey => itemkey,
576: aname => 'NEW_ORDER_DATE',
577: avalue => l_new_date);
578:
579: wf_engine.SetItemAttrNumber( itemtype => itemtype,
580: itemkey => itemkey,
581: aname => 'ORDER_QTY',
582: avalue => l_qty);
583:

Line 1775: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1771: p_load_type number;
1772: BEGIN
1773: if (funcmode = 'RUN') then
1774: p_load_type :=
1775: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1776: itemkey => itemkey,
1777: aname => 'LOAD_TYPE');
1778: if p_load_type = PURCHASE_ORDER_RESCHEDULE then
1779: resultout := 'COMPLETE:PO';

Line 1831: wf_engine.CreateProcess( itemtype => g_item_type,

1827: end if;
1828:
1829: p_process := 'BATCH_UPDATE';
1830:
1831: wf_engine.CreateProcess( itemtype => g_item_type,
1832: itemkey => p_item_key,
1833: process => p_process);
1834: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1835: itemkey => p_item_key,

Line 1834: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

1830:
1831: wf_engine.CreateProcess( itemtype => g_item_type,
1832: itemkey => p_item_key,
1833: process => p_process);
1834: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1835: itemkey => p_item_key,
1836: aname => 'PLAN_ID',
1837: avalue => p_plan_id);
1838: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 1838: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

1834: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1835: itemkey => p_item_key,
1836: aname => 'PLAN_ID',
1837: avalue => p_plan_id);
1838: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1839: itemkey => p_item_key,
1840: aname => 'ORG_ID',
1841: avalue => p_org_id);
1842: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 1842: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

1838: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1839: itemkey => p_item_key,
1840: aname => 'ORG_ID',
1841: avalue => p_org_id);
1842: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1843: itemkey => p_item_key,
1844: aname => 'SR_INSTANCE_ID',
1845: avalue => p_instance_id);
1846: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 1846: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

1842: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1843: itemkey => p_item_key,
1844: aname => 'SR_INSTANCE_ID',
1845: avalue => p_instance_id);
1846: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1847: itemkey => p_item_key,
1848: aname => 'OWNING_ORG_ID',
1849: avalue => p_owning_org);
1850: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 1850: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

1846: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1847: itemkey => p_item_key,
1848: aname => 'OWNING_ORG_ID',
1849: avalue => p_owning_org);
1850: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1851: itemkey => p_item_key,
1852: aname => 'OWNING_INSTANCE_ID',
1853: avalue => p_instance_id);
1854: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

Line 1854: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

1850: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1851: itemkey => p_item_key,
1852: aname => 'OWNING_INSTANCE_ID',
1853: avalue => p_instance_id);
1854: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1855: itemkey => p_item_key,
1856: aname => 'LOAD_TYPE',
1857: avalue => p_load_type);
1858: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 1858: wf_engine.SetItemAttrText( itemtype => g_item_type,

1854: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
1855: itemkey => p_item_key,
1856: aname => 'LOAD_TYPE',
1857: avalue => p_load_type);
1858: wf_engine.SetItemAttrText( itemtype => g_item_type,
1859: itemkey => p_item_key,
1860: aname => 'DBLINK',
1861: avalue => p_dblink);
1862: wf_engine.SetItemAttrText( itemtype => g_item_type,

Line 1862: wf_engine.SetItemAttrText( itemtype => g_item_type,

1858: wf_engine.SetItemAttrText( itemtype => g_item_type,
1859: itemkey => p_item_key,
1860: aname => 'DBLINK',
1861: avalue => p_dblink);
1862: wf_engine.SetItemAttrText( itemtype => g_item_type,
1863: itemkey => p_item_key,
1864: aname => 'INSTANCE_CODE',
1865: avalue => p_instance_code);
1866:

Line 1868: wf_engine.StartProcess( itemtype => g_item_type,

1864: aname => 'INSTANCE_CODE',
1865: avalue => p_instance_code);
1866:
1867: --dbms_output.put_line('item_key='||p_item_key);
1868: wf_engine.StartProcess( itemtype => g_item_type,
1869: itemkey => p_item_key);
1870:
1871: update msc_supplies
1872: SET implement_demand_class = NULL,

Line 1938: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1934: where instance_id = p_instance_id;
1935: BEGIN
1936: if (funcmode = 'RUN') then
1937: p_load_type :=
1938: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'LOAD_TYPE');
1941: p_plan_id :=
1942: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

Line 1942: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1938: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'LOAD_TYPE');
1941: p_plan_id :=
1942: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1943: itemkey => itemkey,
1944: aname => 'PLAN_ID');
1945: p_org_id :=
1946: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

Line 1946: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1942: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1943: itemkey => itemkey,
1944: aname => 'PLAN_ID');
1945: p_org_id :=
1946: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1947: itemkey => itemkey,
1948: aname => 'ORG_ID');
1949: p_instance_id :=
1950: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

Line 1950: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1946: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1947: itemkey => itemkey,
1948: aname => 'ORG_ID');
1949: p_instance_id :=
1950: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1951: itemkey => itemkey,
1952: aname => 'SR_INSTANCE_ID');
1953: p_owning_org :=
1954: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

Line 1954: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1950: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1951: itemkey => itemkey,
1952: aname => 'SR_INSTANCE_ID');
1953: p_owning_org :=
1954: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1955: itemkey => itemkey,
1956: aname => 'OWNING_ORG_ID');
1957: p_owning_instance :=
1958: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

Line 1958: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

1954: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1955: itemkey => itemkey,
1956: aname => 'OWNING_ORG_ID');
1957: p_owning_instance :=
1958: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
1959: itemkey => itemkey,
1960: aname => 'OWNING_INSTANCE_ID');
1961: open apps_ver_cur;
1962: fetch apps_ver_cur into p_apps_ver;

Line 2087: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

2083: p_instance_code varchar2(10);
2084: Begin
2085: if (funcmode = 'RUN') then
2086: p_load_type :=
2087: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2088: itemkey => itemkey,
2089: aname => 'LOAD_TYPE');
2090: p_instance :=
2091: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

Line 2091: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

2087: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2088: itemkey => itemkey,
2089: aname => 'LOAD_TYPE');
2090: p_instance :=
2091: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2092: itemkey => itemkey,
2093: aname => 'SR_INSTANCE_ID');
2094: p_instance_code :=
2095: wf_engine.GetItemAttrText( itemtype => itemtype,

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

2091: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2092: itemkey => itemkey,
2093: aname => 'SR_INSTANCE_ID');
2094: p_instance_code :=
2095: wf_engine.GetItemAttrText( itemtype => itemtype,
2096: itemkey => itemkey,
2097: aname => 'INSTANCE_CODE');
2098: p_dblink :=
2099: wf_engine.GetItemAttrText( itemtype => itemtype,

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

2095: wf_engine.GetItemAttrText( itemtype => itemtype,
2096: itemkey => itemkey,
2097: aname => 'INSTANCE_CODE');
2098: p_dblink :=
2099: wf_engine.GetItemAttrText( itemtype => itemtype,
2100: itemkey => itemkey,
2101: aname => 'DBLINK');
2102:
2103: --commenting out the foll code as this procedure is not being used anywhere.

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

2184:
2185: msc_util.msc_debug('request id is '||p_request_id
2186: ||', in instance '||p_instance_code);
2187:
2188: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2189: itemkey => itemkey,
2190: aname => 'REQUEST_ID',
2191: avalue => p_request_id);
2192: commit;

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

3189: select to_char(mrp_form_query_s.nextval)
3190: into item_key
3191: from dual;
3192:
3193: wf_engine.CreateProcess( itemtype => item_type,
3194: itemkey => item_key,
3195: process => l_process);
3196:
3197: wf_engine.SetItemAttrNumber( itemtype => item_type,

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

3193: wf_engine.CreateProcess( itemtype => item_type,
3194: itemkey => item_key,
3195: process => l_process);
3196:
3197: wf_engine.SetItemAttrNumber( itemtype => item_type,
3198: itemkey => item_key,
3199: aname => 'EXCEPTION_TYPE_ID',
3200: avalue => 70); -- new exception type
3201:

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

3198: itemkey => item_key,
3199: aname => 'EXCEPTION_TYPE_ID',
3200: avalue => 70); -- new exception type
3201:
3202: wf_engine.SetItemAttrNumber( itemtype => item_type,
3203: itemkey => item_key,
3204: aname => 'ORDER_TYPE_CODE',
3205: avalue => -30); -- from release so
3206:

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

3203: itemkey => item_key,
3204: aname => 'ORDER_TYPE_CODE',
3205: avalue => -30); -- from release so
3206:
3207: wf_engine.SetItemAttrNumber( itemtype => item_type,
3208: itemkey => item_key,
3209: aname => 'TRANSACTION_ID',
3210: avalue => all_rec.demand_id);
3211:

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

3208: itemkey => item_key,
3209: aname => 'TRANSACTION_ID',
3210: avalue => all_rec.demand_id);
3211:
3212: wf_engine.SetItemAttrNumber( itemtype => item_type,
3213: itemkey => item_key,
3214: aname => 'INVENTORY_ITEM_ID',
3215: avalue => all_rec.inventory_item_id);
3216:

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

3213: itemkey => item_key,
3214: aname => 'INVENTORY_ITEM_ID',
3215: avalue => all_rec.inventory_item_id);
3216:
3217: wf_engine.SetItemAttrNumber( itemtype => item_type,
3218: itemkey => item_key,
3219: aname => 'ORGANIZATION_ID',
3220: avalue => all_rec.organization_id);
3221:

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

3218: itemkey => item_key,
3219: aname => 'ORGANIZATION_ID',
3220: avalue => all_rec.organization_id);
3221:
3222: wf_engine.SetItemAttrNumber( itemtype => item_type,
3223: itemkey => item_key,
3224: aname => 'INSTANCE_ID',
3225: avalue => all_rec.sr_instance_id);
3226:

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

3223: itemkey => item_key,
3224: aname => 'INSTANCE_ID',
3225: avalue => all_rec.sr_instance_id);
3226:
3227: wf_engine.SetItemAttrNumber( itemtype => item_type,
3228: itemkey => item_key,
3229: aname => 'SUPPLIER_ID',
3230: avalue => p_batch_id);
3231:

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

3228: itemkey => item_key,
3229: aname => 'SUPPLIER_ID',
3230: avalue => p_batch_id);
3231:
3232: wf_engine.SetItemAttrNumber( itemtype => item_type,
3233: itemkey => item_key,
3234: aname => 'PLAN_ID',
3235: avalue => all_rec.plan_id);
3236:

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

3233: itemkey => item_key,
3234: aname => 'PLAN_ID',
3235: avalue => all_rec.plan_id);
3236:
3237: wf_engine.SetItemAttrNumber( itemtype => item_type,
3238: itemkey => item_key,
3239: aname => 'PRE_PRSNG_LEAD_TIME',
3240: avalue => all_rec.old_lead_time);
3241:

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

3238: itemkey => item_key,
3239: aname => 'PRE_PRSNG_LEAD_TIME',
3240: avalue => all_rec.old_lead_time);
3241:
3242: wf_engine.SetItemAttrNumber( itemtype => item_type,
3243: itemkey => item_key,
3244: aname => 'POST_PRSNG_LEAD_TIME',
3245: avalue => all_rec.new_lead_time);
3246:

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

3243: itemkey => item_key,
3244: aname => 'POST_PRSNG_LEAD_TIME',
3245: avalue => all_rec.new_lead_time);
3246:
3247: wf_engine.SetItemAttrText( itemtype => item_type,
3248: itemkey => item_key,
3249: aname => 'ORGANIZATION_CODE',
3250: avalue => all_rec.org_code);
3251:

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

3248: itemkey => item_key,
3249: aname => 'ORGANIZATION_CODE',
3250: avalue => all_rec.org_code);
3251:
3252: wf_engine.SetItemAttrText( itemtype => item_type,
3253: itemkey => item_key,
3254: aname => 'PLAN_NAME',
3255: avalue => all_rec.plan_name);
3256:

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

3253: itemkey => item_key,
3254: aname => 'PLAN_NAME',
3255: avalue => all_rec.plan_name);
3256:
3257: wf_engine.SetItemAttrText( itemtype => item_type,
3258: itemkey => item_key,
3259: aname => 'DEPARTMENT_LINE_CODE',
3260: avalue => all_rec.to_org);
3261:

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

3258: itemkey => item_key,
3259: aname => 'DEPARTMENT_LINE_CODE',
3260: avalue => all_rec.to_org);
3261:
3262: wf_engine.SetItemAttrText( itemtype => item_type,
3263: itemkey => item_key,
3264: aname => 'ITEM_DISPLAY_NAME',
3265: avalue => all_rec.item_name);
3266:

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

3263: itemkey => item_key,
3264: aname => 'ITEM_DISPLAY_NAME',
3265: avalue => all_rec.item_name);
3266:
3267: wf_engine.SetItemAttrText( itemtype => item_type,
3268: itemkey => item_key,
3269: aname => 'ITEM_DESCRIPTION',
3270: avalue => all_rec.item_desc);
3271:

Line 3272: wf_engine.SetItemAttrDate( itemtype => item_type,

3268: itemkey => item_key,
3269: aname => 'ITEM_DESCRIPTION',
3270: avalue => all_rec.item_desc);
3271:
3272: wf_engine.SetItemAttrDate( itemtype => item_type,
3273: itemkey => item_key,
3274: aname => 'FROM_DATE',
3275: avalue => all_rec.old_ship_date);
3276:

Line 3277: wf_engine.SetItemAttrDate( itemtype => item_type,

3273: itemkey => item_key,
3274: aname => 'FROM_DATE',
3275: avalue => all_rec.old_ship_date);
3276:
3277: wf_engine.SetItemAttrDate( itemtype => item_type,
3278: itemkey => item_key,
3279: aname => 'TO_DATE',
3280: avalue => all_rec.new_ship_date);
3281:

Line 3282: wf_engine.SetItemAttrDate( itemtype => item_type,

3278: itemkey => item_key,
3279: aname => 'TO_DATE',
3280: avalue => all_rec.new_ship_date);
3281:
3282: wf_engine.SetItemAttrDate( itemtype => item_type,
3283: itemkey => item_key,
3284: aname => 'DATE1',
3285: avalue => all_rec.old_arrival_date);
3286:

Line 3287: wf_engine.SetItemAttrDate( itemtype => item_type,

3283: itemkey => item_key,
3284: aname => 'DATE1',
3285: avalue => all_rec.old_arrival_date);
3286:
3287: wf_engine.SetItemAttrDate( itemtype => item_type,
3288: itemkey => item_key,
3289: aname => 'DATE2',
3290: avalue => all_rec.new_arrival_date);
3291:

Line 3292: wf_engine.SetItemAttrDate( itemtype => item_type,

3288: itemkey => item_key,
3289: aname => 'DATE2',
3290: avalue => all_rec.new_arrival_date);
3291:
3292: wf_engine.SetItemAttrDate( itemtype => item_type,
3293: itemkey => item_key,
3294: aname => 'DATE3',
3295: avalue => all_rec.earliest_ship_date);
3296:

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

3293: itemkey => item_key,
3294: aname => 'DATE3',
3295: avalue => all_rec.earliest_ship_date);
3296:
3297: wf_engine.SetItemAttrText( itemtype => item_type,
3298: itemkey => item_key,
3299: aname => 'CUSTOMER_NAME',
3300: avalue => all_rec.customer_name);
3301:

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

3298: itemkey => item_key,
3299: aname => 'CUSTOMER_NAME',
3300: avalue => all_rec.customer_name);
3301:
3302: wf_engine.SetItemAttrText( itemtype => item_type,
3303: itemkey => item_key,
3304: aname => 'RESOURCE_CODE',
3305: avalue => all_rec.customer_site);
3306:

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

3303: itemkey => item_key,
3304: aname => 'RESOURCE_CODE',
3305: avalue => all_rec.customer_site);
3306:
3307: wf_engine.SetItemAttrText( itemtype => item_type,
3308: itemkey => item_key,
3309: aname => 'SUPPLIER_NAME',
3310: avalue => all_rec.old_ship_method);
3311:

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

3308: itemkey => item_key,
3309: aname => 'SUPPLIER_NAME',
3310: avalue => all_rec.old_ship_method);
3311:
3312: wf_engine.SetItemAttrText( itemtype => item_type,
3313: itemkey => item_key,
3314: aname => 'SUPPLIER_SITE_CODE',
3315: avalue => all_rec.new_ship_method);
3316:

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

3313: itemkey => item_key,
3314: aname => 'SUPPLIER_SITE_CODE',
3315: avalue => all_rec.new_ship_method);
3316:
3317: wf_engine.SetItemAttrText( itemtype => item_type,
3318: itemkey => item_key,
3319: aname => 'ORDER_NUMBER',
3320: avalue => all_rec.order_number);
3321:

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

3318: itemkey => item_key,
3319: aname => 'ORDER_NUMBER',
3320: avalue => all_rec.order_number);
3321:
3322: wf_engine.SetItemAttrText( itemtype => item_type,
3323: itemkey => item_key,
3324: aname => 'LOT_NUMBER',
3325: avalue => all_rec.line_number);
3326:

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

3323: itemkey => item_key,
3324: aname => 'LOT_NUMBER',
3325: avalue => all_rec.line_number);
3326:
3327: wf_engine.SetItemAttrText( itemtype => item_type,
3328: itemkey => item_key,
3329: aname => 'PLANNING_GROUP',
3330: avalue => all_rec.atp_override_flag);
3331:

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

3328: itemkey => item_key,
3329: aname => 'PLANNING_GROUP',
3330: avalue => all_rec.atp_override_flag);
3331:
3332: wf_engine.SetItemAttrText( itemtype => item_type,
3333: itemkey => item_key,
3334: aname => 'END_ITEM_DISPLAY_NAME',
3335: avalue => all_rec.orig_item_name);
3336:

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

3333: itemkey => item_key,
3334: aname => 'END_ITEM_DISPLAY_NAME',
3335: avalue => all_rec.orig_item_name);
3336:
3337: wf_engine.SetItemAttrText( itemtype => item_type,
3338: itemkey => item_key,
3339: aname => 'END_ITEM_DESCRIPTION',
3340: avalue => all_rec.orig_item_desc);
3341:

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

3338: itemkey => item_key,
3339: aname => 'END_ITEM_DESCRIPTION',
3340: avalue => all_rec.orig_item_desc);
3341:
3342: wf_engine.StartProcess( itemtype => item_type,
3343: itemkey => item_key);
3344: FND_FILE.PUT_LINE(FND_FILE.LOG,'item_key='||item_key||', item_type='||item_type);
3345:
3346: END LOOP;