DBA Data[Home] [Help]

APPS.GHR_TSP_CATCHUP_PLAN_DESIGN dependencies on FND_DATE

Line 287: l_date_start := nvl(fnd_date.canonical_to_date(p_date_start),hr_api.g_sot);

283: select * from per_time_periods where rowid = l_row_id;
284: Begin
285: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
286:
287: l_date_start := nvl(fnd_date.canonical_to_date(p_date_start),hr_api.g_sot);
288: l_date_to := nvl(fnd_date.canonical_to_date(p_date_to),hr_api.g_eot);
289:
290: hr_utility.set_location( g_package||l_proc, 20);
291: for get_rowid in c_get_rowid loop

Line 288: l_date_to := nvl(fnd_date.canonical_to_date(p_date_to),hr_api.g_eot);

284: Begin
285: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
286:
287: l_date_start := nvl(fnd_date.canonical_to_date(p_date_start),hr_api.g_sot);
288: l_date_to := nvl(fnd_date.canonical_to_date(p_date_to),hr_api.g_eot);
289:
290: hr_utility.set_location( g_package||l_proc, 20);
291: for get_rowid in c_get_rowid loop
292: l_row_id := get_rowid.ROWID;