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 454: nextApprover ame_util.approverRecord;

450: p_funcmode IN VARCHAR2,
451: p_resultout OUT NOCOPY VARCHAR2) IS
452: applicationId number :=552;
453: transactionType varchar2(50) := 'oracle.apps.gmd.qm.spec.sts';
454: nextApprover ame_util.approverRecord;
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;

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

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;
506: END IF;
507: l_userName := GET_FND_USER_NAME(l_userId);

Line 596: nextApprover ame_util.approverRecord;

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

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

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;
623: END IF;
624: IF new_user_id = l_userID THEN

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

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

Line 662: nextApprover ame_util.approverRecord;

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

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

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;
689: END IF;
690: IF new_user_id = l_userID THEN

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

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