eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on WF_ENGINE

Line 39: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');

35: p_actid IN NUMBER,
36: p_funcmode IN VARCHAR2,
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;

Line 40: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');

36: p_funcmode IN VARCHAR2,
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;

Line 46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');

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;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
49: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
50: lStartStatus_DESC VARCHAR2(240);

Line 47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

43: l_userName FND_USER.USER_NAME%TYPE;
44: l_Requester FND_USER.USER_NAME%TYPE;
45: l_Owner FND_USER.USER_NAME%TYPE;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
49: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
50: lStartStatus_DESC VARCHAR2(240);
51: lTargetStatus_DESC VARCHAR2(240);

Line 48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

44: l_Requester FND_USER.USER_NAME%TYPE;
45: l_Owner FND_USER.USER_NAME%TYPE;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
49: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
50: lStartStatus_DESC VARCHAR2(240);
51: lTargetStatus_DESC VARCHAR2(240);
52: api_ret_status VARCHAR2(1);

Line 426: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);

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);
427: l_userName := GET_FND_USER_NAME(l_userId);
428:
429: --
430: -- Update status to pending

Line 548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);

544:
545: if (l_spec_type in ('R','L')) then
546: /* This is a monitoring Spec VR */
547: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_MON');
548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);
549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);
550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);
551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST

Line 555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);

551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
553:
554:
555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);

Line 556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);

552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
553:
554:
555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);

Line 557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);

553:
554:
555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );

Line 558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);

554:
555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST

Line 559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);

555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST

Line 560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);

556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST

Line 561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );

557: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',mont_disp_attr_rec.SPEC_STATUS_DESC);
558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST

Line 562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST

558: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',mont_disp_attr_rec.MEANING);
559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);

Line 563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST

559: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',mont_disp_attr_rec.SPEC_VR_STATUS_DESC);
560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);

Line 564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST

560: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',mont_disp_attr_rec.START_DATE);
561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);

Line 565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST

561: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',mont_disp_attr_rec.END_DATE );
562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);

Line 566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);

562: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
570:

Line 567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);

563: --wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
570:
571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST

Line 568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);

564: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
570:
571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST

Line 569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);

565: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',mont_disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
566: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
570:
571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
573:

Line 571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST

567: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
570:
571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
573:
574:
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);

Line 572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST

568: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
569: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
570:
571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
573:
574:
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);

Line 602: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);
599:
600:
601:
602: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
603: aname => '#FROM_ROLE',
604: avalue => l_userName );
605:
606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);

Line 606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);

602: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
603: aname => '#FROM_ROLE',
604: avalue => l_userName );
605:
606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);

Line 607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);

603: aname => '#FROM_ROLE',
604: avalue => l_userName );
605:
606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);
611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);

Line 608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);

604: avalue => l_userName );
605:
606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);
611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);
612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );

Line 609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);

605:
606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);
611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);
612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );
613: /*=======================================

Line 610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);

606: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);
611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);
612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );
613: /*=======================================
614: BUG#4912074 Changed source of data.

Line 611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);

607: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);
611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);
612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );
613: /*=======================================
614: BUG#4912074 Changed source of data.
615: =======================================*/

Line 612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );

608: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.SPEC_STATUS_DESC);
609: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SOURCE_TYPE',l_lookup_code);
610: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_STATUS',disp_attr_rec.SPEC_VR_STATUS_DESC);
611: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_FROM_DATE',disp_attr_rec.START_DATE);
612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );
613: /*=======================================
614: BUG#4912074 Changed source of data.
615: =======================================*/
616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);

Line 616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);

612: wf_engine.setitemattrdate(p_itemtype, p_itemkey,'EFFECTIVE_TO_DATE',disp_attr_rec.END_DATE );
613: /*=======================================
614: BUG#4912074 Changed source of data.
615: =======================================*/
616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
617: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',l_orgn_name);
618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);
619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);

Line 617: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',l_orgn_name);

613: /*=======================================
614: BUG#4912074 Changed source of data.
615: =======================================*/
616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
617: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',l_orgn_name);
618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);
619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:

Line 618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);

614: BUG#4912074 Changed source of data.
615: =======================================*/
616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
617: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',l_orgn_name);
618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);
619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);

Line 619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);

615: =======================================*/
616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
617: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',l_orgn_name);
618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);
619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);

Line 620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);

616: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
617: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',l_orgn_name);
618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);
619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);

Line 622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);

618: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE);
619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
626:

Line 623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);

619: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',l_item_number);
620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
626:
627: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_REVISION',disp_attr_rec.REVISION); -- INVCONV, NSRIVAST

