DBA Data[Home] [Help]

APPS.OTA_CCI_BUS dependencies on OTA_GENERAL

Line 518: l_start_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.start_date_active

514: ) is
515: --
516: l_proc varchar2(72) := g_package||'update_validate';
517:
518: l_start_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.start_date_active
519: ,p_rec.start_date_active);
520: l_end_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.end_date_active
521: ,p_rec.end_date_active );
522: l_start_date ota_cert_cat_inclusions.start_date_active%TYPE;

Line 520: l_end_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.end_date_active

516: l_proc varchar2(72) := g_package||'update_validate';
517:
518: l_start_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.start_date_active
519: ,p_rec.start_date_active);
520: l_end_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.end_date_active
521: ,p_rec.end_date_active );
522: l_start_date ota_cert_cat_inclusions.start_date_active%TYPE;
523: l_end_date ota_cert_cat_inclusions.end_date_active%TYPE;
524: --

Line 717: ota_general.check_start_end_dates( p_start_date, p_end_date);

713: Begin
714: --
715: hr_utility.set_location('Entering:'|| v_proc, 5);
716: --
717: ota_general.check_start_end_dates( p_start_date, p_end_date);
718: --
719: hr_utility.set_location(' Leaving:'|| v_proc, 10);
720:
721: Exception

Line 829: ota_general.check_par_child_dates(v_start_date, v_end_date,p_start_date,p_end_date);

825: --
826: Open sel_check_dates;
827: Fetch sel_check_dates into v_start_date, v_end_date;
828: IF sel_check_dates%FOUND THEN
829: ota_general.check_par_child_dates(v_start_date, v_end_date,p_start_date,p_end_date);
830: END IF;
831: --
832: Close sel_check_dates;
833: --