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 413: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

409: IF (l_debug = 'Y') THEN
410: gmd_debug.put_line('Setting up workflow attributes ');
411: END IF;
412:
413: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
414: aname => 'CURRENT_APPROVER',
415: avalue => l_user);
416: /* Set All other Attributes */
417:

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

414: aname => 'CURRENT_APPROVER',
415: avalue => l_user);
416: /* Set All other Attributes */
417:
418: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
419: aname => 'APPS_FORM',
420: avalue =>l_form );
421: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
422: aname => 'ORGN_CODE',

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

417:
418: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
419: aname => 'APPS_FORM',
420: avalue =>l_form );
421: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
422: aname => 'ORGN_CODE',
423: avalue =>l_orgn_code);
424: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
425: aname => 'ITEM_NO',

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

420: avalue =>l_form );
421: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
422: aname => 'ORGN_CODE',
423: avalue =>l_orgn_code);
424: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
425: aname => 'ITEM_NO',
426: avalue =>l_item_no );
427: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
428: aname => 'ITEM_REVISION',

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

423: avalue =>l_orgn_code);
424: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
425: aname => 'ITEM_NO',
426: avalue =>l_item_no );
427: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
428: aname => 'ITEM_REVISION',
429: avalue =>l_item_revision );
430: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
431: aname => 'ITEM_DESC',

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

426: avalue =>l_item_no );
427: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
428: aname => 'ITEM_REVISION',
429: avalue =>l_item_revision );
430: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
431: aname => 'ITEM_DESC',
432: avalue =>l_item_desc );
433: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
434: aname => 'LOT_NO',

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

429: avalue =>l_item_revision );
430: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
431: aname => 'ITEM_DESC',
432: avalue =>l_item_desc );
433: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
434: aname => 'LOT_NO',
435: avalue =>l_lot_no );
436: --RLNAGARA LPN ME 7027149
437: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

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

433: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
434: aname => 'LOT_NO',
435: avalue =>l_lot_no );
436: --RLNAGARA LPN ME 7027149
437: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
438: aname => 'LPN',
439: avalue =>l_lpn );
440: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
441: aname => 'SAMPLE_NO',

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

436: --RLNAGARA LPN ME 7027149
437: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
438: aname => 'LPN',
439: avalue =>l_lpn );
440: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
441: aname => 'SAMPLE_NO',
442: avalue =>l_sample_no );
443: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
444: aname => 'SAMPLE_DESC',

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

439: avalue =>l_lpn );
440: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
441: aname => 'SAMPLE_NO',
442: avalue =>l_sample_no );
443: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
444: aname => 'SAMPLE_DESC',
445: avalue =>l_sample_desc );
446: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
447: aname => 'SAMPLE_PLAN',

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

442: avalue =>l_sample_no );
443: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
444: aname => 'SAMPLE_DESC',
445: avalue =>l_sample_desc );
446: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
447: aname => 'SAMPLE_PLAN',
448: avalue =>l_sample_plan );
449: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
450: aname => 'SAMPLE_DISPOSITION',

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

445: avalue =>l_sample_desc );
446: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
447: aname => 'SAMPLE_PLAN',
448: avalue =>l_sample_plan );
449: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
450: aname => 'SAMPLE_DISPOSITION',
451: avalue =>l_sample_disposition );
452: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
453: aname => 'SAMPLE_SOURCE',

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

448: avalue =>l_sample_plan );
449: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
450: aname => 'SAMPLE_DISPOSITION',
451: avalue =>l_sample_disposition );
452: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
453: aname => 'SAMPLE_SOURCE',
454: avalue =>l_sample_SOURCE );
455: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
456: aname => 'SPECIFICATION',

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

451: avalue =>l_sample_disposition );
452: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
453: aname => 'SAMPLE_SOURCE',
454: avalue =>l_sample_SOURCE );
455: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
456: aname => 'SPECIFICATION',
457: avalue =>l_SPECIFICATION );
458: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
459: aname => 'SPECIFICATION_VERSION',

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

454: avalue =>l_sample_SOURCE );
455: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
456: aname => 'SPECIFICATION',
457: avalue =>l_SPECIFICATION );
458: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
459: aname => 'SPECIFICATION_VERSION',
460: avalue =>l_spec_vers );
461: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
462: aname => 'GRADE_CODE',

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

457: avalue =>l_SPECIFICATION );
458: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
459: aname => 'SPECIFICATION_VERSION',
460: avalue =>l_spec_vers );
461: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
462: aname => 'GRADE_CODE',
463: avalue =>l_grade_code );
464: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
465: aname => '#FROM_ROLE',

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

460: avalue =>l_spec_vers );
461: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
462: aname => 'GRADE_CODE',
463: avalue =>l_grade_code );
464: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
465: aname => '#FROM_ROLE',
466: avalue =>l_from_role );
467:
468: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

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

464: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
465: aname => '#FROM_ROLE',
466: avalue =>l_from_role );
467:
468: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
469: aname => 'AME_TRANS',
470: avalue =>l_transaction_type );
471:
472: P_resultout:='COMPLETE:'||l_transaction_type;

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

494: p_funcmode IN VARCHAR2,
495: p_resultout OUT NOCOPY VARCHAR2)
496:
497: IS
498: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
499: itemtype=>p_itemtype,
500: itemkey=>P_itemkey,
501: aname=>'EVENT_NAME');
502: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

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

498: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
499: itemtype=>p_itemtype,
500: itemkey=>P_itemkey,
501: aname=>'EVENT_NAME');
502: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
503: itemtype=>p_itemtype,
504: itemkey=>P_itemkey,
505: aname=>'EVENT_KEY');
506:

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

506:
507: l_current_approver varchar2(240);
508:
509: l_application_id number;
510: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
511: itemtype=>p_itemtype,
512: itemkey=>P_itemkey,
513: aname=>'AME_TRANS');
514: l_user varchar2(32);

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

570: end if;
571:
572: /* Set the User Attribute */
573:
574: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
575: aname => 'CURRENT_APPROVER',
576: avalue => l_user);
577: P_resultout:='COMPLETE:Y';
578: Approver.approval_status := ame_util.approvedStatus;