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_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1109: l_return hr_all_organization_units.name%TYPE;

1105: -----------------------------------------------------------------------------
1106: FUNCTION get_bg_name(p_organization_id NUMBER) RETURN VARCHAR2
1107: IS
1108: l_proc VARCHAR2(72) := g_package||'Get_Bg_Name';
1109: l_return hr_all_organization_units.name%TYPE;
1110:
1111: CURSOR bg_cr IS
1112: SELECT bg.name
1113: FROM hr_all_organization_units org,

Line 1113: FROM hr_all_organization_units org,

1109: l_return hr_all_organization_units.name%TYPE;
1110:
1111: CURSOR bg_cr IS
1112: SELECT bg.name
1113: FROM hr_all_organization_units org,
1114: hr_all_organization_units bg
1115: WHERE org.business_group_id = bg.organization_id
1116: AND org.organization_id = p_organization_id;
1117:

Line 1114: hr_all_organization_units bg

1110:
1111: CURSOR bg_cr IS
1112: SELECT bg.name
1113: FROM hr_all_organization_units org,
1114: hr_all_organization_units bg
1115: WHERE org.business_group_id = bg.organization_id
1116: AND org.organization_id = p_organization_id;
1117:
1118: BEGIN

Line 1552: FROM hr_all_organization_units o

1548:
1549: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)
1550: IS
1551: SELECT o.location_id
1552: FROM hr_all_organization_units o
1553: WHERE o.organization_id = p_training_center_id;
1554:
1555: l_proc VARCHAR2(72) := g_package||'Get_Event_Location';
1556: BEGIN

Line 2366: select name from hr_all_organization_units_tl

2362: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2363: RETURN VARCHAR2 IS
2364:
2365: CURSOR c_organization_name IS
2366: select name from hr_all_organization_units_tl
2367: where language = userenv('LANG') and organization_id = p_organization_id;
2368:
2369: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2370: select substrb(party.party_name,1,50)

Line 2383: -- Internal Enrollment, Get org_name from hr_all_organization_units

2379: BEGIN
2380: hr_utility.set_location(' Step:'|| l_proc, 10);
2381:
2382: IF (p_organization_id is not null) THEN
2383: -- Internal Enrollment, Get org_name from hr_all_organization_units
2384: OPEN c_organization_name;
2385: FETCH c_organization_name INTO l_return;
2386: CLOSE c_organization_name;
2387: ELSIF (p_customer_id is not null) THEN