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.HZ_LOCATION_SERVICES_PUB dependencies on FND_DATE

Line 278: l_in_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');

274: log('p_adapter_content_source :'||p_adapter_content_source);
275: log('p_overwrite_threshold :'||p_overwrite_threshold);
276:
277: IF(p_date_validated IS NOT NULL) THEN
278: l_in_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');
279: IF(p_date_validated_op = '>') THEN
280: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)+1,'DD-MON-YYYY');
281: ELSIF(p_date_validated_op = '<') THEN
282: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)-1,'DD-MON-YYYY');

Line 280: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)+1,'DD-MON-YYYY');

276:
277: IF(p_date_validated IS NOT NULL) THEN
278: l_in_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');
279: IF(p_date_validated_op = '>') THEN
280: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)+1,'DD-MON-YYYY');
281: ELSIF(p_date_validated_op = '<') THEN
282: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)-1,'DD-MON-YYYY');
283: ELSE
284: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');

Line 282: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)-1,'DD-MON-YYYY');

278: l_in_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');
279: IF(p_date_validated_op = '>') THEN
280: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)+1,'DD-MON-YYYY');
281: ELSIF(p_date_validated_op = '<') THEN
282: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)-1,'DD-MON-YYYY');
283: ELSE
284: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');
285: END IF;
286: log('temp date_validated: '||l_tmp_dv);

Line 284: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');

280: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)+1,'DD-MON-YYYY');
281: ELSIF(p_date_validated_op = '<') THEN
282: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated)-1,'DD-MON-YYYY');
283: ELSE
284: l_tmp_dv := to_char(fnd_date.canonical_to_date(p_date_validated),'DD-MON-YYYY');
285: END IF;
286: log('temp date_validated: '||l_tmp_dv);
287: END IF;
288:

Line 290: l_in_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');

286: log('temp date_validated: '||l_tmp_dv);
287: END IF;
288:
289: IF(p_last_update_date IS NOT NULL) THEN
290: l_in_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');
291: IF(p_last_update_date_op = '>') THEN
292: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)+1,'DD-MON-YYYY');
293: ELSIF(p_last_update_date_op = '<') THEN
294: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)-1,'DD-MON-YYYY');

Line 292: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)+1,'DD-MON-YYYY');

288:
289: IF(p_last_update_date IS NOT NULL) THEN
290: l_in_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');
291: IF(p_last_update_date_op = '>') THEN
292: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)+1,'DD-MON-YYYY');
293: ELSIF(p_last_update_date_op = '<') THEN
294: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)-1,'DD-MON-YYYY');
295: ELSE
296: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');

Line 294: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)-1,'DD-MON-YYYY');

290: l_in_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');
291: IF(p_last_update_date_op = '>') THEN
292: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)+1,'DD-MON-YYYY');
293: ELSIF(p_last_update_date_op = '<') THEN
294: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)-1,'DD-MON-YYYY');
295: ELSE
296: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');
297: END IF;
298: log('temp last_update_date: '||l_tmp_lud);

Line 296: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');

292: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)+1,'DD-MON-YYYY');
293: ELSIF(p_last_update_date_op = '<') THEN
294: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date)-1,'DD-MON-YYYY');
295: ELSE
296: l_tmp_lud := to_char(fnd_date.canonical_to_date(p_last_update_date),'DD-MON-YYYY');
297: END IF;
298: log('temp last_update_date: '||l_tmp_lud);
299: END IF;
300: