15: p_resultout OUT NOCOPY VARCHAR2)
16:
17: IS
18:
19: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
20: itemtype=>p_itemtype,
21: itemkey=>P_itemkey,
22: aname=>'EVENT_NAME');
23: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
19: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
20: itemtype=>p_itemtype,
21: itemkey=>P_itemkey,
22: aname=>'EVENT_NAME');
23: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
24: itemtype=>p_itemtype,
25: itemkey=>P_itemkey,
26: aname=>'EVENT_KEY');
27:
219: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
220:
221: l_workflow_process:='GMDQSTST_SUB_PROCESS';
222:
223: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
224: itemkey => l_itemkey,
225: process => l_workflow_process );
226:
227: /* Set the User Attribute */
225: process => l_workflow_process );
226:
227: /* Set the User Attribute */
228:
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
230: aname => 'CURRENT_APPROVER',
231: avalue => l_user);
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'APPS_FORM',
228:
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
230: aname => 'CURRENT_APPROVER',
231: avalue => l_user);
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'APPS_FORM',
234: avalue =>l_form );
235: /* Set All other Attributes */
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'APPS_FORM',
234: avalue =>l_form );
235: /* Set All other Attributes */
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
237: aname => 'EVENT_NAME',
238: avalue =>l_event_name );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'EVENT_KEY',
235: /* Set All other Attributes */
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
237: aname => 'EVENT_NAME',
238: avalue =>l_event_name );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'EVENT_KEY',
241: avalue =>l_event_key );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'ORG',
238: avalue =>l_event_name );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'EVENT_KEY',
241: avalue =>l_event_key );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'ORG',
244: avalue =>l_organization ); --INVCONV
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'ITEM_NO',
241: avalue =>l_event_key );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'ORG',
244: avalue =>l_organization ); --INVCONV
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'ITEM_NO',
247: avalue =>l_item_no );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'ITEM_DESC',
244: avalue =>l_organization ); --INVCONV
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'ITEM_NO',
247: avalue =>l_item_no );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'ITEM_DESC',
250: avalue =>l_item_desc );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'ITEM_REVISION',
247: avalue =>l_item_no );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'ITEM_DESC',
250: avalue =>l_item_desc );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'ITEM_REVISION',
253: avalue =>l_item_revision ); --INVCONV
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STUDY',
250: avalue =>l_item_desc );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'ITEM_REVISION',
253: avalue =>l_item_revision ); --INVCONV
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STUDY',
256: avalue =>l_study );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
258: aname => 'STUDY_DESC',
253: avalue =>l_item_revision ); --INVCONV
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STUDY',
256: avalue =>l_study );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
258: aname => 'STUDY_DESC',
259: avalue =>l_study_desc );
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'STATUS',
256: avalue =>l_study );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
258: aname => 'STUDY_DESC',
259: avalue =>l_study_desc );
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'STATUS',
262: avalue =>l_status );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'SAMPLE_QTY',
259: avalue =>l_study_desc );
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'STATUS',
262: avalue =>l_status );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'SAMPLE_QTY',
265: avalue =>l_sample_qty );
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
267: aname => 'SAMPLE_NO',
262: avalue =>l_status );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'SAMPLE_QTY',
265: avalue =>l_sample_qty );
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
267: aname => 'SAMPLE_NO',
268: avalue =>l_sample_no );
269: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
270: aname => 'STUDY_DATE',
265: avalue =>l_sample_qty );
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
267: aname => 'SAMPLE_NO',
268: avalue =>l_sample_no );
269: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
270: aname => 'STUDY_DATE',
271: avalue =>l_study_date);
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
273: aname => 'RESOURCE',
268: avalue =>l_sample_no );
269: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
270: aname => 'STUDY_DATE',
271: avalue =>l_study_date);
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
273: aname => 'RESOURCE',
274: avalue =>l_resource);
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
276: aname => 'SUBINVENTORY',
271: avalue =>l_study_date);
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
273: aname => 'RESOURCE',
274: avalue =>l_resource);
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
276: aname => 'SUBINVENTORY',
277: avalue =>l_storage_subinventory); --INVCONV
278: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
279: aname => 'LOCATOR',
274: avalue =>l_resource);
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
276: aname => 'SUBINVENTORY',
277: avalue =>l_storage_subinventory); --INVCONV
278: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
279: aname => 'LOCATOR',
280: avalue =>l_storage_locator); --INVCONV
281: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
282: aname => 'VARIANT_NO',
277: avalue =>l_storage_subinventory); --INVCONV
278: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
279: aname => 'LOCATOR',
280: avalue =>l_storage_locator); --INVCONV
281: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
282: aname => 'VARIANT_NO',
283: avalue =>l_variant_no);
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
285: aname => 'STORAGE_SPEC',
280: avalue =>l_storage_locator); --INVCONV
281: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
282: aname => 'VARIANT_NO',
283: avalue =>l_variant_no);
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
285: aname => 'STORAGE_SPEC',
286: avalue =>l_storage_spec);
287: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
288: aname => 'STGE_SPEC_VER',
283: avalue =>l_variant_no);
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
285: aname => 'STORAGE_SPEC',
286: avalue =>l_storage_spec);
287: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
288: aname => 'STGE_SPEC_VER',
289: avalue =>l_storage_spec_vers);
290: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
291: aname => 'TIME_NAME',
286: avalue =>l_storage_spec);
287: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
288: aname => 'STGE_SPEC_VER',
289: avalue =>l_storage_spec_vers);
290: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
291: aname => 'TIME_NAME',
292: avalue =>l_time_name);
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
294: aname => '#FROM_ROLE',
289: avalue =>l_storage_spec_vers);
290: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
291: aname => 'TIME_NAME',
292: avalue =>l_time_name);
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
294: aname => '#FROM_ROLE',
295: avalue =>l_from_role );
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
294: aname => '#FROM_ROLE',
295: avalue =>l_from_role );
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
298: aname => 'AME_TRANS',
299: avalue =>l_transaction_type);
300:
301: wf_log_pkg.string(6, 'Dummy','Setting Parent');
300:
301: wf_log_pkg.string(6, 'Dummy','Setting Parent');
302:
303:
304: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
305: parent_itemtype => p_itemtype,
306: parent_itemkey=> p_itemkey,
307: parent_context=> NULL);
308:
323: transactionTypeIn => l_transaction_type,
324: forwardeeIn => ame_util.emptyApproverRecord);
325: end if;
326:
327: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
328:
329: close C1;
330:
331: END IF;
348: p_funcmode IN VARCHAR2,
349: p_resultout OUT NOCOPY VARCHAR2)
350:
351: IS
352: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
353: itemtype=>p_itemtype,
354: itemkey=>P_itemkey,
355: aname=>'EVENT_NAME');
356: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
352: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
353: itemtype=>p_itemtype,
354: itemkey=>P_itemkey,
355: aname=>'EVENT_NAME');
356: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
357: itemtype=>p_itemtype,
358: itemkey=>P_itemkey,
359: aname=>'EVENT_KEY');
360:
360:
361: l_current_approver varchar2(240);
362:
363: l_application_id number;
364: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
365: itemtype=>p_itemtype,
366: itemkey=>P_itemkey,
367: aname=>'AME_TRANS');
368: l_user varchar2(32);
399: end if;
400:
401: /* Set the User Attribute */
402:
403: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
404: aname => 'CURRENT_APPROVER',
405: avalue => l_user);
406:
407: P_resultout:='COMPLETE:Y';
435: l_itemtype :='GMDQSTST';
436: l_itemkey := p_timepoint ;
437:
438: /* Cancel workflow process */
439: wf_engine.abortprocess (ITEMTYPE => l_itemtype,
440: ITEMKEY => l_itemkey);
441:
442:
443: /* update the wf_sent back to N */