DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_STUDENT dependencies on WF_ENGINE

Line 150: l_person_id_sep := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_USERS');

146: -- adhoc role
147: --
148: --
149:
150: l_person_id_sep := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_USERS');
151:
152: WHILE (LENGTH (l_person_id_sep) > 0)
153: LOOP
154: IF (INSTR (l_person_id_sep, ',') > 0) THEN

Line 196: Wf_Engine.SetItemAttrText( ItemType => itemtype,

192:
193: END LOOP;
194:
195: -- now set this role to the workflow
196: Wf_Engine.SetItemAttrText( ItemType => itemtype,
197: ItemKey => itemkey,
198: aname => 'IA_ADHOCROLE',
199: avalue => l_role_name
200: );

Line 223: Wf_Engine.createprocess( ItemType => lv_item_type,

219: 'AS007'||to_char(SYSDATE,'YYYYMMDDHH24MISS');
220:
221: BEGIN
222: -- Create the process
223: Wf_Engine.createprocess( ItemType => lv_item_type,
224: ItemKey => lv_item_key,
225: process => 'P_AS007'
226: );
227: -- set the attribuites

Line 228: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,

224: ItemKey => lv_item_key,
225: process => 'P_AS007'
226: );
227: -- set the attribuites
228: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,
229: ItemKey => lv_item_key,
230: aname => 'IA_USER',
231: avalue => p_user
232: );

Line 234: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,

230: aname => 'IA_USER',
231: avalue => p_user
232: );
233:
234: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,
235: ItemKey => lv_item_key,
236: aname => 'IA_STUD_ID',
237: avalue => p_stud_id
238: );

Line 240: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,

236: aname => 'IA_STUD_ID',
237: avalue => p_stud_id
238: );
239:
240: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,
241: ItemKey => lv_item_key,
242: aname => 'IA_STUD_NUMBER',
243: avalue => p_stud_number
244: );

Line 246: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,

242: aname => 'IA_STUD_NUMBER',
243: avalue => p_stud_number
244: );
245:
246: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,
247: ItemKey => lv_item_key,
248: aname => 'IA_STUD_NAME',
249: avalue => p_stud_name
250: );

Line 251: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,

247: ItemKey => lv_item_key,
248: aname => 'IA_STUD_NAME',
249: avalue => p_stud_name
250: );
251: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,
252: ItemKey => lv_item_key,
253: aname => 'IA_ORDER_NUMBER',
254: avalue => p_order_number
255: );

Line 257: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,

253: aname => 'IA_ORDER_NUMBER',
254: avalue => p_order_number
255: );
256:
257: Wf_Engine.SetItemAttrText( ItemType => lv_item_type,
258: ItemKey => lv_item_key,
259: aname => 'IA_ITEM_NUMBER',
260: avalue => p_item_number
261: );

Line 263: Wf_Engine.StartProcess ( ItemType => lv_item_type,

259: aname => 'IA_ITEM_NUMBER',
260: avalue => p_item_number
261: );
262:
263: Wf_Engine.StartProcess ( ItemType => lv_item_type,
264: ItemKey => lv_item_key
265: );
266:
267: -- Handle the exception using WF_CORE.Context

Line 492: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_INSTRUCTOR');

488: -- adhoc role
489: --
490: --
491:
492: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_INSTRUCTOR');
493:
494: OPEN c_user_name (l_person_id);
495: FETCH c_user_name INTO l_user_name;
496: CLOSE c_user_name;

Line 509: Wf_Engine.SetItemAttrText( ItemType => itemtype,

505: role_users => l_user_name);
506: END IF;
507:
508: -- now set this role to the workflow
509: Wf_Engine.SetItemAttrText( ItemType => itemtype,
510: ItemKey => itemkey,
511: aname => 'IA_USER_ROLE',
512: avalue => l_role_name
513: );