DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on WF_ENGINE

Line 109: wf_engine.SetItemAttrText( p_item_type

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

Line 115: wf_engine.SetItemAttrText( p_item_type

111: , 'ITEM_TYPE'
112: , p_item_type
113: );
114:
115: wf_engine.SetItemAttrText( p_item_type
116: , p_item_key
117: , 'ITEM_KEY'
118: , p_item_key
119: );

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

117: , 'ITEM_KEY'
118: , p_item_key
119: );
120:
121: wf_engine.SetItemAttrText(itemtype => p_item_type,
122: itemkey => p_item_key,
123: aname => 'HISTORY',
124: avalue =>
125: 'PLSQL:PA_WORKFLOW_HISTORY.show_

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

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

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

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

Line 364: wf_engine.SetItemAttrText( p_item_type

360: BEGIN
361:
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: wf_engine.SetItemAttrText( p_item_type
365: , p_item_key
366: , 'ITEM_TYPE'
367: , p_item_type
368: );

Line 370: wf_engine.SetItemAttrText( p_item_type

366: , 'ITEM_TYPE'
367: , p_item_type
368: );
369:
370: wf_engine.SetItemAttrText( p_item_type
371: , p_item_key
372: , 'ITEM_KEY'
373: , p_item_key
374: );

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

373: , p_item_key
374: );
375:
376:
377: wf_engine.SetItemAttrText(itemtype => p_item_type,
378: itemkey => p_item_key,
379: aname => 'HISTORY',
380: avalue =>
381: 'PLSQL:PA_WORKFLOW_HISTORY.show_ci_history/'|| --Bug#14308345

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

382: p_item_type||':'||
383: p_item_key );
384:
385:
386: wf_engine.SetItemAttrText(itemtype => p_item_type,
387: itemkey => p_item_key,
388: aname => 'CLOB_CONTENT',
389: avalue =>
390: 'plsqlclob:pa_control_items_workflow.show_clob_content/'||

Line 395: wf_engine.SetItemAttrNumber( p_item_type

391: p_ci_id);
392:
393:
394:
395: wf_engine.SetItemAttrNumber( p_item_type
396: , p_item_key
397: , 'CI_ID'
398: , p_ci_id
399: );

Line 402: wf_engine.SetItemAttrNumber( p_item_type

398: , p_ci_id
399: );
400:
401:
402: wf_engine.SetItemAttrNumber( p_item_type
403: , p_item_key
404: , 'WF_OBJECT_ID'
405: , p_ci_id
406: );

Line 412: wf_engine.SetItemAttrNumber( p_item_type

408: OPEN get_project_mgr_party_id;
409: FETCH get_project_mgr_party_id INTO l_project_mgr_id;
410: CLOSE get_project_mgr_party_id;
411:
412: wf_engine.SetItemAttrNumber( p_item_type
413: , p_item_key
414: , 'PROJ_MGR_ID'
415: , l_project_mgr_id
416: );

Line 423: wf_engine.SetItemAttrNumber( p_item_type

419: FETCH get_submitted_by_id INTO l_submitted_by_id;
420: CLOSE get_submitted_by_id;
421:
422:
423: wf_engine.SetItemAttrNumber( p_item_type
424: , p_item_key
425: , 'SUBMITTED_BY_ID'
426: , l_submitted_by_id
427: );

Line 432: wf_engine.SetItemAttrNumber( p_item_type

428:
429: FOR rec IN get_ci_info LOOP
430: pa_utils.getprojinfo(rec.project_id, l_project_number, l_project_name);
431:
432: wf_engine.SetItemAttrNumber( p_item_type
433: , p_item_key
434: , 'PROJECT_ID'
435: , rec.project_id
436: );

Line 440: wf_engine.SetItemAttrNumber( p_item_type

436: );
437:
438:
439:
440: wf_engine.SetItemAttrNumber( p_item_type
441: , p_item_key
442: , 'RECORD_VERSION_NUMBER'
443: , rec.record_version_number
444: );

Line 447: wf_engine.SetItemAttrText( p_item_type

443: , rec.record_version_number
444: );
445:
446:
447: wf_engine.SetItemAttrText( p_item_type
448: , p_item_key
449: , 'PROJECT_NAME'
450: ,l_project_name
451: );

Line 453: wf_engine.SetItemAttrText( p_item_type

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

Line 459: wf_engine.SetItemAttrText( p_item_type

455: , 'PROJECT_NUMBER'
456: ,l_project_number
457: );
458:
459: wf_engine.SetItemAttrText( p_item_type
460: , p_item_key
461: , 'PROJECT'
462: ,l_project_name||'('||l_project_number||')'
463: );

Line 465: wf_engine.SetItemAttrDate( p_item_type

461: , 'PROJECT'
462: ,l_project_name||'('||l_project_number||')'
463: );
464:
465: wf_engine.SetItemAttrDate( p_item_type
466: , p_item_key
467: , 'DATE_REQUIRED'
468: ,rec.date_required
469: );

Line 471: wf_engine.SetItemAttrText( p_item_type

467: , 'DATE_REQUIRED'
468: ,rec.date_required
469: );
470:
471: wf_engine.SetItemAttrText( p_item_type
472: , p_item_key
473: , 'SUMMARY'
474: ,rec.summary
475: );

Line 477: wf_engine.SetItemAttrText( p_item_type

473: , 'SUMMARY'
474: ,rec.summary
475: );
476:
477: wf_engine.SetItemAttrText( p_item_type
478: , p_item_key
479: , 'CONTROL_ITEM_TYPE'
480: ,rec.ci_type_name
481: );

Line 483: wf_engine.SetItemAttrText( p_item_type

479: , 'CONTROL_ITEM_TYPE'
480: ,rec.ci_type_name
481: );
482:
483: wf_engine.SetItemAttrText( p_item_type
484: , p_item_key
485: , 'CONTROL_ITEM_CLASS'
486: ,rec.ci_type_class
487: );

Line 489: wf_engine.SetItemAttrText( p_item_type

485: , 'CONTROL_ITEM_CLASS'
486: ,rec.ci_type_class
487: );
488:
489: wf_engine.SetItemAttrText( p_item_type
490: , p_item_key
491: , 'CONTROL_ITEM_NUMBER'
492: ,rec.ci_number
493: );

Line 495: wf_engine.SetItemAttrText( p_item_type

491: , 'CONTROL_ITEM_NUMBER'
492: ,rec.ci_number
493: );
494:
495: wf_engine.SetItemAttrText( p_item_type
496: , p_item_key
497: , 'PRIORITY'
498: ,rec.priority_code
499: );

Line 501: wf_engine.SetItemAttrText( p_item_type

497: , 'PRIORITY'
498: ,rec.priority_code
499: );
500:
501: wf_engine.SetItemAttrText( p_item_type
502: , p_item_key
503: , 'CI_OWNER'
504: ,rec.party_name
505: );

Line 507: wf_engine.SetItemAttrText( p_item_type

503: , 'CI_OWNER'
504: ,rec.party_name
505: );
506:
507: wf_engine.SetItemAttrText( p_item_type
508: , p_item_key
509: , 'CLASSIFICATION'
510: ,rec.classification
511: );

Line 519: wf_engine.SetItemAttrText( p_item_type

515:
516: FETCH get_project_info INTO l_customer,l_project_manager, l_org;
517:
518:
519: wf_engine.SetItemAttrText( p_item_type
520: , p_item_key
521: , 'PROJECT_MANAGER'
522: ,l_project_manager
523: );

Line 526: wf_engine.SetItemAttrText( p_item_type

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

Line 532: wf_engine.SetItemAttrText( p_item_type

528: , 'ORGANIZATION'
529: ,l_org
530: );
531:
532: wf_engine.SetItemAttrText( p_item_type
533: , p_item_key
534: , 'CUSTOMER'
535: ,l_customer
536: );

Line 543: wf_engine.SetItemAttrText( p_item_type

539:
540: IF rec.object_type = 'PA_TASKS' THEN
541: -- set task name, task number
542: pa_utils.gettaskinfo(rec.object_id, l_task_number, l_task_name);
543: wf_engine.SetItemAttrText( p_item_type
544: , p_item_key
545: , 'TASK_NAME'
546: ,l_task_name
547: );

Line 549: wf_engine.SetItemAttrText( p_item_type

545: , 'TASK_NAME'
546: ,l_task_name
547: );
548:
549: wf_engine.SetItemAttrText( p_item_type
550: , p_item_key
551: , 'TASK_NUMBER'
552: ,l_task_number
553: );

Line 561: wf_engine.SetItemAttrText( p_item_type

557:
558: l_url := 'JSP:/OA_HTML/OA.jsp?' ||
559: 'akRegionCode=PA_CI_CI_REVIEW_LAYOUT&akRegionApplicationId=275&addBreadCrumb=RP&paCiId='||p_ci_id || '&paProjectId=' || rec.project_id;
560:
561: wf_engine.SetItemAttrText( p_item_type
562: , p_item_key
563: , 'CI_LINK'
564: , l_url
565: );

Line 676: l_ci_id := wf_engine.GetItemAttrNumber

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

Line 681: l_submitted_by_id := wf_engine.GetItemAttrNumber

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

Line 687: l_proj_mgr_id := wf_engine.GetItemAttrNumber

683: itemkey => p_item_key,
684: aname => 'SUBMITTED_BY_ID');
685:
686:
687: l_proj_mgr_id := wf_engine.GetItemAttrNumber
688: ( itemtype => p_item_type,
689: itemkey => p_item_key,
690: aname => 'PROJ_MGR_ID');
691:

Line 743: wf_engine.SetItemAttrText( p_item_type

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

Line 748: wf_engine.SetItemAttrText( p_item_type

744: , p_item_key
745: , 'CI_APPROVER'
746: , l_approval_role);
747:
748: wf_engine.SetItemAttrText( p_item_type
749: , p_item_key
750: , 'CI_APPROVER_NAME'
751: , l_proj_mgr_name);
752:

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

751: , l_proj_mgr_name);
752:
753:
754:
755: resultout := wf_engine.eng_completed||':'||'T';
756:
757:
758: ELSE
759:

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

756:
757:
758: ELSE
759:
760: resultout := wf_engine.eng_completed||':'||'F';
761: -- Bug 6843085
762: IF l_proj_mgr_id IS null THEN
763: OPEN get_prev_status(l_ci_id);
764: FETCH get_prev_status INTO l_prev_status, l_curr_status;

Line 873: l_ci_id := wf_engine.GetItemAttrNumber

869: territory VARCHAR2(2000);
870:
871: BEGIN
872:
873: l_ci_id := wf_engine.GetItemAttrNumber
874: ( itemtype => p_item_type,
875: itemkey => p_item_key,
876: aname => 'CI_ID');
877:

Line 912: wf_engine.SetItemAttrText( p_item_type

908:
909: IF (l_role_users is NOT NULL) THEN
910: WF_DIRECTORY.AddUsersToAdHocRole( l_role, l_role_users);
911:
912: wf_engine.SetItemAttrText( p_item_type
913: , p_item_key
914: , 'CI_NOTIFICATION_PARTY'
915: , l_role);
916: resultout := wf_engine.eng_completed||':'||'T';

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

912: wf_engine.SetItemAttrText( p_item_type
913: , p_item_key
914: , 'CI_NOTIFICATION_PARTY'
915: , l_role);
916: resultout := wf_engine.eng_completed||':'||'T';
917: ELSE
918:
919: resultout := wf_engine.eng_completed||':'||'F';
920:

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

915: , l_role);
916: resultout := wf_engine.eng_completed||':'||'T';
917: ELSE
918:
919: resultout := wf_engine.eng_completed||':'||'F';
920:
921: END IF;
922:
923:

Line 983: l_ci_id := wf_engine.GetItemAttrNumber

979: language VARCHAR2(2000);
980: territory VARCHAR2(2000);
981:
982: BEGIN
983: l_ci_id := wf_engine.GetItemAttrNumber
984: ( itemtype => p_item_type,
985: itemkey => p_item_key,
986: aname => 'CI_ID');
987:

Line 988: l_submitted_by_id := wf_engine.GetItemAttrNumber

984: ( itemtype => p_item_type,
985: itemkey => p_item_key,
986: aname => 'CI_ID');
987:
988: l_submitted_by_id := wf_engine.GetItemAttrNumber
989: ( itemtype => p_item_type,
990: itemkey => p_item_key,
991: aname => 'SUBMITTED_BY_ID');
992: l_role := 'SUBMITTER_' ||p_item_type || p_item_key;

Line 1020: wf_engine.SetItemAttrText( p_item_type

1016:
1017: IF (l_role_users is NOT NULL) THEN
1018: WF_DIRECTORY.AddUsersToAdHocRole( l_role, l_role_users);
1019:
1020: wf_engine.SetItemAttrText( p_item_type
1021: , p_item_key
1022: , 'CI_SUBMITTED_BY'
1023: , l_role);
1024: resultout := wf_engine.eng_completed||':'||'T';

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

1020: wf_engine.SetItemAttrText( p_item_type
1021: , p_item_key
1022: , 'CI_SUBMITTED_BY'
1023: , l_role);
1024: resultout := wf_engine.eng_completed||':'||'T';
1025: ELSE
1026: resultout := wf_engine.eng_completed||':'||'F';
1027:
1028: END IF;

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

1022: , 'CI_SUBMITTED_BY'
1023: , l_role);
1024: resultout := wf_engine.eng_completed||':'||'T';
1025: ELSE
1026: resultout := wf_engine.eng_completed||':'||'F';
1027:
1028: END IF;
1029: END;
1030: