eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_WF_PKG dependencies on WF_ENGINE

Line 403: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);

399:
400: BEGIN
401:
402: -- Create workflow process.
403: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);
404:
405: -- Set Attributes.
406: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
407: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);

Line 406: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);

402: -- Create workflow process.
403: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);
404:
405: -- Set Attributes.
406: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
407: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
408: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'COMMAND', p_command);
409: IF (p_command = 'PUB') THEN
410: l_pub := fnd_message.GET_STRING('CS','CS_KB_WF_PUB');

Line 407: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);

403: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);
404:
405: -- Set Attributes.
406: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
407: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
408: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'COMMAND', p_command);
409: IF (p_command = 'PUB') THEN
410: l_pub := fnd_message.GET_STRING('CS','CS_KB_WF_PUB');
411: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,

Line 408: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'COMMAND', p_command);

404:
405: -- Set Attributes.
406: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
407: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
408: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'COMMAND', p_command);
409: IF (p_command = 'PUB') THEN
410: l_pub := fnd_message.GET_STRING('CS','CS_KB_WF_PUB');
411: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,
412: 'COMMAND_DISPLAY', l_pub); -- 'Published');

Line 411: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,

407: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
408: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'COMMAND', p_command);
409: IF (p_command = 'PUB') THEN
410: l_pub := fnd_message.GET_STRING('CS','CS_KB_WF_PUB');
411: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,
412: 'COMMAND_DISPLAY', l_pub); -- 'Published');
413: ELSIF (p_command = 'OBS') THEN
414: l_obs := fnd_message.GET_STRING('CS','CS_KB_WF_OBS');
415: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,

Line 415: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,

411: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,
412: 'COMMAND_DISPLAY', l_pub); -- 'Published');
413: ELSIF (p_command = 'OBS') THEN
414: l_obs := fnd_message.GET_STRING('CS','CS_KB_WF_OBS');
415: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,
416: 'COMMAND_DISPLAY', l_obs); --'Obsoleted');
417: END IF;
418: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
419:

Line 418: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);

414: l_obs := fnd_message.GET_STRING('CS','CS_KB_WF_OBS');
415: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey,
416: 'COMMAND_DISPLAY', l_obs); --'Obsoleted');
417: END IF;
418: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
419:
420: IF (p_flow_details_id is not null) THEN
421: WF_ENGINE.SetItemAttrNumber(p_itemtype, p_itemkey, 'FLOW_DETAILS_ID', p_flow_details_id);
422: select step into x_step_code

Line 421: WF_ENGINE.SetItemAttrNumber(p_itemtype, p_itemkey, 'FLOW_DETAILS_ID', p_flow_details_id);

417: END IF;
418: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
419:
420: IF (p_flow_details_id is not null) THEN
421: WF_ENGINE.SetItemAttrNumber(p_itemtype, p_itemkey, 'FLOW_DETAILS_ID', p_flow_details_id);
422: select step into x_step_code
423: from cs_kb_wf_flow_details
424: where flow_details_id = p_flow_details_id;
425:

Line 432: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'FLOWSTEP', x_step_meaning);

428: FROM CS_LOOKUPS
429: WHERE lookup_code = x_step_code
430: AND lookup_type = 'CS_KB_STATUS';
431:
432: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'FLOWSTEP', x_step_meaning);
433:
434: END IF;
435:
436: IF (p_group_id is not null) THEN

Line 437: WF_ENGINE.SetItemAttrNumber(p_itemtype, p_itemkey, 'GROUPID', p_group_id);

433:
434: END IF;
435:
436: IF (p_group_id is not null) THEN
437: WF_ENGINE.SetItemAttrNumber(p_itemtype, p_itemkey, 'GROUPID', p_group_id);
438: END IF;
439:
440: IF (p_solution_title is not null) THEN
441: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);

Line 441: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);

437: WF_ENGINE.SetItemAttrNumber(p_itemtype, p_itemkey, 'GROUPID', p_group_id);
438: END IF;
439:
440: IF (p_solution_title is not null) THEN
441: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);
442: END IF;
443:
444: -- Start workflow process.
445: wf_engine.StartProcess(p_itemtype, p_itemkey);

Line 445: wf_engine.StartProcess(p_itemtype, p_itemkey);

441: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);
442: END IF;
443:
444: -- Start workflow process.
445: wf_engine.StartProcess(p_itemtype, p_itemkey);
446:
447: EXCEPTION
448: WHEN OTHERS THEN
449: RAISE;

Line 469: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);

465: p_itemkey VARCHAR(200) := to_char(p_set_id) || '-' || p_author; --7117561, 7047779
466:
467: BEGIN
468: -- Create workflow process.
469: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);
470:
471: -- Set Attributes.
472: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
473: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);

Line 472: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);

468: -- Create workflow process.
469: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);
470:
471: -- Set Attributes.
472: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
473: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
474: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
475: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'AUTHOR', p_author);
476:

Line 473: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);

469: WF_ENGINE.CreateProcess(p_itemtype, p_itemkey, wf_process);
470:
471: -- Set Attributes.
472: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
473: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
474: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
475: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'AUTHOR', p_author);
476:
477: -- Set the From field:

Line 474: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);

470:
471: -- Set Attributes.
472: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
473: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
474: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
475: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'AUTHOR', p_author);
476:
477: -- Set the From field:
478: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);

Line 475: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'AUTHOR', p_author);

