APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on FND_TIMEZONES

Line 2319: l_server_code := fnd_timezones.get_server_timezone_code;

2315: itemtype => l_item_type,
2316: itemkey => l_wf_item_key,
2317: aname => 'BIS_RUN_DATE' );
2318:
2319: l_server_code := fnd_timezones.get_server_timezone_code;
2320: l_client_code := fnd_timezones.get_client_timezone_code;
2321:
2322: l_server_date := to_date(l_sys_run_date,'DD/MM/RRRR HH24:MI:SS');
2323:

Line 2320: l_client_code := fnd_timezones.get_client_timezone_code;

2316: itemkey => l_wf_item_key,
2317: aname => 'BIS_RUN_DATE' );
2318:
2319: l_server_code := fnd_timezones.get_server_timezone_code;
2320: l_client_code := fnd_timezones.get_client_timezone_code;
2321:
2322: l_server_date := to_date(l_sys_run_date,'DD/MM/RRRR HH24:MI:SS');
2323:
2324: /*

Line 2325: l_client_date := fnd_timezones_pvt.adjust_datetime(

2321:
2322: l_server_date := to_date(l_sys_run_date,'DD/MM/RRRR HH24:MI:SS');
2323:
2324: /*
2325: l_client_date := fnd_timezones_pvt.adjust_datetime(
2326: date_time => l_server_date
2327: ,from_tz => l_server_code
2328: ,to_tz => l_client_code
2329: );

Line 2361: l_client_date := fnd_timezones_pvt.adjust_datetime(

2357:
2358: l_server_date := to_date(l_sys_next_run_date, 'DD/MM/RRRR HH24:MI:SS');
2359:
2360: /*
2361: l_client_date := fnd_timezones_pvt.adjust_datetime(
2362: date_time => l_server_date
2363: ,from_tz => l_server_code
2364: ,to_tz => l_client_code
2365: );

Line 3093: l_sql_stmt := 'begin :1 := fnd_timezones_pvt.adjust_datetime(:2, :3, :4); end;';

3089: BEGIN
3090: l_db_ver := BIS_UTILITIES_PUB.Get_DB_Version;
3091: l_client_date := p_date_time;
3092:
3093: l_sql_stmt := 'begin :1 := fnd_timezones_pvt.adjust_datetime(:2, :3, :4); end;';
3094:
3095: IF l_db_ver > 8 THEN
3096: execute immediate l_sql_stmt using OUT l_client_date , IN p_date_time, IN p_from_tz, IN p_to_tz;
3097: END IF;

Line 3100: l_client_date := fnd_timezones_pvt.adjust_datetime(

3096: execute immediate l_sql_stmt using OUT l_client_date , IN p_date_time, IN p_from_tz, IN p_to_tz;
3097: END IF;
3098:
3099: /*
3100: l_client_date := fnd_timezones_pvt.adjust_datetime(
3101: date_time => p_date_time
3102: ,from_tz => p_from_tz
3103: ,to_tz => p_to_tz
3104: );