The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM jtf_task_dates
WHERE ROWID = l_rowid;
PROCEDURE update_task_dates (
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_object_version_number IN OUT NOCOPY NUMBER ,
p_task_date_id IN NUMBER,
p_date_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
p_date_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
p_date_value IN DATE DEFAULT fnd_api.g_miss_date,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DATES';
CURSOR c_update_task_dates
IS
SELECT task_id,
DECODE (p_date_type_id, fnd_api.g_miss_num, date_type_id, p_date_type_id) date_type_id,
DECODE (p_date_value, fnd_api.g_miss_date, date_value, p_date_value) date_value,
decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
FROM jtf_task_dates
WHERE task_date_id = p_task_date_id;
task_dates c_update_task_dates%ROWTYPE;
SAVEPOINT update_task_dates_pub;
OPEN c_update_task_dates;
FETCH c_update_task_dates INTO task_dates;
IF c_update_task_dates%NOTFOUND
THEN
fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE');
CLOSE c_update_task_dates;
SELECT DECODE (p_date_type_id, fnd_api.g_miss_num, NULL, p_date_type_id)
INTO l_date_type_id
FROM dual;
SELECT DECODE (p_date_type_name, fnd_api.g_miss_char, NULL, p_date_type_name)
INTO l_date_type_name
FROM dual;
jtf_task_dates_pvt.update_task_dates (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => p_object_version_number ,
p_task_date_id => l_task_date_id,
p_date_type_id => l_date_type_id,
p_date_value => l_date_value,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_attribute1 => task_dates.attribute1 ,
p_attribute2 => task_dates.attribute2 ,
p_attribute3 => task_dates.attribute3 ,
p_attribute4 => task_dates.attribute4 ,
p_attribute5 => task_dates.attribute5 ,
p_attribute6 => task_dates.attribute6 ,
p_attribute7 => task_dates.attribute7 ,
p_attribute8 => task_dates.attribute8 ,
p_attribute9 => task_dates.attribute9 ,
p_attribute10 => task_dates.attribute10 ,
p_attribute11 => task_dates.attribute11 ,
p_attribute12 => task_dates.attribute12 ,
p_attribute13 => task_dates.attribute13 ,
p_attribute14 => task_dates.attribute14 ,
p_attribute15 => task_dates.attribute15 ,
p_attribute_category => task_dates.attribute_category
);
rollback to update_task_dates_pub;
rollback to update_task_dates_pub;
PROCEDURE delete_task_dates (
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_object_version_number IN NUMBER ,
p_task_date_id IN NUMBER DEFAULT NULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_date';
SAVEPOINT delete_task_date_pub;
jtf_task_dates_pvt.delete_task_dates (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => p_object_version_number,
p_task_date_id => p_task_date_id,
x_return_status => x_return_status,
x_msg_data => x_msg_data,
x_msg_count => x_msg_count
);
ROLLBACK TO delete_task_date_pub;
ROLLBACK TO delete_task_date_pub;
END; -- Delete Task Dates