APPS.OTA_TDB_BUS2 dependencies on OTA_UTILITY

Line 955: ota_utility.get_commitment_detail(p_line_id,

951: LOOP
952: hr_utility.set_location('Entering:'||l_proc,20);
953: l_event_end_date := c_event_rec.course_end_date;
954: END LOOP;
955: ota_utility.get_commitment_detail(p_line_id,
956: l_commitment_id,
957: l_commitment_number,
958: l_commitment_start_date,
959: l_commitment_end_date);

Line 996: WHERE loc.location_id = ota_utility.get_event_location(p_event_id);

992:
993: CURSOR evt_country_cr IS
994: SELECT loc.country
995: FROM hr_locations_all loc
996: WHERE loc.location_id = ota_utility.get_event_location(p_event_id);
997: --
998: --
999: l_org_country hr_locations_all.country%TYPE := null;
1000: l_evt_country hr_locations_all.country%TYPE := null;