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 2026: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

2022: p_load_type number;
2023: BEGIN
2024: if (funcmode = 'RUN') then
2025: p_load_type :=
2026: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2027: itemkey => itemkey,
2028: aname => 'LOAD_TYPE');
2029: if p_load_type = PURCHASE_ORDER_RESCHEDULE then
2030: resultout := 'COMPLETE:PO';

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

2078: end if;
2079:
2080: p_process := 'BATCH_UPDATE';
2081:
2082: wf_engine.CreateProcess( itemtype => g_item_type,
2083: itemkey => p_item_key,
2084: process => p_process);
2085: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2086: itemkey => p_item_key,

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

2081:
2082: wf_engine.CreateProcess( itemtype => g_item_type,
2083: itemkey => p_item_key,
2084: process => p_process);
2085: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2086: itemkey => p_item_key,
2087: aname => 'PLAN_ID',
2088: avalue => p_plan_id);
2089: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

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

2085: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2086: itemkey => p_item_key,
2087: aname => 'PLAN_ID',
2088: avalue => p_plan_id);
2089: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2090: itemkey => p_item_key,
2091: aname => 'ORG_ID',
2092: avalue => p_org_id);
2093: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

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

2089: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2090: itemkey => p_item_key,
2091: aname => 'ORG_ID',
2092: avalue => p_org_id);
2093: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2094: itemkey => p_item_key,
2095: aname => 'SR_INSTANCE_ID',
2096: avalue => p_instance_id);
2097: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

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

2093: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2094: itemkey => p_item_key,
2095: aname => 'SR_INSTANCE_ID',
2096: avalue => p_instance_id);
2097: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2098: itemkey => p_item_key,
2099: aname => 'OWNING_ORG_ID',
2100: avalue => p_owning_org);
2101: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

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

2097: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2098: itemkey => p_item_key,
2099: aname => 'OWNING_ORG_ID',
2100: avalue => p_owning_org);
2101: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2102: itemkey => p_item_key,
2103: aname => 'OWNING_INSTANCE_ID',
2104: avalue => p_instance_id);
2105: wf_engine.SetItemAttrNumber( itemtype => g_item_type,

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

2101: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2102: itemkey => p_item_key,
2103: aname => 'OWNING_INSTANCE_ID',
2104: avalue => p_instance_id);
2105: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2106: itemkey => p_item_key,
2107: aname => 'LOAD_TYPE',
2108: avalue => p_load_type);
2109: wf_engine.SetItemAttrText( itemtype => g_item_type,

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

2105: wf_engine.SetItemAttrNumber( itemtype => g_item_type,
2106: itemkey => p_item_key,
2107: aname => 'LOAD_TYPE',
2108: avalue => p_load_type);
2109: wf_engine.SetItemAttrText( itemtype => g_item_type,
2110: itemkey => p_item_key,
2111: aname => 'DBLINK',
2112: avalue => p_dblink);
2113: wf_engine.SetItemAttrText( itemtype => g_item_type,

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

2109: wf_engine.SetItemAttrText( itemtype => g_item_type,
2110: itemkey => p_item_key,
2111: aname => 'DBLINK',
2112: avalue => p_dblink);
2113: wf_engine.SetItemAttrText( itemtype => g_item_type,
2114: itemkey => p_item_key,
2115: aname => 'INSTANCE_CODE',
2116: avalue => p_instance_code);
2117:

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

2115: aname => 'INSTANCE_CODE',
2116: avalue => p_instance_code);
2117:
2118: --dbms_output.put_line('item_key='||p_item_key);
2119: wf_engine.StartProcess( itemtype => g_item_type,
2120: itemkey => p_item_key);
2121:
2122: update msc_supplies
2123: SET implement_demand_class = NULL,

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

2185: where instance_id = p_instance_id;
2186: BEGIN
2187: if (funcmode = 'RUN') then
2188: p_load_type :=
2189: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2190: itemkey => itemkey,
2191: aname => 'LOAD_TYPE');
2192: p_plan_id :=
2193: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

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

2189: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2190: itemkey => itemkey,
2191: aname => 'LOAD_TYPE');
2192: p_plan_id :=
2193: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2194: itemkey => itemkey,
2195: aname => 'PLAN_ID');
2196: p_org_id :=
2197: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

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

2193: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2194: itemkey => itemkey,
2195: aname => 'PLAN_ID');
2196: p_org_id :=
2197: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2198: itemkey => itemkey,
2199: aname => 'ORG_ID');
2200: p_instance_id :=
2201: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

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

