APPS.AME_UPDATE_USERNAME_PKG dependencies on WF_ENGINE

Line 47: l_event_key := wf_engine.GetItemAttrText

43: if funcmode = 'RUN' then
44:
45: log_message ('AME User Name Migration Process started at ' || to_char(sysdate,'YYYY:MM:DD:HH24:MI:SS'));
46:
47: l_event_key := wf_engine.GetItemAttrText
48: (itemtype => itemtype
49: ,itemkey => itemkey
50: ,aname => 'AMEUPDUN_EVENT_KEY'
51: );

Line 54: l_event := wf_engine.GetItemAttrEvent

50: ,aname => 'AMEUPDUN_EVENT_KEY'
51: );
52: log_message ('Event Key Recieved is ' || l_event_key);
53:
54: l_event := wf_engine.GetItemAttrEvent
55: (itemtype => itemtype
56: ,itemkey => itemkey
57: ,name => 'AMEUPDUN_EVENT_MSG'
58: );

Line 304: wf_engine.SetItemAttrText

300: where sysdate between start_date and nvl(end_date - (1/86400),sysdate)
301: and variable_name = 'adminApprover'
302: and (application_id is null or application_id = 0)
303: and rownum < 2;
304: wf_engine.SetItemAttrText
305: (itemtype => itemtype
306: ,itemkey => itemkey
307: ,aname => 'AMEUPDUN_ADMIN_APPROVER'
308: ,avalue => admin_approver);

Line 312: wf_engine.SetItemAttrText

308: ,avalue => admin_approver);
309: exception
310: when others then
311: admin_approver := 'SYSADMIN';
312: wf_engine.SetItemAttrText
313: (itemtype => itemtype
314: ,itemkey => itemkey
315: ,aname => 'AMEUPDUN_ADMIN_APPROVER'
316: ,avalue => admin_approver);

Line 320: resultout := wf_engine.eng_completed || ':' || wf_yes;

316: ,avalue => admin_approver);
317: end;
318:
319: if l_success then
320: resultout := wf_engine.eng_completed || ':' || wf_yes;
321: else
322: resultout := wf_engine.eng_completed || ':' || wf_no;
323: end if;
324:

Line 322: resultout := wf_engine.eng_completed || ':' || wf_no;

318:
319: if l_success then
320: resultout := wf_engine.eng_completed || ':' || wf_yes;
321: else
322: resultout := wf_engine.eng_completed || ':' || wf_no;
323: end if;
324:
325: return;
326:

Line 338: wf_engine.SetItemAttrText

334: where sysdate between start_date and nvl(end_date - (1/86400),sysdate)
335: and variable_name = 'adminApprover'
336: and (application_id is null or application_id = 0)
337: and rownum < 2;
338: wf_engine.SetItemAttrText
339: (itemtype => itemtype
340: ,itemkey => itemkey
341: ,aname => 'AMEUPDUN_ADMIN_APPROVER'
342: ,avalue => admin_approver);

Line 346: wf_engine.SetItemAttrText

342: ,avalue => admin_approver);
343: exception
344: when others then
345: admin_approver := 'SYSADMIN';
346: wf_engine.SetItemAttrText
347: (itemtype => itemtype
348: ,itemkey => itemkey
349: ,aname => 'AMEUPDUN_ADMIN_APPROVER'
350: ,avalue => admin_approver);

Line 354: resultout := wf_engine.eng_completed || ':' || wf_no;

350: ,avalue => admin_approver);
351: end;
352: log_message('Migration Failed Completely');
353: log_message(sqlerrm,sqlcode);
354: resultout := wf_engine.eng_completed || ':' || wf_no;
355: return;
356: end update_username;
357:
358: end ame_update_username_pkg;