DBA Data[Home] [Help]

APPS.EAM_WORKPERMIT_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_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

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

116: )IS
117:
118: l_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'PERMIT_ID');
120: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'PERMIT_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

118: l_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'PERMIT_ID');
120: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'PERMIT_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
125: itemkey => itemkey, aname => 'NEW_PERMIT_STATUS');
126: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

120: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'PERMIT_NAME');
122: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
123: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
124: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
125: itemkey => itemkey, aname => 'NEW_PERMIT_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_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
125: itemkey => itemkey, aname => 'NEW_PERMIT_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 236: l_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

232: , funcmode in varchar2
233: , resultout out NOCOPY varchar2
234: )IS
235:
236: l_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
237: itemkey => itemkey, aname => 'PERMIT_ID');
238: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
239: itemkey => itemkey, aname => 'PERMIT_NAME');
240: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 238: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,

234: )IS
235:
236: l_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
237: itemkey => itemkey, aname => 'PERMIT_ID');
238: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
239: itemkey => itemkey, aname => 'PERMIT_NAME');
240: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
241: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
242: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

236: l_permit_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
237: itemkey => itemkey, aname => 'PERMIT_ID');
238: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
239: itemkey => itemkey, aname => 'PERMIT_NAME');
240: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
241: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
242: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
243: itemkey => itemkey, aname => 'NEW_PERMIT_STATUS');
244: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 242: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

238: l_permit_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
239: itemkey => itemkey, aname => 'PERMIT_NAME');
240: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
241: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
242: l_new_permit_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
243: itemkey => itemkey, aname => 'NEW_PERMIT_STATUS');
244: l_organization_id number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
245: itemkey => itemkey, aname => 'ORGANIZATION_ID');
246:

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

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

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

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

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

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

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

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

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

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

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

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

Line 487: l_gid := WF_ENGINE.context_nid;

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

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

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

Line 517: l_original_approver_name:= WF_ENGINE.context_original_recipient;

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

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

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