DBA Data[Home] [Help]

APPS.EAM_ISOLATION_WORKFLOW_PVT dependencies on WF_ENGINE

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

62: END IF;
63:
64: l_item_key := p_event.getEventKey;
65:
66: wf_engine.CreateProcess( itemtype =>l_item_type,
67: itemkey => l_item_key,
68: process => l_wf_process );
69:
70:

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

74: l_param := l_param_list(l_param_idx);
75:
76: BEGIN
77:
78: wf_engine.SetItemAttrText( itemtype => l_item_type,
79: itemkey => l_item_key,
80: aname => l_param.name,
81: avalue => l_param.value);
82:

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

87:
88: l_param_idx := l_param_list.NEXT(l_param_idx);
89: end loop;
90:
91: wf_engine.StartProcess( itemtype => l_item_type,
92: itemkey => l_item_key);
93:
94:
95: x_return_status := 'SUCCESS';

Line 118: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

114: , funcmode in varchar2
115: , resultout out NOCOPY varchar2
116: )IS
117:
118: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'ISOLATION_ID');
120: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'ISOLATION_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 120: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,

116: )IS
117:
118: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'ISOLATION_ID');
120: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'ISOLATION_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

118: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'ISOLATION_ID');
120: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'ISOLATION_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
125: itemkey => itemkey, aname => 'NEW_USER_STATUS');
126: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 124: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

120: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'ISOLATION_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
125: itemkey => itemkey, aname => 'NEW_USER_STATUS');
126: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
127: itemkey => itemkey, aname => 'ORGANIZATION_ID');
128:

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

122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
125: itemkey => itemkey, aname => 'NEW_USER_STATUS');
126: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
127: itemkey => itemkey, aname => 'ORGANIZATION_ID');
128:
129: l_request_id number;
130: l_err_msg varchar2(2000);

Line 237: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

233: , funcmode in varchar2
234: , resultout out NOCOPY varchar2
235: )IS
236:
237: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
238: itemkey => itemkey, aname => 'ISOLATION_ID');
239: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
240: itemkey => itemkey, aname => 'ISOLATION_NAME');
241: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 239: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,

235: )IS
236:
237: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
238: itemkey => itemkey, aname => 'ISOLATION_ID');
239: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
240: itemkey => itemkey, aname => 'ISOLATION_NAME');
241: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
242: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
243: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

237: l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
238: itemkey => itemkey, aname => 'ISOLATION_ID');
239: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
240: itemkey => itemkey, aname => 'ISOLATION_NAME');
241: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
242: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
243: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
244: itemkey => itemkey, aname => 'NEW_USER_STATUS');
245: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 243: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

239: l_isolation_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
240: itemkey => itemkey, aname => 'ISOLATION_NAME');
241: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
242: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
243: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
244: itemkey => itemkey, aname => 'NEW_USER_STATUS');
245: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
246: itemkey => itemkey, aname => 'ORGANIZATION_ID');
247:

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

241: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
242: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
243: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
244: itemkey => itemkey, aname => 'NEW_USER_STATUS');
245: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
246: itemkey => itemkey, aname => 'ORGANIZATION_ID');
247:
248: l_request_id number;
249: l_err_msg varchar2(2000);

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

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

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

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

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

403: end if;
404:
405: if (l_next_approvers_count = 1) then
406: l_next_approver:=l_next_approvers(l_next_approvers.first());
407: wf_engine.SetItemAttrText( itemtype => itemType,
408: itemkey => itemkey,
409: aname => 'APPROVER_USER_NAME' ,
410: avalue => l_next_approver.name);
411:

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

408: itemkey => itemkey,
409: aname => 'APPROVER_USER_NAME' ,
410: avalue => l_next_approver.name);
411:
412: wf_engine.SetItemAttrText( itemtype => itemType,
413: itemkey => itemkey,
414: aname => 'APPROVER_DISPLAY_NAME' ,
415: avalue => l_next_approver.display_name);
416: resultout:='COMPLETE:'||'VALID_APPROVER';

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

443: ,owner_tag => null
444: );
445:
446:
447: wf_engine.setitemattrtext(itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'RECIPIENT_ROLE',
450: avalue => l_role_name
451: );

Line 490: l_gid := WF_ENGINE.context_nid;

486: BEGIN
487: IF (funcmode = 'RUN') THEN
488:
489: l_transaction_id := itemkey;
490: l_gid := WF_ENGINE.context_nid;
491:
492: SELECT responder,notification_id
493: into l_approver_name,l_nid
494: FROM wf_notifications

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

515:
516: ELSIF ( funcmode = 'TRANSFER' ) THEN
517:
518: l_transaction_id := itemkey;
519: l_forwardeeIn.name :=WF_ENGINE.context_new_role;
520: l_original_approver_name:= WF_ENGINE.context_original_recipient;
521:
522:
523: ame_api2.updateApprovalStatus2(applicationIdIn=>426,

Line 520: l_original_approver_name:= WF_ENGINE.context_original_recipient;

516: ELSIF ( funcmode = 'TRANSFER' ) THEN
517:
518: l_transaction_id := itemkey;
519: l_forwardeeIn.name :=WF_ENGINE.context_new_role;
520: l_original_approver_name:= WF_ENGINE.context_original_recipient;
521:
522:
523: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
524: transactionTypeIn=>'oracle.apps.eam.isolation.release.approval',

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

528: forwardeeIn => l_forwardeeIn );
529:
530: END IF; -- run
531:
532: resultout:= wf_engine.eng_completed || ':' || l_result;
533:
534: EXCEPTION
535: WHEN OTHERS THEN
536: RAISE;