Package icalendar_util_pkg

Functions, procedures

procedure set_prodid

procedure set_prodid(
    p_prodid in varchar2
)

set prodid (company/product name)

function get_event_str

function get_event_str(
    p_event in t_event
) return varchar2

get event string

procedure download_event_str

procedure download_event_str(
    p_event_str in varchar2,
    p_filename in varchar2:=null
)

download event string

procedure download_event

procedure download_event(
    p_event in t_event
)

download event

function create_event

function create_event(
    p_start_date in date,
    p_end_date in date,
    p_summary in varchar2,
    p_description in varchar2:=null,
    p_location in varchar2:=null,
    p_organizer_name in varchar2:=null,
    p_organizer_email in varchar2:=null,
    p_status in varchar2:=null,
    p_uid in varchar2:=null
) return t_event

create event

Types

record t_event

type t_event is record(
    start_date date,
    end_date date,
    summary varchar2(2000),
    description varchar2(2000),
    location varchar2(2000),
    organizer_name varchar2(2000),
    organizer_email varchar2(2000),
    status varchar2(2000),
    uid varchar2(2000)
)