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.

[Home] [Help]

APPS.GMD_SS_APPROVAL_WF_PKG dependencies on WF_ENGINE

Line 48: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');

44: l_Requester FND_USER.USER_NAME%TYPE;
45: l_Owner FND_USER.USER_NAME%TYPE;
46: l_storage_name varchar2(200);
47:
48: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
49: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
50: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
51: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
52: l_notify_time_unit varchar2(100);

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

45: l_Owner FND_USER.USER_NAME%TYPE;
46: l_storage_name varchar2(200);
47:
48: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
49: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
50: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
51: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
52: l_notify_time_unit varchar2(100);
53: l_grace_time_unit varchar2(100);

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

46: l_storage_name varchar2(200);
47:
48: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
49: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
50: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
51: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
52: l_notify_time_unit varchar2(100);
53: l_grace_time_unit varchar2(100);
54:

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

182: gmd_debug.put_line('Approver ID ' || l_userID);
183: END IF;
184:
185:
186: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
187: l_userName := GET_FND_USER_NAME(l_userId);
188:
189: --
190: -- Update status to pending

Line 234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);

230: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER);
231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');
232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);

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

231: lStartStatus_DESC := GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'STABILITY');
232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);

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

232: lTargetStatus_DESC:= GMD_SS_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'STABILITY');
233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);

Line 237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);

233:
234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);

Line 238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);

234: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',disp_attr_rec.ORGANIZATION_CODE);
235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);

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

235: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',disp_attr_rec.SPEC_NAME);
236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);

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

236: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'BASE_SPEC',disp_attr_rec.SPEC_NAME);
237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);

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

237: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_VERS',disp_attr_rec.SPEC_VERS);
238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);

Line 242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);

238: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LAB_ORGN',disp_attr_rec.LAB_ORGANIZATION_CODE);
239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);

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

239: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REQUESTER',l_requester);
240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);

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

240: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_NO',disp_attr_rec.ITEM_NO);
241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);

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

241: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ITEM_DESC',disp_attr_rec.ITEM_DESC1);
242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);
249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',

Line 246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);

242: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISION',disp_attr_rec.REVISION);
243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);
249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',
250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);

Line 247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);

243: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'START_STATUS_DESC',lStartStatus_DESC);
244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);
249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',
250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);
251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',

Line 248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);

244: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS_DESC',lTargetStatus_DESC);
245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);
249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',
250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);
251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',
252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);

Line 249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',

245: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
246: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'STORAGE_PLAN',l_storage_name);
247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);
249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',
250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);
251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',
252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);
253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);

Line 251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',

247: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_NAME',disp_attr_rec.SS_NO);
248: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SS_DESC',disp_attr_rec.description);
249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',
250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);
251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',
252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);
253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);
254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);

Line 253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);

249: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'NOTIFY_TIME',
250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);
251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',
252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);
253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);
254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);

Line 254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);

250: disp_attr_rec.NOTIFICATION_LEAD_TIME || ' ' || l_notify_time_unit);
251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',
252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);
253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);
254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);
258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);

Line 255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);

251: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'GRACE_TIME',
252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);
253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);
254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);
258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);
259: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER',l_owner);

Line 256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);

252: disp_attr_rec.TESTING_GRACE_PERIOD || ' ' || l_grace_time_unit);
253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);
254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);
258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);
259: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER',l_owner);
260:

Line 257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);

253: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_START_DATE',disp_attr_rec.SCHEDULED_START_DATE);
254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);
258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);
259: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER',l_owner);
260:
261:

Line 258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);

254: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SCHED_END_DATE',disp_attr_rec.SCHEDULED_END_DATE);
255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);
258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);
259: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER',l_owner);
260:
261:
262: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes

Line 259: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER',l_owner);

255: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_START_DATE',disp_attr_rec.REVISED_START_DATE);
256: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'REVISED_END_DATE',disp_attr_rec.REVISED_END_DATE);
257: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_START_DATE',disp_attr_rec.ACTUAL_START_DATE);
258: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'ACTUAL_END_DATE',disp_attr_rec.ACTUAL_END_DATE);
259: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER',l_owner);
260:
261:
262: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
263:

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