2197: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2198: itemkey => itemkey,
2199: aname => 'ORG_ID');
2200: p_instance_id :=
2201: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2202: itemkey => itemkey,
2203: aname => 'SR_INSTANCE_ID');
2204: p_owning_org :=
2205: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

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

2201: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2202: itemkey => itemkey,
2203: aname => 'SR_INSTANCE_ID');
2204: p_owning_org :=
2205: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'OWNING_ORG_ID');
2208: p_owning_instance :=
2209: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

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

2205: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'OWNING_ORG_ID');
2208: p_owning_instance :=
2209: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2210: itemkey => itemkey,
2211: aname => 'OWNING_INSTANCE_ID');
2212: open apps_ver_cur;
2213: fetch apps_ver_cur into p_apps_ver;

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

2334: p_instance_code varchar2(10);
2335: Begin
2336: if (funcmode = 'RUN') then
2337: p_load_type :=
2338: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2339: itemkey => itemkey,
2340: aname => 'LOAD_TYPE');
2341: p_instance :=
2342: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,

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

2338: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2339: itemkey => itemkey,
2340: aname => 'LOAD_TYPE');
2341: p_instance :=
2342: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2343: itemkey => itemkey,
2344: aname => 'SR_INSTANCE_ID');
2345: p_instance_code :=
2346: wf_engine.GetItemAttrText( itemtype => itemtype,

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

2342: wf_engine.GetItemAttrNUMBER( itemtype => itemtype,
2343: itemkey => itemkey,
2344: aname => 'SR_INSTANCE_ID');
2345: p_instance_code :=
2346: wf_engine.GetItemAttrText( itemtype => itemtype,
2347: itemkey => itemkey,
2348: aname => 'INSTANCE_CODE');
2349: p_dblink :=
2350: wf_engine.GetItemAttrText( itemtype => itemtype,

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

2346: wf_engine.GetItemAttrText( itemtype => itemtype,
2347: itemkey => itemkey,
2348: aname => 'INSTANCE_CODE');
2349: p_dblink :=
2350: wf_engine.GetItemAttrText( itemtype => itemtype,
2351: itemkey => itemkey,
2352: aname => 'DBLINK');
2353:
2354: --commenting out the foll code as this procedure is not being used anywhere.

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

2435:
2436: msc_util.msc_debug('request id is '||p_request_id
2437: ||', in instance '||p_instance_code);
2438:
2439: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2440: itemkey => itemkey,
2441: aname => 'REQUEST_ID',
2442: avalue => p_request_id);
2443: commit;

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

3479: if l_planner is not null then
3480: FND_FILE.PUT_LINE(FND_FILE.LOG,'notification will sent to planner '||l_planner);
3481: end if;
3482:
3483: wf_engine.CreateProcess( itemtype => item_type,
3484: itemkey => item_key,
3485: process => l_process);
3486:
3487: wf_engine.SetItemAttrNumber( itemtype => item_type,

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

3483: wf_engine.CreateProcess( itemtype => item_type,
3484: itemkey => item_key,
3485: process => l_process);
3486:
3487: wf_engine.SetItemAttrNumber( itemtype => item_type,
3488: itemkey => item_key,
3489: aname => 'EXCEPTION_TYPE_ID',
3490: avalue => 70); -- new exception type
3491:

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

3488: itemkey => item_key,
3489: aname => 'EXCEPTION_TYPE_ID',
3490: avalue => 70); -- new exception type
3491:
3492: wf_engine.SetItemAttrNumber( itemtype => item_type,
3493: itemkey => item_key,
3494: aname => 'ORDER_TYPE_CODE',
3495: avalue => -30); -- from release so
3496:

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

3493: itemkey => item_key,
3494: aname => 'ORDER_TYPE_CODE',
3495: avalue => -30); -- from release so
3496:
3497: wf_engine.SetItemAttrNumber( itemtype => item_type,
3498: itemkey => item_key,
3499: aname => 'TRANSACTION_ID',
3500: avalue => all_rec.demand_id);
3501:

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

3498: itemkey => item_key,
3499: aname => 'TRANSACTION_ID',
3500: avalue => all_rec.demand_id);
3501:
3502: wf_engine.SetItemAttrNumber( itemtype => item_type,
3503: itemkey => item_key,
3504: aname => 'INVENTORY_ITEM_ID',
3505: avalue => all_rec.inventory_item_id);
3506:

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

3503: itemkey => item_key,
3504: aname => 'INVENTORY_ITEM_ID',
3505: avalue => all_rec.inventory_item_id);
3506:
3507: wf_engine.SetItemAttrNumber( itemtype => item_type,
3508: itemkey => item_key,
3509: aname => 'ORGANIZATION_ID',
3510: avalue => all_rec.organization_id);
3511:

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

