185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);
187:
188: SELECT
189: FND_DATE.Canonical_To_Date(p_schedule_date_low),
190: FND_DATE.Canonical_To_Date(p_schedule_date_high),
191: FND_DATE.Canonical_To_Date(p_ordered_date_low),
192: FND_DATE.Canonical_To_Date(p_ordered_date_high)
193: INTO
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);
187:
188: SELECT
189: FND_DATE.Canonical_To_Date(p_schedule_date_low),
190: FND_DATE.Canonical_To_Date(p_schedule_date_high),
191: FND_DATE.Canonical_To_Date(p_ordered_date_low),
192: FND_DATE.Canonical_To_Date(p_ordered_date_high)
193: INTO
194: l_schedule_date_low,
187:
188: SELECT
189: FND_DATE.Canonical_To_Date(p_schedule_date_low),
190: FND_DATE.Canonical_To_Date(p_schedule_date_high),
191: FND_DATE.Canonical_To_Date(p_ordered_date_low),
192: FND_DATE.Canonical_To_Date(p_ordered_date_high)
193: INTO
194: l_schedule_date_low,
195: l_schedule_date_high,
188: SELECT
189: FND_DATE.Canonical_To_Date(p_schedule_date_low),
190: FND_DATE.Canonical_To_Date(p_schedule_date_high),
191: FND_DATE.Canonical_To_Date(p_ordered_date_low),
192: FND_DATE.Canonical_To_Date(p_ordered_date_high)
193: INTO
194: l_schedule_date_low,
195: l_schedule_date_high,
196: l_ordered_date_low,