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 467: From FND_USER USR

463: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
464: --bug: 4650509 -- select person_party_id instead of customer_id
465: Cursor C_login_User(c_login_name VARCHAR2) IS
466: Select USR.person_party_id Name
467: From FND_USER USR
468: Where USR.EMPLOYEE_ID is null
469: and user_name = c_login_name;
470:
471: Cursor C_Name_form_ResourceId(c_resource_id number)IS

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

814: End If;
815: End If;
816:
817: -- bug 5221658, setting the notification preference and e-mail so the
818: -- the new fnd user created gets the notification by e-mail
819:
820: open c_get_role_details(l_adhoc_user);
821: fetch c_get_role_details into l_display_name, l_description ,
822: l_start, l_end,l_fax,

Line 1381: l_user_id := fnd_user_pkg.CreateUserId (

1377: x_return_status := FND_API.G_RET_STS_SUCCESS;
1378:
1379: --//////////////////////////////////////////////////////////////////////////
1380: -- create user id with supplied password
1381: l_user_id := fnd_user_pkg.CreateUserId (
1382: x_user_name => p_user_name,
1383: x_owner => null,
1384: x_unencrypted_password => p_user_password,
1385: x_email_address => p_email_address, /* Add for Bug 7334453 */

Line 1389: /* UPDATE FND_USER

1385: x_email_address => p_email_address, /* Add for Bug 7334453 */
1386: x_customer_id => p_party_id );
1387:
1388: --update cutomer id
1389: /* UPDATE FND_USER
1390: SET CUSTOMER_ID = p_party_id
1391: WHERE USER_NAME = p_user_name;
1392: */
1393: -- assign roles

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

1604:
1605: x_return_status := Fnd_Api.g_ret_sts_success;
1606:
1607: IF l_debug = 'Y' THEN
1608: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1609: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1610: END IF;
1611:
1612: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);

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

1608: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1609: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);
1610: END IF;
1611:
1612: x_test_user_status := Fnd_User_Pkg.TestUserName(p_user_name);
1613:
1614: x_msg_data := fnd_message.get;
1615:
1616: IF l_debug = 'Y' THEN