APPS.AHL_PRD_PRINT_PVT dependencies on FND_DATE

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

1322: END IF;
1323:
1324: IF p_sch_start_from IS NOT NULL THEN
1325: l_query_string := l_query_string || ' AND wipd.scheduled_start_date >= :'||l_bind_index;
1326: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_from);
1327: l_bind_index := l_bind_index + 1;
1328: END IF;
1329:
1330: IF p_sch_start_to IS NOT NULL THEN

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

1328: END IF;
1329:
1330: IF p_sch_start_to IS NOT NULL THEN
1331: l_query_string := l_query_string || ' AND wipd.scheduled_completion_date <= :'||l_bind_index;
1332: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_to);
1333: l_bind_index := l_bind_index + 1;
1334: END IF;
1335:
1336: fnd_file.put_line(fnd_file.log, l_query_string);