3508: itemkey => item_key,
3509: aname => 'ORGANIZATION_ID',
3510: avalue => all_rec.organization_id);
3511:
3512: wf_engine.SetItemAttrNumber( itemtype => item_type,
3513: itemkey => item_key,
3514: aname => 'INSTANCE_ID',
3515: avalue => all_rec.sr_instance_id);
3516:

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

3513: itemkey => item_key,
3514: aname => 'INSTANCE_ID',
3515: avalue => all_rec.sr_instance_id);
3516:
3517: wf_engine.SetItemAttrNumber( itemtype => item_type,
3518: itemkey => item_key,
3519: aname => 'SUPPLIER_ID',
3520: avalue => p_batch_id);
3521:

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

3518: itemkey => item_key,
3519: aname => 'SUPPLIER_ID',
3520: avalue => p_batch_id);
3521:
3522: wf_engine.SetItemAttrNumber( itemtype => item_type,
3523: itemkey => item_key,
3524: aname => 'PLAN_ID',
3525: avalue => all_rec.plan_id);
3526:

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

3523: itemkey => item_key,
3524: aname => 'PLAN_ID',
3525: avalue => all_rec.plan_id);
3526:
3527: wf_engine.SetItemAttrNumber( itemtype => item_type,
3528: itemkey => item_key,
3529: aname => 'PRE_PRSNG_LEAD_TIME',
3530: avalue => all_rec.old_lead_time);
3531:

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

3528: itemkey => item_key,
3529: aname => 'PRE_PRSNG_LEAD_TIME',
3530: avalue => all_rec.old_lead_time);
3531:
3532: wf_engine.SetItemAttrNumber( itemtype => item_type,
3533: itemkey => item_key,
3534: aname => 'POST_PRSNG_LEAD_TIME',
3535: avalue => all_rec.new_lead_time);
3536:

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

3533: itemkey => item_key,
3534: aname => 'POST_PRSNG_LEAD_TIME',
3535: avalue => all_rec.new_lead_time);
3536:
3537: wf_engine.SetItemAttrText( itemtype => item_type,
3538: itemkey => item_key,
3539: aname => 'ORGANIZATION_CODE',
3540: avalue => all_rec.org_code);
3541:

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

3538: itemkey => item_key,
3539: aname => 'ORGANIZATION_CODE',
3540: avalue => all_rec.org_code);
3541:
3542: wf_engine.SetItemAttrText( itemtype => item_type,
3543: itemkey => item_key,
3544: aname => 'PLAN_NAME',
3545: avalue => all_rec.plan_name);
3546:

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

3543: itemkey => item_key,
3544: aname => 'PLAN_NAME',
3545: avalue => all_rec.plan_name);
3546:
3547: wf_engine.SetItemAttrText( itemtype => item_type,
3548: itemkey => item_key,
3549: aname => 'DEPARTMENT_LINE_CODE',
3550: avalue => all_rec.to_org);
3551:

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

3548: itemkey => item_key,
3549: aname => 'DEPARTMENT_LINE_CODE',
3550: avalue => all_rec.to_org);
3551:
3552: wf_engine.SetItemAttrText( itemtype => item_type,
3553: itemkey => item_key,
3554: aname => 'ITEM_DISPLAY_NAME',
3555: avalue => all_rec.item_name);
3556:

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

3553: itemkey => item_key,
3554: aname => 'ITEM_DISPLAY_NAME',
3555: avalue => all_rec.item_name);
3556:
3557: wf_engine.SetItemAttrText( itemtype => item_type,
3558: itemkey => item_key,
3559: aname => 'ITEM_DESCRIPTION',
3560: avalue => all_rec.item_desc);
3561:

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

3558: itemkey => item_key,
3559: aname => 'ITEM_DESCRIPTION',
3560: avalue => all_rec.item_desc);
3561:
3562: wf_engine.SetItemAttrDate( itemtype => item_type,
3563: itemkey => item_key,
3564: aname => 'FROM_DATE',
3565: avalue => all_rec.old_ship_date);
3566:

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

3563: itemkey => item_key,
3564: aname => 'FROM_DATE',
3565: avalue => all_rec.old_ship_date);
3566:
3567: wf_engine.SetItemAttrDate( itemtype => item_type,
3568: itemkey => item_key,
3569: aname => 'TO_DATE',
3570: avalue => all_rec.new_ship_date);
3571:

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

