12: p_resultout OUT NOCOPY VARCHAR2)
13:
14: IS
15:
16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: itemtype=>p_itemtype,
18: itemkey=>P_itemkey,
19: aname=>'EVENT_NAME');
20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: itemtype=>p_itemtype,
18: itemkey=>P_itemkey,
19: aname=>'EVENT_NAME');
20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
21: itemtype=>p_itemtype,
22: itemkey=>P_itemkey,
23: aname=>'EVENT_KEY');
24:
202: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
203:
204: l_workflow_process:='GMDQSTSL_SUB_PROCESS';
205:
206: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
207: itemkey => l_itemkey,
208: process => l_workflow_process );
209:
210: /* Set the User Attribute */
208: process => l_workflow_process );
209:
210: /* Set the User Attribute */
211:
212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
213: aname => 'CURRENT_APPROVER',
214: avalue => l_user);
215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
216: aname => 'APPS_FORM',
211:
212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
213: aname => 'CURRENT_APPROVER',
214: avalue => l_user);
215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
216: aname => 'APPS_FORM',
217: avalue =>l_form );
218: /* Set All other Attributes */
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
216: aname => 'APPS_FORM',
217: avalue =>l_form );
218: /* Set All other Attributes */
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
220: aname => 'EVENT_NAME',
221: avalue =>l_event_name );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'EVENT_KEY',
218: /* Set All other Attributes */
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
220: aname => 'EVENT_NAME',
221: avalue =>l_event_name );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'EVENT_KEY',
224: avalue =>l_event_key );
225:
226: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'EVENT_KEY',
224: avalue =>l_event_key );
225:
226: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
227: aname => 'ORG',
228: avalue =>l_organization ); --INVCONV
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
230: aname => 'ITEM_NO',
225:
226: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
227: aname => 'ORG',
228: avalue =>l_organization ); --INVCONV
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
230: aname => 'ITEM_NO',
231: avalue =>l_item_no );
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'ITEM_DESC',
228: avalue =>l_organization ); --INVCONV
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
230: aname => 'ITEM_NO',
231: avalue =>l_item_no );
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'ITEM_DESC',
234: avalue =>l_item_desc );
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'ITEM_REVISION',
231: avalue =>l_item_no );
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'ITEM_DESC',
234: avalue =>l_item_desc );
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'ITEM_REVISION',
237: avalue =>l_item_revision ); --INVCONV
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'STUDY',
234: avalue =>l_item_desc );
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'ITEM_REVISION',
237: avalue =>l_item_revision ); --INVCONV
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'STUDY',
240: avalue =>l_study );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
242: aname => 'STUDY_DESC',
237: avalue =>l_item_revision ); --INVCONV
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'STUDY',
240: avalue =>l_study );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
242: aname => 'STUDY_DESC',
243: avalue =>l_study_desc );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'STATUS',
240: avalue =>l_study );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
242: aname => 'STUDY_DESC',
243: avalue =>l_study_desc );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'STATUS',
246: avalue =>l_status );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'SAMPLE_QTY',
243: avalue =>l_study_desc );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'STATUS',
246: avalue =>l_status );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'SAMPLE_QTY',
249: avalue =>l_sample_qty );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'SAMPLE_NO',
246: avalue =>l_status );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'SAMPLE_QTY',
249: avalue =>l_sample_qty );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'SAMPLE_NO',
252: avalue =>l_sample_no );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'STUDY_DATE',
249: avalue =>l_sample_qty );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'SAMPLE_NO',
252: avalue =>l_sample_no );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'STUDY_DATE',
255: avalue =>l_study_date);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'RESOURCE',
252: avalue =>l_sample_no );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'STUDY_DATE',
255: avalue =>l_study_date);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'RESOURCE',
258: avalue =>l_resource);
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'SUBINVENTORY',
255: avalue =>l_study_date);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'RESOURCE',
258: avalue =>l_resource);
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'SUBINVENTORY',
261: avalue =>l_storage_subinventory); --INVCONV
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'LOCATOR',
258: avalue =>l_resource);
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'SUBINVENTORY',
261: avalue =>l_storage_subinventory); --INVCONV
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'LOCATOR',
264: avalue =>l_storage_locator); --INVCONV
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'VARIANT_NO',
261: avalue =>l_storage_subinventory); --INVCONV
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'LOCATOR',
264: avalue =>l_storage_locator); --INVCONV
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'VARIANT_NO',
267: avalue =>l_variant_no);
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'STORAGE_SPEC',
264: avalue =>l_storage_locator); --INVCONV
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'VARIANT_NO',
267: avalue =>l_variant_no);
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'STORAGE_SPEC',
270: avalue =>l_storage_spec);
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'STGE_SPEC_VER',
267: avalue =>l_variant_no);
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'STORAGE_SPEC',
270: avalue =>l_storage_spec);
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'STGE_SPEC_VER',
273: avalue =>l_storage_spec_vers);
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TIME_NAME',
270: avalue =>l_storage_spec);
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'STGE_SPEC_VER',
273: avalue =>l_storage_spec_vers);
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TIME_NAME',
276: avalue =>l_time_name);
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
278: aname => '#FROM_ROLE',
273: avalue =>l_storage_spec_vers);
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TIME_NAME',
276: avalue =>l_time_name);
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
278: aname => '#FROM_ROLE',
279: avalue =>l_from_role );
280:
281:
278: aname => '#FROM_ROLE',
279: avalue =>l_from_role );
280:
281:
282: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
283: aname => 'AME_TRANS',
284: avalue =>l_transaction_type);
285:
286: wf_log_pkg.string(6, 'Dummy','Setting Parent');
285:
286: wf_log_pkg.string(6, 'Dummy','Setting Parent');
287:
288:
289: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
290: parent_itemtype => p_itemtype,
291: parent_itemkey=> p_itemkey,
292: parent_context=> NULL);
293:
308: transactionTypeIn => l_transaction_type,
309: forwardeeIn => ame_util.emptyApproverRecord);
310: end if;
311:
312: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
313:
314: close C1;
315:
316: END IF;
333: p_funcmode IN VARCHAR2,
334: p_resultout OUT NOCOPY VARCHAR2)
335:
336: IS
337: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
338: itemtype=>p_itemtype,
339: itemkey=>P_itemkey,
340: aname=>'EVENT_NAME');
341: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
337: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
338: itemtype=>p_itemtype,
339: itemkey=>P_itemkey,
340: aname=>'EVENT_NAME');
341: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
342: itemtype=>p_itemtype,
343: itemkey=>P_itemkey,
344: aname=>'EVENT_KEY');
345:
345:
346: l_current_approver varchar2(240);
347:
348: l_application_id number;
349: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
350: itemtype=>p_itemtype,
351: itemkey=>P_itemkey,
352: aname=>'AME_TRANS');
353: l_user varchar2(32);
379: end if;
380:
381: /* Set the User Attribute */
382:
383: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
384: aname => 'CURRENT_APPROVER',
385: avalue => l_user);
386:
387: P_resultout:='COMPLETE:Y';