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 1173: l_return hr_all_organization_units.name%TYPE;

1169: -----------------------------------------------------------------------------
1170: FUNCTION get_bg_name(p_organization_id NUMBER) RETURN VARCHAR2
1171: IS
1172: l_proc VARCHAR2(72) := g_package||'Get_Bg_Name';
1173: l_return hr_all_organization_units.name%TYPE;
1174:
1175: CURSOR bg_cr IS
1176: SELECT bg.name
1177: FROM hr_all_organization_units org,

Line 1177: FROM hr_all_organization_units org,

1173: l_return hr_all_organization_units.name%TYPE;
1174:
1175: CURSOR bg_cr IS
1176: SELECT bg.name
1177: FROM hr_all_organization_units org,
1178: hr_all_organization_units bg
1179: WHERE org.business_group_id = bg.organization_id
1180: AND org.organization_id = p_organization_id;
1181:

Line 1178: hr_all_organization_units bg

1174:
1175: CURSOR bg_cr IS
1176: SELECT bg.name
1177: FROM hr_all_organization_units org,
1178: hr_all_organization_units bg
1179: WHERE org.business_group_id = bg.organization_id
1180: AND org.organization_id = p_organization_id;
1181:
1182: BEGIN

Line 1616: FROM hr_all_organization_units o

1612:
1613: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)
1614: IS
1615: SELECT o.location_id
1616: FROM hr_all_organization_units o
1617: WHERE o.organization_id = p_training_center_id;
1618:
1619: l_proc VARCHAR2(72) := g_package||'Get_Event_Location';
1620: BEGIN

Line 2430: select name from hr_all_organization_units_tl

2426: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2427: RETURN VARCHAR2 IS
2428:
2429: CURSOR c_organization_name IS
2430: select name from hr_all_organization_units_tl
2431: where language = userenv('LANG') and organization_id = p_organization_id;
2432:
2433: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2434: select substrb(party.party_name,1,50)

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

2443: BEGIN
2444: hr_utility.set_location(' Step:'|| l_proc, 10);
2445:
2446: IF (p_organization_id is not null) THEN
2447: -- Internal Enrollment, Get org_name from hr_all_organization_units
2448: OPEN c_organization_name;
2449: FETCH c_organization_name INTO l_return;
2450: CLOSE c_organization_name;
2451: ELSIF (p_customer_id is not null) THEN