DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on FND_DATE

Line 1298: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_from);

1294: END IF;
1295:
1296: IF p_sch_start_from IS NOT NULL THEN
1297: l_query_string := l_query_string || ' AND wipd.scheduled_start_date >= :'||l_bind_index;
1298: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_from);
1299: l_bind_index := l_bind_index + 1;
1300: END IF;
1301:
1302: IF p_sch_start_to IS NOT NULL THEN

Line 1304: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_to);

1300: END IF;
1301:
1302: IF p_sch_start_to IS NOT NULL THEN
1303: l_query_string := l_query_string || ' AND wipd.scheduled_completion_date <= :'||l_bind_index;
1304: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_to);
1305: l_bind_index := l_bind_index + 1;
1306: END IF;
1307:
1308: fnd_file.put_line(fnd_file.log, l_query_string);