39:
40: x_progress VARCHAR2(3);
41:
42: -- 3 PL/SQL tables used for calculating bucket quantities.
43: x_bucket_descriptor_table chv_create_buckets.bkttable;
44: x_bucket_start_date_table chv_create_buckets.bkttable;
45: x_bucket_end_date_table chv_create_buckets.bkttable;
46:
47: x_bucket_count BINARY_INTEGER := 1; -- DEBUG need this?
40: x_progress VARCHAR2(3);
41:
42: -- 3 PL/SQL tables used for calculating bucket quantities.
43: x_bucket_descriptor_table chv_create_buckets.bkttable;
44: x_bucket_start_date_table chv_create_buckets.bkttable;
45: x_bucket_end_date_table chv_create_buckets.bkttable;
46:
47: x_bucket_count BINARY_INTEGER := 1; -- DEBUG need this?
48:
41:
42: -- 3 PL/SQL tables used for calculating bucket quantities.
43: x_bucket_descriptor_table chv_create_buckets.bkttable;
44: x_bucket_start_date_table chv_create_buckets.bkttable;
45: x_bucket_end_date_table chv_create_buckets.bkttable;
46:
47: x_bucket_count BINARY_INTEGER := 1; -- DEBUG need this?
48:
49: CURSOR C_REVISION IS
99: -- Create 3 temp bucket tables (descriptor, start_date and end_date)
100: -- and get x_horizon_end_date in the meantime
101: --dbms_output.put_line('Create_Schedule_Revision: create_bucket_template');
102:
103: chv_create_buckets.create_bucket_template(x_horizon_start_date,
104: x_include_future_releases,
105: x_bucket_pattern_id,
106: x_horizon_end_date,
107: x_bucket_descriptor_table,