DBA Data[Home] [Help]

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 226: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

222: itemkey in varchar2,
223: actid in number,
224: funcmode in varchar2,
225: resultout out NOCOPY varchar2) is
226: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
227: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
228: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
229: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
230: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

224: funcmode in varchar2,
225: resultout out NOCOPY varchar2) is
226: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
227: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
228: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
229: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
230: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
231: itemkey => itemkey, aname => 'ORGANIZATION_ID');
232: l_request_id number;

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

226: l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
227: itemkey => itemkey, aname => 'WIP_ENTITY_ID');
228: l_wip_entity_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
229: itemkey => itemkey, aname => 'WIP_ENTITY_NAME');
230: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
231: itemkey => itemkey, aname => 'ORGANIZATION_ID');
232: l_request_id number;
233: l_err_msg varchar2(2000);
234: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

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

367:
368: l_transaction_id := TO_NUMBER(itemkey);
369: l_transaction_type := 'oracle.apps.eam.workorder.release.approval';
370:
371: wf_engine.SetItemAttrText( itemtype => itemtype,
372: itemkey => itemkey,
373: aname => 'AME_TRANSACTION_TYPE',
374: avalue => l_transaction_type);
375:

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

372: itemkey => itemkey,
373: aname => 'AME_TRANSACTION_TYPE',
374: avalue => l_transaction_type);
375:
376: wf_engine.SetItemAttrText( itemtype => itemtype,
377: itemkey => itemkey,
378: aname => 'AME_TRANSACTION_ID',
379: avalue => l_transaction_id );
380:

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

413: end if;
414:
415: if (l_next_approvers_count = 1) then
416: l_next_approver:=l_next_approvers(l_next_approvers.first());
417: wf_engine.SetItemAttrText( itemtype => itemType,
418: itemkey => itemkey,
419: aname => 'APPROVER_USER_NAME' ,
420: avalue => l_next_approver.name);
421:

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

418: itemkey => itemkey,
419: aname => 'APPROVER_USER_NAME' ,
420: avalue => l_next_approver.name);
421:
422: wf_engine.SetItemAttrText( itemtype => itemType,
423: itemkey => itemkey,
424: aname => 'APPROVER_DISPLAY_NAME' ,
425: avalue => l_next_approver.display_name);
426: resultout:='COMPLETE:'||'VALID_APPROVER';

Line 457: wf_engine.setitemattrtext(itemtype => itemtype,

453: ,owner_tag => null
454: );
455:
456:
457: wf_engine.setitemattrtext(itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'RECIPIENT_ROLE',
460: avalue => l_role_name
461: );

Line 493: l_gid := WF_ENGINE.context_nid;

489: BEGIN
490: IF (funcmode = 'RUN') THEN
491:
492: l_transaction_id := itemkey;
493: l_gid := WF_ENGINE.context_nid;
494: -- FP 14377930
495: SELECT responder,original_recipient,notification_id
496: into l_approver_name,l_original_approver_name,l_nid
497: FROM wf_notifications

Line 529: l_forwardeeIn.name :=WF_ENGINE.context_new_role;

525: ELSIF ( funcmode = 'TRANSFER' ) THEN
526:
527:
528: l_transaction_id := itemkey;
529: l_forwardeeIn.name :=WF_ENGINE.context_new_role;
530: l_original_approver_name:= WF_ENGINE.context_original_recipient;
531:
532:
533: ame_api2.updateApprovalStatus2(applicationIdIn=>426,

Line 530: l_original_approver_name:= WF_ENGINE.context_original_recipient;

526:
527:
528: l_transaction_id := itemkey;
529: l_forwardeeIn.name :=WF_ENGINE.context_new_role;
530: l_original_approver_name:= WF_ENGINE.context_original_recipient;
531:
532:
533: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
534: transactionTypeIn=>'oracle.apps.eam.workorder.release.approval',

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

540:
541:
542: END IF; -- run
543:
544: resultout:= wf_engine.eng_completed || ':' || l_result;
545:
546: EXCEPTION
547: WHEN OTHERS THEN
548: RAISE;