DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on AME_UTIL

Line 39: nextApprover ame_util.approverRecord;

35: p_funcmode IN VARCHAR2,
36: p_resultout OUT NOCOPY VARCHAR2) IS
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;

Line 236: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

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;
239: END IF;
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);

Line 455: nextApprover ame_util.approverRecord;

451: p_funcmode IN VARCHAR2,
452: p_resultout OUT NOCOPY VARCHAR2) IS
453: applicationId number :=552;
454: transactionType varchar2(50) := 'oracle.apps.gmd.qm.spec.sts';
455: nextApprover ame_util.approverRecord;
456: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
457: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
458: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
459: l_userID integer;

Line 504: l_userID := ame_util.personIdToUserId(nextApprover.person_id);

500: -- if we got HR Person then we have to find corresponding FND USER
501: -- assumption here is all HR user configured in AME will have
502: -- corresponding FND USER
503: --
504: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
505: ELSE
506: l_userID := nextApprover.user_id;
507: END IF;
508: l_userName := GET_FND_USER_NAME(l_userId);

Line 597: nextApprover ame_util.approverRecord;

593: p_funcmode IN VARCHAR2,
594: p_resultout OUT NOCOPY VARCHAR2) IS
595: applicationId number :=552;
596: transactionType varchar2(50) := 'oracle.apps.gmd.qm.spec.sts';
597: nextApprover ame_util.approverRecord;
598: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
599: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
600: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
601: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');

Line 621: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

617: -- if we got HR Person then we have to find corresponding FND USER
618: -- assumption here is all HR user configured in AME will have
619: -- corresponding FND USER
620: --
621: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
622: ELSE
623: new_user_id := nextApprover.user_id;
624: END IF;
625: IF new_user_id = l_userID THEN

Line 626: nextApprover.approval_status := ame_util.rejectStatus;

622: ELSE
623: new_user_id := nextApprover.user_id;
624: END IF;
625: IF new_user_id = l_userID THEN
626: nextApprover.approval_status := ame_util.rejectStatus;
627: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
628: transactionIdIn => lSpecId,
629: transactionTypeIn => transactionType,
630: ApproverIn => nextApprover);

Line 663: nextApprover ame_util.approverRecord;

659: p_funcmode IN VARCHAR2,
660: p_resultout OUT NOCOPY VARCHAR2) IS
661: applicationId number :=552;
662: transactionType varchar2(50) := 'oracle.apps.gmd.qm.spec.sts';
663: nextApprover ame_util.approverRecord;
664: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
665: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
666: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
667: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');

Line 687: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);

683: -- if we got HR Person then we have to find corresponding FND USER
684: -- assumption here is all HR user configured in AME will have
685: -- corresponding FND USER
686: --
687: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
688: ELSE
689: new_user_id := nextApprover.user_id;
690: END IF;
691: IF new_user_id = l_userID THEN

Line 692: nextApprover.approval_status := ame_util.approvedStatus;

688: ELSE
689: new_user_id := nextApprover.user_id;
690: END IF;
691: IF new_user_id = l_userID THEN
692: nextApprover.approval_status := ame_util.approvedStatus;
693: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
694: transactionIdIn => lSpecId,
695: transactionTypeIn => transactionType,
696: ApproverIn => nextApprover);