[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM jtf_task_recur_rules
WHERE ROWID = l_rowid;
PROCEDURE update_task_recurrence (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_task_id IN NUMBER,
p_recurrence_rule_id IN NUMBER,
p_occurs_which IN INTEGER DEFAULT NULL,
p_day_of_week IN INTEGER DEFAULT NULL,
p_date_of_month IN INTEGER DEFAULT NULL,
p_occurs_month IN INTEGER DEFAULT NULL,
p_occurs_uom IN VARCHAR2 DEFAULT NULL,
p_occurs_every IN INTEGER DEFAULT NULL,
p_occurs_number IN INTEGER DEFAULT NULL,
p_start_date_active IN DATE DEFAULT NULL,
p_end_date_active IN DATE DEFAULT NULL,
p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_attribute1 IN VARCHAR2 DEFAULT NULL ,
p_attribute2 IN VARCHAR2 DEFAULT NULL ,
p_attribute3 IN VARCHAR2 DEFAULT NULL ,
p_attribute4 IN VARCHAR2 DEFAULT NULL ,
p_attribute5 IN VARCHAR2 DEFAULT NULL ,
p_attribute6 IN VARCHAR2 DEFAULT NULL ,
p_attribute7 IN VARCHAR2 DEFAULT NULL ,
p_attribute8 IN VARCHAR2 DEFAULT NULL ,
p_attribute9 IN VARCHAR2 DEFAULT NULL ,
p_attribute10 IN VARCHAR2 DEFAULT NULL ,
p_attribute11 IN VARCHAR2 DEFAULT NULL ,
p_attribute12 IN VARCHAR2 DEFAULT NULL ,
p_attribute13 IN VARCHAR2 DEFAULT NULL ,
p_attribute14 IN VARCHAR2 DEFAULT NULL ,
p_attribute15 IN VARCHAR2 DEFAULT NULL ,
p_attribute_category IN VARCHAR2 DEFAULT NULL ,
p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
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
)
IS
BEGIN
SAVEPOINT update_task_recurrence_pub;
jtf_task_recurrences_pvt.update_task_recurrence (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_task_id => p_task_id,
p_recurrence_rule_id => p_recurrence_rule_id,
p_occurs_which => p_occurs_which,
p_day_of_week => p_day_of_week,
p_date_of_month => p_date_of_month,
p_occurs_month => p_occurs_month,
p_occurs_uom => p_occurs_uom,
p_occurs_every => p_occurs_every,
p_occurs_number => p_occurs_number,
p_start_date_active => p_start_date_active,
p_end_date_active => p_end_date_active,
p_template_flag => p_template_flag,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute_category => p_attribute_category,
p_sunday => p_sunday,
p_monday => p_monday,
p_tuesday => p_tuesday,
p_wednesday => p_wednesday,
p_thursday => p_thursday,
p_friday => p_friday,
p_saturday => p_saturday,
x_new_recurrence_rule_id => x_new_recurrence_rule_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
ROLLBACK TO update_task_recurrence_pub;
ROLLBACK TO update_task_recurrence_pub;
END update_task_recurrence;