DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on WF_ENGINE

Line 109: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);

105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108:
109: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
110:
111: -- create the workflow process
112: WF_ENGINE.CreateProcess( p_item_type
113: , x_item_key

Line 112: WF_ENGINE.CreateProcess( p_item_type

108:
109: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
110:
111: -- create the workflow process
112: WF_ENGINE.CreateProcess( p_item_type
113: , x_item_key
114: , p_Process_Name);
115: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);
116:

Line 115: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);

111: -- create the workflow process
112: WF_ENGINE.CreateProcess( p_item_type
113: , x_item_key
114: , p_Process_Name);
115: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);
116:
117: pa_report_workflow_client.start_workflow(
118: p_item_type
119: , p_process_name

Line 129: --debug_msg ( 'before WF_ENGINE startProcess' );

125: );
126:
127: IF x_return_status = FND_API.g_ret_sts_success then
128:
129: --debug_msg ( 'before WF_ENGINE startProcess' );
130: --debug_msg ( 'startProcess: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
131:
132:
133: OPEN get_last_workflow_info;

Line 145: WF_ENGINE.AbortProcess( p_Item_Type

141:
142: --debug_msg_s1 ('abort AAAAAAAAAA' || p_item_type);
143:
144: --debug_msg_s1 ('abort AAAAAAAAAA' || To_char(l_last_item_key));
145: WF_ENGINE.AbortProcess( p_Item_Type
146: , l_last_Item_Key
147: );
148: EXCEPTION
149: WHEN OTHERS THEN

Line 158: WF_ENGINE.StartProcess(

154: END IF;
155:
156: CLOSE get_last_workflow_info; -- Bug #3905748
157:
158: WF_ENGINE.StartProcess(
159: p_Item_Type
160: , x_Item_Key
161: );
162: END IF;

Line 164: --debug_msg ( 'after WF_ENGINE startProcess' );

160: , x_Item_Key
161: );
162: END IF;
163:
164: --debug_msg ( 'after WF_ENGINE startProcess' );
165:
166:
167: EXCEPTION
168:

Line 207: WF_ENGINE.AbortProcess( p_Item_Type

203:
204: --debug_msg ( 'after client cancel_workflow call' );
205:
206: IF (x_return_status = FND_API.g_ret_sts_success) THEN
207: WF_ENGINE.AbortProcess( p_Item_Type
208: , p_Item_Key
209: );
210:
211: --debug_msg ( 'after WF_ENGINE abortProcess' );

Line 211: --debug_msg ( 'after WF_ENGINE abortProcess' );

207: WF_ENGINE.AbortProcess( p_Item_Type
208: , p_Item_Key
209: );
210:
211: --debug_msg ( 'after WF_ENGINE abortProcess' );
212:
213: --debug_msg ('before get task_id');
214:
215: END IF;

Line 295: l_version_id := wf_engine.GetItemAttrNumber

291:
292:
293: BEGIN
294:
295: l_version_id := wf_engine.GetItemAttrNumber
296: ( itemtype => itemtype,
297: itemkey => itemkey,
298: aname => 'VERSION_ID');
299:

Line 305: wf_engine.SetItemAttrText

301: FETCH get_progress_status INTO l_status;
302:
303: CLOSE get_progress_status;
304:
305: wf_engine.SetItemAttrText
306: ( itemtype,
307: itemkey,
308: 'REPORT_STATUS',
309: l_status);

Line 311: l_name := wf_engine.getItemAttrText

307: itemkey,
308: 'REPORT_STATUS',
309: l_status);
310: /* Code addition for bug 5027098 starts */
311: l_name := wf_engine.getItemAttrText
312: ( itemtype => itemtype,
313: itemkey => itemkey,
314: aname => 'REPORT_APPROVER_USER_NAME');
315: /* Code addition for bug 5027098 ends */

Line 318: resultout := wf_engine.eng_completed||':'||'PUBLISHED';

314: aname => 'REPORT_APPROVER_USER_NAME');
315: /* Code addition for bug 5027098 ends */
316:
317: IF l_status = 'PROGRESS_REPORT_PUBLISHED' THEN
318: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
319: ELSIF l_status = 'PROGRESS_REPORT_REJECTED' THEN
320: /* Code addition for bug 5027098 starts */
321: wf_engine.SetItemAttrText
322: ( itemtype,

Line 321: wf_engine.SetItemAttrText

317: IF l_status = 'PROGRESS_REPORT_PUBLISHED' THEN
318: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
319: ELSIF l_status = 'PROGRESS_REPORT_REJECTED' THEN
320: /* Code addition for bug 5027098 starts */
321: wf_engine.SetItemAttrText
322: ( itemtype,
323: itemkey,
324: 'FROM_ROLE_VALUE',
325: l_name);

Line 327: resultout := wf_engine.eng_completed||':'||'REJECTED';

323: itemkey,
324: 'FROM_ROLE_VALUE',
325: l_name);
326: /* Code addition for bug 5027098 ends */
327: resultout := wf_engine.eng_completed||':'||'REJECTED';
328: ELSIF l_status = 'PROGRESS_REPORT_APPROVED' THEN
329:
330: /* Code addition for bug 5027098 starts */
331: wf_engine.SetItemAttrText

Line 331: wf_engine.SetItemAttrText

327: resultout := wf_engine.eng_completed||':'||'REJECTED';
328: ELSIF l_status = 'PROGRESS_REPORT_APPROVED' THEN
329:
330: /* Code addition for bug 5027098 starts */
331: wf_engine.SetItemAttrText
332: ( itemtype,
333: itemkey,
334: 'FROM_ROLE_VALUE',
335: l_name);

Line 337: resultout := wf_engine.eng_completed||':'||'APPROVED';

333: itemkey,
334: 'FROM_ROLE_VALUE',
335: l_name);
336: /* Code addition for bug 5027098 ends */
337: resultout := wf_engine.eng_completed||':'||'APPROVED';
338: ELSIF l_status = 'PROGRESS_REPORT_CANCELED' THEN
339: resultout := wf_engine.eng_completed||':'||'CANCELED';
340: END IF;
341:

