[Home] [Help]
36:
37:
38: applicationId number :=552;
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;
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;
179: END IF;
180:
343: p_funcmode IN VARCHAR2,
344: p_resultout OUT NOCOPY VARCHAR2) IS
345: applicationId number :=552;
346: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
347: nextApprover ame_util.approverRecord;
348: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
349: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
350: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
351: l_userID integer;
412: -- if we got HR Person then we have to find corresponding FND USER
413: -- assumption here is all HR user configured in AME will have
414: -- corresponding FND USER
415: --
416: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
417: ELSE
418: l_userID := nextApprover.user_id;
419: END IF;
420: l_userName := GET_FND_USER_NAME(l_userId);
511: p_funcmode IN VARCHAR2,
512: p_resultout OUT NOCOPY VARCHAR2) IS
513: applicationId number :=552;
514: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
515: nextApprover ame_util.approverRecord;
516: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
517: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
518: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
519: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
535: -- if we got HR Person then we have to find corresponding FND USER
536: -- assumption here is all HR user configured in AME will have
537: -- corresponding FND USER
538: --
539: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
540: ELSE
541: new_user_id := nextApprover.user_id;
542: END IF;
543: IF new_user_id = l_userID THEN
540: ELSE
541: new_user_id := nextApprover.user_id;
542: END IF;
543: IF new_user_id = l_userID THEN
544: nextApprover.approval_status := ame_util.rejectStatus;
545: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
546: transactionIdIn => lSSId,
547: transactionTypeIn => transactionType,
548: ApproverIn => nextApprover);
581: p_funcmode IN VARCHAR2,
582: p_resultout OUT NOCOPY VARCHAR2) IS
583: applicationId number :=552;
584: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
585: nextApprover ame_util.approverRecord;
586: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
587: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
588: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
589: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
605: -- if we got HR Person then we have to find corresponding FND USER
606: -- assumption here is all HR user configured in AME will have
607: -- corresponding FND USER
608: --
609: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
610: ELSE
611: new_user_id := nextApprover.user_id;
612: END IF;
613: IF new_user_id = l_userID THEN
610: ELSE
611: new_user_id := nextApprover.user_id;
612: END IF;
613: IF new_user_id = l_userID THEN
614: nextApprover.approval_status := ame_util.approvedStatus;
615: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
616: transactionIdIn => lSpecId,
617: transactionTypeIn => transactionType,
618: ApproverIn => nextApprover);