328: , resp_appl_id => fnd_global.resp_appl_id
329: );
330:
331: -- Create the workflow process
332: --dbms_output.put_line('wf_engine.CreateProcess');
333:
334: wf_engine.CreateProcess( ItemType => ItemType,
335: ItemKey => ItemKey,
336: process => p_process
330:
331: -- Create the workflow process
332: --dbms_output.put_line('wf_engine.CreateProcess');
333:
334: wf_engine.CreateProcess( ItemType => ItemType,
335: ItemKey => ItemKey,
336: process => p_process
337: );
338:
391: -- -----------------------------------------------------------------------------------
392: -- Initialize Workflow Item Attributes
393: -- -----------------------------------------------------------------------------------
394:
395: wf_engine.SetItemAttrNumber (itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'PROJECT_ID',
398: avalue => p_project_id
399: );
397: aname => 'PROJECT_ID',
398: avalue => p_project_id
399: );
400:
401: wf_engine.SetItemAttrText (itemtype => itemtype,
402: itemkey => itemkey,
403: aname => 'PM_PROJECT_REFERENCE',
404: avalue => l_pm_project_reference
405: );
403: aname => 'PM_PROJECT_REFERENCE',
404: avalue => l_pm_project_reference
405: );
406:
407: wf_engine.SetItemAttrText (itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'PA_PROJECT_NUMBER',
410: avalue => l_pa_project_number
411: );
409: aname => 'PA_PROJECT_NUMBER',
410: avalue => l_pa_project_number
411: );
412:
413: wf_engine.SetItemAttrText (itemtype => itemtype,
414: itemkey => itemkey,
415: aname => 'PROJECT_NAME',
416: avalue => l_project_name
417: );
415: aname => 'PROJECT_NAME',
416: avalue => l_project_name
417: );
418:
419: wf_engine.SetItemAttrText (itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'PROJECT_DESCRIPTION',
422: avalue => l_description
423: );
421: aname => 'PROJECT_DESCRIPTION',
422: avalue => l_description
423: );
424:
425: wf_engine.SetItemAttrText (itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'PROJECT_TYPE',
428: avalue => l_project_type
429: );
427: aname => 'PROJECT_TYPE',
428: avalue => l_project_type
429: );
430:
431: wf_engine.SetItemAttrText (itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'PM_PROJECT_PRODUCT_CODE',
434: avalue => l_pm_product_code
435: );
433: aname => 'PM_PROJECT_PRODUCT_CODE',
434: avalue => l_pm_product_code
435: );
436:
437: wf_engine.SetItemAttrNumber (itemtype => itemtype,
438: itemkey => itemkey,
439: aname => 'CARRYING_OUT_ORG_ID',
440: avalue => l_carrying_out_org_id
441: );
439: aname => 'CARRYING_OUT_ORG_ID',
440: avalue => l_carrying_out_org_id
441: );
442:
443: wf_engine.SetItemAttrText (itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'CARRYING_OUT_ORG_NAME',
446: avalue => l_carrying_out_org_name
447: );
445: aname => 'CARRYING_OUT_ORG_NAME',
446: avalue => l_carrying_out_org_name
447: );
448:
449: wf_engine.SetItemAttrText (itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'PROJECT_TYPE_CLASS_CODE',
452: avalue => l_project_type_class_code
453: );
451: aname => 'PROJECT_TYPE_CLASS_CODE',
452: avalue => l_project_type_class_code
453: );
454:
455: wf_engine.SetItemAttrText (itemtype => itemtype,
456: itemkey => itemkey,
457: aname => 'NOTE',
458: avalue => l_change_comment
459: );
457: aname => 'NOTE',
458: avalue => l_change_comment
459: );
460:
461: wf_engine.SetItemAttrNumber (itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'WORKFLOW_STARTED_BY_ID',
464: avalue => l_workflow_started_by_id
465: );
463: aname => 'WORKFLOW_STARTED_BY_ID',
464: avalue => l_workflow_started_by_id
465: );
466:
467: wf_engine.SetItemAttrText (itemtype => itemtype,
468: itemkey => itemkey,
469: aname => 'WORKFLOW_STARTED_BY_NAME',
470: avalue => l_user_name
471: );
469: aname => 'WORKFLOW_STARTED_BY_NAME',
470: avalue => l_user_name
471: );
472:
473: wf_engine.SetItemAttrText (itemtype => itemtype,
474: itemkey => itemkey,
475: aname =>
476: 'WORKFLOW_STARTED_BY_FULL_NAME',
477: avalue => l_user_full_name
476: 'WORKFLOW_STARTED_BY_FULL_NAME',
477: avalue => l_user_full_name
478: );
479:
480: wf_engine.SetItemAttrNumber (itemtype => itemtype,
481: itemkey => itemkey,
482: aname => 'RESPONSIBILITY_ID',
483: avalue => l_resp_id
484: );
482: aname => 'RESPONSIBILITY_ID',
483: avalue => l_resp_id
484: );
485:
486: wf_engine.SetItemAttrText (itemtype => itemtype,
487: itemkey => itemkey,
488: aname => 'PROJECT_STATUS_CODE',
489: avalue => l_project_status_code
490: );
488: aname => 'PROJECT_STATUS_CODE',
489: avalue => l_project_status_code
490: );
491:
492: wf_engine.SetItemAttrText (itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'PROJECT_STATUS_NAME',
495: avalue => l_project_status_name
496: );
494: aname => 'PROJECT_STATUS_NAME',
495: avalue => l_project_status_name
496: );
497:
498: wf_engine.SetItemAttrText (itemtype => itemtype,
499: itemkey => itemkey,
500: aname => 'WF_SUCCESS_STATUS_CODE',
501: avalue => l_wf_success_status_code
502: );
501: avalue => l_wf_success_status_code
502: );
503:
504:
505: wf_engine.SetItemAttrText (itemtype => itemtype,
506: itemkey => itemkey,
507: aname => 'WF_SUCCESS_STATUS_NAME',
508: avalue => l_wf_success_status_name
509: );
507: aname => 'WF_SUCCESS_STATUS_NAME',
508: avalue => l_wf_success_status_name
509: );
510:
511: wf_engine.SetItemAttrText (itemtype => itemtype,
512: itemkey => itemkey,
513: aname => 'WF_FAILURE_STATUS_CODE',
514: avalue => l_wf_failure_status_code
515: );
514: avalue => l_wf_failure_status_code
515: );
516:
517:
518: wf_engine.SetItemAttrText (itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'WF_FAILURE_STATUS_NAME',
521: avalue => l_wf_failure_status_name
522: );
520: aname => 'WF_FAILURE_STATUS_NAME',
521: avalue => l_wf_failure_status_name
522: );
523:
524: wf_engine.SetItemAttrText (itemtype => itemtype,
525: itemkey => itemkey,
526: aname => 'WF_STARTED_DATE',
527: avalue => l_wf_started_date
528: );
539: ||'&'||'addBreadCrumb=Y';
540: End If;
541:
542:
543: wf_engine.SetItemAttrText( itemtype
544: , itemkey
545: , 'PROJECT_SSWA_URL'
546: , l_url
547: );
548:
549: --Bug 6875403
550:
551:
552: --dbms_output.put_line('wf_engine.StartProcess');
553: --
554: wf_engine.StartProcess( itemtype => itemtype,
555: itemkey => itemkey );
556: --
550:
551:
552: --dbms_output.put_line('wf_engine.StartProcess');
553: --
554: wf_engine.StartProcess( itemtype => itemtype,
555: itemkey => itemkey );
556: --
557:
558: EXCEPTION