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');
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');
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);
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:
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');
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');
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);
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: