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.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_USER_GROUPS_B

Line 556: p_user_group_id in ota_user_groups_b.user_group_id%type,

552: AND OAV.activity_version_id = p_activity_version_id
553: ORDER BY OEV.public_event_flag DESC;
554:
555: cursor csr_ug_hierarchy(
556: p_user_group_id in ota_user_groups_b.user_group_id%type,
557: p_business_group_id number) is
558: SELECT child_user_group_id
559: FROM ( SELECT a.user_group_id user_group_id,
560: a.child_user_group_id child_user_group_id,

Line 563: FROM ota_user_group_elements a, ota_user_groups_b b

559: FROM ( SELECT a.user_group_id user_group_id,
560: a.child_user_group_id child_user_group_id,
561: level UG_Level,
562: b.user_group_operator user_group_operator
563: FROM ota_user_group_elements a, ota_user_groups_b b
564: WHERE a.user_group_id = b.user_group_id
565: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and trunc(nvl(b.end_date_active, sysdate+1))
566: and (b.business_group_id = p_business_group_id or p_business_group_id = -1)
567: START WITH a.user_group_id = p_user_group_id

Line 590: p_user_group_id in ota_user_groups_b.user_group_id%type,

586: x.organization_id = p_organization_id and
587: x.sub_org_relative_level > 0;
588:
589: cursor csr_user_group_elements(
590: p_user_group_id in ota_user_groups_b.user_group_id%type,
591: p_business_group_id number) is
592: select uge.organization_id,
593: uge.org_structure_version_id,
594: uge.job_id,

Line 600: from ota_user_group_elements uge, ota_user_groups_b ugb

596: uge.person_id,
597: uge.match_type,
598: uge.child_user_group_id,
599: ugb.user_group_operator
600: from ota_user_group_elements uge, ota_user_groups_b ugb
601: where uge.user_group_id = p_user_group_id
602: and uge.user_group_id = ugb.user_group_id
603: and trunc(sysdate) between trunc(nvl(ugb.start_date_active, sysdate)) and trunc(nvl(ugb.end_date_active, sysdate+1)) --Bug#7120108
604: and (uge.business_group_id = p_business_group_id or p_business_group_id = -1);

Line 2203: p_user_group_id in ota_user_groups_b.user_group_id%type,

2199: done in the procedure get_ug_whereclause
2200: */
2201: function is_learner_in_user_group(
2202: p_person_id in per_people_f.person_id%type,
2203: p_user_group_id in ota_user_groups_b.user_group_id%type,
2204: p_business_group_id number) return varchar2 is
2205:
2206: is_avail BOOLEAN default false;
2207: ug_index NUMBER := 1;

Line 2239: p_user_group_id in ota_user_groups_b.user_group_id%type,

2235: end is_learner_in_user_group;
2236:
2237: function is_learner_matches_user_group(
2238: p_person_id in per_people_f.person_id%type,
2239: p_user_group_id in ota_user_groups_b.user_group_id%type,
2240: p_business_group_id number) return boolean is
2241:
2242: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2243: l_person_id per_people_f.person_id%type;

Line 2242: l_user_group_operator ota_user_groups_b.user_group_operator%type;

2238: p_person_id in per_people_f.person_id%type,
2239: p_user_group_id in ota_user_groups_b.user_group_id%type,
2240: p_business_group_id number) return boolean is
2241:
2242: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2243: l_person_id per_people_f.person_id%type;
2244: l_user_group_id ota_user_groups_b.user_group_id%type;
2245: l_is_avail BOOLEAN default false;
2246:

Line 2244: l_user_group_id ota_user_groups_b.user_group_id%type;

2240: p_business_group_id number) return boolean is
2241:
2242: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2243: l_person_id per_people_f.person_id%type;
2244: l_user_group_id ota_user_groups_b.user_group_id%type;
2245: l_is_avail BOOLEAN default false;
2246:
2247: begin
2248: for elements in csr_user_group_elements(p_user_group_id, p_business_group_id) loop

Line 2318: p_user_group_id in ota_user_groups_b.user_group_id%type,

2314: If there is any change in this procedure make sure, the changes are
2315: done in the procedure is_learner_in_user_group
2316: */
2317: function get_ug_whereclause(
2318: p_user_group_id in ota_user_groups_b.user_group_id%type,
2319: p_business_group_id number) return clob is
2320:
2321: whereclause clob;
2322: ug_index NUMBER := 1;

Line 2349: p_user_group_id in ota_user_groups_b.user_group_id%type,

2345: return whereclause;
2346: end get_ug_whereclause;
2347:
2348: function build_ug_whereclause(
2349: p_user_group_id in ota_user_groups_b.user_group_id%type,
2350: p_business_group_id number) return clob is
2351:
2352: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2353: l_user_group_id ota_user_groups_b.user_group_id%type;

Line 2352: l_user_group_operator ota_user_groups_b.user_group_operator%type;

2348: function build_ug_whereclause(
2349: p_user_group_id in ota_user_groups_b.user_group_id%type,
2350: p_business_group_id number) return clob is
2351:
2352: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2353: l_user_group_id ota_user_groups_b.user_group_id%type;
2354: whereclause clob;
2355: childugwhereclause clob;
2356: ugOperatorCheckCount number := 0;

Line 2353: l_user_group_id ota_user_groups_b.user_group_id%type;

2349: p_user_group_id in ota_user_groups_b.user_group_id%type,
2350: p_business_group_id number) return clob is
2351:
2352: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2353: l_user_group_id ota_user_groups_b.user_group_id%type;
2354: whereclause clob;
2355: childugwhereclause clob;
2356: ugOperatorCheckCount number := 0;
2357: orgHierarchyCount number := 0;

Line 2441: function is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,

2437: return whereclause;
2438:
2439: end build_ug_whereclause;
2440:
2441: function is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,
2442: p_business_group_id number) return varchar2 is
2443:
2444: total_elements_count NUMBER := -2;
2445: restricted_elements_count NUMBER := -1;

Line 2454: ota_user_groups_b b

2450: FROM OTA_USER_GROUP_ELEMENTS
2451: WHERE user_group_id in ( SELECT child_user_group_id
2452: FROM ( SELECT a.child_user_group_id
2453: FROM ota_user_group_elements a,
2454: ota_user_groups_b b
2455: WHERE a.user_group_id = b.user_group_id
2456: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2457: trunc(nvl(b.end_date_active, sysdate+1))
2458: START WITH a.user_group_id = p_user_group_id

Line 2474: ota_user_groups_b b

2470: PER_POSITIONS pos
2471: WHERE a.user_group_id in ( SELECT child_user_group_id
2472: FROM ( SELECT a.child_user_group_id
2473: FROM ota_user_group_elements a,
2474: ota_user_groups_b b
2475: WHERE a.user_group_id = b.user_group_id
2476: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2477: trunc(nvl(b.end_date_active, sysdate+1))
2478: START WITH a.user_group_id = p_user_group_id