13: p_funcmode IN VARCHAR2,
14: p_resultout OUT NOCOPY VARCHAR2)
15:
16: IS
17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
18: itemtype=>p_itemtype,
19: itemkey=>P_itemkey,
20: aname=>'EVENT_NAME');
21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
18: itemtype=>p_itemtype,
19: itemkey=>P_itemkey,
20: aname=>'EVENT_NAME');
21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
22: itemtype=>p_itemtype,
23: itemkey=>P_itemkey,
24: aname=>'EVENT_KEY');
25:
249: l_itemtype:='GMDQMREJ';
250: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
251: l_workflow_process:='GMDQMREJ_SUB_PROCESS';
252:
253: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
254: itemkey => l_itemkey,
255: process => l_workflow_process );
256:
257: /* Set the User Attribute */
254: itemkey => l_itemkey,
255: process => l_workflow_process );
256:
257: /* Set the User Attribute */
258: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
259: aname => '#FROM_ROLE',
260: avalue => l_user );
261:
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
258: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
259: aname => '#FROM_ROLE',
260: avalue => l_user );
261:
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
263: aname => 'CURRENT_APPROVER',
264: avalue => l_user);
265:
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
263: aname => 'CURRENT_APPROVER',
264: avalue => l_user);
265:
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
267: aname => 'APPS_FORM',
268: avalue =>l_form );
269:
270: /* Set All other Attributes */
267: aname => 'APPS_FORM',
268: avalue =>l_form );
269:
270: /* Set All other Attributes */
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => p_itemkey,
272: aname => 'EVENT_NAME',
273: avalue =>l_event_name );
274:
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => p_itemkey,
272: aname => 'EVENT_NAME',
273: avalue =>l_event_name );
274:
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
276: aname => 'EVENT_KEY',
277: avalue =>l_event_key );
278:
279: /* Set Attributes for Common Fields */
276: aname => 'EVENT_KEY',
277: avalue =>l_event_key );
278:
279: /* Set Attributes for Common Fields */
280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
281: aname => 'ORG',
282: avalue => l_orgn_code);
283:
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
281: aname => 'ORG',
282: avalue => l_orgn_code);
283:
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
285: aname => 'SMPLGRP_TYPE',
286: avalue => l_sample_type_desc);
287:
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
285: aname => 'SMPLGRP_TYPE',
286: avalue => l_sample_type_desc);
287:
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
289: aname => 'SMPLGRP_SOURCE',
290: avalue => l_sample_source);
291:
292: /* Set Attributes for Stability Study Sample Group */
289: aname => 'SMPLGRP_SOURCE',
290: avalue => l_sample_source);
291:
292: /* Set Attributes for Stability Study Sample Group */
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
294: aname => 'STUDY',
295: avalue => l_study_no);
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
294: aname => 'STUDY',
295: avalue => l_study_no);
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
298: aname => 'STUDY_DESC',
299: avalue => l_study_desc);
300:
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
298: aname => 'STUDY_DESC',
299: avalue => l_study_desc);
300:
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
302: aname => 'ITEM_NO',
303: avalue => l_item_no);
304:
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
302: aname => 'ITEM_NO',
303: avalue => l_item_no);
304:
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
306: aname => 'ITEM_DESC',
307: avalue =>l_item_desc);
308:
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
306: aname => 'ITEM_DESC',
307: avalue =>l_item_desc);
308:
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
310: aname => 'REVISION',
311: avalue =>l_revision);
312:
313: /* Set Attributes for Resource Sample Group */
310: aname => 'REVISION',
311: avalue =>l_revision);
312:
313: /* Set Attributes for Resource Sample Group */
314: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
315: aname => 'RESOURCE',
316: avalue => l_resource);
317:
318: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
314: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
315: aname => 'RESOURCE',
316: avalue => l_resource);
317:
318: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
319: aname => 'RESOURCE_DESC',
320: avalue => l_resource_desc);
321:
322: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
318: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
319: aname => 'RESOURCE_DESC',
320: avalue => l_resource_desc);
321:
322: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
323: aname => 'RESOURCE_INST',
324: avalue => l_instance_num);
325:
326: /* Set Attributes for Resource Sample Group */
323: aname => 'RESOURCE_INST',
324: avalue => l_instance_num);
325:
326: /* Set Attributes for Resource Sample Group */
327: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
328: aname => 'SUBINVENTORY',
329: avalue => l_subinventory);
330:
331: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
327: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
328: aname => 'SUBINVENTORY',
329: avalue => l_subinventory);
330:
331: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
332: aname => 'LOCATOR',
333: avalue => l_locator);
334:
335: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
331: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
332: aname => 'LOCATOR',
333: avalue => l_locator);
334:
335: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
336: aname => 'AME_TRANS',
337: avalue =>l_transaction_type);
338:
339: wf_log_pkg.string(6, 'Dummy','Setting Parent');
337: avalue =>l_transaction_type);
338:
339: wf_log_pkg.string(6, 'Dummy','Setting Parent');
340:
341: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
342: parent_itemtype => p_itemtype,
343: parent_itemkey=> p_itemkey,
344: parent_context=> NULL);
345:
354: transactionTypeIn => l_transaction_type,
355: forwardeeIn => ame_util.emptyApproverRecord);
356:
357:
358: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
359:
360: IF (l_debug = 'Y') THEN
361: gmd_debug.put_line('created workflow process ');
362: END IF;
385: p_funcmode IN VARCHAR2,
386: p_resultout OUT NOCOPY VARCHAR2)
387:
388: IS
389: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
390: itemtype=>p_itemtype,
391: itemkey=>P_itemkey,
392: aname=>'EVENT_NAME');
393: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
389: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
390: itemtype=>p_itemtype,
391: itemkey=>P_itemkey,
392: aname=>'EVENT_NAME');
393: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
394: itemtype=>p_itemtype,
395: itemkey=>P_itemkey,
396: aname=>'EVENT_KEY');
397:
397:
398: l_current_approver varchar2(240);
399:
400: l_application_id number;
401: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
402: itemtype=>p_itemtype,
403: itemkey=>P_itemkey,
404: aname=>'AME_TRANS');
405: l_user varchar2(32);
431: end if;
432:
433: /* Set the User Attribute */
434:
435: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
436: aname => 'CURRENT_APPROVER',
437: avalue => l_user);
438:
439: P_resultout:='COMPLETE:Y';