APPS.POR_LOAD_FND_USER dependencies on FND_USER

Line 1: PACKAGE BODY POR_LOAD_FND_USER as

1: PACKAGE BODY POR_LOAD_FND_USER as
2: /* $Header: PORFNDUB.pls 115.5 2004/07/02 23:27:57 rwidjaja ship $ */
3:
4: PROCEDURE insert_update_user_info (
5: x_employee_number IN VARCHAR2,

Line 25: IF (NOT get_fnd_user_exists(x_user_name)) THEN

21:
22: l_employee_id := get_employee_exists(x_employee_number);
23:
24:
25: IF (NOT get_fnd_user_exists(x_user_name)) THEN
26:
27: FND_User_PVT.Create_User(
28: p_api_version_number => l_api_version_number
29: ,p_return_status => l_return_status

Line 27: FND_User_PVT.Create_User(

23:
24:
25: IF (NOT get_fnd_user_exists(x_user_name)) THEN
26:
27: FND_User_PVT.Create_User(
28: p_api_version_number => l_api_version_number
29: ,p_return_status => l_return_status
30: ,p_msg_count => l_msg_count
31: ,p_msg_data => l_msg_data

Line 52: FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT (

48: IF l_user_id > 0 and
49: l_ssp_resp_id > 0 THEN
50:
51:
52: FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT (
53: USER_ID => l_user_id,
54: RESPONSIBILITY_ID => l_ssp_resp_id,
55: RESPONSIBILITY_APPLICATION_ID => 178,
56: START_DATE => sysdate,

Line 66: FND_User_PVT.Update_user(

62:
63: ELSE
64:
65:
66: FND_User_PVT.Update_user(
67: p_api_version_number => l_api_version_number
68: ,p_return_status => l_return_status
69: ,p_msg_count => l_msg_count
70: ,p_msg_data => l_msg_data

Line 109: FUNCTION get_fnd_user_exists(p_user_name IN VARCHAR2) RETURN BOOLEAN IS

105: RETURN;
106:
107: END get_default_resp_id;
108:
109: FUNCTION get_fnd_user_exists(p_user_name IN VARCHAR2) RETURN BOOLEAN IS
110: l_fnd_user_exists NUMBER;
111: BEGIN
112:
113: SELECT 1 INTO l_fnd_user_exists FROM fnd_user

Line 110: l_fnd_user_exists NUMBER;

106:
107: END get_default_resp_id;
108:
109: FUNCTION get_fnd_user_exists(p_user_name IN VARCHAR2) RETURN BOOLEAN IS
110: l_fnd_user_exists NUMBER;
111: BEGIN
112:
113: SELECT 1 INTO l_fnd_user_exists FROM fnd_user
114: WHERE user_name = upper(p_user_name);

Line 113: SELECT 1 INTO l_fnd_user_exists FROM fnd_user

109: FUNCTION get_fnd_user_exists(p_user_name IN VARCHAR2) RETURN BOOLEAN IS
110: l_fnd_user_exists NUMBER;
111: BEGIN
112:
113: SELECT 1 INTO l_fnd_user_exists FROM fnd_user
114: WHERE user_name = upper(p_user_name);
115:
116: RETURN true;
117:

Line 123: END get_fnd_user_exists;

119: WHEN NO_DATA_FOUND THEN
120:
121: RETURN false;
122:
123: END get_fnd_user_exists;
124:
125: FUNCTION get_employee_exists (p_employee_number IN VARCHAR2) RETURN NUMBER IS
126: l_person_id NUMBER;
127:

Line 147: UPDATE fnd_user

143: IS
144: BEGIN
145:
146:
147: UPDATE fnd_user
148: SET employee_id = p_employee_id
149: WHERE user_id = p_user_id;
150:
151: EXCEPTION

Line 157: END POR_LOAD_FND_USER;

153: RETURN;
154:
155: END update_employee_id;
156:
157: END POR_LOAD_FND_USER;