APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_TAV_SHD

Line 2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>

2270:
2271: hr_utility.set_location('Entering:'||l_proc, 5);
2272:
2273: if (((p_activity_version_id is not null) and
2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2275: nvl(p_rco_id,hr_api.g_number))
2276: or (p_activity_version_id is null)) then
2277: --
2278: hr_utility.set_location('Entering:'||l_proc, 10);

Line 2284: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');

2280: hr_utility.set_location('Entering:'||l_proc, 15);
2281: open csr_rco;
2282: fetch csr_rco into l_exists;
2283: if csr_rco%found then
2284: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');
2285: end if;
2286: close csr_rco;
2287: hr_utility.set_location('Leaving:'||l_proc, 20);
2288: end if;

Line 2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>

2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:
2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2349: NVL( p_start_date, hr_api.g_date )) THEN
2350: l_upd_start_date := TRUE;
2351: l_start_date := p_start_date;
2352: ELSE

Line 2354: l_start_date := ota_tav_shd.g_old_rec.start_date;

2350: l_upd_start_date := TRUE;
2351: l_start_date := p_start_date;
2352: ELSE
2353: l_upd_start_date := FALSE;
2354: l_start_date := ota_tav_shd.g_old_rec.start_date;
2355: END IF;
2356:
2357: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2358: NVL( p_end_date, hr_api.g_date )) THEN

Line 2357: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>

2353: l_upd_start_date := FALSE;
2354: l_start_date := ota_tav_shd.g_old_rec.start_date;
2355: END IF;
2356:
2357: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2358: NVL( p_end_date, hr_api.g_date )) THEN
2359: l_upd_end_date := TRUE;
2360: l_end_date := p_end_date;
2361: ELSE

Line 2363: l_end_date := ota_tav_shd.g_old_rec.end_date;

2359: l_upd_end_date := TRUE;
2360: l_end_date := p_end_date;
2361: ELSE
2362: l_upd_end_date := FALSE;
2363: l_end_date := ota_tav_shd.g_old_rec.end_date;
2364: END IF;
2365:
2366: IF (l_upd_start_date OR l_upd_end_date) THEN
2367:

Line 2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>

2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:
2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2538: NVL( p_start_date, hr_api.g_date )) THEN
2539: l_upd_start_date := TRUE;
2540: l_start_date := p_start_date;
2541: ELSE

Line 2543: l_start_date := ota_tav_shd.g_old_rec.start_date;

2539: l_upd_start_date := TRUE;
2540: l_start_date := p_start_date;
2541: ELSE
2542: l_upd_start_date := FALSE;
2543: l_start_date := ota_tav_shd.g_old_rec.start_date;
2544: END IF;
2545:
2546: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2547: NVL( p_end_date, hr_api.g_date )) THEN

Line 2546: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>

2542: l_upd_start_date := FALSE;
2543: l_start_date := ota_tav_shd.g_old_rec.start_date;
2544: END IF;
2545:
2546: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2547: NVL( p_end_date, hr_api.g_date )) THEN
2548: l_upd_end_date := TRUE;
2549: l_end_date := p_end_date;
2550: ELSE

Line 2552: l_end_date := ota_tav_shd.g_old_rec.end_date;

2548: l_upd_end_date := TRUE;
2549: l_end_date := p_end_date;
2550: ELSE
2551: l_upd_end_date := FALSE;
2552: l_end_date := ota_tav_shd.g_old_rec.end_date;
2553: END IF;
2554:
2555: IF (l_upd_start_date OR l_upd_end_date) THEN
2556: