DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on AME_UTIL

Line 41: nextApprover ame_util.approverRecord;

37: p_resultout OUT NOCOPY VARCHAR2) IS
38: applicationId number :=552;
39: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');
40: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
41: nextApprover ame_util.approverRecord;
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;

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

418: -- if we got HR Person then we have to find corresponding FND USER
419: -- assumption here is all HR user configured in AME will have
420: -- corresponding FND USER
421: --
422: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
423: ELSE
424: l_userID := nextApprover.user_id;
425: END IF;
426: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);

Line 740: nextApprover ame_util.approverRecord;

736: p_resultout OUT NOCOPY VARCHAR2) IS
737: applicationId number :=552;
738: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');
739: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
740: nextApprover ame_util.approverRecord;
741: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
742: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
743: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
744: l_userID integer;

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

790: -- if we got HR Person then we have to find corresponding FND USER
791: -- assumption here is all HR user configured in AME will have
792: -- corresponding FND USER
793: --
794: l_userID := ame_util.personIdToUserId(nextApprover.person_id);
795: ELSE
796: l_userID := nextApprover.user_id;
797: END IF;
798:

Line 889: nextApprover ame_util.approverRecord;

885: p_resultout OUT NOCOPY VARCHAR2) IS
886: applicationId number :=552;
887: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');
888: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
889: nextApprover ame_util.approverRecord;
890: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
891: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
892: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
893: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');

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

909: -- if we got HR Person then we have to find corresponding FND USER
910: -- assumption here is all HR user configured in AME will have
911: -- corresponding FND USER
912: --
913: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
914: ELSE
915: new_user_id := nextApprover.user_id;
916: END IF;
917: IF new_user_id = l_userID THEN

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

914: ELSE
915: new_user_id := nextApprover.user_id;
916: END IF;
917: IF new_user_id = l_userID THEN
918: nextApprover.approval_status := ame_util.rejectStatus;
919: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
920: transactionIdIn => lSpecVRId,
921: transactionTypeIn => transactionType,
922: ApproverIn => nextApprover);

Line 955: nextApprover ame_util.approverRecord;

951: p_funcmode IN VARCHAR2,
952: p_resultout OUT NOCOPY VARCHAR2) IS
953: applicationId number :=552;
954: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');
955: nextApprover ame_util.approverRecord;
956: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
957: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
958: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
959: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');

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

975: -- if we got HR Person then we have to find corresponding FND USER
976: -- assumption here is all HR user configured in AME will have
977: -- corresponding FND USER
978: --
979: new_user_id := ame_util.personIdToUserId(nextApprover.person_id);
980: ELSE
981: new_user_id := nextApprover.user_id;
982: END IF;
983: IF new_user_id = l_userID THEN

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

980: ELSE
981: new_user_id := nextApprover.user_id;
982: END IF;
983: IF new_user_id = l_userID THEN
984: nextApprover.approval_status := ame_util.approvedStatus;
985: ame_api.updateApprovalStatus(applicationIdIn => applicationId,
986: transactionIdIn => lSpecVRId,
987: transactionTypeIn => transactionType,
988: ApproverIn => nextApprover);