298: l_api_updating boolean;
299: --
300: CURSOR csr_time_period_id IS
301: SELECT NULL
302: FROM PER_TIME_PERIODS
303: WHERE time_period_id = p_time_period_id;
304: --
305: CURSOR csr_members IS
306: SELECT NULL
331: NVL(p_time_period_id, hr_api.g_number) )
332: OR (NOT l_api_updating))
333: THEN
334: --
335: -- The time period_id must exist in per_time_periods
336: --
337: hr_utility.set_location(' Step:'|| l_proc, 30);
338: OPEN csr_time_period_id;
339: FETCH csr_time_period_id INTO l_exists;
459: --
460: --
461: CURSOR csr_get_dates IS
462: SELECT start_date, end_date
463: FROM PER_TIME_PERIODS
464: WHERE time_period_id = p_time_period_id;
465: --
466: CURSOR csr_plan_overlap IS
467: SELECT NULL
464: WHERE time_period_id = p_time_period_id;
465: --
466: CURSOR csr_plan_overlap IS
467: SELECT NULL
468: FROM PER_TIME_PERIODS ptp
469: ,OTA_TRAINING_PLANS tps
470: WHERE ( (p_person_id IS NOT NULL AND tps.person_id = p_person_id )
471: OR (p_organization_id IS NOT NULL AND tps.organization_id = p_organization_id) )
472: AND (NVL(p_training_plan_id, -1) <> training_plan_id)