Line 339: resultout := wf_engine.eng_completed||':'||'CANCELED';

335: l_name);
336: /* Code addition for bug 5027098 ends */
337: resultout := wf_engine.eng_completed||':'||'APPROVED';
338: ELSIF l_status = 'PROGRESS_REPORT_CANCELED' THEN
339: resultout := wf_engine.eng_completed||':'||'CANCELED';
340: END IF;
341:
342: -- added by syao
343: -- set notification party based on the notification type

Line 377: l_version_id := wf_engine.GetItemAttrNumber

373:
374:
375: BEGIN
376:
377: l_version_id := wf_engine.GetItemAttrNumber
378: ( itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'VERSION_ID');
381:

Line 382: l_record_version_number := wf_engine.GetItemAttrNumber

378: ( itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'VERSION_ID');
381:
382: l_record_version_number := wf_engine.GetItemAttrNumber
383: ( itemtype => itemtype,
384: itemkey => itemkey,
385: aname => 'RECORD_VERSION_NUMBER');
386:

Line 424: l_version_id := wf_engine.GetItemAttrNumber

420: l_name VARCHAR2(200);
421:
422: BEGIN
423:
424: l_version_id := wf_engine.GetItemAttrNumber
425: ( itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'VERSION_ID');
428:

Line 429: l_record_version_number := wf_engine.GetItemAttrNumber

425: ( itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'VERSION_ID');
428:
429: l_record_version_number := wf_engine.GetItemAttrNumber
430: ( itemtype => itemtype,
431: itemkey => itemkey,
432: aname => 'RECORD_VERSION_NUMBER');
433:

Line 449: l_comment := wf_engine.GetItemAttrText

445:
446: );
447:
448: IF (l_return_status = 'S' ) THEN
449: l_comment := wf_engine.GetItemAttrText
450: ( itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'COMMENT');
453:

Line 454: l_name := wf_engine.GetItemAttrText( itemtype

450: ( itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'COMMENT');
453:
454: l_name := wf_engine.GetItemAttrText( itemtype
455: , itemkey
456: , 'REPORT_APPROVER_USER_NAME');
457:
458: pa_workflow_history.save_comment_history (

Line 514: l_version_id := wf_engine.GetItemAttrNumber

510: l_name VARCHAR2(200);
511:
512: BEGIN
513:
514: l_version_id := wf_engine.GetItemAttrNumber
515: ( itemtype => itemtype,
516: itemkey => itemkey,
517: aname => 'VERSION_ID');
518:

Line 519: l_record_version_number := wf_engine.GetItemAttrNumber

515: ( itemtype => itemtype,
516: itemkey => itemkey,
517: aname => 'VERSION_ID');
518:
519: l_record_version_number := wf_engine.GetItemAttrNumber
520: ( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'RECORD_VERSION_NUMBER');
523:

Line 525: l_summary_version_number := wf_engine.GetItemAttrNumber

521: itemkey => itemkey,
522: aname => 'RECORD_VERSION_NUMBER');
523:
524: /* Commented for Bug 3629793
525: l_summary_version_number := wf_engine.GetItemAttrNumber
526: ( itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'SUMMARY_VERSION_NUMBER');
529: */

Line 538: l_auto_approved := wf_engine.GetItemAttrText

534: --CLOSE is_auto_published;
535:
536: -- we get the autopublish info from item attribute now
537:
538: l_auto_approved := wf_engine.GetItemAttrText
539: ( itemtype => itemtype,
540: itemkey => itemkey,
541: aname => 'AUTO_APPROVED');
542:

Line 582: l_comment := wf_engine.GetItemAttrText

578:
579: IF (l_return_status = 'S') THEN
580:
581:
582: l_comment := wf_engine.GetItemAttrText
583: ( itemtype => itemtype,
584: itemkey => itemkey,
585: aname => 'COMMENT');
586:

Line 587: l_name := wf_engine.GetItemAttrText( itemtype

583: ( itemtype => itemtype,
584: itemkey => itemkey,
585: aname => 'COMMENT');
586:
587: l_name := wf_engine.GetItemAttrText( itemtype
588: , itemkey
589: , 'REPORT_APPROVER_USER_NAME');
590:
591: pa_workflow_history.save_comment_history (

Line 642: l_reported_by_id := wf_engine.GetItemAttrNumber

638:
639:
640: BEGIN
641:
642: l_reported_by_id := wf_engine.GetItemAttrNumber
643: ( itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'REPORTED_BY_ID');
646:

Line 647: l_submitter_id := wf_engine.GetItemAttrNumber

643: ( itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'REPORTED_BY_ID');
646:
647: l_submitter_id := wf_engine.GetItemAttrNumber
648: ( itemtype => itemtype,
649: itemkey => itemkey,
650: aname => 'SUBMITTER_ID');
651:

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

658: CLOSE get_submitter_emp_id;
659:
660: IF l_submitter_emp_id = l_reported_by_id THEN
661:
662: resultout := wf_engine.eng_completed||':'||'T';
663: ELSE
664:
665: resultout := wf_engine.eng_completed||':'||'F';
666: END IF;

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

661:
662: resultout := wf_engine.eng_completed||':'||'T';
663: ELSE
664:
665: resultout := wf_engine.eng_completed||':'||'F';
666: END IF;
667:
668: --debug_msg('is_submitter_same_as_reporter ');
669: --debug_msg('returning ' || resultout);

Line 770: WF_ENGINE.CreateProcess( p_item_type

766:
767: -- create the workflow process
768:
769: --debug_msg_s1 ('start workflow 1: starting');
770: WF_ENGINE.CreateProcess( p_item_type
771: , l_item_key
772: , p_Process_Name);
773:
774: --debug_msg_s1 ('start workflow 1: starting 2');

Line 776: wf_engine.SetItemAttrNumber( p_item_type

772: , p_Process_Name);
773:
774: --debug_msg_s1 ('start workflow 1: starting 2');
775:
776: wf_engine.SetItemAttrNumber( p_item_type
777: , l_item_key
778: , 'OBJECT_ID'
779: ,p_object_id
780: );

Line 782: wf_engine.SetItemAttrText( p_item_type

778: , 'OBJECT_ID'
779: ,p_object_id
780: );
781:
782: wf_engine.SetItemAttrText( p_item_type
783: , l_item_key
784: , 'OBJECT_TYPE'
785: ,p_object_type
786: );

Line 795: wf_engine.SetItemAttrText( p_item_type

791: FETCH get_project_info INTO l_customer,l_project_manager, l_org, l_project, l_report_type_name, l_project_id;
792:
793: --debug_msg_s ('mgr ' || l_project_manager);
794:
795: wf_engine.SetItemAttrText( p_item_type
796: , l_item_key
797: , 'PROJECT_MANAGER'
798: ,l_project_manager
799: );

Line 803: wf_engine.SetItemAttrText( p_item_type

799: );
800: CLOSE get_project_info;
801:
802: --debug_msg_s ('org ' || l_org);
803: wf_engine.SetItemAttrText( p_item_type
804: , l_item_key
805: , 'ORGANIZATION'
806: ,l_org
807: );

Line 809: wf_engine.SetItemAttrText( p_item_type

805: , 'ORGANIZATION'
806: ,l_org
807: );
808: --debug_msg_s ('customer ' || l_customer);
809: wf_engine.SetItemAttrText( p_item_type
810: , l_item_key
811: , 'CUSTOMER'
812: ,l_customer
813: );

Line 815: wf_engine.SetItemAttrText( p_item_type

811: , 'CUSTOMER'
812: ,l_customer
813: );
814:
815: wf_engine.SetItemAttrText( p_item_type
816: , l_item_key
817: , 'PROJECT'
818: ,l_project
819: );

Line 821: wf_engine.SetItemAttrText( p_item_type

817: , 'PROJECT'
818: ,l_project
819: );
820:
821: wf_engine.SetItemAttrText( p_item_type
822: , l_item_key
823: , 'REPORT_TYPE'
824: ,l_report_type_name
825: );

Line 837: wf_engine.SetItemAttrText( p_item_type

833: l_url2 := 'JSP:/OA_HTML/OA.jsp?paProjectId='|| l_project_id||
834: '&akRegionCode=PA_PROG_RPT_MAINT_LAYOUT&akRegionApplicationId=275&paPageMode=APPROVE&addBreadCrumb=RP&paProgressMode=MAINTENANCE&paReportTypeId='
835: || l_Report_Type_Id;
836:
837: wf_engine.SetItemAttrText( p_item_type
838: , l_item_key
839: , 'REPORT_LINK'
840: , l_url2
841: );

Line 871: wf_engine.SetItemAttrDate( p_item_type

867:
868: END IF;
869:
870: -- set report start date
871: wf_engine.SetItemAttrDate( p_item_type
872: , l_item_key
873: , 'REPORT_START_DATE'
874: ,l_report_start_date
875: );

Line 878: wf_engine.SetItemAttrDate( p_item_type

874: ,l_report_start_date
875: );
876:
877: -- set report start date
878: wf_engine.SetItemAttrDate( p_item_type
879: , l_item_key
880: , 'REPORT_END_DATE'
881: ,l_report_end_date
882: );

Line 900: WF_ENGINE.AbortProcess( p_Item_Type

896: IF get_last_workflow_info%found THEN
897:
898: begin
899: -- abort this process if it is running
900: WF_ENGINE.AbortProcess( p_Item_Type
901: , l_last_Item_Key
902: );
903: EXCEPTION
904: WHEN OTHERS THEN

Line 947: WF_ENGINE.StartProcess(

943:
944:
945: --debug_msg_s1 ('after workflow 1: start process');
946:
947: WF_ENGINE.StartProcess(
948: p_Item_Type
949: , l_Item_Key
950: );
951: END IF;

Line 1091: wf_engine.SetItemAttrText( p_item_type

1087:
1088: -- get Project Name, Number info
1089: pa_utils.getprojinfo(l_project_id, l_project_number, l_project_name);
1090: -- set item attribute for Project Name, Number
1091: wf_engine.SetItemAttrText( p_item_type
1092: , p_item_key
1093: , 'PROJECT_NAME'
1094: ,l_project_name
1095: );

Line 1097: wf_engine.SetItemAttrText( p_item_type

1093: , 'PROJECT_NAME'
1094: ,l_project_name
1095: );
1096:
1097: wf_engine.SetItemAttrText( p_item_type
1098: , p_item_key
1099: , 'PROJECT_NUMBER'
1100: ,l_project_number
1101: );

Line 1104: wf_engine.SetItemAttrDate( p_item_type

1100: ,l_project_number
1101: );
1102:
1103: -- set item attribute for reminder days and next reporting date
1104: wf_engine.SetItemAttrDate( p_item_type
1105: , p_item_key
1106: , 'NEXT_REPORT_DATE'
1107: ,l_next_reporting_date
1108: );

Line 1110: wf_engine.SetItemAttrNumber( p_item_type

1106: , 'NEXT_REPORT_DATE'
1107: ,l_next_reporting_date
1108: );
1109:
1110: wf_engine.SetItemAttrNumber( p_item_type
1111: , p_item_key
1112: , 'REMINDER_DAYS'
1113: ,l_reminder_days
1114: );

Line 1191: wf_engine.SetItemAttrText( p_item_type

1187: WF_DIRECTORY.AddUsersToAdHocRole( l_reminder_role
1188: , l_role_users);
1189:
1190:
1191: wf_engine.SetItemAttrText( p_item_type
1192: , p_item_key
1193: , 'REPORT_REMINDER_NAME'
1194: , l_reminder_role);
1195: --debug_msg ('OK: approver is found ');

Line 1396: wf_engine.SetItemAttrText( p_item_type

1392:
1393: -- get Project Name, Number info
1394: pa_utils.getprojinfo(l_project_id, l_project_number, l_project_name);
1395: -- set item attribute for Project Name, Number
1396: wf_engine.SetItemAttrText( p_item_type
1397: , p_item_key
1398: , 'PROJECT_NAME'
1399: ,l_project_name
1400: );

Line 1402: wf_engine.SetItemAttrText( p_item_type

1398: , 'PROJECT_NAME'
1399: ,l_project_name
1400: );
1401:
1402: wf_engine.SetItemAttrText( p_item_type
1403: , p_item_key
1404: , 'PROJECT_NUMBER'
1405: ,l_project_number
1406: );

Line 1409: wf_engine.SetItemAttrDate( p_item_type

1405: ,l_project_number
1406: );
1407:
1408: -- set item attribute for reminder days and next reporting date
1409: wf_engine.SetItemAttrDate( p_item_type
1410: , p_item_key
1411: , 'NEXT_REPORT_DATE'
1412: ,l_next_reporting_date
1413: );

Line 1415: wf_engine.SetItemAttrNumber( p_item_type

1411: , 'NEXT_REPORT_DATE'
1412: ,l_next_reporting_date
1413: );
1414:
1415: wf_engine.SetItemAttrNumber( p_item_type
1416: , p_item_key
1417: , 'REMINDER_DAYS'
1418: ,l_reminder_days
1419: );

Line 1786: wf_engine.SetItemAttrText( p_item_type

1782: WF_DIRECTORY.AddUsersToAdHocRole( l_reminder_role
1783: , l_role_users);
1784:
1785:
1786: wf_engine.SetItemAttrText( p_item_type
1787: , p_item_key
1788: , 'REPORT_REMINDER_NAME'
1789: , l_reminder_role);
1790:

Line 1864: l_comment := wf_engine.GetItemAttrText

1860:
1861: --debug_msg_s1 ('call forward AAAAAAAAAAA' || funcmode);
1862:
1863: IF funcmode = 'RUN' then
1864: l_comment := wf_engine.GetItemAttrText
1865: ( itemtype => itemtype,
1866: itemkey => itemkey,
1867: aname => 'COMMENT');
1868:

Line 1873: l_forward_to := wf_engine.GetItemAttrText

1869: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment' || funcmode);
1870: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment' || actid);
1871:
1872:
1873: l_forward_to := wf_engine.GetItemAttrText
1874: ( itemtype => itemtype,
1875: itemkey => itemkey,
1876: aname => 'FORWARD_TO_USERNAME_RESPONSE'); -- Changed 'FORWARD_TO' to 'FORWARD_TO_USERNAME_RESPONSE' for bug 4165780
1877:

Line 1885: wf_engine.SetItemAttrText

1881: -- the forward to is invalid
1882: fnd_message.set_name ('PO', 'PO_WF_NOTIF_INVALID_FORWARD');
1883: l_error_msg := fnd_message.get;
1884:
1885: wf_engine.SetItemAttrText
1886: ( itemtype,
1887: itemkey,
1888: 'WRONG_FORWARD',
1889: l_error_msg);

Line 1911: wf_engine.SetItemAttrText( itemtype

1907: END IF;
1908:
1909: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment: forward to = ' || l_forward_to);
1910:
1911: wf_engine.SetItemAttrText( itemtype
1912: , itemkey
1913: , 'REPORT_APPROVER_NAME'
1914: , l_forward_to);
1915:

Line 1924: l_name := wf_engine.GetItemAttrText( itemtype

1920:
1921:
1922: /* Start of Addition for bug 5027098 */
1923:
1924: l_name := wf_engine.GetItemAttrText( itemtype
1925: , itemkey
1926: , 'REPORT_APPROVER_USER_NAME');
1927: wf_engine.SetItemAttrText ( itemtype,
1928: itemkey,

Line 1927: wf_engine.SetItemAttrText ( itemtype,

1923:
1924: l_name := wf_engine.GetItemAttrText( itemtype
1925: , itemkey
1926: , 'REPORT_APPROVER_USER_NAME');
1927: wf_engine.SetItemAttrText ( itemtype,
1928: itemkey,
1929: 'FROM_ROLE_VALUE',
1930: l_name);
1931: /* End of Addition for bug 5027098 */

Line 1933: l_name := wf_engine.GetItemAttrText( itemtype

1929: 'FROM_ROLE_VALUE',
1930: l_name);
1931: /* End of Addition for bug 5027098 */
1932:
1933: l_name := wf_engine.GetItemAttrText( itemtype
1934: , itemkey
1935: , 'REPORT_APPROVER_FULL_NAME');
1936:
1937:

Line 1938: wf_engine.SetItemAttrText( itemtype

1934: , itemkey
1935: , 'REPORT_APPROVER_FULL_NAME');
1936:
1937:
1938: wf_engine.SetItemAttrText( itemtype
1939: , itemkey
1940: , 'REPORT_APPROVER_USER_NAME'
1941: , l_forward_to);
1942:

Line 1944: wf_engine.SetItemAttrText( itemtype

1940: , 'REPORT_APPROVER_USER_NAME'
1941: , l_forward_to);
1942:
1943: /* Start of Addition for bug 4165780*/
1944: wf_engine.SetItemAttrText( itemtype
1945: , itemkey
1946: , 'REPORT_APPROVER_FULL_NAME'
1947: , l_forward_to_name);
1948: /* End of Addition for bug 4165780*/

Line 1959: wf_engine.SetItemAttrText

1955: ,'FORWARD'
1956: ,l_name
1957: ,l_comment);
1958:
1959: wf_engine.SetItemAttrText
1960: ( itemtype,
1961: itemkey ,
1962: 'COMMENT',
1963: ''

Line 1966: wf_engine.SetItemAttrText( itemtype

1962: 'COMMENT',
1963: ''
1964: );
1965:
1966: wf_engine.SetItemAttrText( itemtype
1967: , itemkey
1968: , 'RESULT'
1969: , '');
1970:

Line 1971: wf_engine.SetItemAttrText( itemtype

1967: , itemkey
1968: , 'RESULT'
1969: , '');
1970:
1971: wf_engine.SetItemAttrText( itemtype
1972: , itemkey
1973: , 'FORWARD_TO_USERNAME_RESPONSE' -- Changed 'FORWARD_TO' to 'FORWARD_TO_USERNAME_RESPONSE' for bug 4165780
1974: , '');
1975:

Line 1988: --resultout := wf_engine.eng_completed||':'||'T';

1984:
1985:
1986: resultout:='COMPLETE:'||'SUCCESS';
1987:
1988: --resultout := wf_engine.eng_completed||':'||'T';
1989:
1990:
1991: END;
1992:

Line 2032: resultout := wf_engine.eng_completed||':'||default_result;

2028: default_result := result_rec.result_code;
2029:
2030: END LOOP;
2031:
2032: resultout := wf_engine.eng_completed||':'||default_result;
2033: --resultout := wf_engine.eng_completed||':'||'T';
2034:
2035:
2036: END;

Line 2033: --resultout := wf_engine.eng_completed||':'||'T';

2029:
2030: END LOOP;
2031:
2032: resultout := wf_engine.eng_completed||':'||default_result;
2033: --resultout := wf_engine.eng_completed||':'||'T';
2034:
2035:
2036: END;
2037:

Line 2433: l_submitter_name := wf_engine.GetItemAttrText( l_item_type

2429: OPEN get_wf_info;
2430: FETCH get_wf_info INTO l_item_type, l_item_key;
2431: CLOSE get_wf_info;
2432:
2433: l_submitter_name := wf_engine.GetItemAttrText( l_item_type
2434: , l_item_key
2435: , 'SUBMITTER_FULL_NAME');
2436:
2437: document := document || 'Submitted By';