The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_create_or_update IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_errorcode OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30);
IF(p_create_or_update = 'C') THEN
l_trans_type := EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE;