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.GMDQSVRS_APPROVAL_WF_PKG dependencies on FND_USER

Line 9: -- Following function accepts FND userId and returns

5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6:
7:
8: APPLICATION_ERROR EXCEPTION;
9: -- Following function accepts FND userId and returns
10: -- User name
11: FUNCTION GET_FND_USER_NAME( userId Integer) RETURN VARCHAR2 IS
12: CURSOR GET_USER_NAME IS
13: SELECT USER_NAME

Line 11: FUNCTION GET_FND_USER_NAME( userId Integer) RETURN VARCHAR2 IS

7:
8: APPLICATION_ERROR EXCEPTION;
9: -- Following function accepts FND userId and returns
10: -- User name
11: FUNCTION GET_FND_USER_NAME( userId Integer) RETURN VARCHAR2 IS
12: CURSOR GET_USER_NAME IS
13: SELECT USER_NAME
14: FROM FND_USER
15: WHERE USER_ID = userId;

Line 14: FROM FND_USER

10: -- User name
11: FUNCTION GET_FND_USER_NAME( userId Integer) RETURN VARCHAR2 IS
12: CURSOR GET_USER_NAME IS
13: SELECT USER_NAME
14: FROM FND_USER
15: WHERE USER_ID = userId;
16: l_userName FND_USER.USER_NAME%TYPE;
17: BEGIN
18: OPEN GET_USER_NAME;

Line 16: l_userName FND_USER.USER_NAME%TYPE;

12: CURSOR GET_USER_NAME IS
13: SELECT USER_NAME
14: FROM FND_USER
15: WHERE USER_ID = userId;
16: l_userName FND_USER.USER_NAME%TYPE;
17: BEGIN
18: OPEN GET_USER_NAME;
19: FETCH GET_USER_NAME INTO l_userName;
20: CLOSE GET_USER_NAME;

Line 22: END GET_FND_USER_NAME;

18: OPEN GET_USER_NAME;
19: FETCH GET_USER_NAME INTO l_userName;
20: CLOSE GET_USER_NAME;
21: RETURN l_userName;
22: END GET_FND_USER_NAME;
23:
24: /********************************************************************************
25: *** This procedure is associated with GMDQSVRS_ISAPROVAL_REQUIRED workflow. **
26: *** This code will execute when Spec Validity Rule Approval Business Event **

Line 43: l_userName FND_USER.USER_NAME%TYPE;

39: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');
40: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
41: nextApprover ame_util.approverRecord;
42: l_userID integer;
43: l_userName FND_USER.USER_NAME%TYPE;
44: l_Requester FND_USER.USER_NAME%TYPE;
45: l_Owner FND_USER.USER_NAME%TYPE;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

Line 44: l_Requester FND_USER.USER_NAME%TYPE;

40: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
41: nextApprover ame_util.approverRecord;
42: l_userID integer;
43: l_userName FND_USER.USER_NAME%TYPE;
44: l_Requester FND_USER.USER_NAME%TYPE;
45: l_Owner FND_USER.USER_NAME%TYPE;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

Line 45: l_Owner FND_USER.USER_NAME%TYPE;

41: nextApprover ame_util.approverRecord;
42: l_userID integer;
43: l_userName FND_USER.USER_NAME%TYPE;
44: l_Requester FND_USER.USER_NAME%TYPE;
45: l_Owner FND_USER.USER_NAME%TYPE;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
49: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));

Line 418: -- if we got HR Person then we have to find corresponding FND USER

414: END IF;
415:
416: IF nextApprover.person_id IS NOT NULL THEN
417: --
418: -- if we got HR Person then we have to find corresponding FND USER
419: -- assumption here is all HR user configured in AME will have
420: -- corresponding FND USER
421: --
422: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

Line 420: -- corresponding FND USER

416: IF nextApprover.person_id IS NOT NULL THEN
417: --
418: -- if we got HR Person then we have to find corresponding FND USER
419: -- assumption here is all HR user configured in AME will have
420: -- corresponding FND USER
421: --
422: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
423: ELSE
424: l_userID := nextApprover.user_id;

Line 427: l_userName := GET_FND_USER_NAME(l_userId);

423: ELSE
424: l_userID := nextApprover.user_id;
425: END IF;
426: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
427: l_userName := GET_FND_USER_NAME(l_userId);
428:
429: --
430: -- Update status to pending
431: --

Line 461: l_requester := GET_FND_USER_NAME(mont_disp_attr_rec.LAST_UPDATED_BY);

457: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_VR_ID for Monitoring'));
458: raise APPLICATION_ERROR;
459: END IF;
460:
461: l_requester := GET_FND_USER_NAME(mont_disp_attr_rec.LAST_UPDATED_BY);
462: close get_mont_disp_Attr;
463: else
464: /* This is an item spec VR */
465: open get_disp_Attr;

Line 472: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);

468: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_VR_ID'));
469: raise APPLICATION_ERROR;
470: END IF;
471:
472: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
473: close get_disp_Attr;
474: end if;
475:
476:

Line 745: l_userName FND_USER.USER_NAME%TYPE;

741: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
742: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
743: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
744: l_userID integer;
745: l_userName FND_USER.USER_NAME%TYPE;
746: api_ret_status VARCHAR2(1);
747: api_err_mesg VARCHAR2(240);
748: BEGIN
749: IF p_funcmode = 'RUN' THEN

Line 790: -- if we got HR Person then we have to find corresponding FND USER

786:
787:
788: IF nextApprover.person_id IS NOT NULL THEN
789: --
790: -- if we got HR Person then we have to find corresponding FND USER
791: -- assumption here is all HR user configured in AME will have
792: -- corresponding FND USER
793: --
794: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

Line 792: -- corresponding FND USER

788: IF nextApprover.person_id IS NOT NULL THEN
789: --
790: -- if we got HR Person then we have to find corresponding FND USER
791: -- assumption here is all HR user configured in AME will have
792: -- corresponding FND USER
793: --
794: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
795: ELSE
796: l_userID := nextApprover.user_id;

Line 799: l_userName := GET_FND_USER_NAME(l_userId);

795: ELSE
796: l_userID := nextApprover.user_id;
797: END IF;
798:
799: l_userName := GET_FND_USER_NAME(l_userId);
800: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
801: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
802: p_resultout := 'COMPLETE:Y';
803: END IF;

Line 909: -- if we got HR Person then we have to find corresponding FND USER

905: transactionTypeIn => transactionType,
906: nextApproverOut => nextApprover);
907: IF nextApprover.person_id IS NOT NULL THEN
908: --
909: -- if we got HR Person then we have to find corresponding FND USER
910: -- assumption here is all HR user configured in AME will have
911: -- corresponding FND USER
912: --
913: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

Line 911: -- corresponding FND USER

907: IF nextApprover.person_id IS NOT NULL THEN
908: --
909: -- if we got HR Person then we have to find corresponding FND USER
910: -- assumption here is all HR user configured in AME will have
911: -- corresponding FND USER
912: --
913: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
914: ELSE
915: new_user_id := nextApprover.user_id;

Line 975: -- if we got HR Person then we have to find corresponding FND USER

971: transactionTypeIn => transactionType,
972: nextApproverOut => nextApprover);
973: IF nextApprover.person_id IS NOT NULL THEN
974: --
975: -- if we got HR Person then we have to find corresponding FND USER
976: -- assumption here is all HR user configured in AME will have
977: -- corresponding FND USER
978: --
979: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

Line 977: -- corresponding FND USER

973: IF nextApprover.person_id IS NOT NULL THEN
974: --
975: -- if we got HR Person then we have to find corresponding FND USER
976: -- assumption here is all HR user configured in AME will have
977: -- corresponding FND USER
978: --
979: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
980: ELSE
981: new_user_id := nextApprover.user_id;