12: p_funcmode IN VARCHAR2,
13: p_resultout OUT NOCOPY VARCHAR2)
14:
15: IS
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:
201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line('Going to set workflow attributes ');
203: END IF;
204:
205: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
206: itemkey => l_itemkey,
207: process => l_workflow_process );
208:
209:
208:
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: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'ORG',
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: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'ORG',
227: avalue =>l_orgn_code );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'ITEM_NO',
224: avalue =>l_event_key );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'ORG',
227: avalue =>l_orgn_code );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'ITEM_NO',
230: avalue =>l_item_no );
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
232: aname => 'ITEM_REVISION',
227: avalue =>l_orgn_code );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'ITEM_NO',
230: avalue =>l_item_no );
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
232: aname => 'ITEM_REVISION',
233: avalue =>l_item_revision );
234: -- JD 10/20/2005 Changed item_desc to l_item_revision above.
235:
232: aname => 'ITEM_REVISION',
233: avalue =>l_item_revision );
234: -- JD 10/20/2005 Changed item_desc to l_item_revision above.
235:
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
237: aname => 'ITEM_DESC',
238: avalue =>l_item_desc );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'LOT_NO',
235:
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
237: aname => 'ITEM_DESC',
238: avalue =>l_item_desc );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'LOT_NO',
241: avalue =>l_lot_no );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'SAMPLE_QTY',
238: avalue =>l_item_desc );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'LOT_NO',
241: avalue =>l_lot_no );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'SAMPLE_QTY',
244: avalue =>l_sample_qty );
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'SAMPLE_UOM',
241: avalue =>l_lot_no );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'SAMPLE_QTY',
244: avalue =>l_sample_qty );
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'SAMPLE_UOM',
247: avalue =>l_sample_uom );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'STUDY',
244: avalue =>l_sample_qty );
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'SAMPLE_UOM',
247: avalue =>l_sample_uom );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'STUDY',
250: avalue =>l_study );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'STUDY_DESC',
247: avalue =>l_sample_uom );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'STUDY',
250: avalue =>l_study );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'STUDY_DESC',
253: avalue =>l_study_desc );
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STATUS',
250: avalue =>l_study );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'STUDY_DESC',
253: avalue =>l_study_desc );
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STATUS',
256: avalue =>l_status );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
258: aname => '#FROM_ROLE',
253: avalue =>l_study_desc );
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STATUS',
256: avalue =>l_status );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
258: aname => '#FROM_ROLE',
259: avalue =>l_from_role );
260:
261: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
258: aname => '#FROM_ROLE',
259: avalue =>l_from_role );
260:
261: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
262: aname => 'MSG_DOCUMENT',
263: avalue =>
264: 'plsqlclob:GMD_SS_LOT_WF_PKG.Get_WF_Notif/'||l_event_key );
265:
263: avalue =>
264: 'plsqlclob:GMD_SS_LOT_WF_PKG.Get_WF_Notif/'||l_event_key );
265:
266:
267: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
268: aname => 'AME_TRANS',
269: avalue =>l_transaction_type);
270:
271: wf_log_pkg.string(6, 'Dummy','Setting Parent');
270:
271: wf_log_pkg.string(6, 'Dummy','Setting Parent');
272:
273:
274: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
275: parent_itemtype => p_itemtype,
276: parent_itemkey=> p_itemkey,
277: parent_context=> NULL);
278:
296: forwardeeIn => ame_util.emptyApproverRecord);
297: end if;
298:
299:
300: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
301:
302: IF (l_debug = 'Y') THEN
303: gmd_debug.put_line('Created workflow process ');
304: END IF;
328: p_funcmode IN VARCHAR2,
329: p_resultout OUT NOCOPY VARCHAR2)
330:
331: IS
332: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
333: itemtype=>p_itemtype,
334: itemkey=>P_itemkey,
335: aname=>'EVENT_NAME');
336: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
332: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
333: itemtype=>p_itemtype,
334: itemkey=>P_itemkey,
335: aname=>'EVENT_NAME');
336: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
337: itemtype=>p_itemtype,
338: itemkey=>P_itemkey,
339: aname=>'EVENT_KEY');
340:
340:
341: l_current_approver varchar2(240);
342:
343: l_application_id number;
344: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
345: itemtype=>p_itemtype,
346: itemkey=>P_itemkey,
347: aname=>'AME_TRANS');
348: l_user varchar2(32);
374: end if;
375:
376: /* Set the User Attribute */
377:
378: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
379: aname => 'CURRENT_APPROVER',
380: avalue => l_user);
381:
382: P_resultout:='COMPLETE:Y';