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 431: WF_DIRECTORY.CreateAdHocRole (

427: -- No role with the user_name, create an ad hoc role.
428: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));
429: l_role_name := 'FNDPWD_' || itemkey || '_' || l_username;
430: l_display_name := getDisplayName(l_username);
431: WF_DIRECTORY.CreateAdHocRole (
432: role_name => l_role_name,
433: role_display_name => l_display_name,
434: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));
435: wf_engine.SetItemAttrText (itemtype => itemtype,

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

767: if (l_role_name = 'FNDPWD_' || itemkey || '_' || upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'))) then
768:
769: -- Make Ad Hoc Role to expire.
770: -- The expiration_date is set to +30 based on the recommandation from WF.
771: wf_directory.SetAdHocRoleExpiration (role_name => l_role_name,
772: expiration_date => sysdate + 30);
773:
774: -- Set Ad Hoc Role to inactive
775: wf_directory.SetAdHocRoleStatus (role_name => l_role_name,

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

771: wf_directory.SetAdHocRoleExpiration (role_name => l_role_name,
772: expiration_date => sysdate + 30);
773:
774: -- Set Ad Hoc Role to inactive
775: wf_directory.SetAdHocRoleStatus (role_name => l_role_name,
776: status => 'INACTIVE');
777: end if;
778: end if;
779: