The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_task_recurrence(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_task_id NUMBER
, p_recurrence_rule_id NUMBER
, p_occurs_which INTEGER
, p_day_of_week INTEGER
, p_date_of_month INTEGER
, p_occurs_month INTEGER
, p_occurs_uom VARCHAR2
, p_occurs_every INTEGER
, p_occurs_number INTEGER
, p_start_date_active date
, p_end_date_active date
, p_template_flag VARCHAR2
, p_attribute1 VARCHAR2
, p_attribute2 VARCHAR2
, p_attribute3 VARCHAR2
, p_attribute4 VARCHAR2
, p_attribute5 VARCHAR2
, p_attribute6 VARCHAR2
, p_attribute7 VARCHAR2
, p_attribute8 VARCHAR2
, p_attribute9 VARCHAR2
, p_attribute10 VARCHAR2
, p_attribute11 VARCHAR2
, p_attribute12 VARCHAR2
, p_attribute13 VARCHAR2
, p_attribute14 VARCHAR2
, p_attribute15 VARCHAR2
, p_attribute_category VARCHAR2
, p_sunday VARCHAR2
, p_monday VARCHAR2
, p_tuesday VARCHAR2
, p_wednesday VARCHAR2
, p_thursday VARCHAR2
, p_friday VARCHAR2
, p_saturday VARCHAR2
, x_new_recurrence_rule_id out nocopy NUMBER
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_start_date_active date;
jtf_task_recurrences_pub.update_task_recurrence(p_api_version,
p_init_msg_list,
p_commit,
p_task_id,
p_recurrence_rule_id,
p_occurs_which,
p_day_of_week,
p_date_of_month,
p_occurs_month,
p_occurs_uom,
p_occurs_every,
p_occurs_number,
ddp_start_date_active,
ddp_end_date_active,
p_template_flag,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute_category,
p_sunday,
p_monday,
p_tuesday,
p_wednesday,
p_thursday,
p_friday,
p_saturday,
x_new_recurrence_rule_id,
x_return_status,
x_msg_count,
x_msg_data);