46: x_bucket_end_date_table chv_create_buckets.bkttable;
47:
48: x_bucket_count BINARY_INTEGER := 1; -- DEBUG need this?
49:
50: -- We will be getting the item_planning_method in chv_schedule_items
51: -- in the create_items routine.
52: CURSOR ITEMS IS
53: SELECT schedule_item_id
54: FROM chv_schedule_items
50: -- We will be getting the item_planning_method in chv_schedule_items
51: -- in the create_items routine.
52: CURSOR ITEMS IS
53: SELECT schedule_item_id
54: FROM chv_schedule_items
55: WHERE schedule_id = p_schedule_id
56: AND rebuild_flag = 'Y';
57:
58: BEGIN