APPS.HXC_TCSUMMARY_MIGRATE dependencies on FND_DATE

Line 834: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);

830: l_detail_count := 0;
831: l_elp_upg_count := 0;
832:
833: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
834: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
835: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
836: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
837: l_batch_size := nvl(p_batch_size,500);
838:

Line 835: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));

831: l_elp_upg_count := 0;
832:
833: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
834: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
835: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
836: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
837: l_batch_size := nvl(p_batch_size,500);
838:
839:

Line 836: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));

832:
833: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
834: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
835: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
836: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
837: l_batch_size := nvl(p_batch_size,500);
838:
839:
840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');

Line 1105: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);

1101: l_detail_count := 0;
1102: l_elp_upg_count := 0;
1103:
1104: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1105: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
1106: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
1107: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
1108: l_batch_size := nvl(p_batch_size,500);
1109:

Line 1106: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));

1102: l_elp_upg_count := 0;
1103:
1104: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1105: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
1106: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
1107: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
1108: l_batch_size := nvl(p_batch_size,500);
1109:
1110:

Line 1107: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));

1103:
1104: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1105: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
1106: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
1107: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
1108: l_batch_size := nvl(p_batch_size,500);
1109:
1110:
1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');

Line 1508: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);

1504: fnd_file.put_line(fnd_file.LOG,'Starting Worker Migration');
1505: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1506: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1507:
1508: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
1509: l_worker_id := FND_GLOBAL.CONC_REQUEST_ID;
1510: l_parent_req_id := p_parent_req_id;
1511:
1512: l_time_summary_count := 0;