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.MO_UTILS dependencies on HR_OPERATING_UNITS

Line 180: l_prof_org_id hr_operating_units.organization_id%TYPE;

176: ( p_default_org_id OUT NOCOPY NUMBER
177: , p_default_ou_name OUT NOCOPY VARCHAR2
178: , p_ou_count OUT NOCOPY NUMBER)
179: IS
180: l_prof_org_id hr_operating_units.organization_id%TYPE;
181: l_default_org_id hr_operating_units.organization_id%TYPE;
182: l_default_ou_name hr_operating_units.name%TYPE;
183: BEGIN
184: p_ou_count := mo_global.get_ou_count;

Line 181: l_default_org_id hr_operating_units.organization_id%TYPE;

177: , p_default_ou_name OUT NOCOPY VARCHAR2
178: , p_ou_count OUT NOCOPY NUMBER)
179: IS
180: l_prof_org_id hr_operating_units.organization_id%TYPE;
181: l_default_org_id hr_operating_units.organization_id%TYPE;
182: l_default_ou_name hr_operating_units.name%TYPE;
183: BEGIN
184: p_ou_count := mo_global.get_ou_count;
185:

Line 182: l_default_ou_name hr_operating_units.name%TYPE;

178: , p_ou_count OUT NOCOPY NUMBER)
179: IS
180: l_prof_org_id hr_operating_units.organization_id%TYPE;
181: l_default_org_id hr_operating_units.organization_id%TYPE;
182: l_default_ou_name hr_operating_units.name%TYPE;
183: BEGIN
184: p_ou_count := mo_global.get_ou_count;
185:
186: IF (get_multi_org_flag <> 'Y' OR p_ou_count = 0) THEN

Line 314: l_def_org_id hr_operating_units.organization_id%TYPE;

310: -- Returns the ORG_ID of the default operating unit.
311: --
312: FUNCTION get_default_org_id RETURN NUMBER
313: IS
314: l_def_org_id hr_operating_units.organization_id%TYPE;
315: l_def_org_name hr_operating_units.name%TYPE;
316: l_org_count pls_integer;
317: BEGIN
318: get_default_ou(l_def_org_id, l_def_org_name, l_org_count);

Line 315: l_def_org_name hr_operating_units.name%TYPE;

311: --
312: FUNCTION get_default_org_id RETURN NUMBER
313: IS
314: l_def_org_id hr_operating_units.organization_id%TYPE;
315: l_def_org_name hr_operating_units.name%TYPE;
316: l_org_count pls_integer;
317: BEGIN
318: get_default_ou(l_def_org_id, l_def_org_name, l_org_count);
319: return l_def_org_id;

Line 397: FROM hr_operating_units

393: IF p_org_class = 'OPERATING_UNIT' THEN
394: BEGIN
395: SELECT 'Y'
396: INTO l_org_exists
397: FROM hr_operating_units
398: WHERE business_group_id = l_bg_id
399: AND organization_id = p_org_id;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN

Line 430: FROM hr_operating_units

426: IF p_org_class = 'OPERATING_UNIT' THEN
427: BEGIN
428: SELECT 'Y'
429: INTO l_org_exists
430: FROM hr_operating_units
431: WHERE organization_id = p_org_id;
432: EXCEPTION
433: WHEN NO_DATA_FOUND THEN
434: l_org_exists := 'N';

Line 463: hr_operating_units ou

459: BEGIN
460: SELECT 'Y'
461: INTO l_org_exists
462: FROM per_organization_list per,
463: hr_operating_units ou
464: WHERE per.organization_id = ou.organization_id
465: AND per.security_profile_id = l_security_profile_id
466: AND ou.organization_id = p_org_id;
467: EXCEPTION

Line 516: TYPE OrgIdTab IS TABLE OF hr_operating_units.organization_id%TYPE

512: ( p_ledger_id IN NUMBER )
513: RETURN VARCHAR2
514: IS
515: l_has_full_ledger_access VARCHAR2(1) := 'N';
516: TYPE OrgIdTab IS TABLE OF hr_operating_units.organization_id%TYPE
517: INDEX BY BINARY_INTEGER;
518: TYPE BGTab IS TABLE OF hr_operating_units.business_group_id%TYPE
519: INDEX BY BINARY_INTEGER;
520: t_org_id OrgIdTab;

Line 518: TYPE BGTab IS TABLE OF hr_operating_units.business_group_id%TYPE

514: IS
515: l_has_full_ledger_access VARCHAR2(1) := 'N';
516: TYPE OrgIdTab IS TABLE OF hr_operating_units.organization_id%TYPE
517: INDEX BY BINARY_INTEGER;
518: TYPE BGTab IS TABLE OF hr_operating_units.business_group_id%TYPE
519: INDEX BY BINARY_INTEGER;
520: t_org_id OrgIdTab;
521: t_bg_id BGTab;
522:

Line 524: select distinct ou.organization_id , ou.business_group_id from hr_operating_units ou

520: t_org_id OrgIdTab;
521: t_bg_id BGTab;
522:
523: cursor ledger_cur is
524: select distinct ou.organization_id , ou.business_group_id from hr_operating_units ou
525: where ou.set_of_books_id =p_ledger_id ;
526:
527: begin
528: OPEN LEDGER_CUR;

Line 561: l_org_name HR_OPERATING_UNITS.Name%TYPE;

557: ( p_org_id IN NUMBER
558: )
559: RETURN VARCHAR2
560: IS
561: l_org_name HR_OPERATING_UNITS.Name%TYPE;
562:
563: BEGIN
564:
565: SELECT hr.NAME

Line 567: FROM hr_operating_units hr

563: BEGIN
564:
565: SELECT hr.NAME
566: INTO l_org_name
567: FROM hr_operating_units hr
568: WHERE hr.organization_id = p_org_id;
569:
570: RETURN l_org_name;
571: