eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_TSP_CATCHUP_PLAN_DESIGN dependencies on PER_TIME_PERIODS

Line 273: l_tprec per_time_periods%rowtype;

269: l_proc varchar2(100):= 'Update_Alternate_Chcek_Date';
270: l_date_start Date;
271: l_date_to Date;
272: l_row_id Varchar2(200);
273: l_tprec per_time_periods%rowtype;
274:
275: Cursor c_get_rowid is
276: select ROWID
277: from per_time_periods

Line 277: from per_time_periods

273: l_tprec per_time_periods%rowtype;
274:
275: Cursor c_get_rowid is
276: select ROWID
277: from per_time_periods
278: where payroll_id = p_payroll_id
279: --and start_date between nvl(p_date_start,hr_api.g_sot) and nvl(p_date_to,hr_api.g_eot);
280: and start_date between l_date_start and l_date_to ;
281:

Line 283: select * from per_time_periods where rowid = l_row_id;

279: --and start_date between nvl(p_date_start,hr_api.g_sot) and nvl(p_date_to,hr_api.g_eot);
280: and start_date between l_date_start and l_date_to ;
281:
282: Cursor c_get_details is
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);

Line 298: per_time_periods_pkg.update_row

294: hr_utility.set_location( g_package||l_proc, 30);
295: for get_details in c_get_details loop
296: l_tprec := get_details;
297: hr_utility.set_location( g_package||l_proc, 40);
298: per_time_periods_pkg.update_row
299: (X_Rowid => l_row_id,
300: X_Time_Period_Id => l_tprec.time_period_id,
301: X_Payroll_Id => l_tprec.payroll_id ,
302: X_End_Date => l_tprec.end_date,