DBA Data[Home] [Help]

APPS.QA_SS_IMPORT_WF dependencies on WF_ENGINE

Line 66: x_num_workers := wf_engine.getitemattrnumber(

62:
63: PROCEDURE unblock (item_type IN VARCHAR2, key IN NUMBER) IS
64: x_num_workers NUMBER;
65: BEGIN
66: x_num_workers := wf_engine.getitemattrnumber(
67: itemtype => item_type,
68: itemkey => key,
69: aname => 'NUM_WORKERS');
70: x_num_workers := x_num_workers - 1;

Line 71: wf_engine.setitemattrnumber(

67: itemtype => item_type,
68: itemkey => key,
69: aname => 'NUM_WORKERS');
70: x_num_workers := x_num_workers - 1;
71: wf_engine.setitemattrnumber(
72: itemtype => item_type,
73: itemkey => key,
74: aname => 'NUM_WORKERS',
75: avalue => x_num_workers);

Line 76: wf_engine.completeactivity(item_type, key, 'BLOCK', NULL);

72: itemtype => item_type,
73: itemkey => key,
74: aname => 'NUM_WORKERS',
75: avalue => x_num_workers);
76: wf_engine.completeactivity(item_type, key, 'BLOCK', NULL);
77: RETURN;
78: END unblock;
79:
80: --

