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

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

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

116: )IS
117:
118: l_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'WORK_CLEARANCE_ID');
120: l_work_clearance_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'WORK_CLEARANCE_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_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
119: itemkey => itemkey, aname => 'WORK_CLEARANCE_ID');
120: l_work_clearance_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'WORK_CLEARANCE_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_work_clearance_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
121: itemkey => itemkey, aname => 'WORK_CLEARANCE_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 239: l_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

235: , funcmode in varchar2
236: , resultout out NOCOPY varchar2
237: )IS
238:
239: l_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
240: itemkey => itemkey, aname => 'WORK_CLEARANCE_ID');
241: l_work_clearance_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
242: itemkey => itemkey, aname => 'WORK_CLEARANCE_NAME');
243: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 241: l_work_clearance_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,

237: )IS
238:
239: l_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
240: itemkey => itemkey, aname => 'WORK_CLEARANCE_ID');
241: l_work_clearance_name varchar2(240):= wf_engine.GetItemAttrtext( itemtype => itemtype,
242: itemkey => itemkey, aname => 'WORK_CLEARANCE_NAME');
243: l_new_system_status number:= wf_engine.GetItemAttrNumber( itemtype => itemtype,
244: itemkey => itemkey, aname => 'NEW_SYSTEM_STATUS');
245: l_new_user_status number := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

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

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

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

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

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

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

362:
363: l_transaction_id := TO_NUMBER(itemkey);
364: l_transaction_type := 'oracle.apps.eam.clearance.release.approval';
365:
366: wf_engine.SetItemAttrText( itemtype => itemtype,
367: itemkey => itemkey,
368: aname => 'AME_TRANSACTION_TYPE',
369: avalue => l_transaction_type);
370:

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

367: itemkey => itemkey,
368: aname => 'AME_TRANSACTION_TYPE',
369: avalue => l_transaction_type);
370:
371: wf_engine.SetItemAttrText( itemtype => itemtype,
372: itemkey => itemkey,
373: aname => 'AME_TRANSACTION_ID',
374: avalue => l_transaction_id );
375:

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

407: end if;
408:
409: if (l_next_approvers_count = 1) then
410: l_next_approver:=l_next_approvers(l_next_approvers.first());
411: wf_engine.SetItemAttrText( itemtype => itemType,
412: itemkey => itemkey,
413: aname => 'APPROVER_USER_NAME' ,
414: avalue => l_next_approver.name);
415:

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

412: itemkey => itemkey,
413: aname => 'APPROVER_USER_NAME' ,
414: avalue => l_next_approver.name);
415:
416: wf_engine.SetItemAttrText( itemtype => itemType,
417: itemkey => itemkey,
418: aname => 'APPROVER_DISPLAY_NAME' ,
419: avalue => l_next_approver.display_name);
420: resultout:='COMPLETE:'||'VALID_APPROVER';

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

447: ,owner_tag => null
448: );
449:
450:
451: wf_engine.setitemattrtext(itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'RECIPIENT_ROLE',
454: avalue => l_role_name
455: );

Line 494: l_gid := WF_ENGINE.context_nid;

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

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

519:
520: ELSIF ( funcmode = 'TRANSFER' ) THEN
521:
522: l_transaction_id := itemkey;
523: l_forwardeeIn.name :=WF_ENGINE.context_new_role;
524: l_original_approver_name:= WF_ENGINE.context_original_recipient;
525:
526:
527: ame_api2.updateApprovalStatus2(applicationIdIn=>426,

Line 524: l_original_approver_name:= WF_ENGINE.context_original_recipient;

520: ELSIF ( funcmode = 'TRANSFER' ) THEN
521:
522: l_transaction_id := itemkey;
523: l_forwardeeIn.name :=WF_ENGINE.context_new_role;
524: l_original_approver_name:= WF_ENGINE.context_original_recipient;
525:
526:
527: ame_api2.updateApprovalStatus2(applicationIdIn=>426,
528: transactionTypeIn=>'oracle.apps.eam.clearance.release.approval',

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

532: forwardeeIn => l_forwardeeIn );
533:
534: END IF; -- run
535:
536: resultout:= wf_engine.eng_completed || ':' || l_result;
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: RAISE;