DBA Data[Home] [Help]

APPS.GMD_QMSED dependencies on WF_ENGINE

Line 16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

12: p_funcmode IN VARCHAR2,
13: p_resultout OUT NOCOPY VARCHAR2)
14:
15: IS
16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: itemtype=>p_itemtype,
18: itemkey=>P_itemkey,
19: aname=>'EVENT_NAME');
20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: itemtype=>p_itemtype,
18: itemkey=>P_itemkey,
19: aname=>'EVENT_NAME');
20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
21: itemtype=>p_itemtype,
22: itemkey=>P_itemkey,
23: aname=>'EVENT_KEY');
24:

Line 400: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

396: IF (l_debug = 'Y') THEN
397: gmd_debug.put_line('Setting up workflow attributes ');
398: END IF;
399:
400: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
401: aname => 'CURRENT_APPROVER',
402: avalue => l_user);
403: /* Set All other Attributes */
404:

Line 405: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

401: aname => 'CURRENT_APPROVER',
402: avalue => l_user);
403: /* Set All other Attributes */
404:
405: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
406: aname => 'APPS_FORM',
407: avalue =>l_form );
408: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
409: aname => 'ORGN_CODE',

Line 408: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

404:
405: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
406: aname => 'APPS_FORM',
407: avalue =>l_form );
408: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
409: aname => 'ORGN_CODE',
410: avalue =>l_orgn_code);
411: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
412: aname => 'ITEM_NO',

Line 411: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

407: avalue =>l_form );
408: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
409: aname => 'ORGN_CODE',
410: avalue =>l_orgn_code);
411: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
412: aname => 'ITEM_NO',
413: avalue =>l_item_no );
414: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
415: aname => 'ITEM_REVISION',

Line 414: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

410: avalue =>l_orgn_code);
411: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
412: aname => 'ITEM_NO',
413: avalue =>l_item_no );
414: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
415: aname => 'ITEM_REVISION',
416: avalue =>l_item_revision );
417: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
418: aname => 'ITEM_DESC',

Line 417: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

413: avalue =>l_item_no );
414: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
415: aname => 'ITEM_REVISION',
416: avalue =>l_item_revision );
417: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
418: aname => 'ITEM_DESC',
419: avalue =>l_item_desc );
420: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
421: aname => 'LOT_NO',

Line 420: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

416: avalue =>l_item_revision );
417: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
418: aname => 'ITEM_DESC',
419: avalue =>l_item_desc );
420: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
421: aname => 'LOT_NO',
422: avalue =>l_lot_no );
423: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
424: aname => 'SAMPLE_NO',

Line 423: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

419: avalue =>l_item_desc );
420: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
421: aname => 'LOT_NO',
422: avalue =>l_lot_no );
423: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
424: aname => 'SAMPLE_NO',
425: avalue =>l_sample_no );
426: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
427: aname => 'SAMPLE_DESC',

Line 426: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

422: avalue =>l_lot_no );
423: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
424: aname => 'SAMPLE_NO',
425: avalue =>l_sample_no );
426: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
427: aname => 'SAMPLE_DESC',
428: avalue =>l_sample_desc );
429: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
430: aname => 'SAMPLE_PLAN',

Line 429: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

425: avalue =>l_sample_no );
426: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
427: aname => 'SAMPLE_DESC',
428: avalue =>l_sample_desc );
429: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
430: aname => 'SAMPLE_PLAN',
431: avalue =>l_sample_plan );
432: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
433: aname => 'SAMPLE_DISPOSITION',

Line 432: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

428: avalue =>l_sample_desc );
429: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
430: aname => 'SAMPLE_PLAN',
431: avalue =>l_sample_plan );
432: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
433: aname => 'SAMPLE_DISPOSITION',
434: avalue =>l_sample_disposition );
435: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
436: aname => 'SAMPLE_SOURCE',

Line 435: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

431: avalue =>l_sample_plan );
432: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
433: aname => 'SAMPLE_DISPOSITION',
434: avalue =>l_sample_disposition );
435: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
436: aname => 'SAMPLE_SOURCE',
437: avalue =>l_sample_SOURCE );
438: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
439: aname => 'SPECIFICATION',

Line 438: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

434: avalue =>l_sample_disposition );
435: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
436: aname => 'SAMPLE_SOURCE',
437: avalue =>l_sample_SOURCE );
438: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
439: aname => 'SPECIFICATION',
440: avalue =>l_SPECIFICATION );
441: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
442: aname => 'SPECIFICATION_VERSION',

Line 441: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

437: avalue =>l_sample_SOURCE );
438: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
439: aname => 'SPECIFICATION',
440: avalue =>l_SPECIFICATION );
441: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
442: aname => 'SPECIFICATION_VERSION',
443: avalue =>l_spec_vers );
444: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
445: aname => 'GRADE_CODE',

Line 444: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

440: avalue =>l_SPECIFICATION );
441: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
442: aname => 'SPECIFICATION_VERSION',
443: avalue =>l_spec_vers );
444: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
445: aname => 'GRADE_CODE',
446: avalue =>l_grade_code );
447: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
448: aname => '#FROM_ROLE',

Line 447: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

443: avalue =>l_spec_vers );
444: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
445: aname => 'GRADE_CODE',
446: avalue =>l_grade_code );
447: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
448: aname => '#FROM_ROLE',
449: avalue =>l_from_role );
450:
451: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

Line 451: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

447: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
448: aname => '#FROM_ROLE',
449: avalue =>l_from_role );
450:
451: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
452: aname => 'AME_TRANS',
453: avalue =>l_transaction_type );
454:
455: P_resultout:='COMPLETE:'||l_transaction_type;

Line 481: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

477: p_funcmode IN VARCHAR2,
478: p_resultout OUT NOCOPY VARCHAR2)
479:
480: IS
481: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
482: itemtype=>p_itemtype,
483: itemkey=>P_itemkey,
484: aname=>'EVENT_NAME');
485: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 485: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

481: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
482: itemtype=>p_itemtype,
483: itemkey=>P_itemkey,
484: aname=>'EVENT_NAME');
485: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
486: itemtype=>p_itemtype,
487: itemkey=>P_itemkey,
488: aname=>'EVENT_KEY');
489:

Line 493: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(

489:
490: l_current_approver varchar2(240);
491:
492: l_application_id number;
493: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
494: itemtype=>p_itemtype,
495: itemkey=>P_itemkey,
496: aname=>'AME_TRANS');
497: l_user varchar2(32);

Line 551: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

547: end if;
548:
549: /* Set the User Attribute */
550:
551: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
552: aname => 'CURRENT_APPROVER',
553: avalue => l_user);
554: P_resultout:='COMPLETE:Y';
555: Approver.approval_status := ame_util.approvedStatus;