eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SECURITY_INTERNAL dependencies on DUAL

Line 3387: -- so instead it would be necessary to fetch into individual

3383: -- Fetch the assignments. Bulk collect would not perform better
3384: -- considering the number of assignments a person will typically
3385: -- have: few. As Oracle 8i is still supported at the time of
3386: -- writing, it is not possible to bulk collect into a collection
3387: -- so instead it would be necessary to fetch into individual
3388: -- collections of scalars if bulk collect was to be used.
3389: --
3390: IF g_dbg THEN op(l_proc, 50); END IF;
3391: j := 1;

Line 4620: -- When restrict_on_individual_asg flag on security profile is set

4616: -- This does not return ex-people (ex-employees, etc) and
4617: -- it does not return contacts.
4618: --
4619: -- Bug 3686545
4620: -- When restrict_on_individual_asg flag on security profile is set
4621: -- then custom security should be evaluated as user based because
4622: -- listgen currently does not maintain static assignment list.
4623: --
4624: l_select_from_clause :=

Line 4790: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR

4786: --
4787: -- Restrict by custom (static).
4788: --
4789: IF g_dbg THEN op(l_proc, 85); END IF;
4790: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
4791: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
4792: l_custom_per = 'Y') THEN
4793: l_temp_clause := and_clause(l_temp_clause,
4794: 'EXISTS

Line 4791: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND

4787: -- Restrict by custom (static).
4788: --
4789: IF g_dbg THEN op(l_proc, 85); END IF;
4790: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
4791: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
4792: l_custom_per = 'Y') THEN
4793: l_temp_clause := and_clause(l_temp_clause,
4794: 'EXISTS
4795: (SELECT null

Line 4805: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND

4801: --
4802: -- Restrict by custom (user-based).
4803: --
4804: IF g_dbg THEN op(l_proc, 90); END IF;
4805: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
4806: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
4807: l_custom_per = 'U') AND
4808: p_sec_prof_rec.restriction_text IS NOT NULL THEN
4809: --

Line 4806: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR

4802: -- Restrict by custom (user-based).
4803: --
4804: IF g_dbg THEN op(l_proc, 90); END IF;
4805: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
4806: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
4807: l_custom_per = 'U') AND
4808: p_sec_prof_rec.restriction_text IS NOT NULL THEN
4809: --
4810: -- Check if the custom restriction is using the PERSON or PERSON_TYPE

Line 4947: -- Pre Oracle 9 so fetch each row individually.

4943: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl
4944: ,l_temp_per_tbl;
4945: ELSE
4946: --
4947: -- Pre Oracle 9 so fetch each row individually.
4948: --
4949: l_cnt := 1;
4950: LOOP
4951: --

Line 5112: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR

5108: --
5109: -- Restrict by custom (static).
5110: --
5111: IF g_dbg THEN op(l_proc, 85); END IF;
5112: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
5113: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
5114: l_custom_per = 'Y') THEN
5115: l_temp_clause := and_clause(l_temp_clause,
5116: 'EXISTS

Line 5113: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND

5109: -- Restrict by custom (static).
5110: --
5111: IF g_dbg THEN op(l_proc, 85); END IF;
5112: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
5113: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
5114: l_custom_per = 'Y') THEN
5115: l_temp_clause := and_clause(l_temp_clause,
5116: 'EXISTS
5117: (SELECT null

Line 5127: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND

5123: --
5124: -- Restrict by custom (user-based).
5125: --
5126: IF g_dbg THEN op(l_proc, 90); END IF;
5127: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
5128: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
5129: l_custom_per = 'U') AND
5130: p_sec_prof_rec.restriction_text IS NOT NULL THEN
5131: --

Line 5128: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR

5124: -- Restrict by custom (user-based).
5125: --
5126: IF g_dbg THEN op(l_proc, 90); END IF;
5127: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
5128: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
5129: l_custom_per = 'U') AND
5130: p_sec_prof_rec.restriction_text IS NOT NULL THEN
5131: --
5132: -- Check if the custom restriction is using the PERSON or PERSON_TYPE

Line 5382: -- Pre Oracle 9 so fetch each row individually.

5378: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl
5379: ,l_temp_per_tbl;
5380: ELSE
5381: --
5382: -- Pre Oracle 9 so fetch each row individually.
5383: --
5384: l_cnt := 1;
5385: LOOP
5386: --

Line 6075: ,p_restrict_on_individual_asg IN VARCHAR2)

6071: PROCEDURE add_granted_users_to_cache
6072: (p_user_id IN NUMBER
6073: ,p_effective_date IN DATE
6074: ,p_allow_granted_users_flag IN VARCHAR2
6075: ,p_restrict_on_individual_asg IN VARCHAR2)
6076: IS
6077:
6078: --
6079: -- Local variables.

Line 6151: IF NVL(p_restrict_on_individual_asg, 'N') = 'Y' THEN

