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:
27: l_application_id number;
28: l_transaction_type varchar2(100):='GMDQMPF';
29: l_user varchar2(32);
30: Approver ame_util.approverRecord;
31: l_test_id number:=WF_ENGINE.GETITEMATTRTEXT(
32: itemtype=>p_itemtype,
33: itemkey=>P_itemkey,
34: aname=>'TEST_ID');
35:
224: --insert into rg_debug(vdata) values(l_itemkey);
225:
226: /* Start the subprocess now instead of earlier to fix the cancelled FYI
227: notifications */
228: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
229: itemkey => l_itemkey,
230: process => l_Workflow_Process) ;
231:
232:
231:
232:
233: /* Set the User Attribute */
234:
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'CURRENT_APPROVER',
237: avalue => l_user);
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'APPS_FORM',
234:
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'CURRENT_APPROVER',
237: avalue => l_user);
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'APPS_FORM',
240: avalue =>l_form );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
242: aname => 'EVENT_NAME',
237: avalue => l_user);
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'APPS_FORM',
240: avalue =>l_form );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
242: aname => 'EVENT_NAME',
243: avalue =>l_event_name );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'EVENT_KEY',
240: avalue =>l_form );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
242: aname => 'EVENT_NAME',
243: avalue =>l_event_name );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'EVENT_KEY',
246: avalue =>l_result_id );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'ITEM_NO',
243: avalue =>l_event_name );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'EVENT_KEY',
246: avalue =>l_result_id );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'ITEM_NO',
249: avalue =>l_item_no );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'ITEM_REVISION',
246: avalue =>l_result_id );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'ITEM_NO',
249: avalue =>l_item_no );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'ITEM_REVISION',
252: avalue =>l_item_revision );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'ITEM_DESC',
249: avalue =>l_item_no );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'ITEM_REVISION',
252: avalue =>l_item_revision );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'ITEM_DESC',
255: avalue =>l_item_desc );
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'ITEM_UM',
252: avalue =>l_item_revision );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'ITEM_DESC',
255: avalue =>l_item_desc );
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'ITEM_UM',
258: avalue =>l_item_um );
259: --RLNAGARA B5714214 Added parent_lot to the notification also.
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'ITEM_UM',
258: avalue =>l_item_um );
259: --RLNAGARA B5714214 Added parent_lot to the notification also.
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'PARENT_LOT',
262: avalue =>l_parent_lot );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'LOT_NO',
259: --RLNAGARA B5714214 Added parent_lot to the notification also.
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'PARENT_LOT',
262: avalue =>l_parent_lot );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'LOT_NO',
265: avalue =>l_lot_no );
266: --RLNAGARA LPN ME 7027149
267: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'LOT_NO',
265: avalue =>l_lot_no );
266: --RLNAGARA LPN ME 7027149
267: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
268: aname => 'LPN',
269: avalue =>l_lpn );
270: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
271: aname => 'TEST_CODE',
266: --RLNAGARA LPN ME 7027149
267: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
268: aname => 'LPN',
269: avalue =>l_lpn );
270: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
271: aname => 'TEST_CODE',
272: avalue =>l_test_code );
273: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
274: aname => 'TEST_DESC',
269: avalue =>l_lpn );
270: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
271: aname => 'TEST_CODE',
272: avalue =>l_test_code );
273: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
274: aname => 'TEST_DESC',
275: avalue =>l_test_desc );
276: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
277: aname => 'TEST_CLASS',
272: avalue =>l_test_code );
273: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
274: aname => 'TEST_DESC',
275: avalue =>l_test_desc );
276: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
277: aname => 'TEST_CLASS',
278: avalue =>l_test_class );
279: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
280: aname => 'TEST_METHOD_CODE',
275: avalue =>l_test_desc );
276: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
277: aname => 'TEST_CLASS',
278: avalue =>l_test_class );
279: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
280: aname => 'TEST_METHOD_CODE',
281: avalue =>l_test_method_Code );
282: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
283: aname => 'TEST_METHOD_DESC',
278: avalue =>l_test_class );
279: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
280: aname => 'TEST_METHOD_CODE',
281: avalue =>l_test_method_Code );
282: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
283: aname => 'TEST_METHOD_DESC',
284: avalue =>l_test_method_desc );
285: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
286: aname => 'TEST_REPLICATE',
281: avalue =>l_test_method_Code );
282: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
283: aname => 'TEST_METHOD_DESC',
284: avalue =>l_test_method_desc );
285: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
286: aname => 'TEST_REPLICATE',
287: avalue =>l_test_replicate );
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
289: aname => 'RESOURCES',
284: avalue =>l_test_method_desc );
285: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
286: aname => 'TEST_REPLICATE',
287: avalue =>l_test_replicate );
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
289: aname => 'RESOURCES',
290: avalue =>l_resources );
291: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
292: aname => 'QC_LAB_ORGN_CODE',
287: avalue =>l_test_replicate );
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
289: aname => 'RESOURCES',
290: avalue =>l_resources );
291: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
292: aname => 'QC_LAB_ORGN_CODE',
293: avalue =>l_qc_lab_orgn_code );
294: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
295: aname => 'SAMPLE_NO',
290: avalue =>l_resources );
291: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
292: aname => 'QC_LAB_ORGN_CODE',
293: avalue =>l_qc_lab_orgn_code );
294: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
295: aname => 'SAMPLE_NO',
296: avalue =>l_sample_no );
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
298: aname => 'SAMPLE_DESC',
293: avalue =>l_qc_lab_orgn_code );
294: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
295: aname => 'SAMPLE_NO',
296: avalue =>l_sample_no );
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
298: aname => 'SAMPLE_DESC',
299: avalue =>l_sample_desc);
300: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
301: aname => 'AME_TRANS',
296: avalue =>l_sample_no );
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
298: aname => 'SAMPLE_DESC',
299: avalue =>l_sample_desc);
300: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
301: aname => 'AME_TRANS',
302: avalue =>l_transaction_type);
303: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
304: aname => 'DAYS',
299: avalue =>l_sample_desc);
300: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
301: aname => 'AME_TRANS',
302: avalue =>l_transaction_type);
303: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
304: aname => 'DAYS',
305: avalue =>l_days);
306: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
307: aname => 'HOURS',
302: avalue =>l_transaction_type);
303: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
304: aname => 'DAYS',
305: avalue =>l_days);
306: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
307: aname => 'HOURS',
308: avalue =>l_hours);
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
310: aname => 'MINUTES',
305: avalue =>l_days);
306: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
307: aname => 'HOURS',
308: avalue =>l_hours);
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
310: aname => 'MINUTES',
311: avalue =>l_minutes);
312: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
313: aname => 'SECONDS',
308: avalue =>l_hours);
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
310: aname => 'MINUTES',
311: avalue =>l_minutes);
312: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
313: aname => 'SECONDS',
314: avalue =>l_seconds);
315: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'TEST_BY_DATE',
311: avalue =>l_minutes);
312: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
313: aname => 'SECONDS',
314: avalue =>l_seconds);
315: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'TEST_BY_DATE',
317: avalue =>l_testbydate);
318: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );
319: -- SCHANDRU INVCONV START
314: avalue =>l_seconds);
315: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'TEST_BY_DATE',
317: avalue =>l_testbydate);
318: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );
319: -- SCHANDRU INVCONV START
320: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
321: aname =>'SUBINVENTORY',
322: avalue =>l_SUBINVENTORY);
316: aname => 'TEST_BY_DATE',
317: avalue =>l_testbydate);
318: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );
319: -- SCHANDRU INVCONV START
320: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
321: aname =>'SUBINVENTORY',
322: avalue =>l_SUBINVENTORY);
323: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
324: aname => 'LOCATOR',
319: -- SCHANDRU INVCONV START
320: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
321: aname =>'SUBINVENTORY',
322: avalue =>l_SUBINVENTORY);
323: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
324: aname => 'LOCATOR',
325: avalue => l_LOCATOR);
326: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,
327: aname =>'PLANNED_RESOURCE',
322: avalue =>l_SUBINVENTORY);
323: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
324: aname => 'LOCATOR',
325: avalue => l_LOCATOR);
326: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,
327: aname =>'PLANNED_RESOURCE',
328: avalue =>l_planned_resource);
329: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
330: aname =>'PLANNED_RESULT_DATE',
325: avalue => l_LOCATOR);
326: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,
327: aname =>'PLANNED_RESOURCE',
328: avalue =>l_planned_resource);
329: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
330: aname =>'PLANNED_RESULT_DATE',
331: avalue => l_planned_Result_date);
332: -- SCHANDRU INVCONV END
333: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
329: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
330: aname =>'PLANNED_RESULT_DATE',
331: avalue => l_planned_Result_date);
332: -- SCHANDRU INVCONV END
333: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
334: parent_itemtype => p_itemtype,
335: parent_itemkey=> p_itemkey,
336: parent_context=> NULL);
337:
347: transactionTypeIn => l_transaction_type,
348: forwardeeIn => ame_util.emptyApproverRecord);
349:
350:
351: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
352:
353:
354: wf_log_pkg.string(6, 'Dummy','Child Process Created and current approver is '||l_user);
355:
378: p_funcmode IN VARCHAR2,
379: p_resultout OUT NOCOPY VARCHAR2)
380:
381: IS
382: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
383: itemtype=>p_itemtype,
384: itemkey=>P_itemkey,
385: aname=>'EVENT_NAME');
386: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
382: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
383: itemtype=>p_itemtype,
384: itemkey=>P_itemkey,
385: aname=>'EVENT_NAME');
386: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
387: itemtype=>p_itemtype,
388: itemkey=>P_itemkey,
389: aname=>'EVENT_KEY');
390:
390:
391: l_current_approver varchar2(240);
392:
393: l_application_id number;
394: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
395: itemtype=>p_itemtype,
396: itemkey=>P_itemkey,
397: aname=>'AME_TRANS');
398: l_user varchar2(32);
423: end if;
424:
425: /* Set the User Attribute */
426:
427: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
428: aname => 'CURRENT_APPROVER',
429: avalue => l_user);
430: P_resultout:='COMPLETE:Y';
431: Approver.approval_status := ame_util.approvedStatus;