APPS.MSC_WS_NOTIFICATION_BPEL dependencies on WF_ENGINE

Line 20: v_role_email := upper ( wf_engine.getitemattrtext( itemtype => itemtype, itemkey =>itemkey, aname => 'SEND_TO_EMAIL'));

16: ) is
17: v_role_email varchar2(100);
18: n_ctr NUMBER :=0;
19: begin
20: v_role_email := upper ( wf_engine.getitemattrtext( itemtype => itemtype, itemkey =>itemkey, aname => 'SEND_TO_EMAIL'));
21:
22: select count(*)
23: into n_ctr
24: from wf_local_roles

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

35: expiration_date => NULL);
36:
37: end if;
38:
39: wf_engine.setitemattrtext(itemtype => itemtype,
40: itemkey => itemkey,
41: aname => 'SEND_TO_ROLE',
42: avalue => v_role_email);
43:

Line 90: wf_engine.CreateProcess( l_itemtype, l_itemkey, wfProcessName);

86: select email_address into v_email from fnd_user where user_name = receiver;
87:
88: l_itemtype := wfName;
89:
90: wf_engine.CreateProcess( l_itemtype, l_itemkey, wfProcessName);
91:
92: -- Following to be changed to be NLS compliant
93: l_useritemkey := 'Planning Process';
94:

Line 95: wf_engine.setitemowner( l_itemtype, l_itemkey, receiver );

91:
92: -- Following to be changed to be NLS compliant
93: l_useritemkey := 'Planning Process';
94:
95: wf_engine.setitemowner( l_itemtype, l_itemkey, receiver );
96: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_ROLE', receiver);
97: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_EMAIL', v_email);
98:
99:

Line 96: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_ROLE', receiver);

92: -- Following to be changed to be NLS compliant
93: l_useritemkey := 'Planning Process';
94:
95: wf_engine.setitemowner( l_itemtype, l_itemkey, receiver );
96: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_ROLE', receiver);
97: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_EMAIL', v_email);
98:
99:
100: for i in 1 .. tokenValues.COUNT

Line 97: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_EMAIL', v_email);

93: l_useritemkey := 'Planning Process';
94:
95: wf_engine.setitemowner( l_itemtype, l_itemkey, receiver );
96: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_ROLE', receiver);
97: wf_engine.setitemattrtext(l_itemtype, l_itemkey, 'SEND_TO_EMAIL', v_email);
98:
99:
100: for i in 1 .. tokenValues.COUNT
101: loop

Line 103: wf_engine.setitemattrtext( l_itemtype, l_itemkey, tokenValues(i).token, tokenValues(i).value);

99:
100: for i in 1 .. tokenValues.COUNT
101: loop
102: --dbms_output.put_line('t-v: ' || tokenValues(i).token || ' and ' || tokenValues(i).value);
103: wf_engine.setitemattrtext( l_itemtype, l_itemkey, tokenValues(i).token, tokenValues(i).value);
104:
105: if (tokenValues(i).token = 'PROCESS')
106: then l_useritemkey := l_useritemkey || ' (' ||tokenValues(i).value|| ')';
107: end if;

Line 111: wf_engine.setitemuserkey(l_itemtype, l_itemkey, l_useritemkey);

107: end if;
108: end loop;
109:
110:
111: wf_engine.setitemuserkey(l_itemtype, l_itemkey, l_useritemkey);
112: wf_engine.startprocess(l_itemtype, l_itemkey);
113:
114: return 'SUCCESS';
115:

Line 112: wf_engine.startprocess(l_itemtype, l_itemkey);

108: end loop;
109:
110:
111: wf_engine.setitemuserkey(l_itemtype, l_itemkey, l_useritemkey);
112: wf_engine.startprocess(l_itemtype, l_itemkey);
113:
114: return 'SUCCESS';
115:
116: EXCEPTION

Line 136: actTypeId := wf_engine.getitemattrtext(itemtype, itemkey, 'ACTIVITY_TYPE_ID');

132: ) is
133: actTypeId varchar2(100);
134: actType varchar2(100);
135: begin
136: actTypeId := wf_engine.getitemattrtext(itemtype, itemkey, 'ACTIVITY_TYPE_ID');
137:
138: select meaning into actType
139: from mfg_lookups
140: where lookup_type = 'MSC_PROCESS_ACTIVITY_TYPES'

Line 143: wf_engine.setitemattrtext(itemtype, itemkey, 'ACTIVITY_TYPE', actType);

139: from mfg_lookups
140: where lookup_type = 'MSC_PROCESS_ACTIVITY_TYPES'
141: and lookup_code = to_number(actTypeId);
142:
143: wf_engine.setitemattrtext(itemtype, itemkey, 'ACTIVITY_TYPE', actType);
144:
145: result := 'complete:y';
146:
147: EXCEPTION

Line 169: planId := wf_engine.getitemattrtext(itemtype, itemkey, 'PLAN_ID');

165: ) is
166: planName varchar2(100);
167: planId varchar2(100);
168: begin
169: planId := wf_engine.getitemattrtext(itemtype, itemkey, 'PLAN_ID');
170:
171: select COMPILE_DESIGNATOR
172: into planName
173: from msc_plans

Line 176: wf_engine.setitemattrtext(itemtype, itemkey, 'PLAN_NAME', planName);

172: into planName
173: from msc_plans
174: where plan_id = to_number(planId);
175:
176: wf_engine.setitemattrtext(itemtype, itemkey, 'PLAN_NAME', planName);
177:
178: result := 'complete:y';
179:
180: EXCEPTION

Line 201: escId := wf_engine.getitemattrtext(itemtype, itemkey, 'ESCALATION_LEVEL_ID');

197: ) is
198: escId varchar2(100);
199: escLevel varchar2(100);
200: begin
201: escId := wf_engine.getitemattrtext(itemtype, itemkey, 'ESCALATION_LEVEL_ID');
202:
203: -- 1 => 'Primary Owner'
204: -- 2 => 'Alternate Owner'
205:

Line 211: wf_engine.setitemattrtext(itemtype, itemkey, 'ESCALATION_LEVEL', escLevel);

207: from mfg_lookups
208: where lookup_type = 'MSC_ESCALATION_LEVEL'
209: and lookup_code = to_number(escId);
210:
211: wf_engine.setitemattrtext(itemtype, itemkey, 'ESCALATION_LEVEL', escLevel);
212:
213: result := 'complete:y';
214:
215: EXCEPTION