DBA Data[Home] [Help]

APPS.EDR_FWK_VERIFY dependencies on WF_ENGINE

Line 25: L_event_key := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

21: where ENTITY_NAME='EDR_FWK_TEST_B' and
22: pk1_value=l_event_key;
23: BEGIN
24: --Bug 4073809 : start
25: L_event_key := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
26: itemkey => p_itemkey,
27: aname => 'EVENT_KEY');
28: --Bug 4073809 : end
29:

Line 37: wf_engine.setitemattrtext(itemtype => p_itemtype,

33: -- Bug : 3499311 - End
34: select user_name into l_requester from fnd_user
35: where user_id=l_requester;
36:
37: wf_engine.setitemattrtext(itemtype => p_itemtype,
38: itemkey => p_itemkey,
39: aname => 'FWK_TEST_NO',
40: avalue => l_fwk_test_no);
41: wf_engine.setitemattrtext(itemtype => p_itemtype,

Line 41: wf_engine.setitemattrtext(itemtype => p_itemtype,

37: wf_engine.setitemattrtext(itemtype => p_itemtype,
38: itemkey => p_itemkey,
39: aname => 'FWK_TEST_NO',
40: avalue => l_fwk_test_no);
41: wf_engine.setitemattrtext(itemtype => p_itemtype,
42: itemkey => p_itemkey,
43: aname => 'REQUESTER',
44: avalue => l_requester);
45:

Line 53: wf_engine.setitemattrtext(itemtype => p_itemtype,

49: open c1;
50: fetch c1 into l_count;
51: close c1;
52: if l_count > 0 THEN
53: wf_engine.setitemattrtext(itemtype => p_itemtype,
54: itemkey => p_itemkey,
55: aname => 'ATTACHMENTS',
56: --Bug 4006844: Start
57: avalue => 'FND:entity=EDR_FWK_TEST_B'||'&'||'pk1name=FWK_TEST_ID'||'&'||'pk1value='||l_event_key||'&'||'categories=ERES');

Line 82: wf_engine.setitemattrtext(itemtype => p_itemtype,

78: p_resultout OUT NOCOPY VARCHAR2
79: ) IS
80: BEGIN
81: IF P_FUNCMODE = 'RESPOND' THEN
82: wf_engine.setitemattrtext(itemtype => p_itemtype,
83: itemkey => p_itemkey,
84: aname => 'NOTIFICATION_ID',
85: avalue => wf_engine.context_nid);
86:

Line 85: avalue => wf_engine.context_nid);

81: IF P_FUNCMODE = 'RESPOND' THEN
82: wf_engine.setitemattrtext(itemtype => p_itemtype,
83: itemkey => p_itemkey,
84: aname => 'NOTIFICATION_ID',
85: avalue => wf_engine.context_nid);
86:
87: END IF;
88: EXCEPTION
89: WHEN OTHERS THEN

Line 123: l_Event_name :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

119: l_msg_data varchar2(1000);
120: BEGIN
121:
122: --Bug 4073809 : start
123: l_Event_name :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
124: itemkey => p_itemkey,
125: aname => 'EVENT_NAME');
126: l_Event_key :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
127: itemkey => p_itemkey,

Line 126: l_Event_key :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

122: --Bug 4073809 : start
123: l_Event_name :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
124: itemkey => p_itemkey,
125: aname => 'EVENT_NAME');
126: l_Event_key :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
127: itemkey => p_itemkey,
128: aname => 'EVENT_KEY');
129: l_requester :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
130: itemkey => p_itemkey,

Line 129: l_requester :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

125: aname => 'EVENT_NAME');
126: l_Event_key :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
127: itemkey => p_itemkey,
128: aname => 'EVENT_KEY');
129: l_requester :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
130: itemkey => p_itemkey,
131: aname => 'REQUESTER');
132: l_nid :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
133: itemkey => p_itemkey,

Line 132: l_nid :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

128: aname => 'EVENT_KEY');
129: l_requester :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
130: itemkey => p_itemkey,
131: aname => 'REQUESTER');
132: l_nid :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
133: itemkey => p_itemkey,
134: aname => 'NOTIFICATION_ID');
135: l_fwk_test_no :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
136: itemkey => p_itemkey,

Line 135: l_fwk_test_no :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

131: aname => 'REQUESTER');
132: l_nid :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
133: itemkey => p_itemkey,
134: aname => 'NOTIFICATION_ID');
135: l_fwk_test_no :=wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
136: itemkey => p_itemkey,
137: aname => 'FWK_TEST_NO');
138:
139: --Bug 4073809 : end

Line 171: p_evidenceStore_id => wf_engine.getitemattrtext(p_itemtype, p_itemkey,'#WF_SIG_ID'),

167: p_user_name => l_requester,
168: p_original_recipient => l_requester,
169: p_overriding_comment => null,
170: x_signature_id => l_sig_id,
171: p_evidenceStore_id => wf_engine.getitemattrtext(p_itemtype, p_itemkey,'#WF_SIG_ID'),
172: p_user_response => wf_notification.getattrtext(l_nid,'RESULT'),
173: p_sig_parameters_tbl => l_sign_params );
174:
175: /* Close Document if SUCCESS*/

Line 234: l_Event_name := wf_engine.GETITEMATTRTEXT( itemtype => p_itemtype,

230: l_msg_data varchar2(1000);
231: l_ret_sig_id number;
232: BEGIN
233: begin
234: l_Event_name := wf_engine.GETITEMATTRTEXT( itemtype => p_itemtype,
235: itemkey => p_itemkey, aname => 'EVENT_NAME');
236: exception
237: when others then
238: l_event_name := p_event_name;

Line 241: l_Event_key := wf_engine.GETITEMATTRTEXT( itemtype => p_itemtype,

237: when others then
238: l_event_name := p_event_name;
239: end;
240: begin
241: l_Event_key := wf_engine.GETITEMATTRTEXT( itemtype => p_itemtype,
242: itemkey => p_itemkey, aname => 'EVENT_KEY');
243: exception
244: when others then
245: l_event_key := p_event_key;

Line 248: l_requester := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

244: when others then
245: l_event_key := p_event_key;
246: end;
247: begin
248: l_requester := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
249: itemkey => p_itemkey, aname => 'REQUESTER');
250: exception
251: when others then
252: l_requester := 'MFG';

Line 255: l_nid := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

251: when others then
252: l_requester := 'MFG';
253: end;
254: begin
255: l_nid := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
256: itemkey => p_itemkey, aname => 'NOTIFICATION_ID');
257: exception
258: when others then
259: l_nid := TO_CHAR(p_notif_id);

Line 312: p_evidenceStore_id => wf_engine.getitemattrtext(p_itemtype, p_itemkey,'#WF_SIG_ID'),

308: p_user_name => l_requester,
309: p_original_recipient => l_requester,
310: p_overriding_comment => null,
311: x_signature_id => l_ret_sig_id,
312: p_evidenceStore_id => wf_engine.getitemattrtext(p_itemtype, p_itemkey,'#WF_SIG_ID'),
313: p_user_response => wf_notification.getattrtext(l_nid,'RESULT'),
314: p_sig_parameters_tbl => l_sign_params );
315: x_resultout := l_result;
316: EXCEPTION