APPS.ASO_PUBLISH_MISC_INT dependencies on FND_USER

Line 100: From FND_USER USR

96:
97: -- bug: 4650509 -- select person_party_id instead of customer_id
98: Cursor C_login_User(c_login_name VARCHAR2) IS
99: Select USR.person_party_id Name
100: From FND_USER USR
101: Where USR.EMPLOYEE_ID is null
102: and user_name = c_login_name;
103:
104: Cursor C_Name_form_ResourceId(c_resource_id number)IS

Line 229: -- the new fnd user created gets the notification by e-mail

225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
226: end if;
227:
228: -- bug 5221658, setting the notification preference and e-mail so the
229: -- the new fnd user created gets the notification by e-mail
230:
231: open c_get_role_details(l_adhoc_user);
232: fetch c_get_role_details into l_display_name, l_description ,
233: l_start, l_end,l_fax,

Line 484: From FND_USER USR

480: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
481: --bug: 4650509 -- select person_party_id instead of customer_id
482: Cursor C_login_User(c_login_name VARCHAR2) IS
483: Select USR.person_party_id Name
484: From FND_USER USR
485: Where USR.EMPLOYEE_ID is null
486: and user_name = c_login_name;
487:
488: Cursor C_Name_form_ResourceId(c_resource_id number)IS

Line 835: -- the new fnd user created gets the notification by e-mail

831: End If;
832: End If;
833:
834: -- bug 5221658, setting the notification preference and e-mail so the
835: -- the new fnd user created gets the notification by e-mail
836:
837: open c_get_role_details(l_adhoc_user);
838: fetch c_get_role_details into l_display_name, l_description ,
839: l_start, l_end,l_fax,

Line 1412: l_user_id := fnd_user_pkg.CreateUserId (

1408: x_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: --//////////////////////////////////////////////////////////////////////////
1411: -- create user id with supplied password
1412: l_user_id := fnd_user_pkg.CreateUserId (
1413: x_user_name => p_user_name,
1414: x_owner => null,
1415: x_unencrypted_password => p_user_password,
1416: x_email_address => p_email_address, /* Add for Bug 7334453 */

Line 1420: /* UPDATE FND_USER

1416: x_email_address => p_email_address, /* Add for Bug 7334453 */
1417: x_customer_id => p_party_id );
1418:
1419: --update cutomer id
1420: /* UPDATE FND_USER
1421: SET CUSTOMER_ID = p_party_id
1422: WHERE USER_NAME = p_user_name;
1423: */
1424: -- assign roles

Line 1639: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');

1635:
1636: x_return_status := Fnd_Api.g_ret_sts_success;
1637:
1638: IF l_debug = 'Y' THEN
1639: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1640: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1641: END IF;
1642:
1643: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);

Line 1643: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);

1639: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1640: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1641: END IF;
1642:
1643: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);
1644:
1645: x_msg_data := fnd_message.get;
1646:
1647: IF l_debug = 'Y' THEN