424: --processName := 'SEND_PASSWORD';
425: --
426: -- Start Process
427: --
428: wf_engine.CreateProcess (itemtype,
429: itemkey,
430: processName);
431:
432: -- Set Workflow Attributes
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
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:
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:
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:
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:
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
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:
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:
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
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:
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:
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:
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:
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:
514: --
515: -- Launch the send password workflow
516: --
517:
518: wf_engine.startProcess(itemtype => itemType,
519: itemkey => itemKey);
520:
521:
522: --
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:
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:
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:
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:
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
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: /*
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: */
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:
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:
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:
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
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:
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
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
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
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
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