DBA Data[Home] [Help]

APPS.GMD_QMTES dependencies on WF_ENGINE

Line 16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

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(

Line 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:

Line 31: l_test_id number:=WF_ENGINE.GETITEMATTRTEXT(

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:

Line 224: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

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:

Line 231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 234: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 237: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

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',

Line 240: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 243: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 246: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 249: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 252: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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,

Line 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',

Line 259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 277: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 283: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 286: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 289: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 292: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 295: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 298: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 304: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 307: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

Line 310: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey, aname => '#FROM_ROLE',avalue => l_from_role );

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);

Line 312: 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);
315: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,
316: aname => 'LOCATOR',

Line 315: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,

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',

Line 318: wf_engine.setitemattrtext(itemtype => l_itemtype, itemkey =>l_itemkey,

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',

Line 321: wf_engine.setitemattrtext(itemtype => l_itemtype,itemkey => l_itemkey,

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,

Line 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:

Line 343: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

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:

Line 374: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

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(

Line 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:

Line 386: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(

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);

Line 419: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

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;