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.GMDQSPEC_APPROVAL_WF_PKG dependencies on WF_ENGINE

Line 44: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');

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

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

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

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

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

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

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);
241: l_userName := GET_FND_USER_NAME(l_userId);
242: --
243: -- Update status to pending
244: --

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

273: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER_ID);
274: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
275: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
276:
277: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
278: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);

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

274: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
275: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
276:
277: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
278: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST

Line 279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);

275: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
276:
277: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
278: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);

Line 280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);

276:
277: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
278: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST

Line 281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);

277: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
278: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);

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

278: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST

Line 283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);

279: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_DESC',disp_attr_rec.SPEC_DESC);
280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);

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

280: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_STATUS',disp_attr_rec.MEANING);
281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);

Line 285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);

281: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.OWNER_ORGN_CODE);
282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);

Line 286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST

282: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST

Line 287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);

283: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGN_NAME);
284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);

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

284: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_NAME',disp_attr_rec.ORGANIZATION_NAME); -- INVCONV, NSRIVAST
285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST

Line 289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);

285: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE);
286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);

Line 290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST

286: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRADE',disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
294: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);

Line 291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);

287: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_NAME',l_owner);
288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
294: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
295: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);

Line 292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST

288: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
294: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
295: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
296:

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

289: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
294: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
295: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
296:
297: --RLNAGARA Bug # 4706861

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

290: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.CONCATENATED_SEGMENTS); -- INVCONV, NSRIVAST
291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
294: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
295: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
296:
297: --RLNAGARA Bug # 4706861
298:

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

291: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
292: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.DESCRIPTION); -- INVCONV, NSRIVAST
293: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
294: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
295: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
296:
297: --RLNAGARA Bug # 4706861
298:
299: IF disp_attr_rec.SPEC_TYPE IS NOT NULL THEN

Line 304: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE', l_spectype_desc);

300: SELECT DESCRIPTION INTO l_spectype_desc
301: FROM GEM_LOOKUPS
302: WHERE LOOKUP_TYPE = 'GMD_QC_SPEC_TYPE'
303: AND LOOKUP_CODE = disp_attr_rec.SPEC_TYPE ;
304: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE', l_spectype_desc);
305: END IF;
306:
307: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE',disp_attr_rec.SPEC_TYPE);
308:

Line 307: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE',disp_attr_rec.SPEC_TYPE);

303: AND LOOKUP_CODE = disp_attr_rec.SPEC_TYPE ;
304: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE', l_spectype_desc);
305: END IF;
306:
307: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_TYPE',disp_attr_rec.SPEC_TYPE);
308:
309: --RLNAGARA Bug # 4706861
310:
311:

Line 312: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OVERLAY', disp_attr_rec.OVERLAY_IND);

308:
309: --RLNAGARA Bug # 4706861
310:
311:
312: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OVERLAY', disp_attr_rec.OVERLAY_IND);
313:
314: --RLNAGARA Bug 4706861 Rework
315: IF disp_attr_rec.BASE_SPEC_ID IS NOT NULL THEN
316: OPEN get_spec_det(disp_attr_rec.BASE_SPEC_ID);

Line 319: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', l_base_spec_name);

315: IF disp_attr_rec.BASE_SPEC_ID IS NOT NULL THEN
316: OPEN get_spec_det(disp_attr_rec.BASE_SPEC_ID);
317: FETCH get_spec_det INTO l_base_spec_name, l_base_spec_vers;
318: CLOSE get_spec_det;
319: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', l_base_spec_name);
320: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC_VERS', l_base_spec_vers);
321: END IF;
322: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
323:

Line 320: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC_VERS', l_base_spec_vers);

316: OPEN get_spec_det(disp_attr_rec.BASE_SPEC_ID);
317: FETCH get_spec_det INTO l_base_spec_name, l_base_spec_vers;
318: CLOSE get_spec_det;
319: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', l_base_spec_name);
320: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC_VERS', l_base_spec_vers);
321: END IF;
322: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
323:
324:

Line 322: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);

318: CLOSE get_spec_det;
319: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', l_base_spec_name);
320: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC_VERS', l_base_spec_vers);
321: END IF;
322: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
323:
324:
325:
326: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'ITEM_REVISION', disp_attr_rec.REVISION); -- INVCONV, NSRIVAST

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

322: -- wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
323:
324:
325:
326: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'ITEM_REVISION', disp_attr_rec.REVISION); -- INVCONV, NSRIVAST
327:
328: /* Depending on whether the Spec is for an item or monitor, fill out the
329: tokenized message and set it in the workflow */
330: if (disp_attr_rec.SPEC_TYPE = 'M') THEN

Line 370: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'GMDQSPAP_MSG', FND_MESSAGE.GET());

366: /* Set the message attribute, MSG, in the workflow */
367: -- FND_MESSAGE.SET_TOKEN('GMDQSPAP_MSG', FND_MESSAGE.GET() );
368:
369:
370: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'GMDQSPAP_MSG', FND_MESSAGE.GET());
371:
372: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
373:
374: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

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

370: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'GMDQSPAP_MSG', FND_MESSAGE.GET());
371:
372: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
373:
374: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
375: aname => '#FROM_ROLE',
376: avalue => l_userName );
377: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
378: aname => 'GMDQSPAP_TIMEOUT',

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

373:
374: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
375: aname => '#FROM_ROLE',
376: avalue => l_userName );
377: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
378: aname => 'GMDQSPAP_TIMEOUT',
379: avalue => l_wf_timeout);
380: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
381: aname => 'GMDQSPAP_MESG_CNT',

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

