The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO cn_process_audit_lines(
process_audit_id,process_audit_line_id,
message_type_code,message_text)
VALUES(
cn_process_audits_s.nextval,cn_process_audit_lines_s1.NEXTVAL,
'cnnotes',i_value);
INSERT INTO cn_process_audit_lines(
process_audit_id,process_audit_line_id,
message_type_code,message_text)
VALUES(
cn_process_audits_s.nextval,cn_process_audit_lines_s1.NEXTVAL,
'cnnotes',l_error);
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
p_commit IN VARCHAR2 := CN_API.G_FALSE,
p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_loading_status OUT NOCOPY VARCHAR2) IS
--
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
SAVEPOINT insert_row;
x_loading_status := 'CN_INSERTED';
SELECT cn_reasons_s.NEXTVAL
INTO l_reasons_all_rec.reason_id
FROM DUAL;
(l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
(l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
cn_reasons_pkg.insert_row(l_reasons_all_rec);
ROLLBACK TO insert_row;
ROLLBACK TO insert_row;
ROLLBACK TO insert_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
p_commit IN VARCHAR2 := CN_API.G_FALSE,
p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_loading_status OUT NOCOPY VARCHAR2) IS
--
CURSOR reason_cur(l_reason_id NUMBER) IS
SELECT *
FROM cn_reasons r
WHERE r.reason_id = l_reason_id;
l_api_name CONSTANT VARCHAR2(30) := 'update_row';
SAVEPOINT update_row;
x_loading_status := 'CN_INSERTED';
(l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
(l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
l_history_rec.updated_table := rec.updated_table;
l_history_rec.dml_flag := 'UPDATE';
l_history_rec.update_flag := rec.lookup_type;
SELECT cn_reason_history_s.NEXTVAL
INTO l_history_rec.reason_history_id
FROM dual;
cn_reason_history_pkg.insert_row(l_history_rec);
cn_reasons_pkg.lock_update_row(l_reasons_all_rec);
ROLLBACK TO update_row;
ROLLBACK TO update_row;
ROLLBACK TO update_row;
PROCEDURE delete_notes(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
p_commit IN VARCHAR2 := CN_API.G_FALSE,
p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_loading_status OUT NOCOPY VARCHAR2) IS
--
CURSOR reason_cur(l_reason_id NUMBER) IS
SELECT *
FROM cn_reasons r
WHERE r.reason_id = l_reason_id;
l_api_name CONSTANT VARCHAR2(30) := 'delete_notes';
SAVEPOINT delete_notes;
x_loading_status := 'CN_INSERTED';
l_history_rec.updated_table := rec.updated_table;
l_history_rec.dml_flag := 'DELETE';
l_history_rec.update_flag := rec.lookup_type;
SELECT cn_reason_history_s.NEXTVAL
INTO l_history_rec.reason_history_id
FROM dual;
cn_reason_history_pkg.insert_row(l_history_rec);
cn_reasons_pkg.delete_row(p_reason_id);
ROLLBACK TO update_row;
ROLLBACK TO update_row;
ROLLBACK TO update_row;
PROCEDURE delete_worksheet_notes(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
p_commit IN VARCHAR2 := CN_API.G_FALSE,
p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_loading_status OUT NOCOPY VARCHAR2) IS
--
CURSOR reason_cur IS
SELECT reason_id
FROM cn_reasons
WHERE upd_table_id = p_payment_worksheet_id;
SELECT reason_history_id
FROM cn_reason_history
WHERE upd_table_id = p_payment_worksheet_id;
l_api_name CONSTANT VARCHAR2(30) := 'delete_worksheet_notes';
SAVEPOINT delete_worksheet_notes;
x_loading_status := 'CN_INSERTED';
cn_reason_history_pkg.delete_row(history_rec.reason_history_id);
cn_reasons_pkg.delete_row(reason_rec.reason_id);
ROLLBACK TO delete_worksheet_notes;
ROLLBACK TO delete_worksheet_notes;
ROLLBACK TO delete_worksheet_notes;