DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on FND_CONC_DATE

Line 310: l_new_rev_date_rou := fnd_timezone_pub.adjust_datetime( date_time => fnd_conc_date.string_to_date(p_new_rev_date_rou),

306: /* Added for 12.1 Refresh Bom/Routing Revision Date Project to change the new revision date for BOM or Routing to Server Time Zone */
307: IF(l_rout_rev_basis IN (2,3)) THEN
308: IF (l_timezone_enabled) THEN
309: fnd_file.put_line(fnd_file.log, 'Timezone Convension is enabled and calling adjust_datetime API ');
310: l_new_rev_date_rou := fnd_timezone_pub.adjust_datetime( date_time => fnd_conc_date.string_to_date(p_new_rev_date_rou),
311: from_tz => fnd_timezones.get_client_timezone_code,
312: to_tz => fnd_timezones.get_server_timezone_code);
313: ELSE
314: fnd_file.put_line(fnd_file.log, 'Timezone Conversion is not enabled');

Line 315: l_new_rev_date_rou := fnd_conc_date.string_to_date(p_new_rev_date_rou);

311: from_tz => fnd_timezones.get_client_timezone_code,
312: to_tz => fnd_timezones.get_server_timezone_code);
313: ELSE
314: fnd_file.put_line(fnd_file.log, 'Timezone Conversion is not enabled');
315: l_new_rev_date_rou := fnd_conc_date.string_to_date(p_new_rev_date_rou);
316: END IF;
317: END IF;
318: IF(l_bom_rev_basis IN (2,3)) THEN
319: IF (l_timezone_enabled) THEN

Line 320: l_new_rev_date_bom := fnd_timezone_pub.adjust_datetime(date_time => fnd_conc_date.string_to_date(p_new_rev_date_bom),

316: END IF;
317: END IF;
318: IF(l_bom_rev_basis IN (2,3)) THEN
319: IF (l_timezone_enabled) THEN
320: l_new_rev_date_bom := fnd_timezone_pub.adjust_datetime(date_time => fnd_conc_date.string_to_date(p_new_rev_date_bom),
321: from_tz => fnd_timezones.get_client_timezone_code,
322: to_tz => fnd_timezones.get_server_timezone_code);
323: ELSE
324: l_new_rev_date_bom := fnd_conc_date.string_to_date(p_new_rev_date_bom);

Line 324: l_new_rev_date_bom := fnd_conc_date.string_to_date(p_new_rev_date_bom);

320: l_new_rev_date_bom := fnd_timezone_pub.adjust_datetime(date_time => fnd_conc_date.string_to_date(p_new_rev_date_bom),
321: from_tz => fnd_timezones.get_client_timezone_code,
322: to_tz => fnd_timezones.get_server_timezone_code);
323: ELSE
324: l_new_rev_date_bom := fnd_conc_date.string_to_date(p_new_rev_date_bom);
325: END IF;
326: END IF;
327:
328: l_stmt_num := 50;