3568: itemkey => item_key,
3569: aname => 'TO_DATE',
3570: avalue => all_rec.new_ship_date);
3571:
3572: wf_engine.SetItemAttrDate( itemtype => item_type,
3573: itemkey => item_key,
3574: aname => 'DATE1',
3575: avalue => all_rec.old_arrival_date);
3576:

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

3573: itemkey => item_key,
3574: aname => 'DATE1',
3575: avalue => all_rec.old_arrival_date);
3576:
3577: wf_engine.SetItemAttrDate( itemtype => item_type,
3578: itemkey => item_key,
3579: aname => 'DATE2',
3580: avalue => all_rec.new_arrival_date);
3581:

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

3578: itemkey => item_key,
3579: aname => 'DATE2',
3580: avalue => all_rec.new_arrival_date);
3581:
3582: wf_engine.SetItemAttrDate( itemtype => item_type,
3583: itemkey => item_key,
3584: aname => 'DATE3',
3585: avalue => all_rec.earliest_ship_date);
3586:

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

3583: itemkey => item_key,
3584: aname => 'DATE3',
3585: avalue => all_rec.earliest_ship_date);
3586:
3587: wf_engine.SetItemAttrText( itemtype => item_type,
3588: itemkey => item_key,
3589: aname => 'CUSTOMER_NAME',
3590: avalue => all_rec.customer_name);
3591:

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

3588: itemkey => item_key,
3589: aname => 'CUSTOMER_NAME',
3590: avalue => all_rec.customer_name);
3591:
3592: wf_engine.SetItemAttrText( itemtype => item_type,
3593: itemkey => item_key,
3594: aname => 'RESOURCE_CODE',
3595: avalue => all_rec.customer_site);
3596:

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

3593: itemkey => item_key,
3594: aname => 'RESOURCE_CODE',
3595: avalue => all_rec.customer_site);
3596:
3597: wf_engine.SetItemAttrText( itemtype => item_type,
3598: itemkey => item_key,
3599: aname => 'SUPPLIER_NAME',
3600: avalue => all_rec.old_ship_method);
3601:

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

3598: itemkey => item_key,
3599: aname => 'SUPPLIER_NAME',
3600: avalue => all_rec.old_ship_method);
3601:
3602: wf_engine.SetItemAttrText( itemtype => item_type,
3603: itemkey => item_key,
3604: aname => 'SUPPLIER_SITE_CODE',
3605: avalue => all_rec.new_ship_method);
3606:

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

3603: itemkey => item_key,
3604: aname => 'SUPPLIER_SITE_CODE',
3605: avalue => all_rec.new_ship_method);
3606:
3607: wf_engine.SetItemAttrText( itemtype => item_type,
3608: itemkey => item_key,
3609: aname => 'ORDER_NUMBER',
3610: avalue => all_rec.order_number);
3611:

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

3608: itemkey => item_key,
3609: aname => 'ORDER_NUMBER',
3610: avalue => all_rec.order_number);
3611:
3612: wf_engine.SetItemAttrText( itemtype => item_type,
3613: itemkey => item_key,
3614: aname => 'LOT_NUMBER',
3615: avalue => all_rec.line_number);
3616:

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

3613: itemkey => item_key,
3614: aname => 'LOT_NUMBER',
3615: avalue => all_rec.line_number);
3616:
3617: wf_engine.SetItemAttrText( itemtype => item_type,
3618: itemkey => item_key,
3619: aname => 'PLANNING_GROUP',
3620: avalue => all_rec.atp_override_flag);
3621:

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

3618: itemkey => item_key,
3619: aname => 'PLANNING_GROUP',
3620: avalue => all_rec.atp_override_flag);
3621:
3622: wf_engine.SetItemAttrText( itemtype => item_type,
3623: itemkey => item_key,
3624: aname => 'END_ITEM_DISPLAY_NAME',
3625: avalue => all_rec.orig_item_name);
3626:

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

3623: itemkey => item_key,
3624: aname => 'END_ITEM_DISPLAY_NAME',
3625: avalue => all_rec.orig_item_name);
3626:
3627: wf_engine.SetItemAttrText( itemtype => item_type,
3628: itemkey => item_key,
3629: aname => 'END_ITEM_DESCRIPTION',
3630: avalue => all_rec.orig_item_desc);
3631:

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

3628: itemkey => item_key,
3629: aname => 'END_ITEM_DESCRIPTION',
3630: avalue => all_rec.orig_item_desc);
3631:
3632: wf_engine.StartProcess( itemtype => item_type,
3633: itemkey => item_key);
3634: FND_FILE.PUT_LINE(FND_FILE.LOG,'item_key='||item_key||', item_type='||item_type);
3635:
3636: END LOOP;