APPS.HR_SECURITY_INTERNAL dependencies on PER_ASSIGNMENT_LIST

Line 6133: FROM per_assignment_list pal

6129: --
6130: CURSOR csr_get_static_asg_for_user IS
6131: SELECT pal.assignment_id
6132: ,pal.person_id
6133: FROM per_assignment_list pal
6134: WHERE pal.security_profile_id IS NOT NULL
6135: AND pal.user_id IS NOT NULL
6136: AND pal.security_profile_id = p_security_profile_id
6137: AND pal.user_id = p_user_id;

Line 6149: FROM per_assignment_list pal

6145: --
6146: CURSOR csr_get_static_asg IS
6147: SELECT pal.assignment_id
6148: ,pal.person_id
6149: FROM per_assignment_list pal
6150: WHERE pal.security_profile_id IS NOT NULL
6151: AND pal.user_id IS NULL
6152: AND pal.security_profile_id = p_security_profile_id;
6153:

Line 6169: -- lists for AND they have rows in per_assignment_list.

6165: -- If this is user-based, look for a user and
6166: -- security profile pair. Generally speaking, the static
6167: -- user lists will only be cached when it is known that
6168: -- this user is in the list of users to build static
6169: -- lists for AND they have rows in per_assignment_list.
6170: --
6171: IF g_dbg THEN op(l_proc, 20); END IF;
6172:
6173: IF p_cache_by_user THEN

Line 6727: FROM per_assignment_list pal

6723: IF g_dbg THEN op(l_proc, 30); END IF;
6724:
6725: SELECT pal.assignment_id
6726: INTO l_assignment_id
6727: FROM per_assignment_list pal
6728: WHERE pal.user_id IS NOT NULL
6729: AND pal.security_profile_id IS NOT NULL
6730: AND pal.user_id = p_user_id
6731: AND pal.security_profile_id = p_security_profile_id

Line 6951: -- Delete all assignments in per_assignment_list for this user

6947:
6948: IF p_user_id IS NOT NULL AND p_security_profile_id IS NOT NULL THEN
6949:
6950: --
6951: -- Delete all assignments in per_assignment_list for this user
6952: -- and this security profile.
6953: --
6954: IF g_dbg THEN op(l_proc, 20); END IF;
6955:

Line 6956: DELETE FROM per_assignment_list pal

6952: -- and this security profile.
6953: --
6954: IF g_dbg THEN op(l_proc, 20); END IF;
6955:
6956: DELETE FROM per_assignment_list pal
6957: WHERE pal.user_id IS NOT NULL
6958: AND pal.security_profile_id IS NOT NULL
6959: AND pal.user_id = p_user_id
6960: AND pal.security_profile_id = p_security_profile_id;

Line 7308: INSERT INTO per_assignment_list

7304: -- delete_asg_list_for_user) prior to insertion.
7305: --
7306: IF g_dbg THEN op(l_proc||'('||to_char(i)||'):'); END IF;
7307:
7308: INSERT INTO per_assignment_list
7309: (security_profile_id
7310: ,assignment_id
7311: ,person_id
7312: ,user_id

Line 9088: DELETE FROM per_assignment_list pal

9084: -- Assignment List.
9085: --
9086: IF g_dbg THEN op(l_proc, 50); END IF;
9087:
9088: DELETE FROM per_assignment_list pal
9089: WHERE pal.user_id IS NOT NULL
9090: AND pal.security_profile_id IS NOT NULL
9091: AND pal.user_id = p_user_id
9092: AND pal.security_profile_id = p_security_profile_id;