DBA Data[Home] [Help]

APPS.POS_ANON_PKG dependencies on FND_USER

Line 171: l_user_name FND_USER.USER_NAME%TYPE;

167: l_resp_id NUMBER;
168: l_start_date DATE;
169: l_end_date DATE;
170: l_found_in_view BOOLEAN;
171: l_user_name FND_USER.USER_NAME%TYPE;
172: lv_proc_name VARCHAR2(30) := 'confirm_has_resp';
173:
174: CURSOR l_user_cur
175: IS

Line 177: FROM FND_USER

173:
174: CURSOR l_user_cur
175: IS
176: SELECT user_name
177: FROM FND_USER
178: WHERE user_id = 6
179: AND start_date < sysdate
180: AND (end_date IS NULL OR end_date > sysdate);
181:

Line 193: FROM FND_USER_RESP_GROUPS_DIRECT

189:
190: CURSOR l_assignment_cur
191: IS
192: SELECT end_date, start_date
193: FROM FND_USER_RESP_GROUPS_DIRECT
194: WHERE user_id = 6
195: AND responsibility_id = l_resp_id;
196:
197: BEGIN

Line 227: fnd_user_resp_groups_api.assignment_exists

223: END IF;
224: CLOSE l_resp_cur;
225:
226: l_assignment_exists :=
227: fnd_user_resp_groups_api.assignment_exists
228: (user_id => 6,
229: responsibility_id => l_resp_id,
230: responsibility_application_id => l_app_id,
231: security_group_id => 0

Line 235: FND_USER_RESP_GROUPS_API.insert_assignment

231: security_group_id => 0
232: );
233:
234: IF l_assignment_exists = FALSE THEN
235: FND_USER_RESP_GROUPS_API.insert_assignment
236: ( user_id => 6,
237: responsibility_id => l_resp_id,
238: responsibility_application_id => l_app_id,
239: security_group_id => 0,

Line 261: fnd_user_resp_groups_api.update_assignment

257: END IF;
258:
259: -- assignment exists here but it is not active now
260: -- due to start date or end_date
261: fnd_user_resp_groups_api.update_assignment
262: ( user_id => 6,
263: responsibility_id => l_resp_id,
264: responsibility_application_id => l_app_id,
265: security_group_id => 0,