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 3427: -- so instead it would be necessary to fetch into individual

3423: -- Fetch the assignments. Bulk collect would not perform better
3424: -- considering the number of assignments a person will typically
3425: -- have: few. As Oracle 8i is still supported at the time of
3426: -- writing, it is not possible to bulk collect into a collection
3427: -- so instead it would be necessary to fetch into individual
3428: -- collections of scalars if bulk collect was to be used.
3429: --
3430: IF g_dbg THEN op(l_proc, 50); END IF;
3431: j := 1;

Line 4287: IF p_sec_prof_rec.restrict_on_individual_asg = 'Y' and

4283: if not g_per_tbl.exists(l_temp_per_tbl(i)) then
4284: g_per_tbl(l_temp_per_tbl(i)) := true;
4285: end if;
4286: --
4287: IF p_sec_prof_rec.restrict_on_individual_asg = 'Y' and
4288: l_temp_asg_tbl.COUNT > 0 THEN
4289: -- Enumerate through the temporary table and re-order
4290: -- the list of asgs into the global cache so that the
4291: -- index is the asg_id. This allows for direct index access.

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

4741: -- This does not return ex-people (ex-employees, etc) and
4742: -- it does not return contacts.
4743: --
4744: -- Bug 3686545
4745: -- When restrict_on_individual_asg flag on security profile is set
4746: -- then custom security should be evaluated as user based because
4747: -- listgen currently does not maintain static assignment list.
4748: --
4749:

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

4920: --
4921: -- Restrict by custom (static).
4922: --
4923: IF g_dbg THEN op(l_proc, 85); END IF;
4924: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
4925: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
4926: l_custom_per = 'Y') THEN
4927: l_temp_clause := and_clause(l_temp_clause,
4928: 'EXISTS

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

4921: -- Restrict by custom (static).
4922: --
4923: IF g_dbg THEN op(l_proc, 85); END IF;
4924: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
4925: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
4926: l_custom_per = 'Y') THEN
4927: l_temp_clause := and_clause(l_temp_clause,
4928: 'EXISTS
4929: (SELECT null

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

4935: --
4936: -- Restrict by custom (user-based).
4937: --
4938: IF g_dbg THEN op(l_proc, 90); END IF;
4939: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
4940: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
4941: l_custom_per = 'U') AND
4942: p_sec_prof_rec.restriction_text IS NOT NULL THEN
4943: --

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

4936: -- Restrict by custom (user-based).
4937: --
4938: IF g_dbg THEN op(l_proc, 90); END IF;
4939: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
4940: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
4941: l_custom_per = 'U') AND
4942: p_sec_prof_rec.restriction_text IS NOT NULL THEN
4943: --
4944: -- Check if the custom restriction is using the PERSON or PERSON_TYPE

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

5077: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl
5078: ,l_temp_per_tbl;
5079: ELSE
5080: --
5081: -- Pre Oracle 9 so fetch each row individually.
5082: --
5083: l_cnt := 1;
5084: LOOP
5085: --

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

5257: --
5258: -- Restrict by custom (static).
5259: --
5260: IF g_dbg THEN op(l_proc, 85); END IF;
5261: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
5262: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
5263: l_custom_per = 'Y') THEN
5264: l_temp_clause := and_clause(l_temp_clause,
5265: 'EXISTS

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

5258: -- Restrict by custom (static).
5259: --
5260: IF g_dbg THEN op(l_proc, 85); END IF;
5261: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NULL OR
5262: p_sec_prof_rec.restrict_on_individual_asg = 'N') AND
5263: l_custom_per = 'Y') THEN
5264: l_temp_clause := and_clause(l_temp_clause,
5265: 'EXISTS
5266: (SELECT null

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

5272: --
5273: -- Restrict by custom (user-based).
5274: --
5275: IF g_dbg THEN op(l_proc, 90); END IF;
5276: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
5277: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
5278: l_custom_per = 'U') AND
5279: p_sec_prof_rec.restriction_text IS NOT NULL THEN
5280: --

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

5273: -- Restrict by custom (user-based).
5274: --
5275: IF g_dbg THEN op(l_proc, 90); END IF;
5276: IF ((p_sec_prof_rec.restrict_on_individual_asg IS NOT NULL AND
5277: p_sec_prof_rec.restrict_on_individual_asg = 'Y') OR
5278: l_custom_per = 'U') AND
5279: p_sec_prof_rec.restriction_text IS NOT NULL THEN
5280: --
5281: -- Check if the custom restriction is using the PERSON or PERSON_TYPE

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

5581: END IF;
5582:
5583: ELSE
5584: --
5585: -- Pre Oracle 9 so fetch each row individually.
5586: --
5587: l_cnt := 1;
5588: LOOP
5589: --

Line 6319: ,p_restrict_on_individual_asg IN VARCHAR2)

6315: PROCEDURE add_granted_users_to_cache
6316: (p_user_id IN NUMBER
6317: ,p_effective_date IN DATE
6318: ,p_allow_granted_users_flag IN VARCHAR2
6319: ,p_restrict_on_individual_asg IN VARCHAR2)
6320: IS
6321:
6322: --
6323: -- Local variables.

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

6391: IF NOT g_per_tbl.EXISTS(l_temp_per_tbl(i)) THEN
6392: g_per_tbl(l_temp_per_tbl(i)) := TRUE;
6393: END IF;
6394:
6395: IF NVL(p_restrict_on_individual_asg, 'N') = 'Y' THEN
6396: --
6397: -- This profile is securing at an individual assignment level
6398: -- so add all the assignments for this person into the
6399: -- assignment cache.

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

6393: END IF;
6394:
6395: IF NVL(p_restrict_on_individual_asg, 'N') = 'Y' THEN
6396: --
6397: -- This profile is securing at an individual assignment level
6398: -- so add all the assignments for this person into the
6399: -- assignment cache.
6400: --
6401: FOR asg_rec IN csr_get_asgs_for_per(l_temp_per_tbl(i)) LOOP

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

7438: IF g_dbg THEN op(l_proc||'('||
7439: to_char(p_assignments_tbl(i).assignment_id)||')', 20);
7440: END IF;
7441: END LOOP;
7442: END IF; -- End of evaluating each individual assignment
7443:
7444: ELSE
7445: --
7446: -- Add the organizations in the hierarchy to the cache,

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

7639: IF g_dbg THEN op(l_proc||'('||
7640: to_char(p_assignments_tbl(i).assignment_id)||')', 20);
7641: END IF;
7642: END LOOP;
7643: END IF; -- End of evaluating each individual assignment
7644:
7645: ELSE
7646: --
7647: -- Add the positions in the hierarchy to the cache,

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

7831: -- permissions are not stored in static lists for this user,
7832: -- c) The p_use_static_lists parameter is forcing the dynamic
7833: -- evaluation of security.
7834: if not l_only_use_static or
7835: (nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y'
7836: and not user_in_static_asg_list(p_user_id,
7837: p_sec_prof_rec.security_profile_id)) then
7838: --
7839: -- First, ensure all other security criteria has already

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

7977: ,l_user_restriction);
7978: --
7979: -- If restricting at an assignment level, also cache
7980: -- the assignment list.
7981: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then
7982: --
7983: add_static_asg_to_cache(p_user_id
7984: ,p_sec_prof_rec.security_profile_id
7985: ,l_user_restriction);

Line 7995: ,p_sec_prof_rec.restrict_on_individual_asg);

7991: -- Add granted users and their assignments to the cache.
7992: add_granted_users_to_cache(p_user_id
7993: ,p_effective_date
7994: ,p_sec_prof_rec.allow_granted_users_flag
7995: ,p_sec_prof_rec.restrict_on_individual_asg);
7996: --
7997: -- Caching candidates (registered users through iRecruitment), this is
7998: -- valid only if the iRecruitment is installed.
7999: if p_sec_prof_rec.view_all_candidates_flag = 'Y' and

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

8028: insert_per_list_for_user(p_user_id,p_sec_prof_rec.security_profile_id);
8029: --
8030: if g_dbg then op(l_proc, 140); end if;
8031: --
8032: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then
8033: --
8034: -- Only insert the assignment privileges if securing
8035: -- at an assignment level.
8036: if g_dbg then op(l_proc, 150); end if;

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

8116: -- permissions are not stored in static lists for this user,
8117: -- c) The p_use_static_lists parameter is forcing the dynamic
8118: -- evaluation of security.
8119: if not l_only_use_static or
8120: (nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y'
8121: and not user_in_static_asg_list(p_user_id,
8122: p_sec_prof_rec.security_profile_id)) then
8123: --
8124: -- First, ensure all other security criteria has already

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

8262: ,l_user_restriction);
8263: --
8264: -- If restricting at an assignment level, also cache
8265: -- the assignment list.
8266: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then
8267: --
8268: add_static_asg_to_cache(p_user_id
8269: ,p_sec_prof_rec.security_profile_id
8270: ,l_user_restriction);

Line 8280: ,p_sec_prof_rec.restrict_on_individual_asg);

8276: -- Add granted users and their assignments to the cache.
8277: add_granted_users_to_cache(p_user_id
8278: ,p_effective_date
8279: ,p_sec_prof_rec.allow_granted_users_flag
8280: ,p_sec_prof_rec.restrict_on_individual_asg);
8281: --
8282: -- Caching candidates (registered users through iRecruitment), this is
8283: -- valid only if the iRecruitment is installed.
8284: if p_sec_prof_rec.view_all_candidates_flag = 'Y' and

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

8313: insert_per_list_for_user(p_user_id,p_sec_prof_rec.security_profile_id);
8314: --
8315: if g_dbg then op(l_proc, 140); end if;
8316: --
8317: if nvl(p_sec_prof_rec.restrict_on_individual_asg, 'N') = 'Y' then
8318: --
8319: -- Only insert the assignment privileges if securing
8320: -- at an assignment level.
8321: if g_dbg then op(l_proc, 150); end if;

Line 8413: op(' p_restrict_on_individual_asg '||

8409: op(' p_reporting_oracle_username '||
8410: p_sec_prof_rec.reporting_oracle_username);
8411: op(' p_allow_granted_users_flag '||
8412: p_sec_prof_rec.allow_granted_users_flag);
8413: op(' p_restrict_on_individual_asg '||
8414: p_sec_prof_rec.restrict_on_individual_asg);
8415: op(' p_view_all_employees_flag '||
8416: p_sec_prof_rec.view_all_employees_flag);
8417: op(' p_view_all_cwk_flag '||

Line 8414: p_sec_prof_rec.restrict_on_individual_asg);

8410: p_sec_prof_rec.reporting_oracle_username);
8411: op(' p_allow_granted_users_flag '||
8412: p_sec_prof_rec.allow_granted_users_flag);
8413: op(' p_restrict_on_individual_asg '||
8414: p_sec_prof_rec.restrict_on_individual_asg);
8415: op(' p_view_all_employees_flag '||
8416: p_sec_prof_rec.view_all_employees_flag);
8417: op(' p_view_all_cwk_flag '||
8418: p_sec_prof_rec.view_all_cwk_flag);

Line 8720: op(' p_restrict_on_individual_asg '||

8716: op(' p_reporting_oracle_username '||
8717: p_sec_prof_rec.reporting_oracle_username);
8718: op(' p_allow_granted_users_flag '||
8719: p_sec_prof_rec.allow_granted_users_flag);
8720: op(' p_restrict_on_individual_asg '||
8721: p_sec_prof_rec.restrict_on_individual_asg);
8722: op(' p_view_all_employees_flag '||
8723: p_sec_prof_rec.view_all_employees_flag);
8724: op(' p_view_all_cwk_flag '||

Line 8721: p_sec_prof_rec.restrict_on_individual_asg);

8717: p_sec_prof_rec.reporting_oracle_username);
8718: op(' p_allow_granted_users_flag '||
8719: p_sec_prof_rec.allow_granted_users_flag);
8720: op(' p_restrict_on_individual_asg '||
8721: p_sec_prof_rec.restrict_on_individual_asg);
8722: op(' p_view_all_employees_flag '||
8723: p_sec_prof_rec.view_all_employees_flag);
8724: op(' p_view_all_cwk_flag '||
8725: p_sec_prof_rec.view_all_cwk_flag);

Line 9333: from sys.dual

9329: ,p_request_id
9330: ,p_program_application_id
9331: ,p_program_id
9332: ,p_update_date
9333: from sys.dual
9334: where not exists(select 1
9335: from per_organization_list pol
9336: where pol.organization_id = p_organization_id
9337: and pol.security_profile_id = p_security_profile_Id