APPS.EAM_WORKORDER_WORKFLOW_PVT dependencies on WF_ENGINE

Line 51: wf_engine.CreateProcess( itemtype =>l_item_type,

47: END IF;
48:
49: l_item_key := p_event.getEventKey;
50:
51: wf_engine.CreateProcess( itemtype =>l_item_type,
52: itemkey => l_item_key,
53: process => l_wf_process );
54:
55:

Line 63: wf_engine.SetItemAttrText( itemtype => l_item_type,

59: l_param := l_param_list(l_param_idx);
60:
61: BEGIN
62:
63: wf_engine.SetItemAttrText( itemtype => l_item_type,
64: itemkey => l_item_key,
65: aname => l_param.name,
66: avalue => l_param.value);
67:

Line 76: wf_engine.StartProcess( itemtype => l_item_type,

72:
73: l_param_idx := l_param_list.NEXT(l_param_idx);
74: end loop;
75:
76: wf_engine.StartProcess( itemtype => l_item_type,
77: itemkey => l_item_key);
78:
79:
80: x_return_status := 'SUCCESS';

Line 94: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

90: itemkey in varchar2,
91: actid in number,
92: funcmode in varchar2,
93: resultout out NOCOPY varchar2) is
94: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
95: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
96: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
97: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
98: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 96: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,

92: funcmode in varchar2,
93: resultout out NOCOPY varchar2) is
94: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
95: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
96: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
97: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
98: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
99: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
100: l_new_wo_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 98: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

94: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
95: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
96: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
97: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
98: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
99: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
100: l_new_wo_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
101: itemkey => itemkey, aname => 'NEW_WO_STATUS');
102: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 100: l_new_wo_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

96: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
97: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
98: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
99: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
100: l_new_wo_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
101: itemkey => itemkey, aname => 'NEW_WO_STATUS');
102: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
103: itemkey => itemkey, aname => 'ORGANIZATION_ID');
104: l_request_id number;

Line 102: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

98: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
99: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
100: l_new_wo_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
101: itemkey => itemkey, aname => 'NEW_WO_STATUS');
102: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
103: itemkey => itemkey, aname => 'ORGANIZATION_ID');
104: l_request_id number;
105: l_err_msg varchar2(2000);
106: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 221: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

217: itemkey in varchar2,
218: actid in number,
219: funcmode in varchar2,
220: resultout out NOCOPY varchar2) is
221: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
222: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
223: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
224: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
225: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 223: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,

219: funcmode in varchar2,
220: resultout out NOCOPY varchar2) is
221: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
222: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
223: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
224: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
225: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
226: itemkey => itemkey, aname => 'ORGANIZATION_ID');
227: l_request_id number;

Line 225: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

221: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
222: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
223: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
224: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
225: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
226: itemkey => itemkey, aname => 'ORGANIZATION_ID');
227: l_request_id number;
228: l_err_msg varchar2(2000);
229: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 360: wf_engine.SetItemAttrText( itemtype => itemtype,

356:
357: l_transaction_id := TO_NUMBER(itemkey);
358: l_transaction_type := 'oracle.apps.eam.workorder.release.approval';
359:
360: wf_engine.SetItemAttrText( itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'AME_TRANSACTION_TYPE',
363: avalue => l_transaction_type);
364:

Line 365: wf_engine.SetItemAttrText( itemtype => itemtype,

361: itemkey => itemkey,
362: aname => 'AME_TRANSACTION_TYPE',
363: avalue => l_transaction_type);
364:
365: wf_engine.SetItemAttrText( itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'AME_TRANSACTION_ID',
368: avalue => l_transaction_id );
369:

Line 399: wf_engine.SetItemAttrText( itemtype => itemType,

395: (l_next_approver.orig_system_id is null)) THEN
396: resultout:='COMPLETE:'||'NO_NEXT_APPROVER';
397: return;
398: ELSE
399: wf_engine.SetItemAttrText( itemtype => itemType,
400: itemkey => itemkey,
401: aname => 'APPROVER_USER_NAME' ,
402: avalue => l_next_approver.name);
403:

Line 404: wf_engine.SetItemAttrText( itemtype => itemType,

400: itemkey => itemkey,
401: aname => 'APPROVER_USER_NAME' ,
402: avalue => l_next_approver.name);
403:
404: wf_engine.SetItemAttrText( itemtype => itemType,
405: itemkey => itemkey,
406: aname => 'APPROVER_DISPLAY_NAME' ,
407: avalue => l_next_approver.display_name);
408: if (l_next_approvers_count = 1) then

Line 447: l_nid := WF_ENGINE.context_nid;

443: BEGIN
444: IF (funcmode = 'RUN') THEN
445:
446: l_transaction_id := itemkey;
447: l_nid := WF_ENGINE.context_nid;
448: l_approver_name := WF_NOTIFICATION.GetAttrText(nid => l_nid,
449: aname => 'APPROVER_USER_NAME');
450:
451: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');

Line 470: resultout:= wf_engine.eng_completed || ':' || l_result;

466: approverNameIn => l_approver_name);
467:
468: END IF; -- run
469:
470: resultout:= wf_engine.eng_completed || ':' || l_result;
471:
472: EXCEPTION
473: WHEN OTHERS THEN
474: RAISE;