Line 624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);

620: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',l_item_desc);
621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
626:
627: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_REVISION',disp_attr_rec.REVISION); -- INVCONV, NSRIVAST
628: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',disp_attr_rec.subinventory); -- INVCONV, NSRIVAST

Line 625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);

621:
622: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
626:
627: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_REVISION',disp_attr_rec.REVISION); -- INVCONV, NSRIVAST
628: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
629: /*=======================================

Line 627: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_REVISION',disp_attr_rec.REVISION); -- INVCONV, NSRIVAST

623: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
626:
627: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_REVISION',disp_attr_rec.REVISION); -- INVCONV, NSRIVAST
628: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
629: /*=======================================
630: BUG#4912074 Changed source of data.
631: =======================================*/

Line 628: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',disp_attr_rec.subinventory); -- INVCONV, NSRIVAST

624: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
625: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
626:
627: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_REVISION',disp_attr_rec.REVISION); -- INVCONV, NSRIVAST
628: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
629: /*=======================================
630: BUG#4912074 Changed source of data.
631: =======================================*/
632: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);

Line 632: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);

628: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
629: /*=======================================
630: BUG#4912074 Changed source of data.
631: =======================================*/
632: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
633: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',l_location);
634:
635:
636: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);

Line 633: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',l_location);

629: /*=======================================
630: BUG#4912074 Changed source of data.
631: =======================================*/
632: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
633: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',l_location);
634:
635:
636: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
637: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);

Line 659: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

655: FND_MESSAGE.SET_TOKEN('MSG', FND_MESSAGE.GET() );
656:
657: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
658:
659: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
660: aname => 'GMDQSVRS_TIMEOUT',
661: avalue => l_wf_timeout);
662: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
663: aname => 'GMDQSVRS_MESG_CNT',

Line 662: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

658:
659: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
660: aname => 'GMDQSVRS_TIMEOUT',
661: avalue => l_wf_timeout);
662: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
663: aname => 'GMDQSVRS_MESG_CNT',
664: avalue => 1);
665: p_resultout := 'COMPLETE:Y';
666:

Line 696: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_COMMENT');

692: p_itemkey IN VARCHAR2,
693: p_actid IN NUMBER,
694: p_funcmode IN VARCHAR2,
695: p_resultout OUT NOCOPY VARCHAR2) IS
696: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_COMMENT');
697: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_DISP_COMMENT');
698: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_CURR_PERFORMER');
699: BEGIN
700: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

Line 697: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_DISP_COMMENT');

693: p_actid IN NUMBER,
694: p_funcmode IN VARCHAR2,
695: p_resultout OUT NOCOPY VARCHAR2) IS
696: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_COMMENT');
697: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_DISP_COMMENT');
698: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_CURR_PERFORMER');
699: BEGIN
700: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
701: BEGIN

Line 698: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_CURR_PERFORMER');

694: p_funcmode IN VARCHAR2,
695: p_resultout OUT NOCOPY VARCHAR2) IS
696: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_COMMENT');
697: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_DISP_COMMENT');
698: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_CURR_PERFORMER');
699: BEGIN
700: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
701: BEGIN
702: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||

Line 708: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

704: l_comment := null;
705: EXCEPTION WHEN OTHERS THEN
706: NULL;
707: END;
708: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
709: itemkey => p_itemkey,
710: aname => 'GMDQSVRS_DISP_COMMENT',
711: avalue => l_mesg_comment);
712: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

Line 712: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

708: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
709: itemkey => p_itemkey,
710: aname => 'GMDQSVRS_DISP_COMMENT',
711: avalue => l_mesg_comment);
712: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
713: itemkey => p_itemkey,
714: aname => 'GMDQSVRS_COMMENT',
715: avalue => l_comment);
716: END IF;

Line 737: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');

733: p_actid IN NUMBER,
734: p_funcmode IN VARCHAR2,
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');

Line 738: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');

734: p_funcmode IN VARCHAR2,
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');

Line 740: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

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;
744: l_userName FND_USER.USER_NAME%TYPE;

Line 741: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

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;
744: l_userName FND_USER.USER_NAME%TYPE;
745: api_ret_status VARCHAR2(1);

Line 742: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');

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;
744: l_userName FND_USER.USER_NAME%TYPE;
745: api_ret_status VARCHAR2(1);
746: api_err_mesg VARCHAR2(240);

Line 799: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);

795: l_userID := nextApprover.user_id;
796: END IF;
797:
798: l_userName := GET_FND_USER_NAME(l_userId);
799: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
800: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
801: p_resultout := 'COMPLETE:Y';
802: END IF;
803: END IF;

Line 800: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);

796: END IF;
797:
798: l_userName := GET_FND_USER_NAME(l_userId);
799: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
800: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
801: p_resultout := 'COMPLETE:Y';
802: END IF;
803: END IF;
804: END ANY_MORE_APPROVERS;

Line 818: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQSVRS_MESG_CNT');

814: p_itemkey IN VARCHAR2,
815: p_actid IN NUMBER,
816: p_funcmode IN VARCHAR2,
817: p_resultout OUT NOCOPY VARCHAR2) IS
818: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQSVRS_MESG_CNT');
819: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
820: BEGIN
821: IF (p_funcmode = 'TIMEOUT') THEN
822: l_mesg_cnt := l_mesg_cnt + 1;

Line 819: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');

815: p_actid IN NUMBER,
816: p_funcmode IN VARCHAR2,
817: p_resultout OUT NOCOPY VARCHAR2) IS
818: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQSVRS_MESG_CNT');
819: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
820: BEGIN
821: IF (p_funcmode = 'TIMEOUT') THEN
822: l_mesg_cnt := l_mesg_cnt + 1;
823: IF l_mesg_cnt <= 4 THEN

Line 824: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

820: BEGIN
821: IF (p_funcmode = 'TIMEOUT') THEN
822: l_mesg_cnt := l_mesg_cnt + 1;
823: IF l_mesg_cnt <= 4 THEN
824: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
825: aname => 'GMDQSVRS_MESG_CNT',
826: avalue => l_mesg_cnt);
827: ELSE
828: p_resultout := 'COMPLETE:DEFAULT';

Line 831: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

827: ELSE
828: p_resultout := 'COMPLETE:DEFAULT';
829: END IF;
830: ELSIF (p_funcmode = 'RESPOND') THEN
831: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
832: itemkey => p_itemkey,
833: aname => 'GMDQSVRS_CURR_PERFORMER',
834: avalue => l_approver);
835: END IF;

Line 851: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');

847: p_itemkey IN VARCHAR2,
848: p_actid IN NUMBER,
849: p_funcmode IN VARCHAR2,
850: p_resultout OUT NOCOPY VARCHAR2) IS
851: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
852: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
853: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
854: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
855: api_ret_status VARCHAR2(1);

Line 852: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');

848: p_actid IN NUMBER,
849: p_funcmode IN VARCHAR2,
850: p_resultout OUT NOCOPY VARCHAR2) IS
851: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
852: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
853: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
854: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
855: api_ret_status VARCHAR2(1);
856: api_err_mesg VARCHAR2(240);

Line 853: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

849: p_funcmode IN VARCHAR2,
850: p_resultout OUT NOCOPY VARCHAR2) IS
851: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
852: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
853: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
854: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
855: api_ret_status VARCHAR2(1);
856: api_err_mesg VARCHAR2(240);
857: BEGIN

Line 854: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

850: p_resultout OUT NOCOPY VARCHAR2) IS
851: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');
852: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
853: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
854: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
855: api_ret_status VARCHAR2(1);
856: api_err_mesg VARCHAR2(240);
857: BEGIN
858: IF p_funcmode = 'RUN' THEN

Line 886: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');

882: p_actid IN NUMBER,
883: p_funcmode IN VARCHAR2,
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');

Line 887: l_TABLE_NAME varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TABLE_NAME');

883: p_funcmode IN VARCHAR2,
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');

Line 889: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');

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');
893: new_user_id VARCHAR2(100);

Line 890: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

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');
893: new_user_id VARCHAR2(100);
894: api_ret_status VARCHAR2(1);

Line 891: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

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');
893: new_user_id VARCHAR2(100);
894: api_ret_status VARCHAR2(1);
895: api_err_mesg VARCHAR2(240);

Line 892: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');

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');
893: new_user_id VARCHAR2(100);
894: api_ret_status VARCHAR2(1);
895: api_err_mesg VARCHAR2(240);
896: BEGIN

Line 953: transactionType varchar2(50) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'EVENT_NAME');

949: p_actid IN NUMBER,
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');

Line 955: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');

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');
959: new_user_id VARCHAR2(100);

Line 956: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');

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');
959: new_user_id VARCHAR2(100);
960: api_ret_status VARCHAR2(1);

Line 957: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');

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');
959: new_user_id VARCHAR2(100);
960: api_ret_status VARCHAR2(1);
961: api_err_mesg VARCHAR2(240);

Line 958: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');

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');
959: new_user_id VARCHAR2(100);
960: api_ret_status VARCHAR2(1);
961: api_err_mesg VARCHAR2(240);
962: BEGIN