APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_TAV_SHD

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

2264:
2265: hr_utility.set_location('Entering:'||l_proc, 5);
2266:
2267: if (((p_activity_version_id is not null) and
2268: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2269: nvl(p_rco_id,hr_api.g_number))
2270: or (p_activity_version_id is null)) then
2271: --
2272: hr_utility.set_location('Entering:'||l_proc, 10);

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

2274: hr_utility.set_location('Entering:'||l_proc, 15);
2275: open csr_rco;
2276: fetch csr_rco into l_exists;
2277: if csr_rco%found then
2278: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');
2279: end if;
2280: close csr_rco;
2281: hr_utility.set_location('Leaving:'||l_proc, 20);
2282: end if;

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

2338: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2339: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2340: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2341:
2342: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2343: NVL( p_start_date, hr_api.g_date )) THEN
2344: l_upd_start_date := TRUE;
2345: l_start_date := p_start_date;
2346: ELSE

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

2344: l_upd_start_date := TRUE;
2345: l_start_date := p_start_date;
2346: ELSE
2347: l_upd_start_date := FALSE;
2348: l_start_date := ota_tav_shd.g_old_rec.start_date;
2349: END IF;
2350:
2351: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2352: NVL( p_end_date, hr_api.g_date )) THEN

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

2347: l_upd_start_date := FALSE;
2348: l_start_date := ota_tav_shd.g_old_rec.start_date;
2349: END IF;
2350:
2351: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2352: NVL( p_end_date, hr_api.g_date )) THEN
2353: l_upd_end_date := TRUE;
2354: l_end_date := p_end_date;
2355: ELSE

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

2353: l_upd_end_date := TRUE;
2354: l_end_date := p_end_date;
2355: ELSE
2356: l_upd_end_date := FALSE;
2357: l_end_date := ota_tav_shd.g_old_rec.end_date;
2358: END IF;
2359:
2360: IF (l_upd_start_date OR l_upd_end_date) THEN
2361:

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

2527: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2528: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2529: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2530:
2531: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2532: NVL( p_start_date, hr_api.g_date )) THEN
2533: l_upd_start_date := TRUE;
2534: l_start_date := p_start_date;
2535: ELSE

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

2533: l_upd_start_date := TRUE;
2534: l_start_date := p_start_date;
2535: ELSE
2536: l_upd_start_date := FALSE;
2537: l_start_date := ota_tav_shd.g_old_rec.start_date;
2538: END IF;
2539:
2540: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2541: NVL( p_end_date, hr_api.g_date )) THEN

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

2536: l_upd_start_date := FALSE;
2537: l_start_date := ota_tav_shd.g_old_rec.start_date;
2538: END IF;
2539:
2540: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2541: NVL( p_end_date, hr_api.g_date )) THEN
2542: l_upd_end_date := TRUE;
2543: l_end_date := p_end_date;
2544: ELSE

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

2542: l_upd_end_date := TRUE;
2543: l_end_date := p_end_date;
2544: ELSE
2545: l_upd_end_date := FALSE;
2546: l_end_date := ota_tav_shd.g_old_rec.end_date;
2547: END IF;
2548:
2549: IF (l_upd_start_date OR l_upd_end_date) THEN
2550: