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

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

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

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

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

Line 13: FROM FND_USER

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

Line 15: l_userName FND_USER.USER_NAME%TYPE;

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

Line 21: END GET_FND_USER_NAME;

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

Line 41: l_userName FND_USER.USER_NAME%TYPE;

37: applicationId number :=552;
38: transactionType varchar2(50) := 'oracle.apps.gmd.qm.spec.sts';
39: nextApprover ame_util.approverRecord;
40: l_userID integer;
41: l_userName FND_USER.USER_NAME%TYPE;
42: l_Requester FND_USER.USER_NAME%TYPE;
43: l_Owner FND_USER.USER_NAME%TYPE;
44: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
45: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

Line 42: l_Requester FND_USER.USER_NAME%TYPE;

38: transactionType varchar2(50) := 'oracle.apps.gmd.qm.spec.sts';
39: nextApprover ame_util.approverRecord;
40: l_userID integer;
41: l_userName FND_USER.USER_NAME%TYPE;
42: l_Requester FND_USER.USER_NAME%TYPE;
43: l_Owner FND_USER.USER_NAME%TYPE;
44: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
45: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
46: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

Line 43: l_Owner FND_USER.USER_NAME%TYPE;

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

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

228: -- We got the first approver from AME
229: --
230: IF nextApprover.person_id IS NOT NULL THEN
231: --
232: -- if we got HR Person then we have to find corresponding FND USER
233: -- assumption here is all HR user configured in AME will have
234: -- corresponding FND USER
235: --
236: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

Line 234: -- corresponding FND USER

230: IF nextApprover.person_id IS NOT NULL THEN
231: --
232: -- if we got HR Person then we have to find corresponding FND USER
233: -- assumption here is all HR user configured in AME will have
234: -- corresponding FND USER
235: --
236: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
237: ELSE
238: l_userID := nextApprover.user_id;

Line 241: l_userName := GET_FND_USER_NAME(l_userId);

237: ELSE
238: l_userID := nextApprover.user_id;
239: END IF;
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
241: l_userName := GET_FND_USER_NAME(l_userId);
242: --
243: -- Update status to pending
244: --
245:

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

268: IF (l_debug = 'Y') THEN
269: gmd_debug.put_line('Setting up workflow attributes');
270: END IF;
271:
272: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
273: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER_ID);
274: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
275: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
276:

Line 273: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER_ID);

269: gmd_debug.put_line('Setting up workflow attributes');
270: END IF;
271:
272: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
273: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER_ID);
274: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
275: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
276:
277: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);

Line 459: l_userName FND_USER.USER_NAME%TYPE;

455: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
456: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
457: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
458: l_userID integer;
459: l_userName FND_USER.USER_NAME%TYPE;
460: api_ret_status VARCHAR2(1);
461: api_err_mesg VARCHAR2(240);
462: BEGIN
463: IF p_funcmode = 'RUN' THEN

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

495: p_resultout := 'COMPLETE:N';
496: ELSE
497: IF nextApprover.person_id IS NOT NULL THEN
498: --
499: -- if we got HR Person then we have to find corresponding FND USER
500: -- assumption here is all HR user configured in AME will have
501: -- corresponding FND USER
502: --
503: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

Line 501: -- corresponding FND USER

497: IF nextApprover.person_id IS NOT NULL THEN
498: --
499: -- if we got HR Person then we have to find corresponding FND USER
500: -- assumption here is all HR user configured in AME will have
501: -- corresponding FND USER
502: --
503: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
504: ELSE
505: l_userID := nextApprover.user_id;

Line 507: l_userName := GET_FND_USER_NAME(l_userId);

503: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
504: ELSE
505: l_userID := nextApprover.user_id;
506: END IF;
507: l_userName := GET_FND_USER_NAME(l_userId);
508: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
509: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
510: p_resultout := 'COMPLETE:Y';
511: END IF;

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

612: transactionTypeIn => transactionType,
613: nextApproverOut => nextApprover);
614: IF nextApprover.person_id IS NOT NULL THEN
615: --
616: -- if we got HR Person then we have to find corresponding FND USER
617: -- assumption here is all HR user configured in AME will have
618: -- corresponding FND USER
619: --
620: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

Line 618: -- corresponding FND USER

614: IF nextApprover.person_id IS NOT NULL THEN
615: --
616: -- if we got HR Person then we have to find corresponding FND USER
617: -- assumption here is all HR user configured in AME will have
618: -- corresponding FND USER
619: --
620: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
621: ELSE
622: new_user_id := nextApprover.user_id;

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

678: transactionTypeIn => transactionType,
679: nextApproverOut => nextApprover);
680: IF nextApprover.person_id IS NOT NULL THEN
681: --
682: -- if we got HR Person then we have to find corresponding FND USER
683: -- assumption here is all HR user configured in AME will have
684: -- corresponding FND USER
685: --
686: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

Line 684: -- corresponding FND USER

680: IF nextApprover.person_id IS NOT NULL THEN
681: --
682: -- if we got HR Person then we have to find corresponding FND USER
683: -- assumption here is all HR user configured in AME will have
684: -- corresponding FND USER
685: --
686: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
687: ELSE
688: new_user_id := nextApprover.user_id;