eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_WF_EFF_PKG dependencies on WF_DIRECTORY

Line 123: avalue => wf_directory.GetRoleDisplayName(l_creator_username));

119:
120: wf_engine.SetItemAttrText(itemtype => ItemType,
121: itemkey => ItemKey,
122: aname => 'CREATOR_DISPLAY_NAME',
123: avalue => wf_directory.GetRoleDisplayName(l_creator_username));
124:
125: wf_engine.SetItemAttrText(itemtype => ItemType,
126: itemkey => ItemKey,
127: aname => 'REPORT_ID',

Line 148: wf_directory.GetUserName('PER', l_person_id, l_emp_username, l_emp_display_name);

144: OPEN get_emp_id_csr;
145: FETCH get_emp_id_csr INTO l_person_id;
146: CLOSE get_emp_id_csr;
147:
148: wf_directory.GetUserName('PER', l_person_id, l_emp_username, l_emp_display_name);
149:
150: /*Bug 5145170: person name is null when he dont have any record in fnd users
151: In this case get the name from per_all_people_f*/
152:

Line 299: IF (wf_directory.UserActive(l_employee_username) = TRUE) THEN

295: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_employee_username);
296: l_employee_display_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_DISPLAY_NAME');
297: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_employee_display_name);
298:
299: IF (wf_directory.UserActive(l_employee_username) = TRUE) THEN
300: result := 'COMPLETE:FOUND';
301: ELSE
302: result := 'COMPLETE:NOT_FOUND';
303: END IF;

Line 355: wf_directory.GetUserName('PER', l_supervisor_id, l_certifier_username, l_certifier_display_name);

351: l_supervisor_id := -1;
352: END IF;
353: CLOSE get_supervisor_id_csr;
354:
355: wf_directory.GetUserName('PER', l_supervisor_id, l_certifier_username, l_certifier_display_name);
356:
357: IF ((l_supervisor_id <> -1) AND
358: (l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND
359: (wf_directory.UserActive(l_certifier_username))) THEN

Line 359: (wf_directory.UserActive(l_certifier_username))) THEN

355: wf_directory.GetUserName('PER', l_supervisor_id, l_certifier_username, l_certifier_display_name);
356:
357: IF ((l_supervisor_id <> -1) AND
358: (l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND
359: (wf_directory.UserActive(l_certifier_username))) THEN
360: result := 'COMPLETE:FOUND';
361: ELSE
362: result := 'COMPLETE:NOT_FOUND';
363: END IF;

Line 544: wf_directory.GetUserName('PER', l_certifier_id, l_certifier_username, l_certifier_display_name);

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);
548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);

Line 546: IF ((l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND (wf_directory.UserActive(l_certifier_username))) 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);
548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);
549: result := 'COMPLETE:FOUND';
550: ELSE

Line 586: wf_directory.GetUserName('PER', l_approver_id, l_approver_username, l_approver_display_name);

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);
590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);

Line 588: IF ((l_approver_username IS NOT NULL) AND (l_approver_display_name IS NOT NULL) AND (wf_directory.UserActive(l_approver_username))) 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);
590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);
591: result := 'COMPLETE:FOUND';
592: ELSE

Line 637: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);

633: OPEN get_approval_responder_csr;
634: FETCH get_approval_responder_csr INTO l_responder_username;
635: CLOSE get_approval_responder_csr;
636:
637: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
638:
639: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);
640: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);
641:

Line 683: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);

679: OPEN get_cert_responder_csr;
680: FETCH get_cert_responder_csr INTO l_responder_username;
681: CLOSE get_cert_responder_csr;
682:
683: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
684:
685: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_responder_username);
686: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_responder_display_name);
687: