The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row(
x_rowid IN OUT NOCOPY VARCHAR2
, x_wrap_id NUMBER
, x_object_version_number NUMBER
, x_created_by NUMBER
, x_creation_date DATE
, x_last_updated_by NUMBER
, x_last_update_date DATE
, x_last_update_login NUMBER
, x_outcome_required VARCHAR2
, x_result_required VARCHAR2
, x_reason_required VARCHAR2
, x_result_id NUMBER
, x_reason_id NUMBER
, x_outcome_id NUMBER
, x_action_activity_id NUMBER
, x_object_id NUMBER
, x_object_type VARCHAR2
, x_source_code_id NUMBER
, x_source_code VARCHAR2
, x_start_date DATE
, x_end_date DATE
, x_wrap_up_level VARCHAR2
) IS
CURSOR l_insert IS
SELECT ROWID
FROM jtf_ih_wrap_ups
WHERE wrap_id = x_wrap_id;
INSERT INTO jtf_ih_wrap_ups (
wrap_id
, object_version_number
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, outcome_required
, result_required
, reason_required
, result_id
, reason_id
, outcome_id
, action_activity_id
, object_id
, object_type
, source_code_id
, source_code
, start_date
, end_date
, wrap_up_level
) VALUES (
x_wrap_id
, DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
, DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
, DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
, DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
, DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
, DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
, DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
, DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
, DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
, DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
, DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
, DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
, DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
, DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
, DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
, DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
, DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
, DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
, x_end_date
, DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
);
OPEN l_insert;
FETCH l_insert INTO x_rowid;
IF (l_insert%NOTFOUND) THEN
CLOSE l_insert;
END insert_row;
PROCEDURE delete_row(
x_wrap_id NUMBER
) IS
BEGIN
DELETE FROM jtf_ih_wrap_ups
WHERE wrap_id = x_wrap_id;
END delete_row;
PROCEDURE update_row(
x_wrap_id NUMBER
, x_object_version_number NUMBER
, x_created_by NUMBER
, x_creation_date DATE
, x_last_updated_by NUMBER
, x_last_update_date DATE
, x_last_update_login NUMBER
, x_outcome_required VARCHAR2
, x_result_required VARCHAR2
, x_reason_required VARCHAR2
, x_result_id NUMBER
, x_reason_id NUMBER
, x_outcome_id NUMBER
, x_action_activity_id NUMBER
, x_object_id NUMBER
, x_object_type VARCHAR2
, x_source_code_id NUMBER
, x_source_code VARCHAR2
, x_start_date DATE
, x_end_date DATE
, x_wrap_up_level VARCHAR2
) IS
CURSOR cWrapUps IS SELECT * FROM JTF_IH_WRAP_UPS WHERE WRAP_ID = x_wrap_id;
l_last_updated_by NUMBER;
l_last_update_date DATE;
l_last_update_login NUMBER;
l_last_updated_by := x_last_updated_by;
l_last_update_date := x_last_update_date;
l_last_update_login := x_last_update_login;
IF(l_last_updated_by IS NULL) THEN
l_last_updated_by := rWrapUPS.last_updated_by;
IF(l_last_update_date IS NULL) THEN
l_last_update_date := sysdate;
IF(l_last_update_login IS NULL) THEN
l_last_update_login := -1;
UPDATE jtf_ih_wrap_ups
SET
object_version_number=l_object_version_number
, last_updated_by =l_last_updated_by
, last_update_date = l_last_update_date
, last_update_login =l_last_update_login
, outcome_required =l_outcome_required
, result_required =l_result_required
, reason_required =l_reason_required
, result_id =l_result_id
, reason_id =l_reason_id
, outcome_id =l_outcome_id
, action_activity_id =l_action_activity_id
, object_id =l_object_id
, object_type=l_object_type
, source_code_id=l_source_code_id
, source_code=l_source_code
, start_date = l_start_date
, end_date = l_end_date
, wrap_up_level = l_wrap_up_level
WHERE WRAP_ID = l_wrap_id;
END update_row;
, x_last_updated_by NUMBER
, x_last_update_date DATE
, x_last_update_login NUMBER
, x_outcome_required VARCHAR2
, x_result_required VARCHAR2
, x_reason_required VARCHAR2
, x_result_id NUMBER
, x_reason_id NUMBER
, x_outcome_id NUMBER
, x_action_activity_id NUMBER
, x_object_id NUMBER
, x_object_type VARCHAR2
, x_source_code_id NUMBER
, x_source_code VARCHAR2
) IS
-- bug# 2500341
CURSOR l_lock IS
SELECT *
FROM jtf_ih_wrap_ups
WHERE wrap_id = x_wrap_id
FOR UPDATE OF wrap_id NOWAIT;
FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
AND ((l_table_rec.last_updated_by = x_last_updated_by)
OR ((l_table_rec.last_updated_by IS NULL)
AND ( x_last_updated_by IS NULL)))
AND ((l_table_rec.last_update_date = x_last_update_date)
OR ((l_table_rec.last_update_date IS NULL)
AND ( x_last_update_date IS NULL)))
AND ((l_table_rec.last_update_login = x_last_update_login)
OR ((l_table_rec.last_update_login IS NULL)
AND ( x_last_update_login IS NULL)))
AND ((l_table_rec.outcome_required = x_outcome_required)
OR ((l_table_rec.outcome_required IS NULL)
AND ( x_outcome_required IS NULL)))
AND ((l_table_rec.result_required = x_result_required)
OR ((l_table_rec.result_required IS NULL)
AND ( x_result_required IS NULL)))
AND ((l_table_rec.reason_required = x_reason_required)
OR ((l_table_rec.reason_required IS NULL)
AND ( x_reason_required IS NULL)))
AND ((l_table_rec.result_id = x_result_id)
OR ((l_table_rec.result_id IS NULL)
AND ( x_result_id IS NULL)))
AND ((l_table_rec.reason_id = x_reason_id)
OR ((l_table_rec.reason_id IS NULL)
AND ( x_reason_id IS NULL)))
AND ((l_table_rec.outcome_id = x_outcome_id)
OR ((l_table_rec.outcome_id IS NULL)
AND ( x_outcome_id IS NULL)))
AND ((l_table_rec.action_activity_id = x_action_activity_id)
OR ((l_table_rec.action_activity_id IS NULL)
AND ( x_action_activity_id IS NULL)))
AND ((l_table_rec.object_id = x_object_id)
OR ((l_table_rec.object_id IS NULL)
AND ( x_object_id IS NULL)))
AND ((l_table_rec.object_type = x_object_type)
OR ((l_table_rec.object_type IS NULL)
AND ( x_object_type IS NULL)))
AND ((l_table_rec.source_code_id = x_source_code_id)
OR ((l_table_rec.source_code_id IS NULL)
AND ( x_source_code_id IS NULL)))
AND ((l_table_rec.source_code = x_source_code)
OR ((l_table_rec.source_code IS NULL)
AND ( x_source_code IS NULL)))
) THEN
RETURN;
FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
l_Sql := 'SELECT Wrap_Id FROM jtf_ih_wrap_ups WHERE Outcome_ID = :outcome_id ';
UPDATE jtf_ih_wrap_ups SET wrap_id = l_wrap_id WHERE wrap_id = n_Wrap_Id;
UPDATE jtf_ih_action_action_items SET default_wrap_id = l_wrap_id
WHERE default_wrap_id = n_Wrap_Id;
update_row(
x_wrap_id => l_wrap_id
, x_object_version_number => l_object_version_number
, x_created_by => null
, x_creation_date => null
, x_last_updated_by => user_id
, x_last_update_date => sysdate
, x_last_update_login => 0
, x_outcome_required => l_outcome_required
, x_result_required => l_result_required
, x_reason_required => l_reason_required
, x_result_id => l_result_id
, x_reason_id => l_reason_id
, x_outcome_id => l_outcome_id
, x_action_activity_id => l_action_activity_id
, x_object_id => l_object_id
, x_object_type => l_object_type
, x_source_code_id => l_source_code_id
, x_source_code => l_source_code
, x_start_date => l_start_date
, x_end_date => l_end_date
, x_wrap_up_level => l_wrap_up_level);
insert_row(
x_rowid => row_id
, x_wrap_id => l_wrap_id
, x_object_version_number => l_object_version_number
, x_created_by => user_id
, x_creation_date => sysdate
, x_last_updated_by => user_id
, x_last_update_date => sysdate
, x_last_update_login => 0
, x_outcome_required => l_outcome_required
, x_result_required => l_result_required
, x_reason_required => l_reason_required
, x_result_id => l_result_id
, x_reason_id => l_reason_id
, x_outcome_id => l_outcome_id
, x_action_activity_id => l_action_activity_id
, x_object_id => l_object_id
, x_object_type => l_object_type
, x_source_code_id => l_source_code_id
, x_source_code => l_source_code
, x_start_date => l_start_date
, x_end_date => l_end_date
, x_wrap_up_level => l_wrap_up_level
);