DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on FND_PROFILE

Line 244: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN

240: END IF;
241: x_ReturnStatus := fnd_api.g_ret_sts_success ;
242: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');
243:
244: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
245:
246: HZ_TIMEZONE_PUB.Get_Time(
247: p_api_version => 1.0,
248: p_init_msg_list => 'F',

Line 249: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

245:
246: HZ_TIMEZONE_PUB.Get_Time(
247: p_api_version => 1.0,
248: p_init_msg_list => 'F',
249: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
250: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
251: p_source_day_time => fnd_date.canonical_to_date(p_from_start_date) ,
252: x_dest_day_time => x_from_start_date ,
253: x_return_status => l_return_status,

Line 250: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

246: HZ_TIMEZONE_PUB.Get_Time(
247: p_api_version => 1.0,
248: p_init_msg_list => 'F',
249: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
250: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
251: p_source_day_time => fnd_date.canonical_to_date(p_from_start_date) ,
252: x_dest_day_time => x_from_start_date ,
253: x_return_status => l_return_status,
254: x_msg_count => l_msg_count,

Line 260: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

256:
257: HZ_TIMEZONE_PUB.Get_Time(
258: p_api_version => 1.0,
259: p_init_msg_list => 'F',
260: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
261: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
262: p_source_day_time => fnd_date.canonical_to_date(p_to_start_date) ,
263: x_dest_day_time => x_to_start_date ,
264: x_return_status => l_return_status,

Line 261: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

257: HZ_TIMEZONE_PUB.Get_Time(
258: p_api_version => 1.0,
259: p_init_msg_list => 'F',
260: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
261: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
262: p_source_day_time => fnd_date.canonical_to_date(p_to_start_date) ,
263: x_dest_day_time => x_to_start_date ,
264: x_return_status => l_return_status,
265: x_msg_count => l_msg_count,

Line 271: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

267:
268: HZ_TIMEZONE_PUB.Get_Time(
269: p_api_version => 1.0,
270: p_init_msg_list => 'F',
271: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
272: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
273: p_source_day_time => fnd_date.canonical_to_date(p_from_release_date) ,
274: x_dest_day_time => x_from_release_date ,
275: x_return_status => l_return_status,

Line 272: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

268: HZ_TIMEZONE_PUB.Get_Time(
269: p_api_version => 1.0,
270: p_init_msg_list => 'F',
271: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
272: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
273: p_source_day_time => fnd_date.canonical_to_date(p_from_release_date) ,
274: x_dest_day_time => x_from_release_date ,
275: x_return_status => l_return_status,
276: x_msg_count => l_msg_count,

Line 282: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

278:
279: HZ_TIMEZONE_PUB.Get_Time(
280: p_api_version => 1.0,
281: p_init_msg_list => 'F',
282: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
283: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
284: p_source_day_time => fnd_date.canonical_to_date(p_to_release_date) ,
285: x_dest_day_time => x_to_release_date ,
286: x_return_status => l_return_status,

Line 283: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

279: HZ_TIMEZONE_PUB.Get_Time(
280: p_api_version => 1.0,
281: p_init_msg_list => 'F',
282: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
283: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
284: p_source_day_time => fnd_date.canonical_to_date(p_to_release_date) ,
285: x_dest_day_time => x_to_release_date ,
286: x_return_status => l_return_status,
287: x_msg_count => l_msg_count,

Line 293: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

289:
290: HZ_TIMEZONE_PUB.Get_Time(
291: p_api_version => 1.0,
292: p_init_msg_list => 'F',
293: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
294: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
295: p_source_day_time => fnd_date.canonical_to_date(p_from_completion_date) ,
296: x_dest_day_time => x_from_completion_date ,
297: x_return_status => l_return_status,

Line 294: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

290: HZ_TIMEZONE_PUB.Get_Time(
291: p_api_version => 1.0,
292: p_init_msg_list => 'F',
293: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
294: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
295: p_source_day_time => fnd_date.canonical_to_date(p_from_completion_date) ,
296: x_dest_day_time => x_from_completion_date ,
297: x_return_status => l_return_status,
298: x_msg_count => l_msg_count,

Line 304: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

300:
301: HZ_TIMEZONE_PUB.Get_Time(
302: p_api_version => 1.0,
303: p_init_msg_list => 'F',
304: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
305: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
306: p_source_day_time => fnd_date.canonical_to_date(p_to_completion_date) ,
307: x_dest_day_time => x_to_completion_date ,
308: x_return_status => l_return_status,

Line 305: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

301: HZ_TIMEZONE_PUB.Get_Time(
302: p_api_version => 1.0,
303: p_init_msg_list => 'F',
304: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
305: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
306: p_source_day_time => fnd_date.canonical_to_date(p_to_completion_date) ,
307: x_dest_day_time => x_to_completion_date ,
308: x_return_status => l_return_status,
309: x_msg_count => l_msg_count,

Line 315: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

311:
312: HZ_TIMEZONE_PUB.Get_Time(
313: p_api_version => 1.0,
314: p_init_msg_list => 'F',
315: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
316: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
317: p_source_day_time => fnd_date.canonical_to_date(p_act_close_date) ,
318: x_dest_day_time => x_act_close_date ,
319: x_return_status => l_return_status,

Line 316: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

312: HZ_TIMEZONE_PUB.Get_Time(
313: p_api_version => 1.0,
314: p_init_msg_list => 'F',
315: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
316: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
317: p_source_day_time => fnd_date.canonical_to_date(p_act_close_date) ,
318: x_dest_day_time => x_act_close_date ,
319: x_return_status => l_return_status,
320: x_msg_count => l_msg_count,

Line 1353: l_precision_profile := fnd_profile.value('REPORT_QUANTITY_PRECISION');

1349:
1350: x_ReturnStatus := fnd_api.g_ret_sts_success;
1351: SORT_BY_JOB := 1 ;
1352: l_report_type := p_report_type ;
1353: l_precision_profile := fnd_profile.value('REPORT_QUANTITY_PRECISION');
1354:
1355: IF ( l_precision_profile = NULL ) then
1356: l_precision_profile := 2;
1357: END IF ;