1160: var_return_date := min_date;
1161: ELSE
1162: SELECT cal.next_date
1163: INTO var_return_date
1164: FROM bom_calendar_dates cal
1165: WHERE cal.exception_set_id = var_exception_set_id
1166: AND cal.calendar_code = var_calendar_code
1167: AND cal.calendar_date = TRUNC(arg_date);
1168: END IF;
1230:
1231: SELECT min(calendar_date), max(calendar_date), min(seq_num),
1232: max(seq_num)
1233: INTO min_date, max_date, min_seq_num, max_seq_num
1234: FROM bom_calendar_dates
1235: WHERE calendar_code = arg_calendar_code
1236: AND seq_num is not null
1237: AND exception_set_id = arg_exception_set_id;
1238:
1324: var_return_date := min_date;
1325: ELSE
1326: SELECT cal.prior_date
1327: INTO var_return_date
1328: FROM bom_calendar_dates cal
1329: WHERE cal.exception_set_id = var_exception_set_id
1330: AND cal.calendar_code = var_calendar_code
1331: AND cal.calendar_date = TRUNC(arg_date);
1332: END IF;
1377: var_return_number := min_seq_num;
1378: ELSE
1379: SELECT cal.prior_seq_num
1380: INTO var_return_number
1381: FROM bom_calendar_dates cal
1382: WHERE cal.exception_set_id = var_exception_set_id
1383: AND cal.calendar_code = var_calendar_code
1384: AND cal.calendar_date = TRUNC(arg_date);
1385: END IF;