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 531: p_user_group_id in ota_user_groups_b.user_group_id%type,

527: asg.assignment_type in ('E','A','C');
528:
529:
530: cursor csr_ug_hierarchy(
531: p_user_group_id in ota_user_groups_b.user_group_id%type,
532: p_business_group_id number,
533: p_ignore_ug_date_check varchar2 default 'N') is
534: SELECT child_user_group_id
535: FROM ( SELECT a.user_group_id user_group_id,

Line 539: FROM ota_user_group_elements a, ota_user_groups_b b

535: FROM ( SELECT a.user_group_id user_group_id,
536: a.child_user_group_id child_user_group_id,
537: level UG_Level,
538: b.user_group_operator user_group_operator
539: FROM ota_user_group_elements a, ota_user_groups_b b
540: WHERE a.user_group_id = b.user_group_id
541: and (p_ignore_ug_date_check = 'Y' or
542: trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and trunc(nvl(b.end_date_active, sysdate+1)))
543: and (b.business_group_id = p_business_group_id or p_business_group_id = -1)

Line 567: p_user_group_id in ota_user_groups_b.user_group_id%type,

563: x.organization_id = p_organization_id and
564: x.sub_org_relative_level > 0;
565:
566: cursor csr_user_group_elements(
567: p_user_group_id in ota_user_groups_b.user_group_id%type,
568: p_business_group_id number,
569: p_ignore_ug_date_check varchar2 default 'N') is
570: select uge.organization_id,
571: uge.org_structure_version_id,

Line 580: from ota_user_group_elements uge, ota_user_groups_b ugb

576: uge.child_user_group_id,
577: ugb.user_group_operator,
578: uge.elig_prfl_id,
579: uge.user_group_id
580: from ota_user_group_elements uge, ota_user_groups_b ugb
581: where uge.user_group_id = p_user_group_id
582: and uge.user_group_id = ugb.user_group_id
583: and (p_ignore_ug_date_check = 'Y' or
584: trunc(sysdate) between trunc(nvl(ugb.start_date_active, sysdate)) and trunc(nvl(ugb.end_date_active, sysdate+1))) --Bug#7120108

Line 2284: p_user_group_id in ota_user_groups_b.user_group_id%type,

2280: done in the procedure get_ug_whereclause
2281: */
2282: function is_learner_in_user_group(
2283: p_person_id in per_people_f.person_id%type,
2284: p_user_group_id in ota_user_groups_b.user_group_id%type,
2285: p_business_group_id number,
2286: p_ignore_ug_date_check varchar2 default 'N') return varchar2 is
2287:
2288: is_avail BOOLEAN default false;

Line 2323: p_user_group_id in ota_user_groups_b.user_group_id%type,

2319: end is_learner_in_user_group;
2320:
2321: function is_learner_matches_user_group(
2322: p_person_id in per_people_f.person_id%type,
2323: p_user_group_id in ota_user_groups_b.user_group_id%type,
2324: p_business_group_id number,
2325: p_ignore_ug_date_check varchar2 default 'N') return boolean is
2326:
2327: l_user_group_operator ota_user_groups_b.user_group_operator%type;

Line 2327: l_user_group_operator ota_user_groups_b.user_group_operator%type;

2323: p_user_group_id in ota_user_groups_b.user_group_id%type,
2324: p_business_group_id number,
2325: p_ignore_ug_date_check varchar2 default 'N') return boolean is
2326:
2327: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2328: l_person_id per_people_f.person_id%type;
2329: l_user_group_id ota_user_groups_b.user_group_id%type;
2330: l_is_avail BOOLEAN default false;
2331:

Line 2329: l_user_group_id ota_user_groups_b.user_group_id%type;

2325: p_ignore_ug_date_check varchar2 default 'N') return boolean is
2326:
2327: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2328: l_person_id per_people_f.person_id%type;
2329: l_user_group_id ota_user_groups_b.user_group_id%type;
2330: l_is_avail BOOLEAN default false;
2331:
2332: begin
2333: for elements in csr_user_group_elements(p_user_group_id, p_business_group_id, p_ignore_ug_date_check) loop

Line 2436: p_user_group_id in ota_user_groups_b.user_group_id%type,

2432: If there is any change in this procedure make sure, the changes are
2433: done in the procedure is_learner_in_user_group
2434: */
2435: function get_ug_whereclause(
2436: p_user_group_id in ota_user_groups_b.user_group_id%type,
2437: p_business_group_id number) return clob is
2438:
2439: whereclause clob;
2440: ug_index NUMBER := 1;

Line 2467: p_user_group_id in ota_user_groups_b.user_group_id%type,

2463: return whereclause;
2464: end get_ug_whereclause;
2465:
2466: function build_ug_whereclause(
2467: p_user_group_id in ota_user_groups_b.user_group_id%type,
2468: p_business_group_id number) return clob is
2469:
2470: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2471: l_user_group_id ota_user_groups_b.user_group_id%type;

Line 2470: l_user_group_operator ota_user_groups_b.user_group_operator%type;

2466: function build_ug_whereclause(
2467: p_user_group_id in ota_user_groups_b.user_group_id%type,
2468: p_business_group_id number) return clob is
2469:
2470: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2471: l_user_group_id ota_user_groups_b.user_group_id%type;
2472: whereclause clob;
2473: childugwhereclause clob;
2474: ugOperatorCheckCount number := 0;

Line 2471: l_user_group_id ota_user_groups_b.user_group_id%type;

2467: p_user_group_id in ota_user_groups_b.user_group_id%type,
2468: p_business_group_id number) return clob is
2469:
2470: l_user_group_operator ota_user_groups_b.user_group_operator%type;
2471: l_user_group_id ota_user_groups_b.user_group_id%type;
2472: whereclause clob;
2473: childugwhereclause clob;
2474: ugOperatorCheckCount number := 0;
2475: orgHierarchyCount number := 0;

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

2571: return whereclause;
2572:
2573: end build_ug_whereclause;
2574:
2575: function is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,
2576: p_business_group_id number) return varchar2 is
2577:
2578: total_elements_count NUMBER := -2;
2579: restricted_elements_count NUMBER := -1;

Line 2588: ota_user_groups_b b

2584: FROM OTA_USER_GROUP_ELEMENTS
2585: WHERE user_group_id in ( SELECT child_user_group_id
2586: FROM ( SELECT a.child_user_group_id
2587: FROM ota_user_group_elements a,
2588: ota_user_groups_b b
2589: WHERE a.user_group_id = b.user_group_id
2590: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2591: trunc(nvl(b.end_date_active, sysdate+1))
2592: START WITH a.user_group_id = p_user_group_id

Line 2610: ota_user_groups_b b

2606: BEN_ELIGY_PRFL_F elig_profile
2607: WHERE a.user_group_id in ( SELECT child_user_group_id
2608: FROM ( SELECT a.child_user_group_id
2609: FROM ota_user_group_elements a,
2610: ota_user_groups_b b
2611: WHERE a.user_group_id = b.user_group_id
2612: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2613: trunc(nvl(b.end_date_active, sysdate+1))
2614: START WITH a.user_group_id = p_user_group_id