DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on FND_DATE

Line 251: p_source_day_time => fnd_date.canonical_to_date(p_from_start_date) ,

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,
255: x_msg_data => l_msg_data);

Line 262: p_source_day_time => fnd_date.canonical_to_date(p_to_start_date) ,

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,
266: x_msg_data => l_msg_data);

Line 273: p_source_day_time => fnd_date.canonical_to_date(p_from_release_date) ,

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,
277: x_msg_data => l_msg_data);

Line 284: p_source_day_time => fnd_date.canonical_to_date(p_to_release_date) ,

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,
288: x_msg_data => l_msg_data);

Line 295: p_source_day_time => fnd_date.canonical_to_date(p_from_completion_date) ,

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,
299: x_msg_data => l_msg_data);

Line 306: p_source_day_time => fnd_date.canonical_to_date(p_to_completion_date) ,

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,
310: x_msg_data => l_msg_data);

Line 317: p_source_day_time => fnd_date.canonical_to_date(p_act_close_date) ,

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,
321: x_msg_data => l_msg_data);

Line 325: x_from_release_date := fnd_date.canonical_to_date(p_from_release_date);

321: x_msg_data => l_msg_data);
322:
323: ELSE
324:
325: x_from_release_date := fnd_date.canonical_to_date(p_from_release_date);
326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);
327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);

Line 326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);

322:
323: ELSE
324:
325: x_from_release_date := fnd_date.canonical_to_date(p_from_release_date);
326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);
327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);
330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);

Line 327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);

323: ELSE
324:
325: x_from_release_date := fnd_date.canonical_to_date(p_from_release_date);
326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);
327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);
330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);
331: x_act_close_date := fnd_date.canonical_to_date(p_act_close_date);

Line 328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);

324:
325: x_from_release_date := fnd_date.canonical_to_date(p_from_release_date);
326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);
327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);
330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);
331: x_act_close_date := fnd_date.canonical_to_date(p_act_close_date);
332:

Line 329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);

325: x_from_release_date := fnd_date.canonical_to_date(p_from_release_date);
326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);
327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);
330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);
331: x_act_close_date := fnd_date.canonical_to_date(p_act_close_date);
332:
333:

Line 330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);

326: x_to_release_date := fnd_date.canonical_to_date(p_to_release_date);
327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);
330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);
331: x_act_close_date := fnd_date.canonical_to_date(p_act_close_date);
332:
333:
334: END IF;

Line 331: x_act_close_date := fnd_date.canonical_to_date(p_act_close_date);

327: x_from_start_date := fnd_date.canonical_to_date(p_from_start_date);
328: x_to_start_date := fnd_date.canonical_to_date(p_to_start_date);
329: x_from_completion_date := fnd_date.canonical_to_date(p_from_completion_date);
330: x_to_completion_date := fnd_date.canonical_to_date(p_to_completion_date);
331: x_act_close_date := fnd_date.canonical_to_date(p_act_close_date);
332:
333:
334: END IF;
335: