APPS.ARI_SELF_SERVICE_PKG dependencies on FND_USER

Line 31: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(

27: l_resp_exists boolean;
28: l_count NUMBER;
29: begin
30:
31: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(
32: user_id => p_user_id,
33: responsibility_id => p_responsibility_id,
34: responsibility_application_id => p_resp_appl_id,
35: security_group_id => p_security_group_id);

Line 37: select count(*) into l_count from fnd_user_resp_groups where user_id=p_user_id and responsibility_id=p_responsibility_id;

33: responsibility_id => p_responsibility_id,
34: responsibility_application_id => p_resp_appl_id,
35: security_group_id => p_security_group_id);
36: if l_resp_exists then
37: select count(*) into l_count from fnd_user_resp_groups where user_id=p_user_id and responsibility_id=p_responsibility_id;
38: if l_count <= 0 then
39: return 'N';
40: else
41: return 'Y';

Line 61: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(

57: IS
58: l_resp_exists boolean;
59: BEGIN
60:
61: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(
62: user_id => p_user_id,
63: responsibility_id => p_responsibility_id,
64: responsibility_application_id => p_resp_appl_id,
65: security_group_id => p_security_group_id);

Line 69: fnd_user_resp_groups_api.Insert_Assignment

65: security_group_id => p_security_group_id);
66:
67: if NOT l_resp_exists then
68: -- add the appropriate responsibility
69: fnd_user_resp_groups_api.Insert_Assignment
70: (user_id => p_user_id
71: ,responsibility_id => p_responsibility_id
72: ,responsibility_application_id => p_resp_appl_id
73: ,security_group_id => p_security_group_id

Line 80: fnd_user_resp_groups_api.Update_Assignment

76: ,description => ' ' -- ### description was supposed to default
77: -- to null... but does not look like it has
78: );
79: else
80: fnd_user_resp_groups_api.Update_Assignment
81: (user_id => p_user_id
82: ,responsibility_id => p_responsibility_id
83: ,responsibility_application_id => p_resp_appl_id
84: ,security_group_id => p_security_group_id

Line 119: from fnd_user

115: if l_result = 'N' and p_disable = 'Y' then
116: begin
117: hr_utility.set_location('calling disable user',30);
118: select user_id into userID
119: from fnd_user
120: where user_name = user AND
121: user_id <> 6 and
122: (start_date <= sysdate) AND
123: (end_date is null or end_date > sysdate);