[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:
344: p_funcmode IN VARCHAR2,
345: p_resultout OUT NOCOPY VARCHAR2) IS
346: applicationId number :=552;
347: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
348: nextApprover ame_util.approverRecord;
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;
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;
420: END IF;
421: l_userName := GET_FND_USER_NAME(l_userId);
512: p_funcmode IN VARCHAR2,
513: p_resultout OUT NOCOPY VARCHAR2) IS
514: applicationId number :=552;
515: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
516: nextApprover ame_util.approverRecord;
517: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
518: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
519: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
520: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
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;
543: END IF;
544: IF new_user_id = l_userID THEN
541: ELSE
542: new_user_id := nextApprover.user_id;
543: END IF;
544: IF new_user_id = l_userID THEN
545: nextApprover.approval_status := ame_util.rejectStatus;
546: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
547: transactionIdIn => lSSId,
548: transactionTypeIn => transactionType,
549: ApproverIn => nextApprover);
582: p_funcmode IN VARCHAR2,
583: p_resultout OUT NOCOPY VARCHAR2) IS
584: applicationId number :=552;
585: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
586: nextApprover ame_util.approverRecord;
587: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
588: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
589: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
590: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
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;
613: END IF;
614: IF new_user_id = l_userID THEN
611: ELSE
612: new_user_id := nextApprover.user_id;
613: END IF;
614: IF new_user_id = l_userID THEN
615: nextApprover.approval_status := ame_util.approvedStatus;
616: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
617: transactionIdIn => lSpecId,
618: transactionTypeIn => transactionType,
619: ApproverIn => nextApprover);