DBA Data[Home] [Help]

APPS.JTF_UM_PASSWORD_PVT dependencies on WF_ENGINE

Line 428: wf_engine.CreateProcess (itemtype,

424: --processName := 'SEND_PASSWORD';
425: --
426: -- Start Process
427: --
428: wf_engine.CreateProcess (itemtype,
429: itemkey,
430: processName);
431:
432: -- Set Workflow Attributes

Line 435: wf_engine.SetItemUserKey (itemtype => itemtype,

431:
432: -- Set Workflow Attributes
433:
434: -- set user item key
435: wf_engine.SetItemUserKey (itemtype => itemtype,
436: itemkey => itemkey,
437: UserKey => substr(p_requester_user_name|| ' request for password',1,80));
438:
439: -- set user name

Line 440: wf_engine.SetItemAttrText (itemtype => itemtype,

436: itemkey => itemkey,
437: UserKey => substr(p_requester_user_name|| ' request for password',1,80));
438:
439: -- set user name
440: wf_engine.SetItemAttrText (itemtype => itemtype,
441: itemkey => itemkey,
442: aname => 'REQUESTER_USER_NAME',
443: avalue => l_requester_user_name);
444:

Line 446: wf_engine.SetItemAttrText (itemtype => itemtype,

442: aname => 'REQUESTER_USER_NAME',
443: avalue => l_requester_user_name);
444:
445: -- set user name
446: wf_engine.SetItemAttrText (itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'WF_USER_NAME',
449: avalue => l_wf_user_name);
450:

Line 452: wf_engine.SetItemAttrText (itemtype => itemtype,

448: aname => 'WF_USER_NAME',
449: avalue => l_wf_user_name);
450:
451: -- set password
452: wf_engine.SetItemAttrText (itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'REQUESTER_PASSWORD',
455: avalue => p_requester_password);
456:

Line 458: wf_engine.SetItemAttrText (itemtype => itemtype,

454: aname => 'REQUESTER_PASSWORD',
455: avalue => p_requester_password);
456:
457: -- set name
458: wf_engine.SetItemAttrText (itemtype => itemtype,
459: itemkey => itemkey,
460: aname => 'REQUESTER_LAST_NAME',
461: avalue => p_requester_last_name);
462:

Line 463: wf_engine.SetItemAttrText (itemtype => itemtype,

459: itemkey => itemkey,
460: aname => 'REQUESTER_LAST_NAME',
461: avalue => p_requester_last_name);
462:
463: wf_engine.SetItemAttrText (itemtype => itemtype,
464: itemkey => itemkey,
465: aname => 'REQUESTER_FIRST_NAME',
466: avalue => p_requester_first_name);
467: -- set user type id

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

464: itemkey => itemkey,
465: aname => 'REQUESTER_FIRST_NAME',
466: avalue => p_requester_first_name);
467: -- set user type id
468: wf_engine.SetItemAttrNumber (itemtype => itemtype,
469: itemkey => itemkey,
470: aname => 'REQUESTER_USERTYPE_ID',
471: avalue => p_usertype_id);
472:

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

470: aname => 'REQUESTER_USERTYPE_ID',
471: avalue => p_usertype_id);
472:
473: -- set responsibility id
474: wf_engine.SetItemAttrNumber (itemtype => itemtype,
475: itemkey => itemkey,
476: aname => 'RESPONSIBILITY_ID',
477: avalue => l_responsibility_id);
478:

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

476: aname => 'RESPONSIBILITY_ID',
477: avalue => l_responsibility_id);
478:
479: -- set application id
480: wf_engine.SetItemAttrNumber (itemtype => itemtype,
481: itemkey => itemkey,
482: aname => 'APPLICATION_ID',
483: avalue => l_application_id);
484: -- set confirmation id

Line 485: wf_engine.SetItemAttrText (itemtype => itemtype,

481: itemkey => itemkey,
482: aname => 'APPLICATION_ID',
483: avalue => l_application_id);
484: -- set confirmation id
485: wf_engine.SetItemAttrText (itemtype => itemtype,
486: itemkey => itemkey,
487: aname => 'CONFIRMATION_NUMBER',
488: avalue => p_confirmation_number);
489:

