create or replace package my_calendar_pkg as

/*
 * show
 *
 * Parameters
 *   p_start_date - the first date to display
 *   p_end_date - the last date to display
 *   p_time_scale - the units in the horizontal access, D=Days, W=Weeks, etc.
 *   p_data_sql - the select statement to return the data in the following format:
 *     select row_title, start_date, end_date, key_code, description
 *     from the_data_source order by row_title, start_date
 *   p_key_sql - the select statement to return the key in the following format:
 *     select key_code, key_name, key_colour from the_key_source
 */

procedure show
(
  p_start_date in date,
  p_end_date in date,
  p_time_scale in varchar2,
  p_data_sql in varchar2,
  p_key_sql in varchar2
);

/*
 * show_key
 *
 * Parameters
 *   p_key_sql - the select statement to return the key in the following format:
 *     select key_code, key_name, key_colour from the_key_source
 */

procedure show_key
(
  p_key_sql in varchar2
);

end my_calendar_pkg;