DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on WF_ENGINE

Line 105: wf_engine.SetItemAttrText( p_item_type

101: -- item_key, etc. The best way to override this procedure is to copy the
102: -- code from start_workflow procedure and add your logic to the very end.
103:
104:
105: wf_engine.SetItemAttrText( p_item_type
106: , p_item_key
107: , 'ITEM_TYPE'
108: , p_item_type
109: );

Line 111: wf_engine.SetItemAttrText( p_item_type

107: , 'ITEM_TYPE'
108: , p_item_type
109: );
110:
111: wf_engine.SetItemAttrText( p_item_type
112: , p_item_key
113: , 'ITEM_KEY'
114: , p_item_key
115: );

Line 117: wf_engine.SetItemAttrText(itemtype => p_item_type,

113: , 'ITEM_KEY'
114: , p_item_key
115: );
116:
117: wf_engine.SetItemAttrText(itemtype => p_item_type,
118: itemkey => p_item_key,
119: aname => 'HISTORY',
120: avalue =>
121: 'PLSQL:PA_WORKFLOW_HISTORY.show_

Line 190: -- set return result to wf_engine.eng_completed||':'||'T';

186: -- you can look at the original code in the procedure for example.
187:
188: -- set the item attribute CI_APPROVER and CI_APPROVER_NAME
189:
190: -- set return result to wf_engine.eng_completed||':'||'T';
191:
192: EXCEPTION
193:
194: WHEN OTHERS THEN

Line 247: -- set return result to wf_engine.eng_completed||':'||'T';

243: -- you can look at the original code in the procedure for example.
244:
245: -- set the item attribute CI_NOTIFICATION_PARTY
246:
247: -- set return result to wf_engine.eng_completed||':'||'T';
248: end set_notification_party;
249:
250: =============================================================================*/
251:

Line 359: wf_engine.SetItemAttrText( p_item_type

355: BEGIN
356:
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358:
359: wf_engine.SetItemAttrText( p_item_type
360: , p_item_key
361: , 'ITEM_TYPE'
362: , p_item_type
363: );

Line 365: wf_engine.SetItemAttrText( p_item_type

361: , 'ITEM_TYPE'
362: , p_item_type
363: );
364:
365: wf_engine.SetItemAttrText( p_item_type
366: , p_item_key
367: , 'ITEM_KEY'
368: , p_item_key
369: );

Line 372: wf_engine.SetItemAttrText(itemtype => p_item_type,

368: , p_item_key
369: );
370:
371:
372: wf_engine.SetItemAttrText(itemtype => p_item_type,
373: itemkey => p_item_key,
374: aname => 'HISTORY',
375: avalue =>
376: 'PLSQL:PA_WORKFLOW_HISTORY.show_history/'||

Line 381: wf_engine.SetItemAttrText(itemtype => p_item_type,

377: p_item_type||':'||
378: p_item_key );
379:
380:
381: wf_engine.SetItemAttrText(itemtype => p_item_type,
382: itemkey => p_item_key,
383: aname => 'CLOB_CONTENT',
384: avalue =>
385: 'plsqlclob:pa_control_items_workflow.show_clob_content/'||

Line 390: wf_engine.SetItemAttrNumber( p_item_type

386: p_ci_id);
387:
388:
389:
390: wf_engine.SetItemAttrNumber( p_item_type
391: , p_item_key
392: , 'CI_ID'
393: , p_ci_id
394: );

Line 397: wf_engine.SetItemAttrNumber( p_item_type

393: , p_ci_id
394: );
395:
396:
397: wf_engine.SetItemAttrNumber( p_item_type
398: , p_item_key
399: , 'WF_OBJECT_ID'
400: , p_ci_id
401: );

Line 407: wf_engine.SetItemAttrNumber( p_item_type

403: OPEN get_project_mgr_party_id;
404: FETCH get_project_mgr_party_id INTO l_project_mgr_id;
405: CLOSE get_project_mgr_party_id;
406:
407: wf_engine.SetItemAttrNumber( p_item_type
408: , p_item_key
409: , 'PROJ_MGR_ID'
410: , l_project_mgr_id
411: );

Line 418: wf_engine.SetItemAttrNumber( p_item_type

414: FETCH get_submitted_by_id INTO l_submitted_by_id;
415: CLOSE get_submitted_by_id;
416:
417:
418: wf_engine.SetItemAttrNumber( p_item_type
419: , p_item_key
420: , 'SUBMITTED_BY_ID'
421: , l_submitted_by_id
422: );

Line 427: wf_engine.SetItemAttrNumber( p_item_type

423:
424: FOR rec IN get_ci_info LOOP
425: pa_utils.getprojinfo(rec.project_id, l_project_number, l_project_name);
426:
427: wf_engine.SetItemAttrNumber( p_item_type
428: , p_item_key
429: , 'PROJECT_ID'
430: , rec.project_id
431: );

Line 435: wf_engine.SetItemAttrNumber( p_item_type

431: );
432:
433:
434:
435: wf_engine.SetItemAttrNumber( p_item_type
436: , p_item_key
437: , 'RECORD_VERSION_NUMBER'
438: , rec.record_version_number
439: );

Line 442: wf_engine.SetItemAttrText( p_item_type

438: , rec.record_version_number
439: );
440:
441:
442: wf_engine.SetItemAttrText( p_item_type
443: , p_item_key
444: , 'PROJECT_NAME'
445: ,l_project_name
446: );

Line 448: wf_engine.SetItemAttrText( p_item_type

444: , 'PROJECT_NAME'
445: ,l_project_name
446: );
447:
448: wf_engine.SetItemAttrText( p_item_type
449: , p_item_key
450: , 'PROJECT_NUMBER'
451: ,l_project_number
452: );

Line 454: wf_engine.SetItemAttrText( p_item_type

450: , 'PROJECT_NUMBER'
451: ,l_project_number
452: );
453:
454: wf_engine.SetItemAttrText( p_item_type
455: , p_item_key
456: , 'PROJECT'
457: ,l_project_name||'('||l_project_number||')'
458: );

Line 460: wf_engine.SetItemAttrDate( p_item_type

456: , 'PROJECT'
457: ,l_project_name||'('||l_project_number||')'
458: );
459:
460: wf_engine.SetItemAttrDate( p_item_type
461: , p_item_key
462: , 'DATE_REQUIRED'
463: ,rec.date_required
464: );

Line 466: wf_engine.SetItemAttrText( p_item_type

462: , 'DATE_REQUIRED'
463: ,rec.date_required
464: );
465:
466: wf_engine.SetItemAttrText( p_item_type
467: , p_item_key
468: , 'SUMMARY'
469: ,rec.summary
470: );

Line 472: wf_engine.SetItemAttrText( p_item_type

468: , 'SUMMARY'
469: ,rec.summary
470: );
471:
472: wf_engine.SetItemAttrText( p_item_type
473: , p_item_key
474: , 'CONTROL_ITEM_TYPE'
475: ,rec.ci_type_name
476: );

Line 478: wf_engine.SetItemAttrText( p_item_type

474: , 'CONTROL_ITEM_TYPE'
475: ,rec.ci_type_name
476: );
477:
478: wf_engine.SetItemAttrText( p_item_type
479: , p_item_key
480: , 'CONTROL_ITEM_CLASS'
481: ,rec.ci_type_class
482: );

Line 484: wf_engine.SetItemAttrText( p_item_type

480: , 'CONTROL_ITEM_CLASS'
481: ,rec.ci_type_class
482: );
483:
484: wf_engine.SetItemAttrText( p_item_type
485: , p_item_key
486: , 'CONTROL_ITEM_NUMBER'
487: ,rec.ci_number
488: );

Line 490: wf_engine.SetItemAttrText( p_item_type

486: , 'CONTROL_ITEM_NUMBER'
487: ,rec.ci_number
488: );
489:
490: wf_engine.SetItemAttrText( p_item_type
491: , p_item_key
492: , 'PRIORITY'
493: ,rec.priority_code
494: );

Line 496: wf_engine.SetItemAttrText( p_item_type

492: , 'PRIORITY'
493: ,rec.priority_code
494: );
495:
496: wf_engine.SetItemAttrText( p_item_type
497: , p_item_key
498: , 'CI_OWNER'
499: ,rec.party_name
500: );

Line 502: wf_engine.SetItemAttrText( p_item_type

498: , 'CI_OWNER'
499: ,rec.party_name
500: );
501:
502: wf_engine.SetItemAttrText( p_item_type
503: , p_item_key
504: , 'CLASSIFICATION'
505: ,rec.classification
506: );

Line 514: wf_engine.SetItemAttrText( p_item_type

510:
511: FETCH get_project_info INTO l_customer,l_project_manager, l_org;
512:
513:
514: wf_engine.SetItemAttrText( p_item_type
515: , p_item_key
516: , 'PROJECT_MANAGER'
517: ,l_project_manager
518: );

Line 521: wf_engine.SetItemAttrText( p_item_type

517: ,l_project_manager
518: );
519:
520:
521: wf_engine.SetItemAttrText( p_item_type
522: , p_item_key
523: , 'ORGANIZATION'
524: ,l_org
525: );

Line 527: wf_engine.SetItemAttrText( p_item_type

523: , 'ORGANIZATION'
524: ,l_org
525: );
526:
527: wf_engine.SetItemAttrText( p_item_type
528: , p_item_key
529: , 'CUSTOMER'
530: ,l_customer
531: );

Line 538: wf_engine.SetItemAttrText( p_item_type

534:
535: IF rec.object_type = 'PA_TASKS' THEN
536: -- set task name, task number
537: pa_utils.gettaskinfo(rec.object_id, l_task_number, l_task_name);
538: wf_engine.SetItemAttrText( p_item_type
539: , p_item_key
540: , 'TASK_NAME'
541: ,l_task_name
542: );

Line 544: wf_engine.SetItemAttrText( p_item_type

540: , 'TASK_NAME'
541: ,l_task_name
542: );
543:
544: wf_engine.SetItemAttrText( p_item_type
545: , p_item_key
546: , 'TASK_NUMBER'
547: ,l_task_number
548: );

Line 556: wf_engine.SetItemAttrText( p_item_type

552:
553: l_url := 'JSP:/OA_HTML/OA.jsp?' ||
554: 'akRegionCode=PA_CI_CI_REVIEW_LAYOUT&akRegionApplicationId=275&addBreadCrumb=RP&paCiId='||p_ci_id || '&paProjectId=' || rec.project_id;
555:
556: wf_engine.SetItemAttrText( p_item_type
557: , p_item_key
558: , 'CI_LINK'
559: , l_url
560: );

Line 671: l_ci_id := wf_engine.GetItemAttrNumber

667:
668: BEGIN
669:
670:
671: l_ci_id := wf_engine.GetItemAttrNumber
672: ( itemtype => p_item_type,
673: itemkey => p_item_key,
674: aname => 'CI_ID');
675:

Line 676: l_submitted_by_id := wf_engine.GetItemAttrNumber

672: ( itemtype => p_item_type,
673: itemkey => p_item_key,
674: aname => 'CI_ID');
675:
676: l_submitted_by_id := wf_engine.GetItemAttrNumber
677: ( itemtype => p_item_type,
678: itemkey => p_item_key,
679: aname => 'SUBMITTED_BY_ID');
680:

Line 682: l_proj_mgr_id := wf_engine.GetItemAttrNumber

678: itemkey => p_item_key,
679: aname => 'SUBMITTED_BY_ID');
680:
681:
682: l_proj_mgr_id := wf_engine.GetItemAttrNumber
683: ( itemtype => p_item_type,
684: itemkey => p_item_key,
685: aname => 'PROJ_MGR_ID');
686:

Line 737: wf_engine.SetItemAttrText( p_item_type

733:
734:
735:
736:
737: wf_engine.SetItemAttrText( p_item_type
738: , p_item_key
739: , 'CI_APPROVER'
740: , l_approval_role);
741:

Line 742: wf_engine.SetItemAttrText( p_item_type

738: , p_item_key
739: , 'CI_APPROVER'
740: , l_approval_role);
741:
742: wf_engine.SetItemAttrText( p_item_type
743: , p_item_key
744: , 'CI_APPROVER_NAME'
745: , l_proj_mgr_name);
746:

Line 749: resultout := wf_engine.eng_completed||':'||'T';

745: , l_proj_mgr_name);
746:
747:
748:
749: resultout := wf_engine.eng_completed||':'||'T';
750:
751:
752: ELSE
753:

Line 754: resultout := wf_engine.eng_completed||':'||'F';

750:
751:
752: ELSE
753:
754: resultout := wf_engine.eng_completed||':'||'F';
755: -- Bug 6843085
756: IF l_proj_mgr_id IS null THEN
757: OPEN get_prev_status(l_ci_id);
758: FETCH get_prev_status INTO l_prev_status, l_curr_status;

Line 867: l_ci_id := wf_engine.GetItemAttrNumber

863: territory VARCHAR2(2000);
864:
865: BEGIN
866:
867: l_ci_id := wf_engine.GetItemAttrNumber
868: ( itemtype => p_item_type,
869: itemkey => p_item_key,
870: aname => 'CI_ID');
871:

Line 906: wf_engine.SetItemAttrText( p_item_type

902:
903: IF (l_role_users is NOT NULL) THEN
904: WF_DIRECTORY.AddUsersToAdHocRole( l_role, l_role_users);
905:
906: wf_engine.SetItemAttrText( p_item_type
907: , p_item_key
908: , 'CI_NOTIFICATION_PARTY'
909: , l_role);
910: resultout := wf_engine.eng_completed||':'||'T';

Line 910: resultout := wf_engine.eng_completed||':'||'T';

906: wf_engine.SetItemAttrText( p_item_type
907: , p_item_key
908: , 'CI_NOTIFICATION_PARTY'
909: , l_role);
910: resultout := wf_engine.eng_completed||':'||'T';
911: ELSE
912:
913: resultout := wf_engine.eng_completed||':'||'F';
914:

Line 913: resultout := wf_engine.eng_completed||':'||'F';

909: , l_role);
910: resultout := wf_engine.eng_completed||':'||'T';
911: ELSE
912:
913: resultout := wf_engine.eng_completed||':'||'F';
914:
915: END IF;
916:
917: