The following lines contain the word 'select', 'insert', 'update' or 'delete':
igs_co_interac_hist_pkg.insert_row (
x_rowid => x_rowid,
x_student_id => x_student_id,
x_request_id => x_new_request_id,
x_document_id => x_document_id,
x_document_type => x_document_type,
x_sys_ltr_code => x_sys_ltr_code,
x_adm_application_number => x_adm_application_number,
x_nominated_course_cd => x_nominated_course_cd,
x_sequence_number => x_sequence_number,
x_cal_type => x_cal_type,
x_ci_sequence_number => x_ci_sequence_number,
x_requested_date => x_requested_date,
x_delivery_type => x_delivery_type,
x_mode => 'R' ,
x_version_id => x_version_id
);
last_updated_by NUMBER;
last_update_date DATE;
x_last_updated_by => last_updated_by,
x_last_update_date => last_update_date,
x_attribute_type_codes => l_attribute_type_codes,
x_attribute_type_names => l_attribute_type_names,
x_attributes => l_attributes,
x_component_citems => l_component_citems,
x_component_attrib_types => l_component_attrib_types,
x_component_citem_names => l_component_citem_names,
x_component_owner_ids => l_component_owner_ids,
x_component_owner_types => l_component_owner_types,
x_component_sort_orders => l_component_sort_orders,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT file_data INTO l_xmlBlob_loc
FROM fnd_lobs
WHERE file_id = p_file_id;
IBC_CITEM_ADMIN_GRP.insert_associations(
p_content_item_id => p_doc_id
,p_assoc_type_codes => l_assoc_type_codes
,p_assoc_objects1 => l_letter_code
,p_commit => FND_API.G_TRUE
,p_init_msg_list => FND_API.G_TRUE
,p_api_version_number => IBC_CITEM_ADMIN_GRP.G_API_VERSION_DEFAULT
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);