[Home] [Help]
522: /***********************************************************************
523: **Procedure SELECT_CERTIFIER is called by a workflow process "Select **
524: **Certifier". It is invoked if user profile option "PSP:Can Supervisor**
525: **Certify" is set to "No". Procedure SELECT_CERTIFIER makes a call to **
526: **PSP_WF_CUSTOM.EFFORT_SELECT_CERTIFIER, where users can customize who**
527: **the certifer is. **
528: ************************************************************************/
529: procedure SELECT_CERTIFIER(itemtype in varchar2,
530: itemkey in varchar2,
539: BEGIN
540:
541: IF (funcmode = 'RUN') THEN
542: l_emp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');
543: psp_wf_custom.effort_select_certifier(l_emp_id, l_certifier_id);
544: wf_directory.GetUserName('PER', l_certifier_id, l_certifier_username, l_certifier_display_name);
545:
546: IF ((l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND (wf_directory.UserActive(l_certifier_username))) THEN
547: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_certifier_username);
564: /***********************************************************************
565: **Procedure SELECT_APPROVER is called by a workflow process "Select **
566: **Approver". It is invoked if user profile option "PSP:Can Employee **
567: **Approve" is set to "No". Procedure SELECT_APPROVER makes a call to **
568: **PSP_WF_CUSTOM.EFFORT_SELECT_APPROVER, where users can customize who **
569: **the approver is. **
570: ************************************************************************/
571: procedure SELECT_APPROVER (itemtype in varchar2,
572: itemkey in varchar2,
581: BEGIN
582:
583: IF (funcmode = 'RUN') THEN
584: l_emp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');
585: psp_wf_custom.effort_select_approver(l_emp_id, l_approver_id);
586: wf_directory.GetUserName('PER', l_approver_id, l_approver_username, l_approver_display_name);
587:
588: IF ((l_approver_username IS NOT NULL) AND (l_approver_display_name IS NOT NULL) AND (wf_directory.UserActive(l_approver_username))) THEN
589: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_approver_username);