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 228: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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:

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

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(

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

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

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

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

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;