DBA Data[Home] [Help]

APPS.UMX_PASSWORD_PVT dependencies on WF_DIRECTORY

Line 43: -- First get the email from wf directory

39: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
40: 'p_user_name: ' || p_user_name);
41: end if;
42:
43: -- First get the email from wf directory
44: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
45: x_notification_preference, l_language, l_territory);
46:
47: if x_email_address is not null then

Line 44: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,

40: 'p_user_name: ' || p_user_name);
41: end if;
42:
43: -- First get the email from wf directory
44: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
45: x_notification_preference, l_language, l_territory);
46:
47: if x_email_address is not null then
48: x_role_name := p_user_name;

Line 438: WF_DIRECTORY.CreateAdHocRole (

434: -- No role with the user_name, create an ad hoc role.
435: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));
436: l_role_name := 'FNDPWD_' || itemkey || '_' || l_username;
437: l_display_name := getDisplayName(l_username);
438: WF_DIRECTORY.CreateAdHocRole (
439: role_name => l_role_name,
440: role_display_name => l_display_name,
441: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));
442: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 795: wf_directory.SetAdHocRoleExpiration (role_name => l_role_name,

791: if (l_role_name = 'FNDPWD_' || itemkey || '_' || upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'))) then
792:
793: -- Make Ad Hoc Role to expire.
794: -- The expiration_date is set to +30 based on the recommandation from WF.
795: wf_directory.SetAdHocRoleExpiration (role_name => l_role_name,
796: expiration_date => sysdate + 30);
797:
798: -- Set Ad Hoc Role to inactive
799: wf_directory.SetAdHocRoleStatus (role_name => l_role_name,

Line 799: wf_directory.SetAdHocRoleStatus (role_name => l_role_name,

795: wf_directory.SetAdHocRoleExpiration (role_name => l_role_name,
796: expiration_date => sysdate + 30);
797:
798: -- Set Ad Hoc Role to inactive
799: wf_directory.SetAdHocRoleStatus (role_name => l_role_name,
800: status => 'INACTIVE');
801: end if;
802: end if;
803: