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

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

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

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

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

Line 12: FROM FND_USER

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

Line 14: l_userName FND_USER.USER_NAME%TYPE;

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

Line 20: END GET_FND_USER_NAME;

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

Line 43: l_userName FND_USER.USER_NAME%TYPE;

39: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
40: nextApprover ame_util.approverRecord;
41:
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: l_storage_name varchar2(200);
47:

Line 44: l_Requester FND_USER.USER_NAME%TYPE;

40: nextApprover ame_util.approverRecord;
41:
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: l_storage_name varchar2(200);
47:
48: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');

Line 45: l_Owner FND_USER.USER_NAME%TYPE;

41:
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: l_storage_name varchar2(200);
47:
48: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
49: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

Line 97: select user_name from fnd_user

93:
94: disp_attr_rec get_disp_Attr%ROWTYPE;
95:
96: cursor get_owner_name (owner_id_in number) is
97: select user_name from fnd_user
98: where user_id = owner_id_in ;
99:
100:
101: CURSOR get_ss_time_unit (p_time varchar2) IS

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

168:
169:
170: elsif nextApprover.person_id IS NOT NULL THEN
171: --
172: -- if we got HR Person then we have to find corresponding FND USER
173: -- assumption here is all HR user configured in AME will have
174: -- corresponding FND USER
175: --
176: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

Line 174: -- corresponding FND USER

170: elsif nextApprover.person_id IS NOT NULL THEN
171: --
172: -- if we got HR Person then we have to find corresponding FND USER
173: -- assumption here is all HR user configured in AME will have
174: -- corresponding FND USER
175: --
176: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
177: ELSE
178: l_userID := nextApprover.user_id;

Line 187: l_userName := GET_FND_USER_NAME(l_userId);

183: END IF;
184:
185:
186: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
187: l_userName := GET_FND_USER_NAME(l_userId);
188:
189: --
190: -- Update status to pending
191: --

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

225: IF (l_debug = 'Y') THEN
226: gmd_debug.put_line('Setting workflow attributes');
227: END IF;
228:
229: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
230: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER);
231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');
232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:

Line 230: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER);

226: gmd_debug.put_line('Setting workflow attributes');
227: END IF;
228:
229: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
230: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER);
231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');
232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);

Line 353: l_userName FND_USER.USER_NAME%TYPE;

349: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
350: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
351: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
352: l_userID integer;
353: l_userName FND_USER.USER_NAME%TYPE;
354: api_ret_status VARCHAR2(1);
355: api_se_ret_status VARCHAR2(1);
356: api_err_mesg VARCHAR2(240);
357:

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

409: p_resultout := 'COMPLETE:N';
410: ELSE
411: IF nextApprover.person_id IS NOT NULL THEN
412: --
413: -- if we got HR Person then we have to find corresponding FND USER
414: -- assumption here is all HR user configured in AME will have
415: -- corresponding FND USER
416: --
417: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

Line 415: -- corresponding FND USER

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

Line 421: l_userName := GET_FND_USER_NAME(l_userId);

417: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
418: ELSE
419: l_userID := nextApprover.user_id;
420: END IF;
421: l_userName := GET_FND_USER_NAME(l_userId);
422: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
423: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
424: p_resultout := 'COMPLETE:Y';
425: END IF;

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

532: transactionTypeIn => transactionType,
533: nextApproverOut => nextApprover);
534: IF nextApprover.person_id IS NOT NULL THEN
535: --
536: -- if we got HR Person then we have to find corresponding FND USER
537: -- assumption here is all HR user configured in AME will have
538: -- corresponding FND USER
539: --
540: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

Line 538: -- corresponding FND USER

534: IF nextApprover.person_id IS NOT NULL THEN
535: --
536: -- if we got HR Person then we have to find corresponding FND USER
537: -- assumption here is all HR user configured in AME will have
538: -- corresponding FND USER
539: --
540: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
541: ELSE
542: new_user_id := nextApprover.user_id;

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

602: transactionTypeIn => transactionType,
603: nextApproverOut => nextApprover);
604: IF nextApprover.person_id IS NOT NULL THEN
605: --
606: -- if we got HR Person then we have to find corresponding FND USER
607: -- assumption here is all HR user configured in AME will have
608: -- corresponding FND USER
609: --
610: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

Line 608: -- corresponding FND USER

604: IF nextApprover.person_id IS NOT NULL THEN
605: --
606: -- if we got HR Person then we have to find corresponding FND USER
607: -- assumption here is all HR user configured in AME will have
608: -- corresponding FND USER
609: --
610: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
611: ELSE
612: new_user_id := nextApprover.user_id;