[Home] [Help]
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:
220: --insert into rg_debug(vdata) values(l_itemkey);
221:
222: /* Start the subprocess now instead of earlier to fix the cancelled FYI
223: notifications */
224: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
225: itemkey => l_itemkey,
226: process => l_Workflow_Process) ;
227:
228:
227:
228:
229: /* Set the User Attribute */
230:
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
232: aname => 'CURRENT_APPROVER',
233: avalue => l_user);
234: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
235: aname => 'APPS_FORM',
230:
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
232: aname => 'CURRENT_APPROVER',
233: avalue => l_user);
234: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
235: aname => 'APPS_FORM',
236: avalue =>l_form );
237: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
238: aname => 'EVENT_NAME',
233: avalue => l_user);
234: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
235: aname => 'APPS_FORM',
236: avalue =>l_form );
237: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
238: aname => 'EVENT_NAME',
239: avalue =>l_event_name );
240: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
241: aname => 'EVENT_KEY',
236: avalue =>l_form );
237: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
238: aname => 'EVENT_NAME',
239: avalue =>l_event_name );
240: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
241: aname => 'EVENT_KEY',
242: avalue =>l_result_id );
243: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
244: aname => 'ITEM_NO',
239: avalue =>l_event_name );
240: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
241: aname => 'EVENT_KEY',
242: avalue =>l_result_id );
243: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
244: aname => 'ITEM_NO',
245: avalue =>l_item_no );
246: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
247: aname => 'ITEM_REVISION',
242: avalue =>l_result_id );
243: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
244: aname => 'ITEM_NO',
245: avalue =>l_item_no );
246: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
247: aname => 'ITEM_REVISION',
248: avalue =>l_item_revision );
249: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
250: aname => 'ITEM_DESC',
245: avalue =>l_item_no );
246: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
247: aname => 'ITEM_REVISION',
248: avalue =>l_item_revision );
249: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
250: aname => 'ITEM_DESC',
251: avalue =>l_item_desc );
252: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
253: aname => 'ITEM_UM',
248: avalue =>l_item_revision );
249: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
250: aname => 'ITEM_DESC',
251: avalue =>l_item_desc );
252: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
253: aname => 'ITEM_UM',
254: avalue =>l_item_um );
255: --RLNAGARA B5714214 Added parent_lot to the notification also.
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
253: aname => 'ITEM_UM',
254: avalue =>l_item_um );
255: --RLNAGARA B5714214 Added parent_lot to the notification also.
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'PARENT_LOT',
258: avalue =>l_parent_lot );
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'LOT_NO',
255: --RLNAGARA B5714214 Added parent_lot to the notification also.
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'PARENT_LOT',
258: avalue =>l_parent_lot );
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'LOT_NO',
261: avalue =>l_lot_no );
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'TEST_CODE',
258: avalue =>l_parent_lot );
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'LOT_NO',
261: avalue =>l_lot_no );
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'TEST_CODE',
264: avalue =>l_test_code );
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'TEST_DESC',
261: avalue =>l_lot_no );
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'TEST_CODE',
264: avalue =>l_test_code );
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'TEST_DESC',
267: avalue =>l_test_desc );
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'TEST_CLASS',
264: avalue =>l_test_code );
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'TEST_DESC',
267: avalue =>l_test_desc );
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'TEST_CLASS',
270: avalue =>l_test_class );
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'TEST_METHOD_CODE',
267: avalue =>l_test_desc );
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'TEST_CLASS',
270: avalue =>l_test_class );
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'TEST_METHOD_CODE',
273: avalue =>l_test_method_Code );
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TEST_METHOD_DESC',
270: avalue =>l_test_class );
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'TEST_METHOD_CODE',
273: avalue =>l_test_method_Code );
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TEST_METHOD_DESC',
276: avalue =>l_test_method_desc );
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
278: aname => 'TEST_REPLICATE',
273: avalue =>l_test_method_Code );
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TEST_METHOD_DESC',
276: avalue =>l_test_method_desc );
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
278: aname => 'TEST_REPLICATE',
279: avalue =>l_test_replicate );
280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
281: aname => 'RESOURCES',
276: avalue =>l_test_method_desc );
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
278: aname => 'TEST_REPLICATE',
279: avalue =>l_test_replicate );
280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
281: aname => 'RESOURCES',
282: avalue =>l_resources );
283: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
284: aname => 'QC_LAB_ORGN_CODE',
279: avalue =>l_test_replicate );
280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
281: aname => 'RESOURCES',
282: avalue =>l_resources );
283: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
284: aname => 'QC_LAB_ORGN_CODE',
285: avalue =>l_qc_lab_orgn_code );
286: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
287: aname => 'SAMPLE_NO',
282: avalue =>l_resources );
283: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
284: aname => 'QC_LAB_ORGN_CODE',
285: avalue =>l_qc_lab_orgn_code );
286: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
287: aname => 'SAMPLE_NO',
288: avalue =>l_sample_no );
289: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
290: aname => 'SAMPLE_DESC',
285: avalue =>l_qc_lab_orgn_code );
286: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
287: aname => 'SAMPLE_NO',
288: avalue =>l_sample_no );
289: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
290: aname => 'SAMPLE_DESC',
291: avalue =>l_sample_desc);
292: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
293: aname => 'AME_TRANS',
288: avalue =>l_sample_no );
289: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
290: aname => 'SAMPLE_DESC',
291: avalue =>l_sample_desc);
292: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
293: aname => 'AME_TRANS',
294: avalue =>l_transaction_type);
295: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
296: aname => 'DAYS',
291: avalue =>l_sample_desc);
292: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
293: aname => 'AME_TRANS',
294: avalue =>l_transaction_type);
295: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
296: aname => 'DAYS',
297: avalue =>l_days);
298: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
299: aname => 'HOURS',
294: avalue =>l_transaction_type);
295: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
296: aname => 'DAYS',
297: avalue =>l_days);
298: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
299: aname => 'HOURS',
300: avalue =>l_hours);
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
302: aname => 'MINUTES',
297: avalue =>l_days);
298: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
299: aname => 'HOURS',
300: avalue =>l_hours);
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
302: aname => 'MINUTES',
303: avalue =>l_minutes);
304: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
305: aname => 'SECONDS',
300: avalue =>l_hours);
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
302: aname => 'MINUTES',
303: avalue =>l_minutes);
304: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
305: aname => 'SECONDS',
306: avalue =>l_seconds);
307: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
308: aname => 'TEST_BY_DATE',
303: avalue =>l_minutes);
304: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
305: aname => 'SECONDS',
306: avalue =>l_seconds);
307: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
308: aname => 'TEST_BY_DATE',
309: avalue =>l_testbydate);
310: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );
311: -- SCHANDRU INVCONV START
306: avalue =>l_seconds);
307: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
308: aname => 'TEST_BY_DATE',
309: avalue =>l_testbydate);
310: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );
311: -- SCHANDRU INVCONV START
312: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
313: aname =>'SUBINVENTORY',
314: avalue =>l_SUBINVENTORY);
308: aname => 'TEST_BY_DATE',
309: avalue =>l_testbydate);
310: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );
311: -- SCHANDRU INVCONV START
312: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
313: aname =>'SUBINVENTORY',
314: avalue =>l_SUBINVENTORY);
315: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'LOCATOR',
311: -- SCHANDRU INVCONV START
312: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
313: aname =>'SUBINVENTORY',
314: avalue =>l_SUBINVENTORY);
315: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'LOCATOR',
317: avalue => l_LOCATOR);
318: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,
319: aname =>'PLANNED_RESOURCE',
314: avalue =>l_SUBINVENTORY);
315: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'LOCATOR',
317: avalue => l_LOCATOR);
318: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,
319: aname =>'PLANNED_RESOURCE',
320: avalue =>l_planned_resource);
321: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
322: aname =>'PLANNED_RESULT_DATE',
317: avalue => l_LOCATOR);
318: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,
319: aname =>'PLANNED_RESOURCE',
320: avalue =>l_planned_resource);
321: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
322: aname =>'PLANNED_RESULT_DATE',
323: avalue => l_planned_Result_date);
324: -- SCHANDRU INVCONV END
325: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
321: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
322: aname =>'PLANNED_RESULT_DATE',
323: avalue => l_planned_Result_date);
324: -- SCHANDRU INVCONV END
325: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
326: parent_itemtype => p_itemtype,
327: parent_itemkey=> p_itemkey,
328: parent_context=> NULL);
329:
339: transactionTypeIn => l_transaction_type,
340: forwardeeIn => ame_util.emptyApproverRecord);
341:
342:
343: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
344:
345:
346: wf_log_pkg.string(6, 'Dummy','Child Process Created and current approver is '||l_user);
347:
370: p_funcmode IN VARCHAR2,
371: p_resultout OUT NOCOPY VARCHAR2)
372:
373: IS
374: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
375: itemtype=>p_itemtype,
376: itemkey=>P_itemkey,
377: aname=>'EVENT_NAME');
378: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
374: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
375: itemtype=>p_itemtype,
376: itemkey=>P_itemkey,
377: aname=>'EVENT_NAME');
378: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
379: itemtype=>p_itemtype,
380: itemkey=>P_itemkey,
381: aname=>'EVENT_KEY');
382:
382:
383: l_current_approver varchar2(240);
384:
385: l_application_id number;
386: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
387: itemtype=>p_itemtype,
388: itemkey=>P_itemkey,
389: aname=>'AME_TRANS');
390: l_user varchar2(32);
415: end if;
416:
417: /* Set the User Attribute */
418:
419: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
420: aname => 'CURRENT_APPROVER',
421: avalue => l_user);
422: P_resultout:='COMPLETE:Y';
423: Approver.approval_status := ame_util.approvedStatus;