260:
261:
262: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
263:
264: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
265: aname => '#FROM_ROLE',
266: avalue => l_userName );
267:
268: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

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

264: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
265: aname => '#FROM_ROLE',
266: avalue => l_userName );
267:
268: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
269: aname => 'GMDQMSAP_TIMEOUT',
270: avalue => l_wf_timeout);
271: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
272: aname => 'GMDQMSAP_MESG_CNT',

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

267:
268: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
269: aname => 'GMDQMSAP_TIMEOUT',
270: avalue => l_wf_timeout);
271: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
272: aname => 'GMDQMSAP_MESG_CNT',
273: avalue => 1);
274:
275:

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

300: p_actid IN NUMBER,
301: p_funcmode IN VARCHAR2,
302: p_resultout OUT NOCOPY VARCHAR2) IS
303:
304: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_COMMENT');
305: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_DISP_COMMENT');
306: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_CURR_PERFORMER');
307: BEGIN
308: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

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

301: p_funcmode IN VARCHAR2,
302: p_resultout OUT NOCOPY VARCHAR2) IS
303:
304: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_COMMENT');
305: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_DISP_COMMENT');
306: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_CURR_PERFORMER');
307: BEGIN
308: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
309: BEGIN

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

302: p_resultout OUT NOCOPY VARCHAR2) IS
303:
304: l_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_COMMENT');
305: l_mesg_comment VARCHAR2(4000):= wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_DISP_COMMENT');
306: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQMSAP_CURR_PERFORMER');
307: BEGIN
308: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
309: BEGIN
310: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||

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

313: EXCEPTION WHEN OTHERS THEN
314: NULL;
315: END;
316:
317: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
318: itemkey => p_itemkey,
319: aname => 'GMDQMSAP_DISP_COMMENT',
320: avalue => l_mesg_comment);
321: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

317: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
318: itemkey => p_itemkey,
319: aname => 'GMDQMSAP_DISP_COMMENT',
320: avalue => l_mesg_comment);
321: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
322: itemkey => p_itemkey,
323: aname => 'GMDQMSAP_COMMENT',
324: avalue => l_comment);
325: END IF;

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

344: p_resultout OUT NOCOPY VARCHAR2) IS
345: applicationId number :=552;
346: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
347: nextApprover ame_util.approverRecord;
348: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
349: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
350: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
351: l_userID integer;
352: l_userName FND_USER.USER_NAME%TYPE;

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

345: applicationId number :=552;
346: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
347: nextApprover ame_util.approverRecord;
348: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
349: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
350: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
351: l_userID integer;
352: l_userName FND_USER.USER_NAME%TYPE;
353: api_ret_status VARCHAR2(1);

Line 350: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');

346: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
347: nextApprover ame_util.approverRecord;
348: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
349: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
350: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
351: l_userID integer;
352: l_userName FND_USER.USER_NAME%TYPE;
353: api_ret_status VARCHAR2(1);
354: api_se_ret_status VARCHAR2(1);

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

417: ELSE
418: l_userID := nextApprover.user_id;
419: END IF;
420: l_userName := GET_FND_USER_NAME(l_userId);
421: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
422: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
423: p_resultout := 'COMPLETE:Y';
424: END IF;
425: END IF;

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

418: l_userID := nextApprover.user_id;
419: END IF;
420: l_userName := GET_FND_USER_NAME(l_userId);
421: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'USER_ID',l_userID);
422: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'APPROVER',l_userName);
423: p_resultout := 'COMPLETE:Y';
424: END IF;
425: END IF;
426:

Line 441: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQMSAP_MESG_CNT');

437: p_itemkey IN VARCHAR2,
438: p_actid IN NUMBER,
439: p_funcmode IN VARCHAR2,
440: p_resultout OUT NOCOPY VARCHAR2) IS
441: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQMSAP_MESG_CNT');
442: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
443: BEGIN
444: IF (p_funcmode = 'TIMEOUT') THEN
445: l_mesg_cnt := l_mesg_cnt + 1;

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

438: p_actid IN NUMBER,
439: p_funcmode IN VARCHAR2,
440: p_resultout OUT NOCOPY VARCHAR2) IS
441: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDQMSAP_MESG_CNT');
442: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
443: BEGIN
444: IF (p_funcmode = 'TIMEOUT') THEN
445: l_mesg_cnt := l_mesg_cnt + 1;
446: IF l_mesg_cnt <= 4 THEN

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

443: BEGIN
444: IF (p_funcmode = 'TIMEOUT') THEN
445: l_mesg_cnt := l_mesg_cnt + 1;
446: IF l_mesg_cnt <= 4 THEN
447: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
448: aname => 'GMDQMSAP_MESG_CNT',
449: avalue => l_mesg_cnt);
450: ELSE
451: p_resultout := 'COMPLETE:DEFAULT';

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

450: ELSE
451: p_resultout := 'COMPLETE:DEFAULT';
452: END IF;
453: ELSIF (p_funcmode = 'RESPOND') THEN
454: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
455: itemkey => p_itemkey,
456: aname => 'GMDQMSAP_CURR_PERFORMER',
457: avalue => l_approver);
458: END IF;

Line 475: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');

471: p_itemkey IN VARCHAR2,
472: p_actid IN NUMBER,
473: p_funcmode IN VARCHAR2,
474: p_resultout OUT NOCOPY VARCHAR2) IS
475: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
476: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
477: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
478: api_ret_status VARCHAR2(1);
479: api_err_mesg VARCHAR2(240);

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

472: p_actid IN NUMBER,
473: p_funcmode IN VARCHAR2,
474: p_resultout OUT NOCOPY VARCHAR2) IS
475: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
476: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
477: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
478: api_ret_status VARCHAR2(1);
479: api_err_mesg VARCHAR2(240);
480: BEGIN

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

473: p_funcmode IN VARCHAR2,
474: p_resultout OUT NOCOPY VARCHAR2) IS
475: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
476: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
477: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
478: api_ret_status VARCHAR2(1);
479: api_err_mesg VARCHAR2(240);
480: BEGIN
481: IF p_funcmode = 'RUN' THEN

Line 516: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');

512: p_resultout OUT NOCOPY VARCHAR2) IS
513: applicationId number :=552;
514: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
515: nextApprover ame_util.approverRecord;
516: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
517: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
518: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
519: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
520: new_user_id VARCHAR2(100);

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

513: applicationId number :=552;
514: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
515: nextApprover ame_util.approverRecord;
516: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
517: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
518: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
519: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
520: new_user_id VARCHAR2(100);
521: api_ret_status VARCHAR2(1);

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

514: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
515: nextApprover ame_util.approverRecord;
516: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
517: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
518: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
519: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
520: new_user_id VARCHAR2(100);
521: api_ret_status VARCHAR2(1);
522: api_err_mesg VARCHAR2(240);

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

515: nextApprover ame_util.approverRecord;
516: lSSId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
517: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
518: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
519: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
520: new_user_id VARCHAR2(100);
521: api_ret_status VARCHAR2(1);
522: api_err_mesg VARCHAR2(240);
523: BEGIN

Line 586: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');

582: p_resultout OUT NOCOPY VARCHAR2) IS
583: applicationId number :=552;
584: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
585: nextApprover ame_util.approverRecord;
586: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
587: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
588: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
589: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
590: new_user_id VARCHAR2(100);

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

583: applicationId number :=552;
584: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
585: nextApprover ame_util.approverRecord;
586: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
587: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
588: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
589: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
590: new_user_id VARCHAR2(100);
591: api_ret_status VARCHAR2(1);

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

584: transactionType varchar2(50) := 'GMDQM_STABILITY_CSTS';
585: nextApprover ame_util.approverRecord;
586: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
587: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
588: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
589: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
590: new_user_id VARCHAR2(100);
591: api_ret_status VARCHAR2(1);
592: api_err_mesg VARCHAR2(240);

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

585: nextApprover ame_util.approverRecord;
586: lSpecId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SS_ID');
587: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
588: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
589: l_userID VARCHAR2(100) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'USER_ID');
590: new_user_id VARCHAR2(100);
591: api_ret_status VARCHAR2(1);
592: api_err_mesg VARCHAR2(240);
593: BEGIN