6147: IF NOT g_per_tbl.EXISTS(l_temp_per_tbl(i)) THEN
6148: g_per_tbl(l_temp_per_tbl(i)) := TRUE;
6149: END IF;
6150:
6151: IF NVL(p_restrict_on_individual_asg, 'N') = 'Y' THEN
6152: --
6153: -- This profile is securing at an individual assignment level
6154: -- so add all the assignments for this person into the
6155: -- assignment cache.

Line 6153: -- This profile is securing at an individual assignment level

6149: END IF;
6150:
6151: IF NVL(p_restrict_on_individual_asg, 'N') = 'Y' THEN
6152: --
6153: -- This profile is securing at an individual assignment level
6154: -- so add all the assignments for this person into the
6155: -- assignment cache.
6156: --
6157: FOR asg_rec IN csr_get_asgs_for_per(l_temp_per_tbl(i)) LOOP

Line 7198: END IF; -- End of evaluating each individual assignment

7194: IF g_dbg THEN op(l_proc||'('||
7195: to_char(p_assignments_tbl(i).assignment_id)||')', 20);
7196: END IF;
7197: END LOOP;
7198: END IF; -- End of evaluating each individual assignment
7199:
7200: ELSE
7201: --
7202: -- Add the organizations in the hierarchy to the cache,

Line 7399: END IF; -- End of evaluating each individual assignment

7395: IF g_dbg THEN op(l_proc||'('||
7396: to_char(p_assignments_tbl(i).assignment_id)||')', 20);
7397: END IF;
7398: END LOOP;
7399: END IF; -- End of evaluating each individual assignment
7400:
7401: ELSE
7402: --
7403: -- Add the positions in the hierarchy to the cache,

Line 7590: (nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y'

7586: -- permissions are not stored in static lists for this user,
7587: -- c) The p_use_static_lists parameter is forcing the dynamic
7588: -- evaluation of security.
7589: if not l_only_use_static or
7590: (nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y'
7591: and not user_in_static_asg_list(p_user_id,
7592: p_sec_prof_rec.security_profile_id)) then
7593: --
7594: -- First, ensure all other security criteria has already

Line 7736: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then

7732: ,l_user_restriction);
7733: --
7734: -- If restricting at an assignment level, also cache
7735: -- the assignment list.
7736: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then
7737: --
7738: add_static_asg_to_cache(p_user_id
7739: ,p_sec_prof_rec.security_profile_id
7740: ,l_user_restriction);

Line 7750: ,p_sec_prof_rec.restrict_on_individual_asg);

7746: -- Add granted users and their assignments to the cache.
7747: add_granted_users_to_cache(p_user_id
7748: ,p_effective_date
7749: ,p_sec_prof_rec.allow_granted_users_flag
7750: ,p_sec_prof_rec.restrict_on_individual_asg);
7751: --
7752: -- Caching candidates (registered users through iRecruitment), this is
7753: -- valid only if the iRecruitment is installed.
7754: if p_sec_prof_rec.view_all_candidates_flag = 'Y' and

Line 7775: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then

7771: insert_per_list_for_user(p_user_id,p_sec_prof_rec.security_profile_id);
7772: --
7773: if g_dbg then op(l_proc, 140); end if;
7774: --
7775: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then
7776: --
7777: -- Only insert the assignment privileges if securing
7778: -- at an assignment level.
7779: if g_dbg then op(l_proc, 150); end if;

Line 7866: op(' p_restrict_on_individual_asg '||

7862: op(' p_reporting_oracle_username '||
7863: p_sec_prof_rec.reporting_oracle_username);
7864: op(' p_allow_granted_users_flag '||
7865: p_sec_prof_rec.allow_granted_users_flag);
7866: op(' p_restrict_on_individual_asg '||
7867: p_sec_prof_rec.restrict_on_individual_asg);
7868: op(' p_view_all_employees_flag '||
7869: p_sec_prof_rec.view_all_employees_flag);
7870: op(' p_view_all_cwk_flag '||

Line 7867: p_sec_prof_rec.restrict_on_individual_asg);

7863: p_sec_prof_rec.reporting_oracle_username);
7864: op(' p_allow_granted_users_flag '||
7865: p_sec_prof_rec.allow_granted_users_flag);
7866: op(' p_restrict_on_individual_asg '||
7867: p_sec_prof_rec.restrict_on_individual_asg);
7868: op(' p_view_all_employees_flag '||
7869: p_sec_prof_rec.view_all_employees_flag);
7870: op(' p_view_all_cwk_flag '||
7871: p_sec_prof_rec.view_all_cwk_flag);

Line 8469: from sys.dual

8465: ,p_request_id
8466: ,p_program_application_id
8467: ,p_program_id
8468: ,p_update_date
8469: from sys.dual
8470: where not exists(select 1
8471: from per_organization_list pol
8472: where pol.organization_id = p_organization_id
8473: and pol.security_profile_id = p_security_profile_Id