DBA Data[Home] [Help]

APPS.QA_SS_IMPORT_WF dependencies on WF_ENGINE

Line 64: x_num_workers := wf_engine.getitemattrnumber(

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

Line 69: wf_engine.setitemattrnumber(

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

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

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

Line 97: x_num_workers := wf_engine.getitemattrnumber(

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

Line 159: x_request_id := wf_engine.getitemattrnumber(

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

Line 278: wf_engine.setitemattrtext(

274:
275: IF x_buyer_id IS NOT NULL THEN
276: x_buyer_name := get_buyer_name(x_buyer_id);
277: END IF;
278: wf_engine.setitemattrtext(
279: itemtype => x_itemtype,
280: itemkey => x_itemkey,
281: aname => 'BUYER_NAME',
282: avalue => x_buyer_name);

Line 292: wf_engine.setitemattrtext(

288: IF x_source_id IS NOT NULL THEN
289: x_user_name := get_user_name(x_source_id);
290: set_supplier_info(x_source_id, x_itemkey, x_itemtype);
291: END IF;
292: wf_engine.setitemattrtext(
293: itemtype => x_itemtype,
294: itemkey => x_itemkey,
295: aname => 'USER_NAME',
296: avalue => x_user_name);

Line 305: wf_engine.setitemattrtext(

301:
302: IF x_plan_id IS NOT NULL THEN
303: x_plan_name := get_plan_name(x_plan_id);
304: END IF;
305: wf_engine.setitemattrtext(
306: itemtype => x_itemtype,
307: itemkey => x_itemkey,
308: aname => 'PLAN_NAME',
309: avalue => x_plan_name);

Line 316: wf_engine.setitemattrnumber(

312: --Get OrgId and set it.
313: --
314:
315: x_org_id := get_org_id(x_plan_id);
316: wf_engine.setitemattrnumber(
317: itemtype => x_itemtype,
318: itemkey => x_itemkey,
319: aname => 'ORGANIZATION_ID',
320: avalue => x_org_id);

Line 335: wf_engine.setitemattrtext(

331: --
332:
333: x_org_code := get_org_code(x_org_id);
334:
335: wf_engine.setitemattrtext(
336: itemtype => x_itemtype,
337: itemkey => x_itemkey,
338: aname => 'ORGANIZATION_CODE',
339: avalue => x_org_code);

Line 346: wf_engine.setitemattrtext(

342: --Get OrgName and set it.
343: --
344:
345: x_org_name := get_org_name(x_org_id);
346: wf_engine.setitemattrtext(
347: itemtype => x_itemtype,
348: itemkey => x_itemkey,
349: aname => 'ORGANIZATION_NAME',
350: avalue => x_org_name);

Line 359: wf_engine.setitemattrtext(

355:
356: IF x_item_id IS NOT NULL THEN
357: x_item := get_item(x_item_id);
358: END IF;
359: wf_engine.setitemattrtext(
360: itemtype => x_itemtype,
361: itemkey => x_itemkey,
362: aname => 'ITEM',
363: avalue => x_item);

Line 372: wf_engine.setitemattrtext(

368:
369: IF x_po_header_id IS NOT NULL THEN
370: x_po_number := get_po_number(x_po_header_id);
371: END IF;
372: wf_engine.setitemattrtext(
373: itemtype => x_itemtype,
374: itemkey => x_itemkey,
375: aname => 'PO_NUMBER',
376: avalue => x_po_number);

Line 382: wf_engine.startprocess(

378: --
379: --Start WF Process
380: --
381:
382: wf_engine.startprocess(
383: itemtype => x_itemtype,
384: itemkey => x_itemkey);
385: END start_buyer_notification;
386:

Line 422: x_buyer_name := wf_engine.getitemattrtext(

418:
419: BEGIN
420: IF (funcmode='RUN') THEN
421:
422: x_buyer_name := wf_engine.getitemattrtext(
423: itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'BUYER_NAME');
426: x_plan_name := wf_engine.getitemattrtext(

Line 426: x_plan_name := wf_engine.getitemattrtext(

422: x_buyer_name := wf_engine.getitemattrtext(
423: itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'BUYER_NAME');
426: x_plan_name := wf_engine.getitemattrtext(
427: itemtype => itemtype,
428: itemkey => itemkey,
429: aname => 'PLAN_NAME');
430: x_user_name := wf_engine.getitemattrtext(

Line 430: x_user_name := wf_engine.getitemattrtext(

426: x_plan_name := wf_engine.getitemattrtext(
427: itemtype => itemtype,
428: itemkey => itemkey,
429: aname => 'PLAN_NAME');
430: x_user_name := wf_engine.getitemattrtext(
431: itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'USER_NAME');
434: x_item := wf_engine.getitemattrtext(

Line 434: x_item := wf_engine.getitemattrtext(

430: x_user_name := wf_engine.getitemattrtext(
431: itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'USER_NAME');
434: x_item := wf_engine.getitemattrtext(
435: itemtype => itemtype,
436: itemkey => itemkey,
437: aname => 'ITEM');
438: x_supplier_name := wf_engine.getitemattrtext(

Line 438: x_supplier_name := wf_engine.getitemattrtext(

434: x_item := wf_engine.getitemattrtext(
435: itemtype => itemtype,
436: itemkey => itemkey,
437: aname => 'ITEM');
438: x_supplier_name := wf_engine.getitemattrtext(
439: itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'SUPPLIER_NAME');
442: x_contact_name := wf_engine.getitemattrtext(

Line 442: x_contact_name := wf_engine.getitemattrtext(

438: x_supplier_name := wf_engine.getitemattrtext(
439: itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'SUPPLIER_NAME');
442: x_contact_name := wf_engine.getitemattrtext(
443: itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'CONTACT_NAME');
446: x_contact_phone := wf_engine.getitemattrtext(

Line 446: x_contact_phone := wf_engine.getitemattrtext(

442: x_contact_name := wf_engine.getitemattrtext(
443: itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'CONTACT_NAME');
446: x_contact_phone := wf_engine.getitemattrtext(
447: itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'CONTACT_PHONE');
450: x_po_number := wf_engine.getitemattrtext(

Line 450: x_po_number := wf_engine.getitemattrtext(

446: x_contact_phone := wf_engine.getitemattrtext(
447: itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'CONTACT_PHONE');
450: x_po_number := wf_engine.getitemattrtext(
451: itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'PO_NUMBER');
454:

Line 455: x_org_id := wf_engine.getitemattrnumber(

451: itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'PO_NUMBER');
454:
455: x_org_id := wf_engine.getitemattrnumber(
456: itemtype => itemtype,
457: itemkey => itemkey,
458: aname => 'ORGANIZATION_ID');
459:

Line 464: x_org_code := wf_engine.getitemattrtext(

460: -- The next two gets are added to resolve the bug 1052466
461: --
462: -- orashid
463:
464: x_org_code := wf_engine.getitemattrtext(
465: itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'ORGANIZATION_CODE');
468:

Line 469: x_org_name := wf_engine.getitemattrtext(

465: itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'ORGANIZATION_CODE');
468:
469: x_org_name := wf_engine.getitemattrtext(
470: itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'ORGANIZATION_NAME');
473:

Line 523: wf_engine.createprocess(

519: BEGIN
520: open c;
521: fetch c INTO x_itemkey;
522: close c;
523: wf_engine.createprocess(
524: itemtype => x_type,
525: itemkey => x_itemkey,
526: process => 'BUYER_NOTIFICATION');
527: RETURN x_itemkey;

Line 781: wf_engine.setitemattrtext(

777:
778: open c(l_supplier_id);
779: fetch c INTO x_supplier_name, x_contact_name, x_contact_phone;
780: IF c%found THEN
781: wf_engine.setitemattrtext(
782: itemtype => x_itemtype,
783: itemkey => x_itemkey,
784: aname => 'SUPPLIER_NAME',
785: avalue => x_supplier_name);

Line 786: wf_engine.setitemattrtext(

782: itemtype => x_itemtype,
783: itemkey => x_itemkey,
784: aname => 'SUPPLIER_NAME',
785: avalue => x_supplier_name);
786: wf_engine.setitemattrtext(
787: itemtype => x_itemtype,
788: itemkey => x_itemkey,
789: aname => 'CONTACT_NAME',
790: avalue => x_contact_name);

Line 791: wf_engine.setitemattrtext(

787: itemtype => x_itemtype,
788: itemkey => x_itemkey,
789: aname => 'CONTACT_NAME',
790: avalue => x_contact_name);
791: wf_engine.setitemattrtext(
792: itemtype => x_itemtype,
793: itemkey => x_itemkey,
794: aname => 'CONTACT_PHONE',
795: avalue => x_contact_phone);