[Home] [Help]
33: begin
34:
35: x_progress := '010' ;
36:
37: /* Select the bucket pattern from chv_bucket_patterns based on
38: ** incoming parameter bucket_pattern_id including the week
39: ** start day.
40: ** We have to hardcode the date due to nls issue when using the next_day function. We have to use
41: ** a known date to get the correct 3 char day in the current language.
58: x_day_count,
59: x_week_count,
60: x_month_count,
61: x_quarter_count
62: FROM chv_bucket_patterns cbp
63: WHERE cbp.bucket_pattern_id = p_bucket_pattern_id;
64:
65: /* Creating a Past Due bucket with just the end date
66: ** which is the day before the horizon start date.