Line 491: wf_engine.SetItemAttrText (itemtype => itemtype,

487: aname => 'CONFIRMATION_NUMBER',
488: avalue => p_confirmation_number);
489:
490: -- set first time user
491: wf_engine.SetItemAttrText (itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'FIRST_TIME_USER',
494: avalue => p_first_time_user);
495:

Line 497: wf_engine.SetItemAttrText (itemtype => itemtype,

493: aname => 'FIRST_TIME_USER',
494: avalue => p_first_time_user);
495:
496: -- set user verified
497: wf_engine.SetItemAttrText (itemtype => itemtype,
498: itemkey => itemkey,
499: aname => 'USER_VERIFIED',
500: avalue => p_user_verified);
501:

Line 503: wf_engine.SetItemAttrText (itemtype => itemtype,

499: aname => 'USER_VERIFIED',
500: avalue => p_user_verified);
501:
502: -- set enrollment only
503: wf_engine.SetItemAttrText (itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'ENROLLMENT_ONLY',
506: avalue => p_enrollment_only);
507:

Line 509: wf_engine.SetItemAttrText (itemtype => itemtype,

505: aname => 'ENROLLMENT_ONLY',
506: avalue => p_enrollment_only);
507:
508: -- set enrollment information
509: wf_engine.SetItemAttrText (itemtype => itemtype,
510: itemkey => itemkey,
511: aname => 'ENROLLMENTS',
512: avalue => p_enrollment_list);
513:

Line 518: wf_engine.startProcess(itemtype => itemType,

514: --
515: -- Launch the send password workflow
516: --
517:
518: wf_engine.startProcess(itemtype => itemType,
519: itemkey => itemKey);
520:
521:
522: --

Line 647: wf_engine.SetItemAttrText (itemtype => itemtype,

643: fetch approval_needed into l_approval_needed;
644: close approval_needed;
645: end if;
646: --dbms_output.put_line('approval needed '||l_approval_needed);
647: wf_engine.SetItemAttrText (itemtype => itemtype,
648: itemkey => itemkey,
649: aname => 'APPROVAL_REQUIRED',
650: avalue => l_approval_needed);
651:

Line 669: wf_engine.SetItemAttrText (itemtype => itemtype,

665: resp_appl_id => p_application_id,
666: application_id => p_application_id,
667: site_level => true);
668:
669: wf_engine.SetItemAttrText (itemtype => itemtype,
670: itemkey => itemkey,
671: aname => 'APPL_URL',
672: avalue => l_appl_url);
673:

Line 682: wf_engine.SetItemAttrText (itemtype => itemtype,

678: resp_appl_id => p_application_id,
679: application_id => p_application_id,
680: site_level => true);
681:
682: wf_engine.SetItemAttrText (itemtype => itemtype,
683: itemkey => itemkey,
684: aname => 'SUPPORT_CONTACT',
685: avalue => l_support_contact);
686:

Line 694: wf_engine.SetItemAttrText (itemtype => itemtype,

690: resp_appl_id => p_application_id,
691: application_id => l_application_id,
692: site_level => true);
693:
694: wf_engine.SetItemAttrText (itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'MERCHANT_NAME',
697: avalue => l_merchant_name);
698:

Line 707: wf_engine.SetItemAttrText (itemtype => itemtype,

703: application_id => l_application_id,
704: site_level => true);
705:
706: --l_sender := nvl(l_sender, l_merchant_name);
707: wf_engine.SetItemAttrText (itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'SENDER',
710: avalue => l_sender);
711: -- set name

Line 713: wf_engine.SetItemAttrText (itemtype => itemtype,

709: aname => 'SENDER',
710: avalue => l_sender);
711: -- set name
712: if p_requester_first_name is NULL and p_requester_last_name is NULL then
713: wf_engine.SetItemAttrText (itemtype => itemtype,
714: itemkey => itemkey,
715: aname => 'REQUESTER_LAST_NAME',
716: avalue => p_requester_user_name);
717: /*

Line 718: wf_engine.SetItemAttrText (itemtype => itemtype,

714: itemkey => itemkey,
715: aname => 'REQUESTER_LAST_NAME',
716: avalue => p_requester_user_name);
717: /*
718: wf_engine.SetItemAttrText (itemtype => itemtype,
719: itemkey => itemkey,
720: aname => 'ENROLLMENTS',
721: avalue => p_requester_user_name);
722: */

Line 767: l_requester_user_name := wf_engine.GetItemAttrText (

763: --
764: -- RUN mode - normal process execution
765: --
766: -- get user name
767: l_requester_user_name := wf_engine.GetItemAttrText (
768: itemtype => itemtype,
769: itemkey => itemkey,
770: aname => 'REQUESTER_USER_NAME');
771:

Line 773: l_requester_first_name := wf_engine.GetItemAttrText (

769: itemkey => itemkey,
770: aname => 'REQUESTER_USER_NAME');
771:
772: -- get first and last name
773: l_requester_first_name := wf_engine.GetItemAttrText (
774: itemtype => itemtype,
775: itemkey => itemkey,
776: aname => 'REQUESTER_FIRST_NAME');
777:

Line 778: l_requester_last_name := wf_engine.GetItemAttrText (

774: itemtype => itemtype,
775: itemkey => itemkey,
776: aname => 'REQUESTER_FIRST_NAME');
777:
778: l_requester_last_name := wf_engine.GetItemAttrText (
779: itemtype => itemtype,
780: itemkey => itemkey,
781: aname => 'REQUESTER_LAST_NAME');
782:

Line 784: l_usertype_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

780: itemkey => itemkey,
781: aname => 'REQUESTER_LAST_NAME');
782:
783: -- get user type id
784: l_usertype_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
785: itemkey => itemkey,
786: aname => 'REQUESTER_USERTYPE_ID');
787:
788: -- get responsibility id

Line 789: l_responsibility_id := wf_engine.GetItemAttrNumber (

785: itemkey => itemkey,
786: aname => 'REQUESTER_USERTYPE_ID');
787:
788: -- get responsibility id
789: l_responsibility_id := wf_engine.GetItemAttrNumber (
790: itemtype => itemtype,
791: itemkey => itemkey,
792: aname => 'RESPONSIBILITY_ID');
793:

Line 795: l_application_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

791: itemkey => itemkey,
792: aname => 'RESPONSIBILITY_ID');
793:
794: -- get application id
795: l_application_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'APPLICATION_ID');
798:
799: -- set values of other parameters

Line 853: l_result := wf_engine.GetItemAttrText (

849: funcmode in varchar2,
850: resultout out NOCOPY varchar2) is
851: l_result varchar2(10);
852: begin
853: l_result := wf_engine.GetItemAttrText (
854: itemtype => itemtype,
855: itemkey => itemkey,
856: aname => 'FIRST_TIME_USER');
857: if l_result = 'N' then

Line 896: l_result := wf_engine.GetItemAttrText (

892: funcmode in varchar2,
893: resultout out NOCOPY varchar2) is
894: l_result varchar2(10);
895: begin
896: l_result := wf_engine.GetItemAttrText (
897: itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'APPROVAL_REQUIRED');
900: if l_result = 'F' then

Line 939: l_result := wf_engine.GetItemAttrText (

935: funcmode in varchar2,
936: resultout out NOCOPY varchar2) is
937: l_result varchar2(10);
938: begin
939: l_result := wf_engine.GetItemAttrText (
940: itemtype => itemtype,
941: itemkey => itemkey,
942: aname => 'USER_VERIFIED');
943: if l_result = 'Y' then

Line 982: l_result := wf_engine.GetItemAttrText (

978: funcmode in varchar2,
979: resultout out NOCOPY varchar2) is
980: l_result varchar2(10);
981: begin
982: l_result := wf_engine.GetItemAttrText (
983: itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'ENROLLMENT_ONLY');
986: if l_result = 'Y' then