Line 99: x_num_workers := wf_engine.getitemattrnumber(

95: x_num_workers NUMBER;
96: x_comp_workers NUMBER;
97: BEGIN
98: IF (funcmode = 'RUN') THEN
99: x_num_workers := wf_engine.getitemattrnumber(
100: itemtype => itemtype,
101: itemkey => itemkey,
102: aname => 'NUM_WORKERS');
103:

Line 161: x_request_id := wf_engine.getitemattrnumber(

157: fu2.user_name, fu3.user_name;
158:
159: BEGIN
160: IF (funcmode = 'RUN') THEN
161: x_request_id := wf_engine.getitemattrnumber(
162: itemtype => 'QASSIMP',
163: itemkey => itemkey,
164: aname => 'REQUEST_ID');
165:

Line 290: wf_engine.setitemattrtext(

286:
287: IF x_buyer_id IS NOT NULL THEN
288: x_buyer_name := get_buyer_name(x_buyer_id);
289: END IF;
290: wf_engine.setitemattrtext(
291: itemtype => x_itemtype,
292: itemkey => x_itemkey,
293: aname => 'BUYER_NAME',
294: avalue => x_buyer_name);

Line 304: wf_engine.setitemattrtext(

300: IF x_source_id IS NOT NULL THEN
301: x_user_name := get_user_name(x_source_id);
302: set_supplier_info(x_source_id, x_itemkey, x_itemtype);
303: END IF;
304: wf_engine.setitemattrtext(
305: itemtype => x_itemtype,
306: itemkey => x_itemkey,
307: aname => 'USER_NAME',
308: avalue => x_user_name);

Line 317: wf_engine.setitemattrtext(

313:
314: IF x_plan_id IS NOT NULL THEN
315: x_plan_name := get_plan_name(x_plan_id);
316: END IF;
317: wf_engine.setitemattrtext(
318: itemtype => x_itemtype,
319: itemkey => x_itemkey,
320: aname => 'PLAN_NAME',
321: avalue => x_plan_name);

Line 328: wf_engine.setitemattrnumber(

324: --Get OrgId and set it.
325: --
326:
327: x_org_id := get_org_id(x_plan_id);
328: wf_engine.setitemattrnumber(
329: itemtype => x_itemtype,
330: itemkey => x_itemkey,
331: aname => 'ORGANIZATION_ID',
332: avalue => x_org_id);

Line 347: wf_engine.setitemattrtext(

343: --
344:
345: x_org_code := get_org_code(x_org_id);
346:
347: wf_engine.setitemattrtext(
348: itemtype => x_itemtype,
349: itemkey => x_itemkey,
350: aname => 'ORGANIZATION_CODE',
351: avalue => x_org_code);

Line 358: wf_engine.setitemattrtext(

354: --Get OrgName and set it.
355: --
356:
357: x_org_name := get_org_name(x_org_id);
358: wf_engine.setitemattrtext(
359: itemtype => x_itemtype,
360: itemkey => x_itemkey,
361: aname => 'ORGANIZATION_NAME',
362: avalue => x_org_name);

Line 371: wf_engine.setitemattrtext(

367:
368: IF x_item_id IS NOT NULL THEN
369: x_item := get_item(x_item_id);
370: END IF;
371: wf_engine.setitemattrtext(
372: itemtype => x_itemtype,
373: itemkey => x_itemkey,
374: aname => 'ITEM',
375: avalue => x_item);

Line 384: wf_engine.setitemattrtext(

380:
381: IF x_po_header_id IS NOT NULL THEN
382: x_po_number := get_po_number(x_po_header_id);
383: END IF;
384: wf_engine.setitemattrtext(
385: itemtype => x_itemtype,
386: itemkey => x_itemkey,
387: aname => 'PO_NUMBER',
388: avalue => x_po_number);

Line 394: wf_engine.startprocess(

390: --
391: --Start WF Process
392: --
393:
394: wf_engine.startprocess(
395: itemtype => x_itemtype,
396: itemkey => x_itemkey);
397: END start_buyer_notification;
398:

Line 444: x_buyer_name := wf_engine.getitemattrtext(

440:
441: BEGIN
442: IF (funcmode='RUN') THEN
443:
444: x_buyer_name := wf_engine.getitemattrtext(
445: itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'BUYER_NAME');
448: x_plan_name := wf_engine.getitemattrtext(

Line 448: x_plan_name := wf_engine.getitemattrtext(

444: x_buyer_name := wf_engine.getitemattrtext(
445: itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'BUYER_NAME');
448: x_plan_name := wf_engine.getitemattrtext(
449: itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'PLAN_NAME');
452: x_user_name := wf_engine.getitemattrtext(

Line 452: x_user_name := wf_engine.getitemattrtext(

448: x_plan_name := wf_engine.getitemattrtext(
449: itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'PLAN_NAME');
452: x_user_name := wf_engine.getitemattrtext(
453: itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'USER_NAME');
456: x_item := wf_engine.getitemattrtext(

Line 456: x_item := wf_engine.getitemattrtext(

452: x_user_name := wf_engine.getitemattrtext(
453: itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'USER_NAME');
456: x_item := wf_engine.getitemattrtext(
457: itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'ITEM');
460: x_supplier_name := wf_engine.getitemattrtext(

Line 460: x_supplier_name := wf_engine.getitemattrtext(

456: x_item := wf_engine.getitemattrtext(
457: itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'ITEM');
460: x_supplier_name := wf_engine.getitemattrtext(
461: itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'SUPPLIER_NAME');
464: x_contact_name := wf_engine.getitemattrtext(

Line 464: x_contact_name := wf_engine.getitemattrtext(

460: x_supplier_name := wf_engine.getitemattrtext(
461: itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'SUPPLIER_NAME');
464: x_contact_name := wf_engine.getitemattrtext(
465: itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'CONTACT_NAME');
468: x_contact_phone := wf_engine.getitemattrtext(

Line 468: x_contact_phone := wf_engine.getitemattrtext(

464: x_contact_name := wf_engine.getitemattrtext(
465: itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'CONTACT_NAME');
468: x_contact_phone := wf_engine.getitemattrtext(
469: itemtype => itemtype,
470: itemkey => itemkey,
471: aname => 'CONTACT_PHONE');
472: x_po_number := wf_engine.getitemattrtext(

Line 472: x_po_number := wf_engine.getitemattrtext(

468: x_contact_phone := wf_engine.getitemattrtext(
469: itemtype => itemtype,
470: itemkey => itemkey,
471: aname => 'CONTACT_PHONE');
472: x_po_number := wf_engine.getitemattrtext(
473: itemtype => itemtype,
474: itemkey => itemkey,
475: aname => 'PO_NUMBER');
476:

Line 477: x_org_id := wf_engine.getitemattrnumber(

473: itemtype => itemtype,
474: itemkey => itemkey,
475: aname => 'PO_NUMBER');
476:
477: x_org_id := wf_engine.getitemattrnumber(
478: itemtype => itemtype,
479: itemkey => itemkey,
480: aname => 'ORGANIZATION_ID');
481:

Line 486: x_org_code := wf_engine.getitemattrtext(

482: -- The next two gets are added to resolve the bug 1052466
483: --
484: -- orashid
485:
486: x_org_code := wf_engine.getitemattrtext(
487: itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'ORGANIZATION_CODE');
490:

Line 491: x_org_name := wf_engine.getitemattrtext(

487: itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'ORGANIZATION_CODE');
490:
491: x_org_name := wf_engine.getitemattrtext(
492: itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'ORGANIZATION_NAME');
495:

Line 548: wf_engine.createprocess(

544: BEGIN
545: open c;
546: fetch c INTO x_itemkey;
547: close c;
548: wf_engine.createprocess(
549: itemtype => x_type,
550: itemkey => x_itemkey,
551: process => 'BUYER_NOTIFICATION');
552: RETURN x_itemkey;

Line 814: wf_engine.setitemattrtext(

810:
811: open c(l_supplier_id);
812: fetch c INTO x_supplier_name, x_contact_name, x_contact_phone;
813: IF c%found THEN
814: wf_engine.setitemattrtext(
815: itemtype => x_itemtype,
816: itemkey => x_itemkey,
817: aname => 'SUPPLIER_NAME',
818: avalue => x_supplier_name);

Line 819: wf_engine.setitemattrtext(

815: itemtype => x_itemtype,
816: itemkey => x_itemkey,
817: aname => 'SUPPLIER_NAME',
818: avalue => x_supplier_name);
819: wf_engine.setitemattrtext(
820: itemtype => x_itemtype,
821: itemkey => x_itemkey,
822: aname => 'CONTACT_NAME',
823: avalue => x_contact_name);

Line 824: wf_engine.setitemattrtext(

820: itemtype => x_itemtype,
821: itemkey => x_itemkey,
822: aname => 'CONTACT_NAME',
823: avalue => x_contact_name);
824: wf_engine.setitemattrtext(
825: itemtype => x_itemtype,
826: itemkey => x_itemkey,
827: aname => 'CONTACT_PHONE',
828: avalue => x_contact_phone);