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

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

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

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

Line 888: nextApprover ame_util.approverRecord;

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

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

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

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

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

Line 954: nextApprover ame_util.approverRecord;

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

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

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

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

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