DBA Data[Home] [Help]

APPS.GMD_QMREJ dependencies on WF_ENGINE

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

13: p_funcmode IN VARCHAR2,
14: p_resultout OUT NOCOPY VARCHAR2)
15:
16: IS
17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
18: itemtype=>p_itemtype,
19: itemkey=>P_itemkey,
20: aname=>'EVENT_NAME');
21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

17: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
18: itemtype=>p_itemtype,
19: itemkey=>P_itemkey,
20: aname=>'EVENT_NAME');
21: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
22: itemtype=>p_itemtype,
23: itemkey=>P_itemkey,
24: aname=>'EVENT_KEY');
25:

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

249: l_itemtype:='GMDQMREJ';
250: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
251: l_workflow_process:='GMDQMREJ_SUB_PROCESS';
252:
253: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
254: itemkey => l_itemkey,
255: process => l_workflow_process );
256:
257: /* Set the User Attribute */

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

254: itemkey => l_itemkey,
255: process => l_workflow_process );
256:
257: /* Set the User Attribute */
258: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
259: aname => '#FROM_ROLE',
260: avalue => l_user );
261:
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

258: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
259: aname => '#FROM_ROLE',
260: avalue => l_user );
261:
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
263: aname => 'CURRENT_APPROVER',
264: avalue => l_user);
265:
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
263: aname => 'CURRENT_APPROVER',
264: avalue => l_user);
265:
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
267: aname => 'APPS_FORM',
268: avalue =>l_form );
269:
270: /* Set All other Attributes */

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

267: aname => 'APPS_FORM',
268: avalue =>l_form );
269:
270: /* Set All other Attributes */
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => p_itemkey,
272: aname => 'EVENT_NAME',
273: avalue =>l_event_name );
274:
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => p_itemkey,
272: aname => 'EVENT_NAME',
273: avalue =>l_event_name );
274:
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
276: aname => 'EVENT_KEY',
277: avalue =>l_event_key );
278:
279: /* Set Attributes for Common Fields */

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

276: aname => 'EVENT_KEY',
277: avalue =>l_event_key );
278:
279: /* Set Attributes for Common Fields */
280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
281: aname => 'ORG',
282: avalue => l_orgn_code);
283:
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

280: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
281: aname => 'ORG',
282: avalue => l_orgn_code);
283:
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
285: aname => 'SMPLGRP_TYPE',
286: avalue => l_sample_type_desc);
287:
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
285: aname => 'SMPLGRP_TYPE',
286: avalue => l_sample_type_desc);
287:
288: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
289: aname => 'SMPLGRP_SOURCE',
290: avalue => l_sample_source);
291:
292: /* Set Attributes for Stability Study Sample Group */

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

289: aname => 'SMPLGRP_SOURCE',
290: avalue => l_sample_source);
291:
292: /* Set Attributes for Stability Study Sample Group */
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
294: aname => 'STUDY',
295: avalue => l_study_no);
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

293: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
294: aname => 'STUDY',
295: avalue => l_study_no);
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
298: aname => 'STUDY_DESC',
299: avalue => l_study_desc);
300:
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
298: aname => 'STUDY_DESC',
299: avalue => l_study_desc);
300:
301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
302: aname => 'ITEM_NO',
303: avalue => l_item_no);
304:
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

301: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
302: aname => 'ITEM_NO',
303: avalue => l_item_no);
304:
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
306: aname => 'ITEM_DESC',
307: avalue =>l_item_desc);
308:
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
306: aname => 'ITEM_DESC',
307: avalue =>l_item_desc);
308:
309: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
310: aname => 'REVISION',
311: avalue =>l_revision);
312:
313: /* Set Attributes for Resource Sample Group */

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

310: aname => 'REVISION',
311: avalue =>l_revision);
312:
313: /* Set Attributes for Resource Sample Group */
314: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
315: aname => 'RESOURCE',
316: avalue => l_resource);
317:
318: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

314: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
315: aname => 'RESOURCE',
316: avalue => l_resource);
317:
318: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
319: aname => 'RESOURCE_DESC',
320: avalue => l_resource_desc);
321:
322: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

318: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
319: aname => 'RESOURCE_DESC',
320: avalue => l_resource_desc);
321:
322: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
323: aname => 'RESOURCE_INST',
324: avalue => l_instance_num);
325:
326: /* Set Attributes for Resource Sample Group */

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

323: aname => 'RESOURCE_INST',
324: avalue => l_instance_num);
325:
326: /* Set Attributes for Resource Sample Group */
327: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
328: aname => 'SUBINVENTORY',
329: avalue => l_subinventory);
330:
331: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

327: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
328: aname => 'SUBINVENTORY',
329: avalue => l_subinventory);
330:
331: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
332: aname => 'LOCATOR',
333: avalue => l_locator);
334:
335: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

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

331: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
332: aname => 'LOCATOR',
333: avalue => l_locator);
334:
335: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
336: aname => 'AME_TRANS',
337: avalue =>l_transaction_type);
338:
339: wf_log_pkg.string(6, 'Dummy','Setting Parent');

Line 341: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,

337: avalue =>l_transaction_type);
338:
339: wf_log_pkg.string(6, 'Dummy','Setting Parent');
340:
341: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
342: parent_itemtype => p_itemtype,
343: parent_itemkey=> p_itemkey,
344: parent_context=> NULL);
345:

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

354: transactionTypeIn => l_transaction_type,
355: forwardeeIn => ame_util.emptyApproverRecord);
356:
357:
358: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
359:
360: IF (l_debug = 'Y') THEN
361: gmd_debug.put_line('created workflow process ');
362: END IF;

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

385: p_funcmode IN VARCHAR2,
386: p_resultout OUT NOCOPY VARCHAR2)
387:
388: IS
389: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
390: itemtype=>p_itemtype,
391: itemkey=>P_itemkey,
392: aname=>'EVENT_NAME');
393: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 393: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

389: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
390: itemtype=>p_itemtype,
391: itemkey=>P_itemkey,
392: aname=>'EVENT_NAME');
393: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
394: itemtype=>p_itemtype,
395: itemkey=>P_itemkey,
396: aname=>'EVENT_KEY');
397:

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

397:
398: l_current_approver varchar2(240);
399:
400: l_application_id number;
401: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
402: itemtype=>p_itemtype,
403: itemkey=>P_itemkey,
404: aname=>'AME_TRANS');
405: l_user varchar2(32);

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

431: end if;
432:
433: /* Set the User Attribute */
434:
435: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
436: aname => 'CURRENT_APPROVER',
437: avalue => l_user);
438:
439: P_resultout:='COMPLETE:Y';