376: avalue => l_userName );
377: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
378: aname => 'GMDQSPAP_TIMEOUT',
379: avalue => l_wf_timeout);
380: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
381: aname => 'GMDQSPAP_MESG_CNT',
382: avalue => 1);
383: p_resultout := 'COMPLETE:Y';
384: ELSE

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

407: p_actid IN NUMBER,
408: p_funcmode IN VARCHAR2,
409: p_resultout OUT NOCOPY VARCHAR2) IS
410:
411: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_COMMENT');
412: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_DISP_COMMENT');
413: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_CURR_PERFORMER');
414: BEGIN
415: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

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

408: p_funcmode IN VARCHAR2,
409: p_resultout OUT NOCOPY VARCHAR2) IS
410:
411: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_COMMENT');
412: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_DISP_COMMENT');
413: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_CURR_PERFORMER');
414: BEGIN
415: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
416: BEGIN

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

409: p_resultout OUT NOCOPY VARCHAR2) IS
410:
411: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_COMMENT');
412: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_DISP_COMMENT');
413: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_CURR_PERFORMER');
414: BEGIN
415: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
416: BEGIN
417: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING

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

421: EXCEPTION WHEN OTHERS THEN
422: NULL;
423: END;
424:
425: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
426: itemkey => p_itemkey,
427: aname => 'GMDQSPAP_DISP_COMMENT',
428: avalue => l_mesg_comment);
429: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

425: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
426: itemkey => p_itemkey,
427: aname => 'GMDQSPAP_DISP_COMMENT',
428: avalue => l_mesg_comment);
429: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
430: itemkey => p_itemkey,
431: aname => 'GMDQSPAP_COMMENT',
432: avalue => l_comment);
433: END IF;

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

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

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

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

Line 458: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');

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;
460: l_userName FND_USER.USER_NAME%TYPE;
461: api_ret_status VARCHAR2(1);
462: api_err_mesg VARCHAR2(240);

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

505: ELSE
506: l_userID := nextApprover.user_id;
507: END IF;
508: l_userName := GET_FND_USER_NAME(l_userId);
509: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
510: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
511: p_resultout := 'COMPLETE:Y';
512: END IF;
513: END IF;

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

506: l_userID := nextApprover.user_id;
507: END IF;
508: l_userName := GET_FND_USER_NAME(l_userId);
509: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
510: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
511: p_resultout := 'COMPLETE:Y';
512: END IF;
513: END IF;
514: END ANY_MORE_APPROVERS;

Line 527: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQSPAP_MESG_CNT');

523: p_itemkey IN VARCHAR2,
524: p_actid IN NUMBER,
525: p_funcmode IN VARCHAR2,
526: p_resultout OUT NOCOPY VARCHAR2) IS
527: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQSPAP_MESG_CNT');
528: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
529: BEGIN
530: IF (p_funcmode = 'TIMEOUT') THEN
531: l_mesg_cnt := l_mesg_cnt + 1;

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

524: p_actid IN NUMBER,
525: p_funcmode IN VARCHAR2,
526: p_resultout OUT NOCOPY VARCHAR2) IS
527: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQSPAP_MESG_CNT');
528: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
529: BEGIN
530: IF (p_funcmode = 'TIMEOUT') THEN
531: l_mesg_cnt := l_mesg_cnt + 1;
532: IF l_mesg_cnt <= 4 THEN

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

529: BEGIN
530: IF (p_funcmode = 'TIMEOUT') THEN
531: l_mesg_cnt := l_mesg_cnt + 1;
532: IF l_mesg_cnt <= 4 THEN
533: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
534: aname => 'GMDQSPAP_MESG_CNT',
535: avalue => l_mesg_cnt);
536: ELSE
537: p_resultout := 'COMPLETE:DEFAULT';

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

536: ELSE
537: p_resultout := 'COMPLETE:DEFAULT';
538: END IF;
539: ELSIF (p_funcmode = 'RESPOND') THEN
540: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
541: itemkey => p_itemkey,
542: aname => 'GMDQSPAP_CURR_PERFORMER',
543: avalue => l_approver);
544: END IF;

Line 561: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');

557: p_itemkey IN VARCHAR2,
558: p_actid IN NUMBER,
559: p_funcmode IN VARCHAR2,
560: p_resultout OUT NOCOPY VARCHAR2) IS
561: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
562: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
563: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
564: api_ret_status VARCHAR2(1);
565: api_err_mesg VARCHAR2(240);

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

558: p_actid IN NUMBER,
559: p_funcmode IN VARCHAR2,
560: p_resultout OUT NOCOPY VARCHAR2) IS
561: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
562: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
563: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
564: api_ret_status VARCHAR2(1);
565: api_err_mesg VARCHAR2(240);
566: BEGIN

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

559: p_funcmode IN VARCHAR2,
560: p_resultout OUT NOCOPY VARCHAR2) IS
561: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');
562: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
563: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
564: api_ret_status VARCHAR2(1);
565: api_err_mesg VARCHAR2(240);
566: BEGIN
567: IF p_funcmode = 'RUN' THEN

Line 598: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');

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

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

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

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

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');
602: new_user_id VARCHAR2(100);
603: api_ret_status VARCHAR2(1);
604: api_err_mesg VARCHAR2(240);

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

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');
602: new_user_id VARCHAR2(100);
603: api_ret_status VARCHAR2(1);
604: api_err_mesg VARCHAR2(240);
605: BEGIN

Line 664: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_ID');

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

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

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

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

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');
668: new_user_id VARCHAR2(100);
669: api_ret_status VARCHAR2(1);
670: api_err_mesg VARCHAR2(240);

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

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');
668: new_user_id VARCHAR2(100);
669: api_ret_status VARCHAR2(1);
670: api_err_mesg VARCHAR2(240);
671: BEGIN