471: -- Set Attributes.
472: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETNO', p_set_number);
473: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SETID', p_set_id);
474: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
475: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'AUTHOR', p_author);
476:
477: -- Set the From field:
478: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);
479:

Line 478: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);

474: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'LANGUAGE', FND_GLOBAL.CURRENT_LANGUAGE);
475: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'AUTHOR', p_author);
476:
477: -- Set the From field:
478: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);
479:
480: IF (p_solution_title is not null) THEN
481: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);
482: END IF;

Line 481: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);

477: -- Set the From field:
478: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);
479:
480: IF (p_solution_title is not null) THEN
481: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);
482: END IF;
483:
484: -- Start workflow process.
485: wf_engine.StartProcess(p_itemtype, p_itemkey);

Line 485: wf_engine.StartProcess(p_itemtype, p_itemkey);

481: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'SOLTITLE', p_solution_title);
482: END IF;
483:
484: -- Start workflow process.
485: wf_engine.StartProcess(p_itemtype, p_itemkey);
486:
487: EXCEPTION
488: WHEN OTHERS THEN
489: RAISE;

Line 1708: command VARCHAR2(30) := WF_ENGINE.GetItemAttrText(p_itemtype,p_itemkey,'COMMAND');

1704: p_funcmode IN VARCHAR2,
1705: p_result OUT NOCOPY VARCHAR2
1706: ) IS
1707:
1708: command VARCHAR2(30) := WF_ENGINE.GetItemAttrText(p_itemtype,p_itemkey,'COMMAND');
1709: set_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'SETID');
1710: l_group_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'GROUPID');
1711:
1712: adhoc_role VARCHAR2(320);

Line 1709: set_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'SETID');

1705: p_result OUT NOCOPY VARCHAR2
1706: ) IS
1707:
1708: command VARCHAR2(30) := WF_ENGINE.GetItemAttrText(p_itemtype,p_itemkey,'COMMAND');
1709: set_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'SETID');
1710: l_group_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'GROUPID');
1711:
1712: adhoc_role VARCHAR2(320);
1713: adhoc_role_name VARCHAR2(360);

Line 1710: l_group_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'GROUPID');

1706: ) IS
1707:
1708: command VARCHAR2(30) := WF_ENGINE.GetItemAttrText(p_itemtype,p_itemkey,'COMMAND');
1709: set_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'SETID');
1710: l_group_id NUMBER := WF_ENGINE.GetItemAttrNumber(p_itemtype,p_itemkey,'GROUPID');
1711:
1712: adhoc_role VARCHAR2(320);
1713: adhoc_role_name VARCHAR2(360);
1714:

Line 1742: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'PROCTYPENAME', getActionName(command));

1738:
1739: BEGIN
1740:
1741: -- Loading process type name
1742: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'PROCTYPENAME', getActionName(command));
1743:
1744: OPEN GET_GROUP_NAME (l_group_id);
1745: FETCH GET_GROUP_NAME INTO adhoc_role_name;
1746: CLOSE GET_GROUP_NAME;

Line 1758: WF_ENGINE.SetItemAttrText(p_itemtype,p_itemkey,'RECIPIENTGROUP',adhoc_role);

1754: END IF;
1755:
1756: WF_DIRECTORY.CREATEADHOCROLE(adhoc_role,adhoc_role_name,null,null,null,'MAILHTML',null,null,null,'ACTIVE',sysdate+365);
1757:
1758: WF_ENGINE.SetItemAttrText(p_itemtype,p_itemkey,'RECIPIENTGROUP',adhoc_role);
1759:
1760: FOR Users IN Get_Group_Members (l_group_id) LOOP
1761:
1762: IF ((inCategory(Users.user_id,set_id) = 1) OR

Line 1774: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);

1770:
1771: END LOOP;
1772:
1773: -- Set the From field:
1774: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'NOTFROM', FND_GLOBAL.User_Name);
1775:
1776: -- Send workflow down correct path according to command determined.
1777: IF (command = 'PUB') OR (command = 'OBS') THEN
1778: p_result := 'COMPLETE:PUB_OBS';

Line 1785: wf_engine.SetItemAttrNumber(p_itemtype,p_itemkey,'TRACKING','NO VALID COMMAND FOUND');

1781: END IF;
1782:
1783: EXCEPTION
1784: WHEN BAD_INFORMATION_SUPPLIED THEN
1785: wf_engine.SetItemAttrNumber(p_itemtype,p_itemkey,'TRACKING','NO VALID COMMAND FOUND');
1786: RAISE;
1787: WHEN OTHERS THEN
1788: wf_engine.SetItemAttrNumber(p_itemtype,p_itemkey,'TRACKING','Unspecified error in Start_wf_processing procedure');
1789: RAISE;

Line 1788: wf_engine.SetItemAttrNumber(p_itemtype,p_itemkey,'TRACKING','Unspecified error in Start_wf_processing procedure');

1784: WHEN BAD_INFORMATION_SUPPLIED THEN
1785: wf_engine.SetItemAttrNumber(p_itemtype,p_itemkey,'TRACKING','NO VALID COMMAND FOUND');
1786: RAISE;
1787: WHEN OTHERS THEN
1788: wf_engine.SetItemAttrNumber(p_itemtype,p_itemkey,'TRACKING','Unspecified error in Start_wf_processing procedure');
1789: RAISE;
1790: END Start_wf_processing;
1791:
1792: