The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION insert_header_row (
p_header IN gme_text_header%ROWTYPE
,x_header IN OUT NOCOPY gme_text_header%ROWTYPE)
RETURN BOOLEAN
IS
l_api_name CONSTANT VARCHAR2 (30) := 'GET_ITEM_NO';
INSERT INTO gme_text_header
(text_code, created_by
,creation_date, last_updated_by
,last_update_date)
VALUES (gem5_text_code_s.NEXTVAL, gme_common_pvt.g_user_ident
,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
,gme_common_pvt.g_timestamp)
RETURNING text_code
INTO x_header.text_code;
END insert_header_row;
FUNCTION insert_text_row (
p_text_row IN gme_text_table%ROWTYPE
,x_text_row IN OUT NOCOPY gme_text_table%ROWTYPE)
RETURN BOOLEAN
IS
l_rowid VARCHAR2 (40);
l_api_name CONSTANT VARCHAR2 (30) := 'insert_text_row';
gma_gme_text_tbl_pkg.insert_row
(x_rowid => l_rowid
,x_text_code => p_text_row.text_code
,x_lang_code => p_text_row.lang_code
,x_paragraph_code => p_text_row.paragraph_code
,x_sub_paracode => p_text_row.sub_paracode
,x_line_no => p_text_row.line_no
,x_text => p_text_row.text
,x_creation_date => gme_common_pvt.g_timestamp
,x_created_by => gme_common_pvt.g_user_ident
,x_last_updated_by => gme_common_pvt.g_user_ident
,x_last_update_date => gme_common_pvt.g_timestamp
,x_last_update_login => gme_common_pvt.g_login_id);
END insert_text_row;